Onsite Role: Data Analyst at Cook, IL-NEED LOCAL ONLY

[HMG America]

Hi,

This is Harman and I am working with HMG America LLC, The best Business Solutions focused Information Technology Company with IT consulting and services, software and web development, staff augmentation and other professional services. One of our direct clients is looking for  Data Analyst. Below is the detailed job description. Kindly let me know if you feel comfortable. Thanks,

Data Analyst

Location : Cook, IL-Onsite (Day 1 Onsite)

Duration: 6-12 months

NEED LOCAL ONLY

Experience: 11+ years

Mandatory Skills:

• Source-to-Target Mapping (STTM/STM) 
• Snowflake
• ETL/ELT 
• SQL 
• Python

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

 

Thanks & Regards,

Harmanpreet Singh 

Senior US IT Recruiter

HMG America LLC  

har...@hmgamerica.com

http://www.hmgamerica.com