Sr Data Specialist

ADP, Inc.

Niles (IL)

On-site

USD 44,000 - 52,000

Full time

6 days ago
Be an early applicant

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Job summary

ADP, Inc. is seeking a Sr Data Specialist in Niles, IL. The role focuses on designing and maintaining data models that power reporting and analytics, leveraging SQL Server, Power BI, and Microsoft Fabric to deliver accurate, reusable data insights.

You will own projects end-to-end and collaborate with cross-functional teams to translate business processes into structured data solutions. The Senior Data Analyst position emphasizes building semantic Power BI models, implementing security, and

Qualifications

  • Bachelor’s degree in Data Science, Computer Science, Information Systems, or related field.
  • 3+ years in data analysis, BI, or analytics engineering, including hands-on data modeling.
  • Strong Power BI skills, including building semantic models, table relationships, and intermediate-to-advanced DAX measures.
  • Hands-on experience with Microsoft Fabric (lakehouses, warehouses, Dataflows Gen2, pipelines, or Direct Lake semantic models).
  • Experience implementing row-level security in Power BI.
  • Advanced skills in Microsoft Excel (formulas, pivot tables, macros).

Responsibilities

  • Independently design, build, and maintain dimensional data models for reporting and analytics.
  • Translate business requirements into data models, define entities and relationships.
  • Develop Power BI semantic models and manage data relationships and measures.
  • Build SQL Server views and Fabric data transformations for clean, analysis-ready data.
  • Design and maintain interactive dashboards for key metrics.
  • Implement row-level security and ensure data quality and reliability.

Skills

Data modeling
Data analysis
Data visualization
Stakeholder collaboration
Problem solving
Project management

Education

Bachelor’s degree in Data Science, Computer Science, Information Systems, or related field

Tools

SQL Server
Power BI
Microsoft Fabric
DAX
Dataflows Gen2
Pipelines

Job description

If you are unable to complete this application due to a disability, contact this employer to ask for an accommodation or an alternative application process.

Sr Data Specialist

Main Department Full Time Niles, IL, US

Salary Range: $32.00 To $38.00 Hourly

Job Title: Senior Data Analyst

Department: Data & Analytics

Location: Niles, IL

Employment Type: Full-time

Job Summary:

The Data Analyst II independently designs and maintains the data models that power our reporting, and uses them to deliver analysis, reports, and dashboards that support strategic and operational decision-making. Building on a solid foundation in SQL Server, Power BI, and Microsoft Fabric, this role structures data so that metrics are accurate , consistent, and reusable across the organization, and helps uphold the modeling standards the team builds on. The Data Analyst II takes ownership of assigned projects from requirements through delivery, serves as a technical resource for colleagues, and partners with cross-functional teams to translate business processes into well-structured data and actionable insights.

Key Responsibilities:
Data Modeling
  • Independently design, build, and maintain dimensional data models that serve as the foundation for reporting and analytics.
  • Translate business processes and stakeholder requirements into conceptual, logical, and physical data models, defining entities, relationships, keys, and grain.
  • Develop and maintain Power BI semantic models, including table relationships, DAX measures, and hierarchies, choosing appropriate storage modes (Import, DirectQuery , Direct Lake) for performance and reuse.
  • Build and maintain SQL Server views and Fabric transformation logic (e.g., Dataflows Gen2, pipelines, or notebooks) that turn raw data from source systems into clean, analysis-ready tables in Fabric lakehouses and warehouses.
  • Apply, and help refine, team standards for naming conventions, metric definitions, and handling of historical changes (e.g., slowly changing dimensions).
  • Design, build, and maintain interactive Power BI dashboards for key business metrics, built on shared, well-structured data models.
  • Implement row-level security so that sensitive client, employee, and financial data is visible only to the appropriate users.
  • Ensure data accuracy, consistency, and reliability across reporting systems.
  • Lead requirements conversations with stakeholders for assigned projects and translate their needs into effective visual solutions.
