Senior Healthcare Analyst

Primary Responsibilities

• Data Engineering & SQL Development
• Design, develop, and maintain complex SQL solutions to support reporting, analytics, and business decision-making.
• Write highly efficient and scalable SQL queries against large datasets containing millions of records.
• Analyze and troubleshoot data quality, performance, and reporting issues.
• Develop repeatable and maintainable data solutions that are easy to understand and support.
• Data Modeling & Analytics
• Design and maintain data models that accurately represent business processes and reporting requirements.
• Possess a strong understanding of dimensional modeling concepts, including fact tables, dimension tables, and their relationships.
• Partner with stakeholders to translate business requirements into scalable data solutions.
• Ensure consistency and accuracy across reporting and analytical datasets.
• Power BI Development
• Develop and maintain enterprise-level Power BI dashboards and reports.
• Create optimized Power BI data models capable of supporting large datasets while maintaining strong report performance.
• Leverage best practices around relationships, DAX, data model design, and dataset optimization.
• Design intuitive and visually compelling dashboards that effectively communicate key business insights.
• Balance technical performance with user experience and dashboard usability.
• Automation & Python Support
• Utilize Python to support data processing, automation, and analytical workflows when appropriate.
• Understand fundamental Python concepts, including: script execution, functions and modules, reading and writing data files, and reusing and integrating code across multiple scripts.
• Collaborate with other technical team members to support automation initiatives and process improvements.
• Leadership & Technical Ownership
• Serve as a subject matter expert for data architecture, SQL development, and reporting solutions.
• Mentor team members and promote best practices in analytics, reporting, and data management.
• Independently solve complex technical problems with minimal supervision.
• Drive continuous improvement in data processes, reporting capabilities, and overall analytical maturity.

Required Qualifications

• Bachelor's degree in Information Systems, Computer Science, Data Analytics, Finance, Mathematics, Statistics, or a related field, or equivalent practical experience
• 5+ years of experience in data analytics, business intelligence, data engineering, or a related technical role
• Advanced SQL expertise with experience building complex queries and data solutions
• Deep understanding of: window functions, CTEs, temporary tables, query performance tuning, multi-step data transformations, relational databases
• Understanding of data warehousing concepts and dimensional modeling, including fact and dimension tables
• Advanced Power BI experience, including: data modeling, DAX, report optimization, dashboard development, large dataset performance management
• Ability to work independently and translate ambiguous business requirements into actionable technical solutions
• Problem-solving, analytical, and communication skills
• Ability to work full-time. Employees are required to have flexibility to work any of our shift schedules during our normal business hours of 8am - 5pm. It may be necessary, given the business need, to work occasional overtime

Preferred Qualifications

• Experience working with datasets containing tens of millions of records
• Experience with Python for automation, data processing, or analytical workflows
• Experience designing scalable reporting and data architecture solutions
• Experience mentoring analysts or serving as a technical lead
• Knowledge of data governance, ETL processes, and enterprise reporting best practices