Cleared Data Analyst (5553)

SMX; Hartford (CT); 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 and document data lineage, aligning data to a canonical domain model that underpins enterprise data products. You will work with data engineers, architects, and build teams to translate data structures into actionable specifications.

You will contribute to API design and data governance, producing clear documentation and ensuring data quality across systems. This role emphasizes collaboration and rigorous technical writing.

Qualifications

• Bachelor’s degree in Computer Science, IT, Data Engineering, or related field.
• 2–6 years of professional experience in data analysis, data mapping, data modeling, or related data role.
• Strong SQL skills and ability to profile, query, and analyze data across multiple source systems.
• Experience with data mapping and source-to-target documentation.
• Knowledge of data modeling, domain data models, and API contracts.

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 model and map to target structures.
• Translate business needs into API schemas and data requirements.
• Develop and document data rules, MD management, and data quality practices.
• Produce mappings, dictionaries, metadata, and lineage artifacts for teams.
• Communicate requirements to engineering and gather data needs from stakeholders.
• Collaborate with engineers, architects, and analysts to meet downstream needs.

Skills

SQL skills

Data profiling

Data mapping

Data modeling

API schema design

Data lifecycle

Technical writing

Communication

Education

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

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