Sr Data Specialist

SERENITY HOME HEALTH CARE

Niles (IL)

On-site

USD 44,000 - 52,000

Full time

4 hours 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

Serenity Home Health Care in Niles, IL is seeking a Senior Data Analyst to design and maintain data models powering reporting and dashboards. You will work with SQL Server, Power BI, and Microsoft Fabric to deliver accurate, reusable data for strategic decisions.

Responsibilities include building semantic models, managing data pipelines, applying security, and partnering with Operations, Finance, and other teams to translate business processes into effective analytics solutions.

Qualifications

  • Bachelor’s degree in Data Science, Computer Science, Information Systems, or related field (or equivalent 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, structured approach, multi-project management, and teamwork.

Responsibilities

  • Design, build, and maintain dimensional data models for reporting and analytics.
  • Translate business processes and stakeholder requirements into conceptual, logical, and physical data models.
  • Develop and maintain Power BI semantic models and dashboards.
  • Build and maintain SQL Server views and Fabric data pipelines for data preparation.
  • Apply team standards for naming conventions, metrics, and slowly changing dimensions.
  • Maintain data models and documentation for governance and reuse.
  • Implement row-level security to protect sensitive data.
  • Lead requirements conversations with stakeholders and translate needs into visuals.
  • Perform trend analysis and provide actionable insights.
  • Collaborate with cross-functional teams to improve data collection and reporting.

Skills

Power BI
SQL
Data modeling
Microsoft Fabric
DAX
Excel
Row-level security
Power Automate
Healthcare domain knowledge

Education

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

Tools

SQL Server
Power BI
Microsoft Fabric
Dataflows Gen2
Pipelines
Direct Lake
DAX
Excel

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

9 days ago Requisition ID: 1113

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 Data Specialist
Sr Data Specialist

ADP, Inc. • Niles (IL)

On-site
USD 44,000 - 52,000
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
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
Data Analyst II
Data Analyst II

Aureon • West Des Moines (IA)

On-site
USD 65,000 - 85,000
Sr. Data Engineer
Sr. Data Engineer

ProArch • Atlanta (GA)

On-site
USD 120,000 - 180,000