Senior Data Engineer

CarePartners is one of Ontarios largest accredited home health care providers providing nursing personal support therapy and rehabilitation support services for patients of all ages. We care for approximately 72000 patients each year in homes schools clinics workplaces and retirement homes through our 24 locations and 24 nursing clinics. CarePartners is proud of its commitment to quality relentlessly seeking to improve the patient and caregiver experience promoting a healthy and resilient workplace culture and contributing to a sustainable healthcare system in Ontario.

The Senior Data Engineer is responsible for the design governance and ongoing evolution of the organizations enterprise data environment. This role provides leadership in data governance data architecture integration quality analytics enablement and AI readiness. Working across clinical operational financial HR and technology domains the role ensures organizational data is trusted secure accessible and structured to support decision-making regulatory compliance operational excellence and emerging technologies such as Artificial Intelligence (AI). The position serves as theorganizations senior technical expert on data management practices and acts as a strategic partnerto business and technology leaders using technical expertise to create a data environment that supports our team.

• This position offers a competitive compensation range. The salary range is$100000.00 to $120000.00and placement within the range will be determined in accordance with company policies and procedures as well as the candidates knowledge skills qualifications and relevant experience.
• Comprehensive health and dental benefits
• Other employment perks such asEmployee Assistance Program Perkopolis Rewards Points
• Inspiring leadership and opportunities for professional growth
• Rewarding and meaningful work in healthcare

DATA GOVERNANCE PRIVACY AND COMPLIANCE

• Lead the organizations Data Governance framework through the Data Governance Councilestablishing standards for data ownership stewardship quality access and lifecycle management.
• Ensure the secure and compliant management of sensitive information including Personal Health Information (PHI) and Personally Identifiable Information (PII).
• Develop and maintain data governance processes policies standards and controls that support privacy security compliance and organizational objectives.
• Promote accountability and consistent data management practices across all business operational and clinical functions.
• Support governance frameworks that enables the responsible and ethical use of data and AI technologies.

ENTERPRISE DATA ARCHITECTURE AND PLATFORM MANAGEMENT

• Design develop and maintain the organizations enterprise data platform and data warehouse architecture.
• Establish and maintain data models structures standards and integration patterns that support reporting analytics operational processes and strategic decision-making.
• Define the long-term data architecture roadmap ensuring solutions are scalable secure sustainable and aligned with organizational priorities.
• Evaluate and recommend data technologies platforms and architectural approaches that improve organizational capabilities.
• Ensure data architecture supports future growth advanced analytics automation and AI initiatives. DATA INTEGRATION ENGINEERING AND MODELING
• Design develop and maintain enterprise data pipelines that integrate data from clinical financial operational HR and third-party systems.
• Develop and support ETL/ELT processes that transform complex source data into trusted and reusable organizational datasets.
• Create and maintain data models that improve consistency usability and performance across reporting and analytics solutions.
• Implement automated monitoring validation and error-handling processes to ensure data reliability and integrity.
• Maintain scalable maintainable and high-performing data solutions that support evolving business need

DATA QUALITY AND INFORMATION MANAGEMENT

• Establish enterprise standards and processes for data quality management validation monitoring and issue resolution.
• Identify data quality risks gaps inconsistencies and root causes and collaborate with stakeholders to implement sustainable corrective actions.
• Translate complex healthcare and business data into accurate reliable and accessible information assets.
• Develop controls and quality measures that improve trust and confidence in organizational data.
• Foster a culture of data stewardship and continuous improvement across the organization.

ANALYTICS ENABLEMENT AND BUSINESS PARTNERSHIP

• Develop and maintain trusted datasets that support reporting dashboards analytics quality improvement initiatives and performance measurement.
• Partner with business clinical operational and technology leaders to understand information needs and deliver scalable data solutions.
• Act as a senior advisor on data governance architecture integration analytics and information management initiatives.
• Translate complex technical concepts into clear and meaningful information for both technical and non-technical stakeholders.
• Support organizational efforts to become increasingly data-driven through accessible and trusted information.

AI READINESS AND INNOVATION

• Lead the development of the foundational data capabilities required to support Artificial Intelligence (AI) machine learning automation and advanced analytics initiatives.
• Ensure data used for AI solutions is governed secure high-quality and compliant with privacy and regulatory requirements.
• Help evaluate emerging AI analytics and data technologies and provide recommendations to support organizational strategy and innovation.
• Support the organizations responsible adoption of AI through strong governance transparency and risk management practices.

DOCUMENTATION STANDARDS AND CONTINUOUS IMPROVEMENT

• Maintain comprehensive documentation of data sources lineage transformations business definitions architecture governance processes and technical standards.
• Establish documentation and operational standards that support transparency maintainability and long-term sustainability of the data environment.
• Drive continuous improvement initiatives that improve data reliability scalability security and operational effectiveness.
• Promote best practices for data management governance analytics and AI readiness across the organization.
• Contribute to the ongoing advancement of the organizations data maturity and information management capabilities.

• A bachelors degree or equivalent practical experience in data engineering information systems health informatics or a related field.
• At least 7 years experience in data-based roles including time as a Data Engineer Analytics Engineer Data Warehouse Engineer or similar roles.
• Superb SQL skills and experience working with relational databases.
• Experience building ETL or ELT pipelines from source systems into a data warehouse database or cloud data platform.
• Experience with Python or another programming language used for data processing.
• In depth understanding of data modeling data warehouse design (such as medallion architectures) and organizing data for analytics and reporting.
• Experience working with healthcare (ideally home healthcare) data or in a healthcare clinical or related environment is preferred.
• In depth understanding of healthcare privacy and security requirements including responsible handling of PHI is preferred.
• Ability to work with incomplete or inconsistent data and create solutions. Comfortable working in an environment where processes are still being built.
• Experience with healthcare data standards such as HL7 FHIR or ICD is preferred.
• Experience with cloud platforms such as AWS Azure or Google Cloud.
• Experience with data platforms such as Snowflake Databricks or Azure Synapse.
• Experience supporting business intelligence tools such as Power BI Tableau Looker or similar platforms.
• Strong communication skills and the ability to explain technical work to non-technical partners. Experience with data governance practices including data quality documentation access controls privacy data ownership and secure handling of healthcare data.
• Ability to create and maintain clear data definitions business rules and documentation.
• Ability to work well with a team of data analysts and provide indirect leadership guidance and mentorship.
• Travel within Ontario and the ability to work non-traditional and on-call hours is a requirement
• Valid drivers license own vehicle and appropriate insurance
• Clear Criminial Record

In addition to providing home-based health care CarePartners also serves the community through clinics transitional care units and provides relief in retirement homes and shared care settings. Through our Community Nursing Services outreach program weve been organizing staff-led medical care and clinics in countries with poor access to health care since 2009

CarePartners welcomes and encourages applicants from people with disabilities. Candidates can request accommodations at any time in the hiring process.

Artificial Intelligence

CarePartners uses iCIMs as part of our recruitment and hiring process. While we incorporate select Artificial Intelligence (AI) features to enhance process efficiency we remain committed to human-led decision making. All AI-generated outputs are subject to human review to ensure accuracy and fairness.

This job posting is available due to an existing vacancy.