Data Engineer

About CareRx Corporation 

At CareRx, we are shaping the future of senior care through pharmacy services that make a real difference. As Canada’s trusted leader in specialty pharmacy services for long-term care, retirement and congregate living communities, we are committed to enhancing the health of Canadians with unique and complex medication needs. Our goal is to improve clinical outcomes and provide personalized care every step of the way.

CareRx’s Enterprise Data platforms enable the organisation to harness the power of its data. Core to this is the ability to source, transform and move data from multiple locations and store it in an enterprise-grade data warehousing platform. The Data Engineer is responsible for operating the platform day to day: keeping data flowing, connecting new sources, and building data pipelines that extract raw data from the data sources and transform the data into trusted structures to support analytical and operational reporting, as well as AI and ML data operations. This role is instrumental in advancing the company's data strategy through the design and delivery of modern cloud-based data platforms leveraging Microsoft Azure and Microsoft Fabric technologies. The role requires strong technical leadership, hands-on development expertise, and the ability to work collaboratively with both technical and business stakeholders.

Why you should join CareRx 

Collaborative Team: Work with colleagues who share a passion for shaping the future of senior care. 

Make a Real Impact: Feel fulfilled knowing your work directly benefits others within the communities we serve. 

Flexible Benefits: For eligible roles, enjoy flexible medical and dental coverage that fits your needs. 

Defined Work Schedule: Offers a healthy work-life balance with predictable hours. 

Focus on Care: Work in an environment where your clinical expertise takes priority - without the demands of retail pharmacy. 

Supportive Culture: Be part of a respectful, inclusive workplace where collaboration, connection and shared purpose drive everything we do. 

Stability and Growth: Join a well-established Canadian company with a strong foundation for job security and opportunities to grow your career. 

Appreciation in Action: We recognize great work through peer-nominated awards, team shout-outs and everyday moments of appreciation. 

Celebrations and Community: From cultural events to team socials and holiday fun - we make time to connect, celebrate and enjoy the moments that bring us together. 

Role Accountabilities:

• Designs and maintains enterprise-scale Azure and Microsoft Fabric data platforms.
• Participates in vendor engagement to implement base Fabric and data integration pipeline, including validation of vendor deliverables, knowledge transfer, and responsibility for maintaining and enhancing the platform after handover.
• Designs and builds change data capture for new data sources using the platform's native or integration tools and document the approach for each source.
• Writes and maintains transformations (SQL and/or visual mapping tools) that move data from raw to curated to reporting layers, with tests for data quality.
• Manages and executes controlled deployments in the data pipeline, including testing and rollback, and recovery procedures.
• Handles source changes such as schema updates and new fields before they affect downstream reports.
• Administers access to data stores through group-based permissions, in line with data access policies.
• Tracks platform capacity and usage and flag issues early.
• Maintains clear documentation and works with architecture, source system owners, and report developers.

What You Will Bring to The Team:

• Bachelor’s degree in Computer Science, Information Systems, Engineering, Mathematics, or related discipline.
• Minimum of 4 years of data engineering experience.
• Experience with Microsoft Fabric core (OneLake, Warehouse, Mirroring).
• Hands-on experience with at least one enterprise data integration platform (e.g. Microsoft Fabric or Azure Data Factory, Informatica, Qlik, or similar).
• Strong knowledge of CDC approaches (log-based, change tracking, watermark/timestamp comparison).
• Experience designing a warehouse or lakehouse layer model (raw, curated, reporting).
• Strong SQL and a working understanding of dimensional modelling.
• Experience with Git or other version control.
• Experience working within an established enterprise data architecture.
• Clear written communication and a habit of documenting what you build.
• Comfort learning new tools quickly.

Preferred

• Experience in a healthcare, pharmacy, and awareness of health privacy obligations.
• Familiarity with enterprise data governance concepts (data classification, canonical/master data, data quality frameworks)
• Experience with Power BI
• Experience with monitoring and incident tools (e.g. Dynatrace, ServiceNow).
• Experience with AI/ML solutions.
• Vendor certifications in data management, data integration or data engineering.

Compensation Range: $120,000 to 130,000. Actual pay rate will be based on the individual candidate’s credentials and experience.

Location: Please note that this role currently requires 1 day per week in the office at our 320 Bay Street location. Beginning January 2027, the office will relocate to Richmond Hill with an expectation of 2 days per week onsite, increasing to 3 days per week as of June 2027.

Opportunity: This is a current existing position

AI Disclosure: CareRx does not use AI to screen candidates

Application Process  

CareRx is committed to employment equity and a diverse, inclusive workplace where everyone can thrive. We welcome applicants of all abilities and will provide accommodations upon request throughout the selection process.

All applicants must successfully pass satisfactory background screening which can include depending on role, Criminal Record Check, Credit Check, Driver’s Abstract, Education Verification, Current Professional Registration and Referencing. Background screening will be completed after an offer of employment has been extended and accepted.