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.