Manager – Data Engineering & Platforms

Position overview

Data integration and engineering

• Own and maintain data connections, APIs, integrations, and pipelines between operational systems and the Azure SQL warehouse.
• Build new integrations and ETL/ELT processes; support current automation and business-system integrations involving Zapier and Salesforce.
• Work with software providers and IT to assess APIs, database structures, exports, and integration options.
• Monitor pipeline failures, latency, and completeness; troubleshoot issues and implement monitoring and exception handling.

Warehouse and architecture

• Operate and improve the Azure SQL data warehouse and design scalable structures, tables, relationships, and data models.
• Maintain architecture standards, naming conventions, dbt transformations, and documentation; optimize queries and pipelines.
• Evaluate technology and architecture improvements and maintain development, testing, change, and deployment practices.

Business requirements and data quality

• Manage new data elements from business requirements and source identification through integration, modeling, validation, and production deployment.
• Advise stakeholders on data availability and limitations and collaborate with Power BI developers and analysts on reporting-ready datasets.
• Monitor data completeness, accuracy, consistency, and timeliness; investigate issues with operational owners and automate validation and reconciliation where practical.
• Establish ownership, definitions, business rules, and documentation for important organizational data and metrics.

Governance and technical leadership

• Ensure data solutions meet security, privacy, and access-control requirements; document sources, flows, transformations, rules, and dependencies.
• Advance data classification, access segmentation, governance, and controls for safe future AI-enabled tools and workflows.
• Set engineering standards, act as the internal subject-matter expert, and manage external technical resources where needed.
• Develop the data platform roadmap and evaluate modernization options such as Microsoft Fabric and other Azure technologies.

Required qualifications

• Bachelor's degree in a relevant discipline or equivalent professional experience; approximately 5–8+ years of progressive relevant experience.
• Production experience with Python, SQL, relational databases, dbt, ETL/ELT pipelines, and enterprise data warehouses.
• Advanced SQL, data modeling, API and source-system integration, and Azure SQL or comparable cloud-hosted relational platform experience.
• Experience diagnosing data-quality and integration issues and translating business requirements into technical solutions.
• Experience supporting Power BI or another enterprise BI platform and familiarity with Git, Azure DevOps, or similar development practices.
• Strong documentation, communication, and stakeholder-management skills.

Preferred experience

• Experience with Zapier, Salesforce, or similar integration platforms is an asset.
• Automated data-quality controls, Microsoft Fabric, Azure Data Factory, data lakes, or lakehouse architectures are assets.
• Healthcare or regulated-data experience, Canadian healthcare privacy familiarity, and data governance or AI-readiness experience are assets.
• Managing consultants, vendors, or external development resources is an asset.

Compensation

• The posting lists compensation of $125,000–$150,000 without specifying a pay period.

Benefits

• The posting describes group benefits, employee assistance programs, fitness discounts, paid time off, professional development, retirement savings, and service recognition.

About the company