Senior Data Integrations Engineer to support the analysis, design, and documentation of enterprise data integration solutions (Canada)

Senior Data Integrations Engineer to support the analysis, design, and documentation of enterprise data integration solutions (Canada)

13 Nov
|
S.i. Systems
|
Canada

13 Nov

S.i. Systems

Canada

Senior Data Integrations Engineer to support the analysis, design, and documentation of enterprise data integration solutions

Job Type: Contract

Positions to fill: 1

Job End Date: Nov 30, 2027

Pay Rate: Hourly: Negotiable

Job ID: 155995

We are seeking a SeniorData Integrations Engineer to support the analysis, design, and documentation of enterprise data integration solutions. The successful candidate will work closely with data engineering, data architecture, and business teams to analyze source systems, assess data requirements, and develop detailed Source-to-Target Mapping (STTM) documentation to support data pipeline development.

This role requires strong expertise in SQL, data profiling, dimensional data modeling, Data Vault methodology, impact analysis, and data transformation logic. The ideal candidate will have experience working with complex data environments and translating business requirements into clear, accurate technical specifications for engineering teams.

Number of openings - 2

Duration - 1 year

Start - ASAP

Work Mode - Remote

Key Responsibilities

Data Analysis & Profiling

- Analyze and profile data from multiple source systems to understand data structures, relationships, and quality.
- Identify data gaps, inconsistencies, anomalies, and potential data quality issues.
- Perform detailed SQL queries to validate source data and support transformation requirements.
- Collaborate with business and technical stakeholders to investigate data discrepancies and recommend solutions.
- Document source data findings and provide actionable insights to support downstream data integration activities.

Source-to-Target Mapping (STTM)



& Transformation Design

- Develop, maintain, and validate comprehensive Source-to-Target Mapping (STTM) documentation for enterprise data integration pipelines.
- Translate business and technical requirements into detailed data mapping specifications and transformation rules.
- Define transformation logic based on target data models, including data cleansing, standardization, aggregation, and validation rules.
- Apply dimensional modeling techniques, including fact tables, dimension tables, star and snowflake schemas, and Slowly Changing Dimensions (SCD).
- Leverage Data Vault modeling concepts, including hubs, links, and satellites, to define transformation logic where applicable.
- Ensure STTM documentation is accurate, complete, and aligned with enterprise data architecture standards.
- Work closely with data engineers to clarify mapping requirements and support successful pipeline implementation.

Impact Analysis & Feasibility Assessment

- Conduct detailed impact assessments to determine how new business requirements affect existing data models, integrations, and source systems.
- Identify dependencies, potential risks, and required changes to existing data integration designs.




- Evaluate the technical feasibility of new data requirements within the existing system architecture.
- Recommend alternative approaches when requirements cannot be supported by current data models or integration frameworks.
- Document findings, technical considerations, and recommended solutions for business and technology stakeholders.

Data Quality & Collaboration

- Collaborate with data architects, data engineers, business analysts, and data governance teams to ensure consistency across data integration solutions.
- Validate data mapping specifications and transformation rules against business requirements.
- Support data quality assessments and contribute to the development of data validation rules.
- Assist engineering teams in troubleshooting data mapping and transformation issues.
- Maintain detailed technical documentation, including data mappings, transformation specifications, impact assessments, and data analysis findings.
- Ensure alignment with enterprise data governance, metadata management, and data quality standards.

Required Qualifications & Technical Skills

- Proven experience in Data Integration, Data Analysis, Data Engineering, or Data Mapping within complex enterprise environments.
- Strong hands-on experience with Source-to-Target Mapping (STTM) documentation and data transformation specifications.
- Advanced SQL skills, including complex queries, joins, aggregations, and data profiling across large datasets.
- Solid understanding of dimensional data modeling, including fact and dimension tables, star/snowflake schemas, and Slowly Changing Dimensions (SCD)

📌 Senior Data Integrations Engineer to support the analysis, design, and documentation of enterprise data integration solutions (Canada)
🏢 S.i. Systems
📍 Canada

Reply to this offer

Impress this employer describing Your skills and abilities, fill out the form below and leave Your personal touch in the presentation letter.

Subscribe to this job alert:

Get the latest job offers by email for: senior data integrations engineer to support the analysis, design, and documentation of enterprise data integration solutions (canada) / canada

Subscribe to this job alert:

Get the latest job offers by email for: senior data integrations engineer to support the analysis, design, and documentation of enterprise data integration solutions (canada) / canada