Senior Data Integrations Engineer (10+ years) to own source-to-target mapping and data integration

Our other industry client is seeking a Senior Data Integrations Engineer (10+ years) to own source-to-target mapping and data integration pipeline analysis

This role sits at the intersection of source systems and target data models, supporting the analysis, design, and documentation required for data integration pipelines. The position focuses on profiling incoming data, assessing the impact of new requirements on existing designs, and producing source-to-target mapping artifacts for engineering teams. Success in this role requires validating and translating new data requirements into transformation logic before pipeline development begins.

1 year Contract, Remote, Working Hours: EST

Must Haves

· Proven experience in data analysis, data profiling, and gap identification across heterogeneous source systems.

· Strong command of dimensional modeling (facts, dimensions, star/snowflake schemas, slowly changing dimensions).

· Working knowledge of Data Vault modeling (hubs, links, satellites) and its application to transformation logic.

· Demonstrated ability to perform impact analysis on existing data models and systems.

· Hands-on experience authoring Source-to-Target Mapping (STTM) documents.

· Solid SQL skills and comfort querying/profiling large datasets.

· Ability to assess requirement feasibility and communicate trade-offs to technical and business stakeholders.

· Strong written communication and documentation discipline.

Responsibilities

• Own the analysis, design, and documentation supporting data integration pipelines
• Profile incoming data from source systems
• Assess the impact of new requirements on existing designs
• Produce source-to-target mapping artifacts for engineering teams
• Validate new data requirements before pipeline development begins
• Translate validated requirements into transformation logic