Data Analyst: Data Lineage, Modeling & API Schemas

SMX; Austin (TX); 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 align data to a canonical domain model that powers enterprise data products, APIs, and analytics.

You will work closely with data engineers, architects, and build teams to translate how data is structured and how it moves into clear, well-governed specifications, turning fragmented source data into standardized, trustworthy data for the enterprise.

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 profiling

Data mapping

Data modeling

Technical writing

API design

Education

Bachelor's degree in CS/IT/Data-related field

Job description

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

You will work closely with data engineers, architects, and build teams to translate how data is structured and how it moves into clear, well-governed specifications, turning fragmented source data into standardized, trustworthy data for the enterprise.