Business Intelligence Analyst - (Hybrid – 2 Days On-Site)

Job Responsibility

• Design, build, and optimize tables, views, and data models in BigQuery; maintain thorough documentation for all data assets and transformation logic.
• Implement data quality validation checks that proactively surface anomalies before they reach stakeholders.
• Build and maintain interactive Tableau dashboards that transform complex datasets into intuitive, self-service experiences for decision-makers.
• Identify automation opportunities and build Python-based scripts and workflows that eliminate manual work and reduce cycle time.
• Integrate internal operational data with external market intelligence to produce a unified view of Northwell's competitive position.
• Manage analytical code in GitHub using disciplined version control practices.
• Analyzes, verifies, tracks and reports on quantitative and qualitative data concerning hospital and multi-care services, utilization and population demographics.
• Provides internal and external strategic planning and market research databases to perform analysis.
• Evaluates strategic business unit market performance through the use of benchmark data.
• Provides information to management, Strategic Planning and staff on formal presentations.
• Supports certificate of need and grant writing functions through analysis of System and Health care market data.
• Provides technical assistance to staff on use of computer software and databases, as required.
• Assists in preparing information for presentation to internal constituencies and local, state agencies.

Job Qualification

• Bachelor's Degree required, or equivalent combination of education and related experience.
• 1-3 years of relevant experience, required.
• Highly Preferred Technical Skills:
• SQL Proficiency: Working knowledge of intermediate SQL including common table expressions (CTEs), window functions, and multi-table joins
• Python Programming: Experience using Python for data manipulation and automation, including pandas library and basic scripting capabilities
• Data Visualization Tools: Hands-on experience building reports and dashboards in Tableau or Power BI, including foundational data modeling concepts
• Advanced Excel: Proficiency with Excel functions, pivot tables, and Power Query for data transformation
• Healthcare Data: Familiarity with healthcare datasets such as medical/pharmacy claims summaries, CMS public use files, or National Plan and Provider Enumeration System (NPPES) data
• Cloud Platforms: Exposure to Google Cloud Platform (GCP) or Amazon Web Services (AWS), particularly executing queries in BigQuery and accessing cloud storage solutions

Valued Competencies

• Strategic Thinking: Ability to connect data to broader business context—surfacing the questions that should be asked.
• Communication: Skill in distilling complex analyses into clear, compelling narratives for non-technical audiences.
• Ownership & Initiative: Self-directed with a bias toward action—identifying problems and proposing solutions proactively.
• Attention to Detail: Meticulous approach to data accuracy and deliverable quality.