Job Details: Remote Full-time Experienced 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 #Information Technology jobs