Data Engineer

Our government client in Regina, SK is looking for several Senior Data Engineers for a 9+ mth contract to start, with

possible extensions, reference #C19003374. This position can be remote located anywhere in Canada

Things You Need To 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.
  
  

Rated Resource Qualifications/Requirements

• 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
  
  

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.
  
  

For information about TEEMA Solutions Group and to consider other career opportunities, please visit

our website at www.teemagroup.com