Data Engineer, Information Technology

At Doctors of BC our vision is to promote a social, economic, and political climate in which members can provide the citizens of BC with the highest standard of health care, while achieving maximum professional satisfaction and fair economic reward.

Together, we make a difference so our doctors can make theirs. Join us today

THE JOB: Data Engineer, Information Technology

The starting salary range falls within the minimum to mid-point of the salary range.

Starting Salary Range: $102,720- $128,400

Reporting to the Data Management Manager, Information Technology, the Data Engineer, is responsible for designing and implementing effective data solutions and models to store and retrieve organizational data. This role participates in the development of our modern cloud-based data platforms with capabilities such as Data Lakes, ETL/ELT, modern Data Warehouses to meet defined business purposes, capturing and documenting architectural requirements, and building data models and pipelines necessary for data integration and transformation. This role works hands-on to build a Data driven organization by mapping the systems and interfaces used to manage data, while working closely with the Sr.Data Engineer and other Data Management team members. 

This position collaborates across IT, multiple departments, stakeholders, partners, external vendors, and business data analytics power users responsible for delivering business solutions. With a focus on digital transformation and a cloud-first mandate, the Data Engineer will play a vital role in linking together business needs and opportunities for improvement within a multi partnered environment.

Technical skills:

• Builds data schemas and data models for existing and new applications while providing integration capabilities between various systems. 
• Monitor and create robust ETL/ELT processes for multiple data sources and troubleshoot as needed. 
• Develop Data flows, pipelines, and transformations across the ETL/ELT. 
• Intermediate understanding of security standards and application security layer models. 
• Implement Data quality with checks on data sanity and integrity. 
• Implement best practices and frameworks for unit, functional and integration tests. 
• Implement solutions to migrate data from legacy systems to new solutions. 
• Experience working on enterprise implementations leveraging agile methodology. 
• Monitor the system performance by regular tests, troubleshooting, and integrating new features.

WHAT SUCCESS LOOKS LIKE

Building Relationships (A):

Sets objectives necessary for obtaining feedback and assistance. Maintains effective communication. Shares ideas, issues, and opportunities with members of personal network. Seeks referrals from others with relevant expertise and influence. Attends and maintains relationships with relevant formal and informal professional groups and organizations.

Communication for Results (I):

Conducts discussions with and writes memoranda to all levels of colleagues and peer groups in ways that support troubleshooting and problem solving. Seeks and shares relevant information, opinions, and judgments. Handles conflict empathetically. Explains the context of interrelated situations, asks probing questions, and solicits multiple sources of advice prior to taking action when appropriate.

Strategic Thinking (A):
Identifies and considers emerging development opportunities and risks when articulating new options and recommendations. Maintains a broad, strategic perspective while identifying and focusing on crucial details.  Analyzes project inputs from various elements (e.g., budgetary, technical, compliance, policy) and correctly prioritizes issues and solutions in support of goal accomplishment. Conceives likely scenarios and recommends effective courses of action to others. Integrates input from sophisticated models and tools to predict outcomes and identify issues that may not be obvious to others.  

Problem Solving (A):
Diagnoses problems using formal problem-solving tools and techniques from multiple angles and probes underlying issues to generate multiple potential solutions. Proactively anticipates and prevents problems. Devises, facilitates buy-in, makes recommendations, and guides implementation of corrective and/or preventive actions for complex issues that cross organizational boundaries and are unclear in nature. Identifies potential consequences and risk levels. Seeks support and buy-in for problem definition, methods of resolution, and accountability. 

WHAT YOU BRING

• Bachelor's degree in Computer Science, Data Science, Computer Engineering, or relevant field. 
• Demonstrated success in a similar role with at least 3 to 5 years of experience. 
• 3 to 5 years of experience in data modeling and database design: Understanding of all phases of data modeling, from conceptualization to database optimization, development and administration on Snowflake data platform is a must. 
• 3 to 5 years of experience working with GitHub, Visual Studio Code and DBT is needed. 
• 3 to 5 years of Azure data platform experience specifically with Azure Databricks and Azure Data Factory is needed.
• Experience with programming languages such as Python, and YML, Jinja. 
• Strong knowledge of database structure systems and data mining technologies including consuming, transforming, cleaning, and persisting data. 
• Experience working with relational databases and ability to write advanced SQL scripts for data modelling, analysis, and reporting.  
• Excellent documentation and communication skills (verbal and written) and dedication to quality and timeliness. 
• Solid understanding of the system development life cycle; software project management approaches; and requirements, design, and test techniques.

Doctors of BC thanks all applicants; however, only those selected for an interview will be notified.

Doctors of BC recognize the pervasive and ongoing harms of colonialism faced by Indigenous peoples and that these harms include the widespread systemic racism against Indigenous peoples in BC's health system. Physicians have a significant role to play in addressing the health disparities that exist between Indigenous and non-Indigenous patients, and Doctors of BC is committed to continuing to advance reconciliation and address and eliminate racism in health care.

Doctors of BC celebrates diversity, challenges inequality and is committed to sustaining an inclusive and diverse community. We seek qualified applicants who share our commitments to equity, diversity and inclusion, and truth and reconciliation. We especially welcome applications from persistently and historically oppressed groups, including Indigenous (First Nations, Métis or Inuit) peoples, members of racialized communities, persons with disabilities, women, gender-diverse, and persons who identify as 2SLGBTQ+. 

We acknowledge that the land Doctors of BC operates and supports physicians from is the traditional territories of the Coast Salish peoples including the Musqueam, Squamish, and Tsleil-Waututh Nations whose historical relationship with the land continues today. For Doctors of BC, acknowledging the land is an expression of cultural humility that involves recognizing our commitment to support the provision of culturally safe care to First Nations, Inuit, and Métis people in BC.