Data Engineer

Job Description

Salary range: The salary range for this position is CAD $44.14 - $63.45 / hour Why Fraser Health?: Fraser Health is responsible for the delivery of hospital and community-based health services to over 1.9 million people in 20 diverse communities from Burnaby to Fraser Canyon on the traditional territories of the Coast Salish and Nlaka’pamux Nations. Our team of 45,000 staff, medical staff and volunteers is dedicated to serving our patients, families and communities to deliver on our vision: Better health, best in health care. At System Optimization department of Fraser Health, we are looking for a Senior Data Engineer to join our agile and fast paced team. Reporting to the Data Engineering & Infrastructure Manager, this position is part of the team responsible for developing and maintaining ETL pipelines, developing data models and supporting the creation of a hybrid cloud model. A Senior Data Engineer leads the team across our data strategy, analysis, data integration, and data management. The work performed has a significant impact on the delivery and use of our data products to the organization. The Senior Data Engineer will rely on extensive background and experience in data modeling and building traditional and distributed data pipelines to help guide and explore new grounds in adopting new tools to improve System Optimization’s Data Lake and relevant infrastructure. We currently have 4 Full Time vacancies for this role. We offer the option of hybrid work with in office days based at our Central City offices in Surrey, BC, with access to rapid transit, shopping, restaurants, on-site gym and other amenities. Job duties: Lead the evolution and ensure the performance of our System Optimization Data Lake Prepare technical documents and oversee technical issues Identify areas for improvement and provide solutions Clarify program intent and requirements with various personnel, and suggest changes Guide cloud migration from on premise SQL servers to MS Azure Liaise with various data source teams and stakeholders, assisting with data and technical issues Develop and align ETL/ELT processes to current and developing architecture Perform complex programming and data structure alterations Strive for code quality improvement and self-learn new technologies Translate business issues into technical terms and implement best practices Collaborate with cross-functional teams to produce optimal solutions Anticipate system challenges and propose solutions Contribute to work estimates and participate in design and code reviews Provide mentorship for junior Data Engineering team members. Qualifications: Bachelor's degree in Health Information Science, Computer Science, Software Engineering or a related study Seven (7) years of related experience in a large complex organization A good understanding of modern data platforms with proven experience in assembling large, complex sets of data that meets non-functional and functional business requirements using a variety of languages. An equivalent combination of education, training and experience may be considered. Preference will be given to candidates with experience in: Five years of data engineering experience or equivalent combination of education, training, and experience. Hands-on experience with scripting, analytics, and Microsoft BI tools (SQL, Python, PowerShell, JavaScript, SSIS, SSAS, SSRS, PowerBI) Understanding of data platforms including data lakes and data warehouses Experience assembling large, complex data sets that meet business requirements Proficiency in integration, modelling, and orchestration of complex data; optimization and automation skills required Expertise in designing and optimizing data table structures, reports, and queries Knowledge of performance tuning and troubleshooting in ambiguous environments Experience with Azure DevOps, Azure Data Factory, and Azure Synapse is a plus Ability to design, implement, and monitor best practices for Dev framework Experience with large volume data; Healthcare data experience is a plus Effective October 26th 2021, all new hires to Fraser Health will need to have full COVID 19 vaccination (have received a full series of a World Health Organization “WHO” approved vaccine against infection by SARS-COV-2, or a combination of approved WHO vaccines). Please note this applies to all postings, and individual medical exemptions must be approved by the Provincial Health Officer. Curious to learn what it’s like to work here? Like us on Facebook (@fraserhealthcareers), follow us on Twitter & Instagram (@FHCareer), or connect with us on LinkedIn (fraserhealthcareers) for first-hand employee insights. Detailed Overview: Supporting the Vision, Values, Purpose and Commitments of Fraser Health including service delivery that is centered around patients/clients/residents and families: The Senior Data Engineer provides senior consulting to Fraser Health executive within an assigned portfolio in the areas of data and data management, decision support and in corporate business areas which may include the development and implementation of application architecture. Leads enterprise-wide information systems projects; manages timelines and resources; provides leadership to team members and may facilitate change management strategies as part of the project. Coordinates the procurement and management of external services. Manages assigned staff. A Senior Data Engineer leads the team across our data strategy, analysis, data integration, and data management. Responsibilities: Provides senior data engineering services to all disciplines and partners within an assigned portfolio by keeping abreast of the initiatives and issues within the business areas assigned and leading the business area through developing business cases, process reengineering initiatives, etc. Formulates project plans with the business areas and/or provides input into operational or strategic plans. Ensures that projects and initiatives are aligned with the Fraser Health's Strategic direction. Provides project leadership to a variety of large, complex projects including a number of diverse disciplines and/or affecting multiple partners; develops and manages project timelines; facilitates change management strategies; defines tasks; identifies, sources and manages resources such as contractors, staff or dollars; identifies and mitigates project related risks; provides guidance to team members. Ensures project closure by providing post-implementation evaluation; measuring key outcomes, assessing project related staff, ensuring customer satisfaction, obtaining project sign off, and documenting lessons learned. Provides leadership to staff assigned to lead small to medium scale projects by providing guidance on project requirements, budget management, or technical issues; receives updates from assigned team leaders on project status. Provides input into project budget development and, once approved, manages the budget dollars by approving required contractors, purchasing software and hardware. Monitors and reports on budget variances if necessary and discusses with project sponsor as required. Liaises and communicates with project sponsors and partners by monitoring and reporting on all phases of projects to ensure success and to increase overall quality of products implemented. Provides updates on project status and all aspects of the project as required. Manages assigned projects using standard documentation methodologies. Manages assigned staff by selecting, supervising, and evaluating staff; assigns, evaluates and monitors work assignments; disciplines staff as necessary and initiates terminations; assesses and recommends staffing requirements; orients staff; authorize leaves of absences and approves overtime as necessary. Champions data management methodologies and best practices through mentoring, coaching, and communicating with team members, business units and staff. Researches and analyzes market, technology, and industry trends and standards related to technologies for the purposes of collaboration in problem solving merging business needs with a focus on leveraging data. Provides recommendations on the use and evolution of applications and tools. Provides expert advice and consultation by performing or managing the research, analysis, and recommendations for proposed technology changes. Provides input into development and into the use of new technology for inclusion in the technology architecture. Provides consultation and advice to senior management on technology alternatives and solutions. Develops annual goals and objectives for the area of responsibility, in collaboration with the Manager, ensuring consistency with department plans and authority objectives and strategies. Responsible for collaborating with teams to advise, design, and implement the data infrastructure and systems to support the organization's data-driven initiatives. Responsible for developing and maintaining ETL pipelines, developing data models and supporting the creation of a hybrid cloud model. Applying performance tuning and optimization, perform bottleneck problems analysis, and technical troubleshooting. Participates in assigned Fraser Health, Provincial, and Federal committees; chairs and/or leads discussion as required. Performs other related duties as required. Qualifications: Bachelor's degree in Health Information Science, Computer Science, Software Engineering or a related study or equivalent combination of education, training and experience. Seven (7) years of related experience in a large complex organization. A good understanding of modern data platforms with proven experience in assembling large, complex sets of data that meets non-functional and functional business requirements using a variety of languages. COMPETENCIES: Demonstrates the leadership practices of the Fraser Health Leadership Framework of Clear, Caring and Courageous and creates the conditions for people to succeed. Professional/Technical Capabilities Ability to provide leadership to a variety of large project teams in an environment that constantly changes and that has fluctuating priorities. Advanced knowledge of information management, business processes, technologies and applications. Knowledge of all components of a technical architecture. Ability to translate business needs into application architecture requirements. Ability to quickly comprehend the functions and capabilities of new technologies. Demonstrated knowledge of the project management process and the systems development life cycle. Ability to be organized, goal-oriented, proactive, solution-oriented, pragmatic, and the ability to understand the long-term and short-term perspectives. Diplomatic negotiation skills and the ability to influence. Understanding of and the ability to manage the political climate of the organization. Ability to provide input into project budget development, manage assigned dollars and estimate financial impact of application architecture alternatives. Demonstrated decision making ability within complex and diverse issues. Physical ability to perform the duties of the position.