Senior Data Engineer
Senior Data Engineer
Employer Active
Job Alert
You will be updated with latest job alerts via email
Share
Job Alert
You will be updated with latest job alerts via email
Job Description
Pour obtenir une traduction en franais de loffre demploi suivante veuillez envoyer un courriel . Les demandes seront traites dans un dlai de trois jours ouvrables et la priode de dpt des demandes sera prolonge de trois jours.
To obtain a French translation of the following job posting please email . Requests will be addressed within three business days and the application window will be extended by three business days.
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.
What Ontario Health offers:
Achieving your career goals is a priority to us. Benefits of working at Ontario Health may include the following based on employment type:
Fully paid medical dental and vision coverage from your first day
a health care spending or wellness 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 valuesbased 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.
Data Engineer II is 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. As part of this role the Data Engineer gathers and reviews requirements plays an active role and takes the lead in designing and selecting appropriate solutions writes and implements efficient solutions identifies any risks and issues and evaluates impact and supports the testing productization and release processes. A strong collaborative working relationship with the Architects Software Engineers Quality Engineers and other team members is essential.
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 daytoday 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.
- Recommends changes across the teams engineering practices as well as external team practices to improve the teams cycle time as well as lead time for the teams product backlog.
- Collaborating with Quality Assurance DBAs and Release management teams for implementation.
- Leads change processes for the adoption of new engineering practices across the team.
- 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.
- 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 crossportfolio and external stakeholder interactions.
- Makes decisions where results have major impact across the organization requiring sophisticated solutions and longterm correction.
- Provides work estimates for their own development tasks and verifies works estimates of others development tasks on project plans.
- Provides updates on tasks via discussions and status reports.
- Identifies risks and escalates to project leadership on a timely basis.
- Maintain uptodate knowledge of emerging tools including investigation and guidance with new/emerging technologies (POCs) and applying them to data engineering solutions as appropriate.
- Responsible for creating detailed technical documentation for end users.
Here is what you will need to be successful:
Education and Experience:
- Bachelors or Masters 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.
- Experience with Informatica PowerCenter.
- Experience using Informatica Intelligent Cloud Services (IICS) Big Data Management.
- Experience with relational database systems: Oracle and SQL Server.
- Experience in designing developing and implementing data solutions in Cloud preferably Microsoft Azure: Synapse Databricks including storage in Azure Data Lake (Gen 2.
- Experience in Windows PowerShell and Unix/Linux Bash shell scripting.
- Indepth knowledge of software development and software development Life Cycle (SDLC).
- Strong knowledge of agile development practices.
- Indepth knowledge of data models data mining and segmentation techniques.
- Strong knowledge of relevant programming languages (e.g. Python Java etc..
- Strong knowledge of relevant data query languages (e.g. SQL KQL etc..
- Indepth knowledge of relevant data manipulation techniques.
- Strong knowledge of data analytics techniques.
- Indepth knowledge of database design using relational document object big data tabular and other platform types.
- Strong operational knowledge of relevant data platforms in onpremises 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 stakeholders feedback; communicate issues found and solutions clearly; create data mapping documentation; engage with the team and with product groups.
- Strong debugging problemsolving 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 data movement pipelines onpremises 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 and negotiation skills.
- Capability to design and develop complex large scale and multiplatform environments.
- Strong research and analysis skills.
- Ability to maintain indepth knowledge of data engineering platforms and technologies.
- Ability 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 design complex data architectures and entity relationships. Ability to design complex data movement and transformation solutions.
- Ability to assess and maintain data integrity and quality.
- Ability to collaborate with product team to deliver solutions using modern DevOps tools and best practices.
- Ability to create and maintain up to date documentation on architectural patterns and data standards.
- Ability to communicate clearly within the team and with product groups.
- Ability to make decisions where results have a major impact across the organization.
- Capacity to be aware of control and express ones emotions and to handle interpersonal relationships judiciously and empathetically within product/project teams and with crossportfolio and external stakeholder interactions.
#LIhybrid
#LI AP1
#OHINDDIG
Location: Ontario (currently hybrid; subject to change)
Employment Type:
Temporary (Fixed Term) Full timeContract Length:
12 Month(s)Salary Band:
Band 6External Application Deadline Date:
April 17 2025All applicants must be a resident of Ontario to be considered for roles at Ontario Health.
Ontario Health encourages applications from candidates who are First Nations Mtis Inuit and urban Indigenous; Francophone; members ofBlack and racializedgroups; 2SLGBTQIA communities; trans and nonbinary individuals;and people living with disabilities.
Ontario Health is an accessible employer and we offer accommodation in all aspects of employment including the recruitment process. If you require a disability related accommodation in order to participate in the recruitment process please email and a member of the team will connect with you within 48 hours.
Required Experience:
Senior IC
Employment Type
Full-Time
