Data Analyst: Data Governance & Lineage

SMX; Trenton (NJ); On-site; USD 65,000 - 108,000; Full time

Benefits offered by this job

Health Insurance

Paid leave

Retirement

Job summary

SMX is hiring a Data Analyst to profile data sources, document data lineage, and map data to a canonical domain model that powers enterprise data products, APIs, and analytics.

The role collaborates with data engineers, architects, and build teams to translate how data is structured and moves — from source systems through transformation to consumption — into clear, well-governed specifications that enable trusted, reusable enterprise data.

Qualifications

• Bachelor’s degree in Computer Science, Information Technology, Data Engineering, Information Systems, or a related field.
• 2–6 years of professional experience in data analysis, data mapping, data modeling, or a related data role.
• Strong SQL skills and the ability to profile, query, and analyze data across multiple source systems.
• Experience with data mapping and source-to-target documentation.
• Working knowledge of data modeling and domain/canonical data models, schema design, and database design concepts.
• Understanding of the end-to-end data lifecycle and how data moves across integrated systems.
• Familiarity with API schema design and how data elements map to API contracts.
• Strong technical writing skills and the ability to communicate requirements to both technical and non-technical audiences.

Responsibilities

• Profile data sources to assess structure, quality, completeness, and relationships, and document findings that inform mapping and design decisions.
• Document end-to-end data lineage — tracing how data moves across systems through its full lifecycle, from origin through transformation to consumption.
• Align source data to a canonical/domain data model, mapping source elements to target structures to support database design and consistent enterprise definitions.
• Apply data elements to API schema design, translating business and data requirements into schemas that build teams can implement.
• Develop and document data rules — standardization, validation, and quality rules — and apply Master Data Management (MDM) and well-managed data practices.
• Produce clear technical documentation (source-to-target mappings, data dictionaries, metadata, and lineage artifacts) that other teams can build from.
• Communicate technical requirements to engineering and build teams, and gather and clarify data requirements directly with clients and stakeholders.
• Collaborate with data engineers, architects, and analysts to ensure mapped data meets downstream needs for products, APIs, and analytics.

Skills

SQL

Data mapping

Data modeling

Data profiling

Technical writing

End-to-end data lifecycle

Education

Bachelor’s degree in Computer Science / Information Technology / Data Engineering / Information Systems

Tools

Databricks

Snowflake

AWS

Job description

SMX is hiring a Data Analyst to profile data sources, document data lineage, and map data to a canonical domain model that powers enterprise data products, APIs, and analytics.

The role collaborates with data engineers, architects, and build teams to translate how data is structured and moves — from source systems through transformation to consumption — into clear, well-governed specifications that enable trusted, reusable enterprise data.