Data Engineer (Hybrid)

at  Workplace Safety and Insurance Board

• The data engineers will design, build, integrate data from various sources and are the managers of big data within WSIB.
• Will write complex queries to ensure data is easily accessible, runs efficiently and optimizes the performance of the WSIB’s information management system.
• The data engineer will enable and support the design and architecture of big data warehouses and data sets
• Will build and maintain ETL on big data sets on MS Azure platform, utilizing Azure Data Factory, Synapse and delta lake technologies and concepts.

JOB REQUIREMENTS

Education

• University degree at the undergraduate level with a specialty focus in mathematics, statistics, computer science, business, engineering, information management or science.

Experience

• Five years prior experience in SQL Server, DB2, Oracle and related programming languages, business intelligence tools and data visualization software.

2. Design and build high quality information products and solutions, customized to client requirements

• Use a variety of programming languages (Java, SAS, Angular 2+, etc) in order to create user-friendly products and services in order to create comprehensive and detailed products to facilitate engagement with various stakeholders
• Run ETL on big data sets and support the creation of big data warehouses that are used by the analysts and data scientist, by using their extensive experience with data wrangling and data cleansing techniques
• Use modern methods to enhance the end user experience for analytical information products
• Recommend solutions to team members and senior management on how to best consolidate and retrieve data
• Where possible, build automation using Maven and NPM (node package manage

3. Lead front-end requirements and development of information and analytics projects

• Develop and deliver front-end visualization solutions that allow end users to interpret datasets in an easy-to-understand way
• Lead and/or perform front-end application development and maintenance, adhering to best practices and methodologies
• Provide application support and enhancements to existing CBIA application

1. Lead back-end development to define and build data pipelines

• Design, build, and integrate data from various sources and are the managers of big data within WSIB
• Integrate data from a variety of sources (both structured and unstructured data), assuring that they adhere to data quality and accessibility standards
• Responsible for defining the data model and building data hierarchy structures that will serve as the basis for business intelligence and analytics products and solutions
• Write complex queries to ensure data is easily accessible, runs efficiently and optimizes the performance of the WSIB’s system wide information management systems
• Enable and support the design and architecture of system wide information management systems

1. Design and build high quality information products and solutions, customized to client requirements

• Use a variety of programming languages (Java, SAS, Angular 2+, etc) in order to create user-friendly products and services in order to create comprehensive and detailed products to facilitate engagement with various stakeholders
• Run ETL on big data sets and support the creation of big data warehouses that are used by the analysts and data scientist, by using their extensive experience with data wrangling and data cleansing techniques
• Use modern methods to enhance the end user experience for analytical information products
• Recommend solutions to team members and senior management on how to best consolidate and retrieve data
• Where possible, build automation using Maven and NPM (node package manage)

1. Lead front-end requirements and development of information and analytics projects

• Develop and deliver front-end visualization solutions that allow end users to interpret datasets in an easy-to-understand way
• Lead and/or perform front-end application development and maintenance, adhering to best practices and methodologies
• Provide application support and enhancements to existing CBIA applications

1. Ensure all information and analytics projects adhere to WSIB standards and processes

• Manage data verification, leverage new data collection processes, and collaboration with subject matter experts to select the relevant sources of information
• Follow proper protocol when dealing with confidential data sets, and monitor the establishment of analytical data sets that combine various data sources with needed transformation to serve various analytical purposes
• Ensure data and analysis are methodologically sound and meet commonly accepted standards

1. Work independently on complex technical projects

• Build high quality mockups and design prototypes to influence and assist senior management in enterprise-wide product design decisions
• Effectively manage multiple projects and tasks at one time

1. Collaborate efficiently with various internal and external stakeholders and experts

• Work closely with other developers, user experience analysts, project managers, business analysts and senior management to design and implement products and tools based on the business requirements defined by internal and external clients
• Develop and maintain effective communication linkages, working relationships and collaborations with various business areas across the organization to identify needs and discuss and resolve issues.

1. Act as an expert in special technology projects and assignments

• Provide technical expertise and recommendations to management in the assessing software applications or tools in support of systems implementations and operations
• Provide a lead technical role during upgrades, modifications and defect/fixes on CBIA developed applications, and clearly communicate anticipated issues and mitigation strategies to stakeholder.
• Provide specialized technical advice, recommendations and information to internal and externals clients on proposed change requests and provide recommendations of alternative technical or functional application solutions
• Explore, investigate and leverage new technologies to explore solutions for legacy reporting issues and traditional, technologically-deprived challenges.
• Comprehensive understanding of software lifecycle including development, testing, release management and production monitoring

1. Other duties, as required