Senior Data Engineer ( SQL Server Developer )

At Ontario Health, we are committed to developing a strong organizational culture that connects and inspires all team members across the province. Our vision is that together, we will be a leader in health and wellness for all. Our mission is to connect the health system to drive improved and equitable health outcomes, experiences and value. How we work together is reflected through our five values: integrity, inspiration, tenacity, humility and care.

• Fully paid medical, dental and vision coverage from your first day

• a health care spending account

• a premium defined benefit pension plan

• three personal days and two float days annually

• three weeks' vacation to start (for individual contributors), increasing to four weeks after two years

• career development opportunities

• a collaborative values-based team culture

• a wellness program

• a hybrid working model

• participation in Communities of Inclusion

Want to make a difference in your career? Consider this opportunity.

Responsible for the design, development (new and upgrades), and support of data platforms and related components including schemas, reports, ETL packages/data transformation routines, stored procedures, and archival processes amongst others.
To lead the design and selection of appropriate solutions, write and implement efficient solutions, identify risks and issues and evaluates impact, and support the testing, production, and release processes.

Here is what you will be doing:

• Provides guidance, expertise, and mentoring to the Data Engineer I to discuss specific engineering practices and problems that may arise during day-to-day work.
• Provides context and perspective to their fellow Data Engineer I and Data Engineer II colleagues regarding engineering design decisions as well as business requirements that influence implementation details.
• Ensures a consistent approach to executing work assignments in a timely and competent manner.
• Accountable for workload, tasks and initiatives and for service quality within assigned work and within direct scope of operations.
• Leads the design and development of complex, large scale, and multi-platform environments, data architectures and entity relationships, and data movement and transformation solutions.
• Creates and maintains up to date documentation on architectural patterns and data standards.
• Recommends changes across the team's engineering practices as well as external team practices to improve the team's cycle time as well as lead time for the team's product backlog.
• Leads change processes for the adoption of new engineering practices across the team.
• Independently makes modifications or changes and/or recommendations to current processes and/or systems that impact other areas.
• Independently engages and actively participates in team discussion with product management teams to recommend product features and changes to product features to improve the user experience, operation and maintainability of the product.
• Works with a high level of autonomy within a defined project/solution/system scope based on direction from Lead Engineers, Architects, and Product Managers, exercising considerable latitude in determining objectives and strategies in support of goals.
• Participates in the development of engineering plans and systems specifications with Lead Engineers.
• Collaborates with internal peers to ensure alignment of practices, patterns, and solutions.
• Ensures work aligns to broader roadmaps and systems strategies.
• Stays abreast of evolving technology, architecture, and design, patterns, practices, and platforms.
• Occasionally has cross-portfolio and external stakeholder interactions.
• Makes decisions where results have high impacts across the organization requiring sophisticated solutions and long-term correction. Errors may have major or critical impact on overall service delivery and quality.

Here is what you will need to be successful:

Education and Experience

• Bachelor's or Master's degree in Computer Science, Information Technology, Computer Engineering or related field or equivalent experience.
• 5 - 7 years of extensive relevant technical experience developing data platforms solutions.
• In-depth knowledge of software development and software development Life Cycle (SDLC).
• Strong knowledge of agile development practices.
• In-depth knowledge of data models, data mining, and segmentation techniques.
• Expertise in multiple programming languages, databases, and big data technologies (e.g., Python, Java, R, etc.).
• Strong knowledge of relevant data query languages (e.g., SQL, KQL, etc.).
• In-depth knowledge of relevant data manipulation techniques.
• Strong knowledge of data analytics techniques to review and analyze existing data collection systems, and make recommendations on improvement, maintenance, or other factors to improve the system.
• Strong knowledge of data processing platforms (Spark, ADF, etc.).
• In-depth knowledge of database design using relational, document, object, big data, tabular, and other platform types.
• Strong operational knowledge of relevant data platforms in on-premises environments and cloud platforms.
• Excellent knowledge of best practices related to product deployment, operations, and support of databases and pipelines.
• Excellent knowledge of data security and data protection mechanisms.
• Strong knowledge and understanding of data management authorities and legislation relevant to health care in Ontario.

Knowledge and Skills

• Strong written and oral communication skills to provide guidance and mentoring to staff; communicate technical direction; discuss and incorporate stakeholder's feedback; communicate issues found and solutions clearly; create data mapping documentation; engage with the team and with product groups.
• Communications skills, both oral and written, to resolve problems and /or reach consensus through negotiation/persuasion, requiring active listening and collaboration to deliver solutions; to coach, guide and provide expertise to staff; create and maintain up to date internal and external operational documentation.
• Strong debugging, problem-solving, and analytical skills to identify and gather requirements; translate requirements into data systems and pipelines; assess and improve data query and pipeline performance; identify impact of changes to existing solutions or data assets; identify risks.
• Ability to use relevant software tools, frameworks, and platforms to develop databases and reliable data movement pipelines on-premises and in the cloud to meet identified business requirements and architectural specifications.
• Ability to perform quality assurance testing, data integrity validation, and risk assessment.
• Ability to apply data security and data protection mechanisms.
• Ability to develop control documentation and create run books to support product operations.
• Strong presentation skills to present materials for a variety of audiences with different levels of technical expertise.
• Strong analytical thinking, investigative and problem-solving skills where the full scope of issues and facts may not be clearly evident and require interpretation and modifications outside of normal existing processes and procedures.
• Ability to exercise.
• Ability to maintain in-depth knowledge of data engineering platforms and technologies.
• Project management and leadership skills to provide technical leadership / guidance to work closely with members of the product team, and other teams such as IT Operations, Cloud Centre of Excellence, Architecture and Security to ensure data services are implemented efficiently and securely.
• Ability to form internal relationships to ensure a comprehensive understanding of client current and projected needs in order to design short term and long-term solutions.
• Ability to assess and maintain data integrity and quality.
• Ability to collaborate with product team to deliver solutions using modern DevSecOps tools and best practices.
• Ability to communicate clearly within the team and with product groups.
• Ability to make decisions where results have a major impact across the organization. Errors in decisions impact internal and external stakeholders and their use of agency data in making program-related decisions. Errors in decisions require sophisticated solutions and are usually able to be corrected over the short to medium term (e.g., two to four weeks).
• Capacity to be aware of, control, and express one's emotions, and to handle interpersonal relationships judiciously and empathetically within product/project teams and with cross-portfolio and external stakeholder interactions.

#OH-IND-DIG
#LI- SR1
#LI-hybrid

Location: Ontario (currently hybrid; subject to change)
All applicants must be a resident of Ontario to be considered for roles at Ontario Health.

Employment Type:

Contract Length:

Salary Band:

External Application Deadline Date: