Data Engineer

Job Title: Senior Data Engineer
Job ID: 80594
Location: Regina, Saskatchewan

Overview:
Our government client in Regina, SK is looking for several Senior Data Engineers for a 9+ month contract to start, with possible  extensions, reference #C19003374. This position can be remote located anywhere in Canada.


What you will be doing:

• Design and build the infrastructure required for optimal extracting, transformation, and loading of data from a wide variety of data sources using Informatica, SQL, SSIS, 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.

What you must have:

• Possesses a bachelor’s degree in information technology, Engineering or Computer Science.

• Minimum of five (5) years of proven experience working as a Data Engineer or similar role.

• Experience using Informatica software (i.e., Power Centre, Integration Services, Workflow Manager, IDMC and TDM) in an integrated support environment.

• 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.

The ideal Resource(s) should have extensive experience with:

• Information management, logic modeling, conceptual, business process, and workflow design.

• Requirements gathering, analysis, plan, design, develop, implement and maintain Data Management systems.

• Critical, constructive and creative problem-solving skills that involve issue identification, development of objectives, development of an action plan overseeing what needs to done, while identifying the resources required to ensure quality products.

• Cloud platform for data management. It would be an asset for the ideal Resource(s) to have:

• Microsoft Certified: Azure Data Engineer Associate would be considered an asset.

• Experience working with healthcare data would be considered an asset

For more information about TEEMA and to consider other career opportunities, please visit our website at www.teemagroup.com