Job Type Full-time Description SentriLock is a global provider of access control services and is looking for a Data Integration Specialist to join the team. We are a subsidiary of the National Association of Realtors and a nationally-certified “Great Place to Work.” We provide competitive pay, excellent benefits, and a supportive work environment committed to developing our team members. Working for SentriLock is more than just a job, it’s an experience! The Data Integration Specialist is responsible for onboarding and maintaining SentriLock’s real estate customers listing & agent data provided by partner associations and MLS’s. This requires working directly with internal and external clients to interpret & communicate data integration requirements for both parties and then successfully integrating them into SentriLock’s database via data import technologies such as API, RETS, and SFTP. This is a hands-on technical role that ensures the success of ever-changing support of strategic initiatives in modernizing our systems and processes. On a periodic basis, this position may require ad hoc support outside of normal business hours. Benefits include:
- Health benefits
- Generous PTO
- Flexible schedules
- Ability to work hybrid in office/work from home schedule
- Casual work environment
Essential Duties and Responsibilities Serve as a data migration point-of-contact during implementation process, conversions, and migrations for new and existing customers. o Able to create, understand, and document data flows and their relationship to the business o Detail-focused in reviewing all imported customer data daily for accuracy o Write API’s and web services to permit a bi-directional flow of data o Work with FTP/SFTP/RETS/API technologies to extract customer data from third parties o Continuously update and maintain project and ticket tracking on assignments o Establish vendor relationships and effectively communicate to resolve issues Ensure all data imports and job automations are successful. o Create custom MySQL queries to determine data accuracy in a timely fashion o Security-focused to assist in enhancing our systems continuously for the best security posture possible o Troubleshoot and resolve issues with data records Serve as a technical expert regarding data feeds, data integration, and segmentation techniques. o Assist in the deprecation of legacy FTP & SFTP customer data feeds o Document processes for internal and external customers’ review o Troubleshoot, resolve and repair data issues experienced o Communicate issue and resolution effectively with technical and nontechnical, internal and external customers. Make recommendations to management on integration technologies to consider Other duties as assigned. o Participate in projects assigned by manager o Maintain and follow ISO standards o Seek out and complete appropriate training, development and research Knowledge of department processes o Support the mission and goals of the company Requirements Educational Requirements Associates Degree in a Technology Related Field Required Experience Requirements Intermediate to expert experience with MySQL databases & Linux Able to write queries to obtain accurate data returned, update and create records Able to manage and process data feeds from multiple sources 2+ Experience with API/RETS/SFTP/FTP data migration technologies preferred
