Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Senior Data Integrations Engineer To Support The Analysis, Design, And Documentation Of Enterprise D

S I Systems

Senior Data Integrations Engineer to support the analysis, design, and documentation of enterprise data integration solutionsJob Type:
Contract
Positions to fill:
1
Job End Date:
Nov 30, 2027
Pay Rate:
Hourly: Negotiable
Job ID:
155995
We are seeking a Senior Data 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.
Strong understanding of
dimensional data modeling, including fact and dimension tables, star/snowflake schemas, and Slowly Changing Dimensions (SCD).
Working knowledge of
Data Vault modeling, including hubs, links, satellites, and associated transformation logic.
Demonstrated experience performing data profiling, data quality assessments, and gap analysis across multiple source systems.
Experience conducting
impact analysis and feasibility assessments
for new data integration requirements.
Strong understanding of data integration concepts, ETL/ELT processes, data warehousing, and data transformation methodologies.
Ability to interpret complex business requirements and translate them into detailed technical data mapping specifications.
Experience working with data architects and engineering teams to support enterprise data integration initiatives.
Excellent analytical, troubleshooting, and problem-solving skills.
Strong technical documentation skills and attention to detail.
Excellent communication and stakeholder management skills, with the ability to explain complex data concepts to technical and non-technical audiences.
Nice-to-Have Qualifications
Experience with cloud-based data platforms such as
Snowflake or Databricks .
Familiarity with cloud data architectures and modern data integration frameworks.
Exposure to
data governance, data lineage, metadata management, and data cataloguing tools .
Experience with automated data profiling and data quality frameworks.
Knowledge of enterprise data warehouse architecture and modern data lakehouse environments.
Experience working in Agile delivery environments and collaborating with cross-functional data teams.
Ideal Candidate Profile
The ideal candidate is a technically strong
Data Integrations Engineer / Data Mapping Specialist
with extensive experience analyzing complex source data, defining transformation logic, and producing detailed Source-to-Target Mapping documentation.
They should possess advanced SQL capabilities, strong dimensional modeling knowledge, and practical experience with Data Vault methodologies.
The successful candidate will be able to independently assess data requirements, identify potential integration challenges, and deliver accurate technical specifications that enable data engineering teams to develop reliable, scalable, and high-quality data pipelines.
Key Success Factors
Identify and communicate source data issues early to minimize downstream development risks.
Ensure new requirements are assessed for technical feasibility and impact before development begins.
Deliver accurate, comprehensive, and actionable STTM documentation.
Define transformation logic aligned with dimensional and Data Vault modeling best practices.
Enable efficient and reliable data pipeline development through clear technical specifications and collaboration.
Position Overview
We are seeking a Senior Data 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.
Strong understanding of
dimensional data modeling, including fact and dimension tables, star/snowflake schemas, and Slowly Changing Dimensions (SCD).
Working knowledge of
Data Vault modeling, including hubs, links, satellites, and associated transformation logic.
Demonstrated experience performing data profiling, data quality assessments, and gap analysis across multiple source systems.
Experience conducting
impact analysis and feasibility assessments
for new data integration requirements.
Strong understanding of data integration concepts, ETL/ELT processes, data warehousing, and data transformation methodologies.
Ability to interpret complex business requirements and translate them into detailed technical data mapping specifications.
Experience working with data architects and engineering teams to support enterprise data integration initiatives.
Excellent analytical, troubleshooting, and problem-solving skills.
Strong technical documentation skills and attention to detail.
Excellent communication and stakeholder management skills, with the ability to explain complex data concepts to technical and non-technical audiences.
Nice-to-Have Qualifications
Experience with cloud-based data platforms such as
Snowflake or Databricks .
Familiarity with cloud data architectures and modern data integration frameworks.
Exposure to
data governance, data lineage, metadata management, and data cataloguing tools .
Experience with automated data profiling and data quality frameworks.
Knowledge of enterprise data warehouse architecture and modern data lakehouse environments.
Experience working in Agile delivery environments and collaborating with cross-functional data teams.
Ideal Candidate Profile
The ideal candidate is a technically strong
Data Integrations Engineer / Data Mapping Specialist
with extensive experience analyzing complex source data, defining transformation logic, and producing detailed Source-to-Target Mapping documentation.
They should possess advanced SQL capabilities, strong dimensional modeling knowledge, and practical experience with Data Vault methodologies.
The successful candidate will be able to independently assess data requirements, identify potential integration challenges, and deliver accurate technical specifications that enable data engineering teams to develop reliable, scalable, and high-quality data pipelines.
Key Success Factors
Identify and communicate source data issues early to minimize downstream development risks.
Ensure new requirements are assessed for technical feasibility and impact before development begins.
Deliver accurate, comprehensive, and actionable STTM documentation.
Define transformation logic aligned with dimensional and Data Vault modeling best practices.
Enable efficient and reliable data pipeline development through clear technical specifications and collaboration.
Disclaimer:
AI may be used in evaluating candidates.
This posting is for an existing vacancy.
#J-18808-Ljbffr
Vacancy posted 1 hour ago
Similar jobs that could be interesting for youBased on the Senior Data Integrations Engineer To Support The Analysis, Design, And Documentation Of Enterprise D in Winnipeg, MB vacancy
  • Drive enterprise data integration using advanced SQL, Python, and AWS while translating business requirements into technical solutions.This Data Engineer contract contributes to a large enterprise transformation across business-critical applications and workflows. You will... 
    Suggested
    Contract work

    Insight Global (United States)

    Winnipeg, MB
    1 hour ago
  • A multidisciplinary design and engineering firm in Vancouver is seeking a Structural Engineer for a full-time role. You will conduct structural analysis and design while preparing documentation and supporting senior staff. The ideal candidate should have a degree in Structural... 
    Senior
    Full time

    Recruitment By Design

    Winnipeg, MB
    1 hour ago
  • $140k - $160k per year

    Interested in joining one of Canada’s top performing asset managers? We are looking for a Senior Data Integration Engineer for an existing vacancy in our IT department, Connor, Clark & Lunn Financial Group (CC&LFG) is building an AI Enablement Team to accelerate the responsible... 
    Senior
    Internship
    Work at office
    Flexible hours

    Connor, Clark & Lunn Financial Group Ltd.

    Winnipeg, MB
    1 hour ago
  • Apply Logistics Support Analysis expertise to Combat Systems, leading LSAR reviews, supportability studies, and customer-facing...  ...requirements across product lifecycles.As a Senior Logistics Support Analysis Engineer, you will validate LSA processes and analyze new platforms... 
    Senior

    Lockheed Martin

    Winnipeg, MB
    1 hour ago
  • S.I. Systems Ltd. is seeking a Senior Data Integrations Engineer to support analysis, design, and documentation of enterprise data integration solutions. You will work with data engineering, data architecture, and business teams to analyze source systems and develop STTM documentation... 
    Senior
    Remote work

    S I Systems

    Winnipeg, MB
    1 hour ago
  •  ...Canada in Toronto, ON, is seeking a Solutions Engineer to drive the Industry Managed Solutions...  ...will work directly with subscribers to design and implement solutions, gaining deep...  .... As a business tech leader, you will document requirements, lead cross-department solution... 
    Long term contract

    GS1 Canada

    Winnipeg, MB
    1 hour ago
  •  ...startup founded by prominent Senior ISRO scientists and IIT Bombay...  ...20 years of experience in designing, manufacturing, testing and flying...  ...structures, ensuring integration with propulsion, avionics, and...  ...thermal systems. Structural Analysis & Load Evaluation Conduct... 
    Senior

    Astrobase Space Technologies

    Winnipeg, MB
    1 hour ago
  •  ...specialist in project management and engineering for large-scale programs, now counts,...  ...Group, acts as a trusted partner for designers and operators of major industrial systems...  ...in Reliability, Systems Engineering, Integrated Logistics Support (ILS), Technical Documentation,... 
    Senior

    LGM North America

    Winnipeg, MB
    4 hours ago
  •  ...MBLL is seeking a Senior Solution Architect – Integrations to define and govern enterprise integration architecture and strategies. You will lead a team to design scalable data movement patterns, integrate SaaS and legacy systems, and ensure alignment with MBLL goals and security... 
    Senior

    Cambrian College

    Winnipeg, MB
    1 hour ago
  •  ...Hiring Organization: Rose International Position Number: 508785 Industry: Government Job Title: Senior Data Architect (Databricks, Azure & Enterprise Data Integration) Job Location: Remote, Canada Work Model: Remote Shift: 8:15 to 4:30 Alberta time... 
    Senior
    Hourly pay
    Full time
    Temporary work
    Remote work
    Shift work

    Rose International

    Winnipeg, MB
    1 hour ago
  • $75k - $90k per year

     ...future of care. The OpportunityThe Senior Technical Writer owns documentation for one or more product areas of...  ...the content strategy behind how the Support Center as a whole is structured. It...  ...platform behavior, including integrations, identity and permissions, and net‑... 
    Senior
    Remote work
    Flexible hours

    Fullscript

    Winnipeg, MB
    1 hour ago
  •  ...supervision, plans and executes the engineering activities assigned by the...  ...evaluation of piping systems supports (nuclear class or non-nuclear...  .... Review of technical documents and drawings (e.G. equipment...  ...diagrams and P&ID), calculations, design/analysis reports, design... 
    Senior
    Internship
    Flexible hours

    AtkinsRéalis Group

    Winnipeg, MB
    1 hour ago
  • Talend integration and enterprise data delivery define this remote Edmonton contract. Bring TMC, runtime infrastructure, Git-based SDLC, and production support experience.Supreme International is seeking Intermediate and Senior Data Engineers for six-month Government of Alberta... 
    Senior
    Contract work
    Remote work

    Compu-Vision Consulting Inc.

    Winnipeg, MB
    1 hour ago
  •  ...and research moves at the speed of its data. LanceDB is the AI-native Multimodal Lakehouse...  ...vehicles. About The RoleAs the Documentation Engineer at LanceDB, you will make Lance and...  ...opportunity to define how documentation supports a growing ecosystem of AI-assisted development... 
    Senior

    LanceDB

    Winnipeg, MB
    1 hour ago
  • Join our team as a Senior Structures Design Integration Engineer, where your leadership will shape airframe design and enhance aircraft development programs. Drive structural efficiency through your expertise in metallic and composite structures while overseeing the design... 
    Senior

    Segula Technologies

    Winnipeg, MB
    1 hour ago
  • Become a Senior Engineer for Structures Design Integration at Bombardier and shape the future of aerospace innovation. Lead complex aircraft structural projects through detailed design and technical collaboration. Bombardier seeks a proficient Senior Engineer to guide the... 
    Senior

    Bombardier

    Winnipeg, MB
    1 hour ago
  • Apply pipeline integrity expertise to corrosion analysis at TC Energy, using Inline Inspection data for gas transmission pipelines in a hybrid work model.The Pipeline Integrity Engineer/Technologist analyzes anomaly data and supports integrity program planning. You will use... 

    TC Energy Corp.

    Winnipeg, MB
    1 hour ago
  •  ...PositionNorthleaf is seeking an experienced integration leader to own and evolve the firm's enterprise integration capability. This role...  ...scalable, modern patterns for data exchange across internal systems...  ...Delivery & Execution Lead the design and delivery of complex... 
    Long term contract
    Remote work
    Flexible hours
    2 days per week

    Northleaf Capital Partners

    Winnipeg, MB
    1 hour ago
  • $110k per year

     ...experience. About the Team: The Data & Analytics team is moving...  ...data foundations that support internal decision-making, customer...  ...quality standards, and creating engineering patterns that let analytics,...  ...confidence. About the Role: The Senior Data Engineer will design,... 
    Senior
    Full time

    iQmetrix

    Winnipeg, MB
    a month ago
  •  ...Recruitment is partnering with a Vancouver-headquartered enterprise software company to hire a Senior Solutions Engineer. This role sits between bank partners, product, and...  ...across implementations. You will lead scoping, design discussions, and launch plans with partners, while... 
    Senior

    Metrics Recruitment

    Winnipeg, MB
    1 hour ago
  • Lead enterprise integration and full-stack development as a senior Applications Development Technology Lead Analyst at Citi. Apply Java, Spring, and AI-assisted engineering expertise.This senior-level technology role leads application design, implementation, and enhancement... 
    Senior

    Citi

    Winnipeg, MB
    1 hour ago
  • $113.68k - $155.22k per year

    Join to apply for the SENIOR DATA SOLUTIONS INTEGRATOR role at City of Toronto .This range is provided by City of Toronto. Your actual pay...  ....00/yr - CA$155,216.00/yrJob ID: 57235Job Category: Engineering & TechnicalDivision & Section: Social Development, HSI... 
    Senior
    Permanent employment
    Full time
    Internship

    Toronto

    Winnipeg, MB
    1 hour ago
  •  ...aspirations are met.As a Mechanical Engineer on our team you will have the opportunity to design and develop heavy industrial...  ...designs and apply finite element analysis (FEA) techniques to the...  ...components to assess structural integrity and suitability of designsCollaborate... 
    Work from home

    FLSmidth

    Winnipeg, MB
    1 hour ago
  • Connect Salesforce, Workday, NetSuite, and other enterprise platforms as EverCommerce’s Canada-based Staff Engineer working fully remotely.This senior technical leadership role focuses on reliable SaaS integrations, business operations, and secure enterprise delivery. You will... 
    Senior
    Remote work

    Jobgether

    Winnipeg, MB
    1 hour ago
  • $85k - $100k per year

     ...the United States. Position Description The Senior DfMA Designer plays a key role within the VDC/Engineering group, reporting directly to the Fabrication Design...  ...optimized for CLT and Glulam fabrication. Support process, template, catalog, and modeling standard... 
    Senior
    Internship

    Mercer Mass Timber LLC

    Winnipeg, MB
    1 day ago
  • Shape enterprise integration requirements in Montreal through data mapping, system-flow documentation, and bilingual stakeholder engagement.ML arteka needs an experienced professional combining business analysis and delivery leadership for enterprise integration. You will examine... 

    ML arteka

    Winnipeg, MB
    1 hour ago
  • Engineer dependable data integrations using SQL, Python, and Azure Data Factory for Amphenol High Speed Products Group in Markham. Build governed services.As a Data Engineer, you will connect enterprise applications, databases, APIs, and files while supporting production reliability... 

    Amphenol ICC

    Winnipeg, MB
    1 hour ago
  •  ...Cyber Support Engineer Winnipeg, MB Manitoba Hydro is consistently recognized as one of Manitoba...  ...: Responsible for leading the design, support, maintenance, architecture, and...  ...complex work and compliance processes for analysis and optimization. Implement, deploy, and... 
    Hourly pay
    Long term contract
    Permanent employment
    Internship

    Manitoba Hydro

    Winnipeg, MB
    1 day ago
  • Extendicare is seeking a Senior Data Engineer to design and build scalable data integration solutions in a hybrid Markham-based role. You will lead ETL development using SQL Server, SSIS, Python, and Azure, while supporting cloud transformation and on-prem data migration efforts... 
    Senior

    111000 Extendicare (Canada) Inc.

    Winnipeg, MB
    1 hour ago
  •  ...technology for 40+ charity clients across Canada and the US via payment/CRM integrations, our tablet app (Insight), and Azure/SQL Server data pipelines. We are seeking a Senior Integrations Engineer to own the architecture, delivery, and reliability of secure, PCI-... 
    Senior
    Long term contract
    Flexible hours

    Globalfaces Direct

    Winnipeg, MB
    1 hour ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Senior Data Integrations Engineer To Support The Analysis, Design, And Documentation Of Enterprise D. Be the first to apply!