Data Analysis & Reporting
  • Perform trend analysis and provide actionable insights to support business performance and planning.
  • Collect, clean, validate, and analyze data from multiple sources.
  • Generate recurring and ad-hoc reports and visualizations for leadership and operational teams.
  • Work with cross-functional teams (Operations, Marketing, Finance, etc.) to identify and implement efficient data collection methods for tracking workflows and outcomes.
Database Design & Query Optimization
  • Write, optimize, and maintain complex SQL queries, views, and stored procedures for efficient data extraction and analysis.
  • Contribute to database design decisions, including normalization, indexing, and table structures that support both data integrity and reporting performance.
Platform & Data Quality
  • Use Fabric deployment pipelines and version control to promote Power BI and Fabric content from development to production.
  • Build and monitor data quality checks that catch issues before they reach reports.
  • Maintain clear documentation for data models (including entity-relationship diagrams), data sources, transformations, metric definitions, and reporting logic.
  • Educate and support stakeholders in the interpretation and effective use of dashboards and reports.
  • Review peers’ models, DAX, and SQL, and provide guidance and support to team .
Qualifications & Skills:
  • Education: Bachelor’s degree in Data Science , Computer Science, Information Systems, or related field (or equivalent experience).
  • Experience:
  • 3+ years in data analysis, business intelligence, or analytics engineering, including hands-on data modeling.
  • Strong Power BI skills, including building semantic models, table relationships, and intermediate-to-advanced DAX measures.
  • Hands-on experience with Microsoft Fabric ( lakehouses , warehouses, Dataflows Gen2, pipelines, or Direct Lake semantic models).
  • Experience implementing row-level security in Power BI.
  • Experience with Power Automate (or similar automation tools like Zapier).
  • Advanced skills in Microsoft Excel (formulas, pivot tables, macros).
  • Preferred:
  • Microsoft Power BI or Fabric certification.
  • Healthcare or home care industry experience.
  • Soft Skills:
  • Strong problem-solving and troubleshooting abilities.
  • Structured , detail-oriented approach to organizing data, with the ability to translate business processes into logical data structures.
  • Ability to manage multiple projects independently and prioritize competing requests.
  • Ability to communicate technical concepts to non-technical teams.
  • Willingness to share knowledge and support the growth of less experienced teammates.
  • Collaborative mindset with a focus on process improvement.
Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Sr. SQL Data Analyst (SQL Server Preferred!)
Sr. SQL Data Analyst (SQL Server Preferred!)

MMD Services • Gurnee (IL)

On-site
USD 100,000 - 115,000
Sr Data Visualization Analyst
Sr Data Visualization Analyst

CB&I • The Woodlands (TX)

On-site
USD 95,000 - 150,000
Sr Data Visualization Analyst
Sr Data Visualization Analyst

CB&I • Town Center (TX)

On-site
USD 90,000 - 130,000
Senior BI Data Engineer: Cloud Data & Power BI Lead
Senior BI Data Engineer: Cloud Data & Power BI Lead

Compunnel Inc. • New York (NY)

Hybrid
USD 120,000 - 150,000
Data Engineer
Data Engineer

Fracht Group - North America • Houston (TX)

On-site
USD 140,000 - 190,000
Data Analyst II
Data Analyst II

Aureon • West Des Moines (IA)

On-site
USD 65,000 - 85,000
Senior Data Analyst
Senior Data Analyst

Kake Group • United States

Remote
USD 120,000 - 160,000
Data & Analytics Engineer
Data & Analytics Engineer

ADP, Inc. • Greensboro (NC)

On-site
USD 90,000 - 120,000
Analytics Engineer
Analytics Engineer

Benchmark Utility Services • Virginia

On-site
USD 100,000 - 130,000
Senior BI Data Engineer
Senior BI Data Engineer

Compunnel Inc. • New York (NY)

On-site
USD 120,000 - 150,000