Business Intelligence Developer

How you move is why we’re here. ® Now more than ever. Get back to what you need and love to do. The possibilities are endless... Now more than ever, our guiding principles are helping us in our search for exceptional talent - candidates who align with our unique workplace culture and who want to maximize the abundant opportunities for growth and success. If this describes you then let’s talk! HSS is consistently among the top-ranked hospitals for orthopedics and rheumatology by U.S. News & World Report. As a recipient of the Magnet Award for Nursing Excellence, HSS was the first hospital in New York City to receive the distinguished designation. Whether you are early in your career or an expert in your field, you will find HSS an innovative, supportive and inclusive environment. Working with colleagues who love what they do and are deeply committed to our Mission, you too can be part of our transformation across the enterprise. Emp Status Regular Full time Work Shift Compensation Range The base pay scale for this position is $99,000.00 - $150,750.00. In addition, this position will be eligible for additional benefits consistent with the role. The salary of the finalist selected for this role will be determined based on various factors, including but not limited to: scope of role, level of experience, education, accomplishments, internal equity, budget, and subject to Fair Market Value evaluation. The hiring range listed is a good faith determination of potential compensation at the time of this job advertisement and may be modified in the future. What you will be doing About Us 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. The Role You will be the technical builder of analytics experiences—designing and developing experiences that are performant, reusable, and aligned with real user needs. You’ll work within a POD to deliver data products that go beyond static dashboards to become embedded tools in daily workflows. Success in this role means building products that users adopt quickly, trust deeply, and rely on consistently—while adhering to enterprise standards for security, performance, and maintainability. Key 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. Qualifications Required 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. Preferred 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. Why Join Us? Be a key contributor to the evolution of our analytics platform—from reporting to productized insights. Work in a mission-driven environment focused on improving musculoskeletal care. Collaborate with experts in data engineering, clinical informatics, and product management. Grow into a leadership role shaping the future of BI and data applications at scale. Non-Discrimination Policy Hospital for Special Surgery is committed to providing high quality care and skilled, compassionate, reliable service to our community in a safe and healing environment. Consistent with this commitment, Hospital for Special Surgery provides care, admits, and treats patients and provides all services without regard to age, race, color, creed, ethnicity, religion, national origin, culture, language, physical or mental disability, socioeconomic status, veteran or military status, marital status, sex, sexual orientation, gender identity or expression, or any other basis prohibited by federal, state, or local law or by accreditation standards.