Manager, Data Engineering, Integration

This is a fully remote position, open to applicants in United States.

📋 Description

• Lead and mentor a team of data integration analysts tasked with loading data feeds from clients and vendors.

• Supervise the design, development, and execution of data loads and integrations utilizing Boomi, SQL, and Python-based scripting.

• Facilitate the onboarding of new client and vendor data feeds, coordinating specifications, mapping, and testing through to production.

• Monitor production data feeds, addressing failures, delays, and issues related to data quality.

• Provide visibility into client data loads through detailed waterfall reporting covering record counts, load statuses, and exceptions.

• Collaborate with Client Success Managers, regional Vice Presidents, and Directors to communicate feed statuses and resolve data-related problems.

• Engage with clients and external data partners to discuss data structure, quality, and completeness.

• Oversee the secure delivery of data exports and extracts, including SFTP with PGP encryption.

• Establish and maintain the scheduling and automation of recurring data loads and exports using tools like VisualCron.

• Ensure the precise and complete loading of data into SQL Server EDW and Snowflake.

• Define and uphold data integration standards, intake specifications, and best practices for the team.

• Work in collaboration with Reporting, Data Engineering, and internal teams to support downstream reporting and analytics.

• Monitor and report on team workload, SLAs, and load status using a scrum/agile model.

• Maintain comprehensive technical documentation for feeds, mappings, integration processes, and data exchange specifications.

• Utilize automation and AI-assisted tools to enhance the efficiency, accuracy, and monitoring of data loads.

⛳️ Requirements

• Bachelor’s degree in computer science, information systems, or a related field with 7+ years of experience in data integration, data engineering, ETL/ELT, or data warehousing, or a comparable combination of education and experience.

• Minimum of 3 years experience in a management or team lead position, preferably overseeing a team of data integration or data analysts.

• Proficient SQL skills, including the ability to write and optimize complex queries and stored procedures.

• Practical experience with an integration/iPaaS platform like Boomi.

• Familiarity with scripting and automation utilizing Python.

• Experience with job scheduling and workflow automation tools such as VisualCron.

• Proven experience in loading and managing data within SQL Server and cloud data platforms such as Snowflake.

• Understanding of cloud computing platforms, especially AWS (S3, EC2).

• Experience in secure file exchanges, including SFTP and PGP encryption.

• Background in producing and delivering data exports/extracts to external clients and partners.

• Familiarity with Salesforce data is advantageous.

• Experience managing projects and priorities within an agile/scrum team framework.

• Exposure to utilizing AI or automation for enhancing data loading, monitoring, or anomaly detection is a plus.

• Strong communication skills to engage both technical and non-technical audiences, including clients, CSMs, and senior leadership.

• A client-focused mindset with a commitment to responsiveness, transparency, and service.

• Critical thinking and problem-solving abilities to identify and resolve data and feed issues.

• Keen attention to detail and a dedication to data accuracy and completeness.

• Capability to manage time effectively, prioritize competing demands, and meet deadlines in a dynamic environment.

• Leadership qualities to mentor, develop, and inspire a team of analysts.

• Flexibility to adapt to changing client needs and priorities.

• Strategic mindset regarding data integration processes, scalability, and continuous improvement.

• Willingness to stay updated on new integration technologies, tools, and best practices.

• Collaborative approach to working with internal teams and external partners.

🏝️ Benefits

• Annual incentive eligibility.

• Great Place to Work® certified inclusive, high-trust culture.