Overview
Reporting to the Manager, Strategic Analytics, the Data and Analytics Engineer plays a key role in advancing data-driven decision making across the organization. This position is responsible for building and maintaining modern, cloud-based data infrastructure that supports high quality reporting, analytics, and clinical insights. You will design and develop data pipelines, curated data models, and analytical data structures that make data accessible, reliable, and impactful in a healthcare environment. The role requires the ability to work independently and collaboratively within a team committed to advancing data and analytics and strengthening a data driven culture.
Description
As a Data and Analytics Engineer, you will design, build, and optimize data systems that support analytics, reporting, and decision making. You will develop and maintain scalable data pipelines that ingest, transform, and deliver structured and unstructured data. Using SQL and Python, you will create reliable data solutions and build foundational data structures such as tables, views, and schemas, while supporting modern development practices including automated testing, deployment, and version control. You will work with cloud-based data platforms, including Snowflake or similar technologies, to deliver efficient and scalable data solutions. This includes optimizing performance, managing schema architecture, and ensuring consistency across environments. A key focus will be ensuring data quality and reliability through validation frameworks, monitoring, and operational controls to maintain accurate, timely, and trusted data. The role requires a strong focus on data governance, privacy, and compliance. You will ensure data is handled securely while meeting Alberta’s legislative requirements, including the Protection of Privacy Act and the Health Information Act. Collaboration is central to this role. You will partner with analysts, data scientists, and stakeholders to translate requirements into scalable data solutions and design analytical models for reporting and advanced analytics. You will also support and troubleshoot analytics solutions, provide user guidance, and maintain clear documentation. This role combines technical expertise with strong communication skills to enable effective, data informed decision making.
Responsibilities
- Design, build, and optimize data systems that support analytics, reporting, and decision making.
- Develop and maintain scalable data pipelines that ingest, transform, and deliver structured and unstructured data.
- Create reliable data solutions using SQL and Python; build foundational data structures such as tables, views, and schemas.
- Support modern development practices including automated testing, deployment, and version control.
- Work with cloud-based data platforms (e.g., Snowflake) to deliver efficient and scalable data solutions; optimize performance and manage schema architecture across environments.
- Ensure data quality and reliability through validation frameworks, monitoring, and operational controls.
- Uphold data governance, privacy, and compliance with Alberta’s legislation (POPA & HIA).
- Collaborate with analysts, data scientists, and stakeholders to translate requirements into scalable data solutions and design analytical models for reporting and advanced analytics.
- Provide support, troubleshooting, user guidance, and maintain clear documentation.
- Communicate effectively to enable data-informed decision making.
Minimum Qualifications
- Bachelor’s degree in computer science, data analytics, business analytics or a related field.
- 3 to 5 years of experience in data modelling, data warehousing and modern data pipeline frameworks.
- 3 to 5 years of demonstrated proficiency in SQL, including experience working with large, complex datasets.
Additional Required Qualifications
- Strong understanding of data engineering fundamentals, including ingestion, transformation, orchestration, serving layers, monitoring, alerting, logging, error handling, and performance tuning.
- Hands-on experience with cloud-based data platforms (e.g., Snowflake), including schema design, performance-optimized queries, and migration strategies across environments.
- Solid understanding of relational database concepts, indexing, normalization, and query optimization.
- Experience implementing data quality validation, testing, and monitoring frameworks.
- Experience with Docker and containerized concepts, including packaging applications and dependencies for reproducible deployment.
- Experience implementing CI/CD pipelines for data products.
- Proficiency in Python, stored procedures, and dbt; data modeling and unit testing.
- Working knowledge of PostgreSQL and MySQL.
- Familiarity with version control, change management, and disciplined development practices.
- Strong understanding of data governance, including privacy, security, and ethical use of data; knowledge of Alberta’s POPA & HIA and its application in analytics workflows.
- Demonstrated ability to work independently and collaboratively within multidisciplinary teams.
Preferred Qualifications
- Experience with healthcare or health system data (e.g., Connect Care Epic Clarity, NACRS, DAD, or CIHI datasets).
- Experience implementing data engineering solutions that support advanced analytics, quality improvement, or clinical performance reporting.
- Knowledge of reporting and visualization tools that consume analytical and dimensional data models.
Hiring Requirements
Please submit your resume to apply. We will review only the information provided in your resume during the screening process. The following must be provided prior to your first day of work: Security Screening: a satisfactory Criminal Record Check and disclosure of previous convictions, record suspensions or pardons for sexual offences to Covenant Health prior to commencement of any work.
#J-18808-Ljbffr
Sign in
To continue your applicationor continue with email
By continuing you agree to our Terms & Privacy Policy.
