22 Nov
|
Manitoba Public Insurance
|
Winnipeg
22 Nov
Manitoba Public Insurance
Winnipeg
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.
Responsibilities : 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 helpful 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.
- 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.
Qualifications: 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 Tableau, Business Objects, PowerBI or similar Business Intelligence tools.
- Working knowledge of handling log or event streaming data sources.
- Knowledge of Data Science and Machine Learning concepts.
- Perform root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.
General
- Working knowledge of DevOps, DataOps, and Git.
- Working knowledge of container technologies e.g., Docker, and Kubernetes.
- Knowledge of additional programming languages (e.g., Java,.Net) and ETL tools (e.g., SSIS) would be an asset.
- Minimum of 4+ year experience in writing Stored Procedures and developing in tools such as Microsoft SQL Server.
- Advanced written and oral communications skills with the ability to convey technical informat
📌 Data Transformation Specialist (Winnipeg)
🏢 Manitoba Public Insurance
📍 Winnipeg