Cleared Data Analyst (5553)

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

Benefits offered by this job

Health insurance

Paid leave

Retirement plan

Job summary

SMX is seeking a Data Analyst to profile data sources, document data lineage, and align data to a canonical domain model used across enterprise data products, APIs, and analytics.

You will work with data engineers, architects, and build teams to translate data structures and movements into clear, well-governed specifications that standardize fragmented source data into trustworthy, reusable enterprise data.

Qualifications

• Bachelor’s degree required or equivalent in CS/IT/Data-related field.
• 2–6 years of professional experience in data analysis or related roles.
• Strong SQL skills and ability to profile, query, and analyze data across multiple sources.
• Experience with data mapping and source-to-target documentation.
• Working knowledge of data modeling and domain/canonical data models.
• Understanding of data lifecycle across integrated systems.
• Familiarity with API schema design and mapping data elements to APIs.
• Strong technical writing skills to document data requirements clearly.

Responsibilities

• Profile data sources to assess structure, quality, and relationships and document findings.
• Document end-to-end data lineage from origin to consumption.
• Align source data to a canonical/domain data model for database design.
• Apply data elements to API schema design and define schemas for teams.
• Develop and document data rules and quality standards (MDM favored).
• Produce clear documentation (mappings, dictionaries, metadata, lineage artifacts).
• Communicate requirements to engineering and build teams and gather data needs from stakeholders.
• Collaborate with data engineers, architects, and analysts to ensure data meets downstream needs.

Skills

SQL

Data analysis

Data mapping

Data modeling

API schema design

Technical writing

Education

Bachelor’s degree in Computer Science, IT, Data Engineering, Information Systems, or related field

Tools

Databricks

Snowflake

AWS

Job description

SMX is hiring a Data Analyst responsible for profiling data sources, documenting data lineage, and aligning data to a common domain model that powers enterprise data products, APIs, and analytics. Working closely with data engineers, architects, and build teams, the Data Analyst translates how data is structured and how it moves — from source systems through transformation to consumption — into clear, well-governed specifications. This role is essential for turning fragmented, inconsistent source data into standardized, trustworthy, and reusable data the enterprise can rely on.

Essential Duties & 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.

Required Skills/Experience

• 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.

Desired Skills/Experience

• Experience with Master Data Management (MDM), golden-record concepts, and survivorship rules.
• Experience with data governance, metadata management, data quality frameworks, and lineage tooling.
• Experience defining data rules and validation logic for ingestion or transformation processes.
• Familiarity with cloud data platforms (e.g., Databricks, Snowflake, AWS) and modern data catalogs.
• Exposure to data-as-a-product or domain-driven data design.
• Experience working in Agile delivery teams and communicating requirements to build/engineering teams.

The SMX salary determination process takes into account a number of factors, including but not limited to, geographic location, Federal Government contract labor categories, relevant prior work experience, specific skills, education and certifications. At SMX, one of our Core Values is to Invest in Our People so we offer a competitive mix of compensation, learning & development opportunities, and benefits. Some key components of our robust benefits include health insurance, paid leave, and retirement.

The proposed salary for this position is:

$65,000—$108,000 USD

At SMX, we are a team of technical and domain experts dedicated to enabling your mission. From priority national security initiatives for the DoD to highly assured and compliant solutions for healthcare, we understand that digital transformation is key to your future success.

We share your vision for the future and strive to accelerate your impact on the world. We bring both cutting edge technology and an expansive view of what’s possible to every engagement. Our delivery model and unique approaches harness our deep technical and domain knowledge, providing forward-looking insights and practical solutions to power secure mission acceleration.

SMX is an Equal Opportunity employer including disabilities and veterans.

Selected applicant may be subject to a background investigation and/or education verification.

SMX does not sponsor a new applicant for employment authorization or immigration related support for this position (i.e. H1B, F-1 OPT, F-1 STEM OPT, F-1 CPT, J-1, TN, E-2, E-3, L-1 and O-1, or any EADs or other forms of work authorization that require immigration support from an employer).