Design, develop, and implement SQL-based transformations, queries, and database objects that support enterprise analytics and reporting.
Architect and manage curated, analytics-ready datasets and data models within the Databricks Lakehouse environment, ensuring alignment with enterprise data standards.
Lead the transformation of raw and source-system data into structured, reusable datasets aligned with enterprise analytics needs.
Develop scalable data logic that simplifies data access for analysts, BI tools, and downstream data products.
Define and promote best practices for data modeling, transformation logic, and performance optimization across all stakeholders.
Optimize query performance and data transformations to ensure efficient processing and scalability across large datasets.
Collaborate with the Data Team and business stakeholders to translate requirements into well-defined data structures and logic ; serve as a subject matter expert.
Investigate and resolve data discrepancies, lineage issues, and quality concerns across data assets.
Maintain clear documentation for datasets, transformations, and data definitions to support transparency and reuse.
Ensure compliance with enterprise data governance, security standards, and HIPAA requirements when working with sensitive healthcare data.
Requirements
Required
8+ years of experience developing SQL-based data solutions in analytics or data engineering environments.
Deep proficiency in SQL development, including complex joins, aggregations, window functions, and query performance optimization.
Strong experience working with large-scale datasets in relational or analytical database environments.
Experience designing curated datasets, semantic layers, or data models that support reporting and analytics use cases.
Experience driving data design decisions and influencing best practices across teams.
Familiarity with modern data platforms and cloud-based analytics environments.
Strong analytical thinking, problem-solving ability, and cross-functional collaboration skills.
Excellent problem-solving skills, with the ability to independently lead investigations into data issues and drive resolution.
Preferred
Experience working with Databricks and lakehouse architectures.
Experience in healthcare data environments.
Familiarity with modern CI/CD pipelines and development practices
Experience supporting BI and analytics tools such as Sigma.
Knowledge of data warehousing, dimensional modeling, or analytics engineering best practices.
Why Join Us?
Help evolve our analytics platform from traditional reporting to scalable, productized data solutions.
Contribute to a mission-driven organization focused on improving musculoskeletal care.
Collaborate with experts across data engineering, clinical informatics, and analytics.
Grow your career while helping shape the future of data and analytics at HSS.
Non-Discrimination Policy
Benefits
Health insuranceEquity / stock options
Additional Information
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 $128,500.00 - $196,375.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.
Hss · New York, NY