Data Analyst
(Cooksville, IL, 61730) | 05/13/26
Job Description
Title : Data Analyst
Location : Cook, IL
Mode of work : Onsite (Day 1 Onsite)
Job Description:
Work closely with business stakeholders to gather, validate, and clarify data and reporting requirements.
Translate business needs into detailed functional and technical requirement documents.
Develop comprehensive Source-to-Target Mapping (STTM/STM) documents capturing field-level data logic.
Create detailed Business Rules, Data Definitions, and Data Transformation documentation.
Perform complete data lineage analysis across Snowflake, APIs, upstream sources, and reporting layers.
Assist in data modeling and design aligned with Medallion architecture (Bronze/Silver/Gold layer separation).
Conduct data profiling, validation, and reconciliation using Snowflake SQL.
Work with REST API data integrations, including reading API specifications, understanding payloads, and mapping to Snowflake tables.
Collaborate with data engineers, ETL/ELT developers, and QA to ensure accurate interpretation of the requirements.
Support UAT and resolve data-related gaps through iterative testing and validation.
Mentor and guide more junior team members.
Skills
Proven experience with programming languages such as SQL and Python for data validation, profiling, reconciliation, and analytics.
Strong hands-on Snowflake experience is required, including: Ability to construct & optimize complex SQL queries o Variant/JSON parsing o Schema and stage understanding o Performance analysis & troubleshooting
Working experience in Medallion Architecture (Bronze, Silver, Gold data layers) including mapping data flows across layers.
Proven experience with API-based data ingestion (REST APIs, JSON/XML nice to have
Data Analyst1Data analyst United States
(Cooksville, IL, 61730) | 05/13/26
Job Description
Title : Data Analyst
Location : Cook, IL
Mode of work : Onsite (Day 1 Onsite)
Job Description:
Work closely with business stakeholders to gather, validate, and clarify data and reporting requirements.
Translate business needs into detailed functional and technical requirement documents.
Develop comprehensive Source-to-Target Mapping (STTM/STM) documents capturing field-level data logic.
Create detailed Business Rules, Data Definitions, and Data Transformation documentation.
Perform complete data lineage analysis across Snowflake, APIs, upstream sources, and reporting layers.
Assist in data modeling and design aligned with Medallion architecture (Bronze/Silver/Gold layer separation).
Conduct data profiling, validation, and reconciliation using Snowflake SQL.
Work with REST API data integrations, including reading API specifications, understanding payloads, and mapping to Snowflake tables.
Collaborate with data engineers, ETL/ELT developers, and QA to ensure accurate interpretation of the requirements.
Support UAT and resolve data-related gaps through iterative testing and validation.
Mentor and guide more junior team members.
Skills
Proven experience with programming languages such as SQL and Python for data validation, profiling, reconciliation, and analytics.
Strong hands-on Snowflake experience is required, including: Ability to construct & optimize complex SQL queries o Variant/JSON parsing o Schema and stage understanding o Performance analysis & troubleshooting
Working experience in Medallion Architecture (Bronze, Silver, Gold data layers) including mapping data flows across layers.
Proven experience with API-based data ingestion (REST APIs, JSON/XML nice to have
Data Analyst1Data analyst United States
Job ID: 522886848
Originally Posted on: 5/29/2026
Want to find more Technology opportunities?
Check out the 165,053 verified Technology jobs on iHireTechnology
Similar Jobs
Sign Up for Job Alerts
