Job Description:
About the Job:
The Senior Data Analyst will join the Enterprise Data and Analytics team and play a key role in modernizing the organization’s analytics and reporting landscape. This role is directly responsible for supporting and executing the migration of enterprise reporting from legacy BI platforms (BusinessObjects and Qlik Sense) to Microsoft Power BI.
The Senior Data Analyst will design and refactor dimensional data models, support Power BI semantic models, and work across multiple Power BI workspaces to enable governed, scalable, and high-performance reporting. This role partners closely with analytics engineers, data engineers, BI developers, and clinical and business stakeholders to ensure analytics solutions are trusted, reusable, and aligned with enterprise standards.
The ideal candidate combines strong Power BI migration experience, star schema data modeling expertise, SQL proficiency, and analytics engineering practices, along with excellent communication and data storytelling skills.
What You Will Do:
- Lead and support the migration of reports and dashboards from BusinessObjects and Qlik Sense to Microsoft Power BI, including redesign of underlying data models and metric logic.
- Assess existing legacy BI reports and datasets to identify refactoring opportunities needed to support Power BI performance, usability, and scalability.
- Design and support Power BI semantic models(datasets), ensuring proper relationships, metric definitions, hierarchies, and performance optimization.
- Work across multiple Power BI workspaces, applying best practices for workspace organization, dataset ownership, access control, and deployment workflows.
- Refactor existing models to improve analytical correctness, reuse, clarity, and performance.
- Partner with analysts and developers to validate metrics, relationships, and grain so Power BI reports accurately reflect business and clinical logic.
- Recommend appropriate modeling strategies based on analytical use cases, grain, report interactivity, and Power BI consumption patterns.
- Design, implement, and maintain dimensional data models(fact tables, dimensions, and conformed dimensions) using star schema best practices as needed
- Implement data quality checks, validation logic, and testing frameworks to ensure trusted and reliable datasets.
- Optimize SQL and model design to manage warehouse compute usage and reporting performance.
- Document dimensional models, Power BI dataset design decisions, assumptions, and usage guidance to support adoption and long-term sustainability.
- Collaborate with data engineers and architects to resolve upstream data issues and align modeling approaches with enterprise data architecture standards.
- Utilize modern analytics development practices including version control, peer review, and documentation.
- Demonstrated familiarity with Snowflake and dbt,
- Ability to follow established modeling, testing, and documentation standards.
- Serve as a trusted analytics advisor through strong communication, data storytelling, and thought partnership with stakeholders.
- Support mentoring and knowledge transfer to ensure continuity and long-term team capability.
Required Skills & Experience:
- Bachelor’s degree or equivalent experience
- 5+ years of experience in analytics, business intelligence, or data analysis
- Hands-on experience migrating reports and datasets from legacy BI tools (BusinessObjects, Qlik Sense, Tableau) to Microsoft Power BI
- Strong experience with Microsoft Power BI, including semantic model (dataset) design
- Experience working across multiple Power BI workspaces , including dataset ownership and access management
- Strong expertise in dimensional data modeling and star schema design
- Advanced SQL skills and experience with relational databases
- Experience working with modern data warehouse platforms
- Strong communication skills and experience presenting insights to non-technical audiences
Preferred Skills & Experience:
- Experience with additional BI tools (Qlik Sense, Tableau, BusinessObjects)
- MS Power BI Certification
- Experience with Snowflake and analytics engineering tools such as dbt
- Familiarity with Power BI deployment patterns, workspace separation (development / test / production), and governance concepts
- Healthcare analytics experience, including clinical, hospital, or financial data
- Experience with Python, R, or other analytical programming languages
- Experience mentoring analysts or contributing to analytics standards and best practices
- Master’s degree in analytics, data science, informatics, or a related field
