Sr Data Specialist

SERENITY HOME HEALTH CARE•Niles, IL

10h•$32 - $38

About The Position

The Senior Data Analyst independently designs and maintains data models that power reporting, and delivers analysis, reports, and dashboards to support strategic and operational decision-making. Using SQL Server, Power BI, and Microsoft Fabric, the role structures data so metrics are accurate, consistent, and reusable across the organization, while helping uphold team modeling standards. The analyst owns 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. The role covers dimensional and semantic data modeling, dashboard development, analysis and reporting, SQL query optimization, database design, data quality, platform deployment, documentation, stakeholder education, and peer support. It is based in Niles, Illinois, and is listed as full-time.

Requirements

Bachelor’s degree in Data Science, Computer Science, Information Systems, or a related field, or equivalent experience.
At least 3 years of experience in data analysis, business intelligence, or analytics engineering, including hands-on data modeling.
Strong Power BI skills, including semantic models, table relationships, and intermediate-to-advanced DAX measures.
Hands-on experience with Microsoft Fabric, including lakehouses, warehouses, Dataflows Gen2, pipelines, or Direct Lake semantic models.
Proficiency in MSSQL, including complex queries, views, stored procedures, schema design, and database optimization.
Experience implementing row-level security in Power BI.
Experience with Power Automate or similar automation tools such as Zapier.
Advanced Microsoft Excel skills, including formulas, pivot tables, and macros.
Strong problem-solving and troubleshooting abilities.
Structured, detail-oriented approach to organizing data and translating 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.

Nice To Haves

Microsoft Power BI or Fabric certification.
Healthcare or home care industry experience.

Responsibilities

Independently design, build, and maintain dimensional data models 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 relationships, DAX measures, and hierarchies, and select suitable storage modes for performance and reuse.
Build and maintain SQL Server views and Microsoft Fabric transformation logic to prepare source data as analysis-ready tables in Fabric lakehouses and warehouses.
Apply and help refine team standards for naming conventions, metric definitions, and historical changes such as slowly changing dimensions.
Design, build, and maintain interactive Power BI dashboards based on shared data models.
Implement row-level security to restrict access to sensitive client, employee, and financial data.
Ensure data accuracy, consistency, and reliability across reporting systems.
Lead requirements conversations for assigned projects and translate stakeholder needs into visual solutions.
Perform trend analysis and provide actionable insights for 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.
Collaborate with Operations, Marketing, Finance, and other teams to identify and implement efficient data collection methods for workflows and outcomes.
Write, optimize, and maintain complex SQL queries, views, and stored procedures for data extraction and analysis.
Contribute to database design decisions, including normalization, indexing, and table structures for data integrity and reporting performance.
Use Fabric deployment pipelines and version control to promote Power BI and Fabric content from development to production.
Build and monitor data quality checks to catch issues before they reach reports.
Document data models, including entity-relationship diagrams, data sources, transformations, metric definitions, and reporting logic.
Educate and support stakeholders in interpreting and using dashboards and reports effectively.
Review peers’ models, DAX, and SQL, and provide guidance and support to the team.
Take ownership of assigned projects from requirements through delivery and serve as a technical resource for colleagues.