Senior Data Analyst: Power BI & Fabric Modeling Lead

ADP, Inc.

Niles (IL)

On-site

USD 44,000 - 52,000

Full time

9 days ago

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

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

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Senior Data Analytics Engineer - Power BI & Fabric
Senior Data Analytics Engineer - Power BI & Fabric

SERENITY HOME HEALTH CARE • Niles (IL)

On-site
USD 44,000 - 52,000
Sr Data Specialist
Sr Data Specialist

ADP, Inc. • Niles (IL)

On-site
USD 44,000 - 52,000
Sr Data Specialist
Sr Data Specialist

SERENITY HOME HEALTH CARE • Niles (IL)

On-site
USD 44,000 - 52,000
Senior Analytics Engineer - Power BI & Fabric
Senior Analytics Engineer - Power BI & Fabric

SHI International • Somerset (NJ)

On-site
USD 125,000 - 140,000
Health, wellness, and financial ben­ef
Office or remote work options
Data-Driven BI Solutions Specialist
Data-Driven BI Solutions Specialist

ADP, Inc. • Town of West Seneca (NY)

On-site
USD 85,000 - 105,000
Senior Analytics Engineer - Power BI & Fabric
Senior Analytics Engineer - Power BI & Fabric

SHI International • Austin (TX)

Hybrid
USD 125,000 - 140,000
Medical
Vision
Dental
+2
Senior Analytics Engineer — Power BI & Microsoft Fabric
Senior Analytics Engineer — Power BI & Microsoft Fabric

SHI International • Austin (TX)

Hybrid
USD 125,000 - 140,000
Senior BI Developer - Power BI & Fabric Analytics
Senior BI Developer - Power BI & Fabric Analytics

EDIS Group • Cincinnati (OH)

On-site
USD 110,000 - 150,000
Senior Data & Analytics Leader - Power BI & Fabric
Senior Data & Analytics Leader - Power BI & Fabric

Automatic Data Processing, Inc. • Colwich (KS)

On-site
USD 140,000 - 190,000
Senior BI Analyst - Power BI & Fabric Expert
Senior BI Analyst - Power BI & Fabric Expert

Illuminate USA • Pataskala (OH)

On-site
USD 90,000 - 150,000
Competitive pay
Comprehensive benefits
Career development opportunities