Data Analyst

Data Analyst at AllSTEM Connections Data Analyst at AllSTEM Connections in Melrose Park, Illinois Posted in 7 days ago.

Type:

full-time

Job Description:

Candidates will be disqualified if the following criteria are not met:

Employment Type:

No C2C (Corp-to-Corp) or C2H (Contract-to-Hire) arrangements. W2 contract only. No referral fees will be entertained.

Work Authorization:

US CITIZEN and

GREENCARD ONLY!

!! Hybrid- Chicago, IL or an hour travel to Chicago, IL Experience in Power BI, SQL and Databricks. Build and manage Databricks notebooks, Delta tables, and data pipelines for transforming large datasets into curated analytical datasets. Design, optimize, and maintain complex SQL queries, views, and stored procedures to support analytics, self-service reporting, and data quality controls.

Requirements:

Job Requirements:

Required expertise: Power BI, SQL and Databricks. Design, optimize, and maintain complex SQL queries, views, and stored procedures to support analytics, self-service reporting, and data quality controls. Build and manage Databricks notebooks, Delta tables, and data pipelines for transforming large datasets into curated analytical datasets. Lead development, enhancement, and maintenance of Power BI dashboards, reports, and semantic models for executive and operational stakeholders. Collaborate with business SMEs to translate requirements into scalable data models, KPIs, and documentation across finance and operations use cases. Perform advanced data profiling, validation, and reconciliation across source systems, ensuring accuracy, performance, and adherence to governance standards. Provide SME-level guidance, code review, and best practices coaching in Power BI, SQL, and Databricks to internal analytics teams.