Data Transformation Specialist

Overview

Data Transformation Specialist will help build, scale, and maintain MPI’s business intelligence and data science platform. The position will scale the corporation’s cloud and on-premises infrastructure, improve tools used by analysts and data scientists, streamline data feeds processes, and help improve data quality.

This Data Transformation Specialist plays a key role in elevating the business intelligence and data science delivery by building reliable pipelines and infrastructure to help the team improve modelling efficiency and consistency of data.

Data Transformation and Engineering

• Contributes to data pipelines by implementing a solid, robust, extensible design that supports key business flows.
• Performs data transformations to populate data-hub, data-lake, data warehouse, reporting databases and downstream data marts.
• Identifies technical requirements and delivers solutions by establishing efficient design and programming patterns that meet Service Level Agreements (SLAs) and help manage the data platform.
• Responsible for finding trends in data sets and developing algorithms to help make raw data more useful to the enterprise.
• Designs, integrates, and documents technical components for seamless data extraction and analysis.
• Presents insights on data and its quality via presentations, visualizations, and whitepapers.
• Actively promotes automation of data quality, proposes, and implements solutions.
• Supports the corporation’s broader technical and operational requirements by adopting best practices in our data systems.
• Works in a team environment, interacting with multiple groups daily, within the department, as well as throughout the corporation.

Support Analytics and Data Science Capabilities

• Works with business stakeholders to establish an understanding of the business and determine the data needs of the business.
• Communicates challenges and requirements to subject matter experts and clients, providing clear objectives over estimated timeline.
• Facilitates effective communication between business stakeholders and technology resources. Translates complex technology information into simple, clear, and accurate language to ensure understanding by stakeholders.
• Provides training to MPI system users, as required.
• Remains up-to-date on recent technologies that maximize the speed, performance, and access to data for analytics and machine learning and reducing costs.
• Responds to ad-hoc client requests.
• Leads projects from conception to completion and provides leadership to project resources.
• Provides training on data modelling and on the maintenance of data quality to analysts and project resources.
• Focuses on continuous learning, experimenting, applying, and contributing towards cutting edge open source data technologies and software.

Education:

• Degree in Computer Science, Information Technology, or related technical discipline.

Experience:

• Five years of progressive experience performing relevant data transformation and engineering work, including:
• Three years of related experience in general data management, such as data architecture, integration, warehousing, or analytics.
• Two years of experience with the Cloud.
• Experience in a leadership capacity is an asset.
• Experience with virtualization in an enterprise environment is an asset.
• Experience in the insurance or finance industry is an asset.

Technical Knowledge and

Skills:

Cloud Platforms

• Working knowledge of cloud platforms, Microsoft Azure or similar cloud-hosted databases such as AWS Redshift, Snowflake.
• Working knowledge of architecting efficient framework and optimization designs for analytics platforms, data warehouse design, virtualization, pipelines, ELT, ETL, SSIS packages.
• Intermediate knowledge of big data, distributed computing, data pipelines, dimensional modelling, columnar and row-based databases, data visualization, machine learning, and data layer designs.
• Strong knowledge of Python, and high proficiency to design and develop ELT pipelines using Spark and Databricks
• Working knowledge and ability to program in XML.
• Working knowledge of Duck Creek Insights and its XML mapping are assets.

Data Analytics

• Working knowledge of…