Sr Data Specialist in Niles, Illinois at Serenity Home Health Care

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).

Business Intelligence & Dashboards

• 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.

Documentation, Collaboration & Peer Support

• 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).
• Proficiency in MSSQL (complex queries, views, stored procedures, schema design, database optimization).
• 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.