Skip to content

Data Engineer

Organization: RCCbc

 

Location: Hybrid or remote option dependent upon location

 

Led by rural physicians, the Rural Coordination Centre of BC (RCCbc) is a network that improves the health of people and communities in rural British Columbia. Funded primarily by the Joint Standing Committee on Rural Issues, our network partners include healthcare providers, healthcare administrators, community members, policymakers, educators, researchers, and non-profit and business leaders. We serve all communities in British Columbia covered by the Rural Practice Subsidiary Agreement.

 

RCCbc is committed to advocating for equity in rural, remote and Indigenous healthcare, and this includes advancing the recommendations in the Truth and Reconciliation Calls to Action (TRC) and embedding our work with respectful relationships and reciprocity, and leading with compassion, empathy and inclusivity.

 

Role Summary

In accordance with the established vision and values of the organization, the Data Engineer reports to the Executive Director, Operations at RCCbc, receives day-to-day direction from the Chief Data Scientist and works closely with other members of the data informatics team. In particular, the Data Engineer (DE) builds systems for collecting, validating and preparing high-quality data for RCCbc to make data-informed decisions by the team and our network. The DE is responsible for working with the data owners to ensure the quality and integrity of the data and reporting systems.

 

The DE is responsible for helping develop and maintain data processing systems like databases. With guidance from the Chief Data Scientist, the DE creates unique data infrastructure, runs tests on the design to isolate errors and updates systems to accommodate changes in organization needs.

Key Duties and Responsibilities

  • Work together with subject matter experts to understand the needs for data and create effective, secure data workflows.
  • Design, build and maintain secure and compliant data processing pipelines using various Microsoft Azure data services and frameworks.
  • Build provincial health databases and perform data migration work from various sources.
  • Design, implement and maintain data pipelines for data ingestion, processing and transformation in Microsoft Azure Cloud.
  • Build reporting and analytical tools to utilize the data, provide actionable insight into key metrics
  • Create and maintain data storage solutions including Azure SQL Database, Azure Data Lake, and/or Azure Blob Storage.
  • Use Azure Data Factory to create and maintain ETL (Extract, Transform, Load).
  • Implement data validation and cleansing methods to ensure accurate and dependable data.
  • Monitor and resolve data pipeline issues to ensure consistency and availability of data.
  • Develop algorithms to transform data into usable information to support the work of RCCbc staff and partners.
  • Identify, design and implement processes to allow for scalability, optimizing data delivery and automating manual processes.

Qualifications

Education, Training and Experience

  • A level of education, training, and experience equivalent to a Bachelor’s degree in Computer Science, Health Informatics, or a related discipline plus relevant experience.
  • Minimum three (3) years of recent experience working with databases (PostgreSQL), query authoring (SQL) and scripting language (Python).
  • Practical knowledge of DevOps and experience with CI/CD best practices.
  • Experience programming ETL code, building and optimizing data pipelines, architectures and datasets using Microsoft Azure technologies.
  • Ability to manipulate, process and extract value from large, unstructured, disconnected datasets.
  • Knowledge of version control systems (Git).
  • Demonstrated knowledge and application of health care data governance, guidelines relating to privacy, confidentiality and security
  • Ability to use audience appropriate communication and language to present information, analyze results and convey concepts.
  • Ability to work outside of regular work hours, as needed, to accommodate meetings and time sensitive deliverables.
  • Demonstrated understanding of diversity, inclusion and cultural humility as they apply to health care is an asset.

RCCbc welcomes and encourages applications from equity deserving groups and diverse experiences including, but not limited to, Indigenous people, racialized people, people with disabilities, and members of the 2S/LGBTQIA+ community. We are an equal opportunity employer, and our employees are people with different strengths, experiences and backgrounds, who share a passion for improving people’s lives. Diversity not only includes race and gender identity, but also age, disability status, veteran status, sexual orientation, religion and many other parts of one’s identity. All of our employee’s points of view are key to our success, and inclusion is everyone’s responsibility.

 

If there are any barriers that you are experiencing or require an accommodation that we can provide, to support you through the application process, please reach out to us at [email protected].

 

Location: Individual/applicant must reside in British Columbia. Node Office: Hybrid or remote option dependent upon location.

 

Compensation: $74,542 to $87,696. Note this is a 12-month term position.

 

Please send cover letter and resume to [email protected].

Start typing and press enter to see results