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