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.
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).
Similar Jobs
.jpeg)
What you need to know about the Chicago Tech Scene
Key Facts About Chicago Tech
- Number of Tech Workers: 245,800; 5.2% of overall workforce (2024 CompTIA survey)
- Major Tech Employers: McDonald’s, John Deere, Boeing, Morningstar
- Key Industries: Artificial intelligence, biotechnology, fintech, software, logistics technology
- Funding Landscape: $2.5 billion in venture capital funding in 2024 (Pitchbook)
- Notable Investors: Pritzker Group Venture Capital, Arch Venture Partners, MATH Venture Partners, Jump Capital, Hyde Park Venture Partners
- Research Centers and Universities: Northwestern University, University of Chicago, University of Illinois Urbana-Champaign, Illinois Institute of Technology, Argonne National Laboratory, Fermi National Accelerator Laboratory
