This list contains only the countries for which job offers have been published in the selected language (e.g., in the French version, only job offers written in French are displayed, and in the English version, only those in English).
We are seeking a Senior Data Engineers to join our client's team. We need a highly skilled and adaptable professional to support a diverse range of technology-driven projects across our organization. This is a dynamic role where you'll apply your expertise in a fast-paced environment, working with various teams and leaders to deliver successful outcomes.
Job Responsibility:
Design and build the infrastructure required for optimal extracting, transformation, and loading of data from a wide variety of data sources using Informatica, Structured Query Language (SQL), SQL Server Integration Services (SSIS), Application Programming Interface (API) and other technologies
Architect relational and multi-dimensional databases from structured, semi-structured and unstructured data with development techniques including star and snowflake schemas, ETL, Slow Changing Dimensions (SCD), Fact and Cube development in a data management framework in conjunction with the Provincial Data Platform Infrastructure
Identify, design and implement internal process improvements: automate manual processes, optimize data delivery, re-design data pipelines for greater scalability
Build analytics tools that utilize the data pipeline to provide actionable insights into customer acquisition, operational efficiencies, and other key business performance metrics
Develop, maintain, optimize, troubleshoot, debug, monitor, backup and recovery operations for the ETL environment
Analyze datasets to ensure compliance with data sharing agreements and legislation restrictions, and for alignment with data architecture guidelines
Mentor, support and train Information Analyst and Junior Data Management resources, as required
Requirements:
Minimum of five (5) years of proven experience working as a Data Engineer or similar role
Possess a bachelor’s degree in information technology, Engineering or Computer Science, or a diploma in related data management/information technology stream with three (3) additional years of experience (over the required five (5) years) working as a Data Engineer or similar role
Minimum of two (2) years of proven experience using Informatica software (i.e., Power Centre, Integration Services, Workflow Manager, IDMC and TDM) in an integrated support environment
Expert knowledge of: Oracle and SQL Server Database Management Systems and tools
ETL and data pipeline development experience
providing technical consulting and guidance to development teams for the design and development of highly complex or critical ETL architecture
Computer programming languages such as PL/SQL, R, Python
Operating systems such as Unix, Linux, and Windows
Shell Scripting language
Data Application Programming Interface (API)
Algorithms and data structures
What we offer:
Opportunity to lead and shape the modernization of platforms
Collaborative environment working closely with stakeholders from various business areas and Information Management & Technology team
Chance to develop and implement cutting-edge solutions
Platform to showcase excellent presentation skills by regularly updating and engaging with project stakeholders and IT leadership