Business Intelligence Developer

Hospital for Special Surgery•New York, NY

2d•$99,000 - $150,750•Onsite

About The Position

We are transforming musculoskeletal healthcare through intelligent, scalable data products. Our Enterprise Analytics team empowers clinicians, researchers, and operational leaders with timely, trusted insights. We operate in cross-functional Product-Oriented Delivery (POD) teams, using modern data platforms like Databricks and Sigma Computing to turn data into action. We are seeking a Business Intelligence Developer (L2) to help build intuitive, high-impact data products in Sigma Computing and Databricks. You will be responsible for turning structured data into interactive, user-centered workbooks and apps that drive decision-making across clinical, financial, and operational domains.

Requirements

2+ years of experience in business intelligence or data visualization.
Proven fluency in Sigma Computing—you’ve built complex, production-grade workbooks from scratch.
Strong understanding of relational data models and SQL (you can debug query logic when needed).
Experience working in agile, cross-functional teams (e.g., product, engineering, clinical).
Familiarity with cloud data platforms (AWS, Databricks, etc.).
Demonstrated ability to work independently, prioritize tasks, and deliver iteratively.
Solid understanding of data governance, including data quality, access control, and documentation.

Nice To Haves

Experience in healthcare analytics (clinical, financial, or operational).
Experience with migrating legacy dashboards to Sigma or similar modern tools.
Background in product thinking—you’ve helped define what to build, not just how to build it.
Experience setting BI best practices or leading standards in a prior role.

Responsibilities

Design, develop, and maintain production-grade workbooks in Sigma and Databricks that deliver actionable insights to stakeholders.
Translate complex data models (from Databricks) into intuitive, performant visualizations with clear narratives.
Write clean, well-documented formulas using Sigma’s calculation engine (aggregations, conditionals, time-series logic).
Ensure adherence to row-level security and access controls in alignment with HIPAA and data governance policies.
Partner with Product Managers, Analytics Engineers, and Clinical Informaticists to refine requirements and validate outputs.
Establish and follow BI development standards (e.g., consistent metrics, reusable components, version control).
Identify opportunities to productize recurring analytics and reduce redundancy across the ecosystem.
Participate in agile ceremonies as a core member of a POD—contributing to planning, reviews, and retrospectives.