Senior Data Engineer
American Academy of Orthopaedic Surgeons (AAOS)
Rosemont, IL
Information Technology
If this sounds like you, please read on!
Build Next‑Generation Data Platforms
- Design, build, and maintain scalable enterprise data environments using Microsoft Fabric components including Lakehouse, Warehouse, OneLake, and Dataflows Gen2 .
- Develop, optimize, and troubleshoot high-performance Spark workloads using PySpark and SparkSQL to process large-scale structured and semi-structured datasets.
- Architect and implement enterprise-grade ETL/ELT solutions using Azure Data Factory (ADF), Microsoft Fabric Data Pipelines, Dataflows Gen2, and SSIS (including Azure‑SSIS IR and on‑prem migration scenarios).
- Implement modern data modeling frameworks such as Medallion Architecture (Bronze/Silver/Gold) and dimensional modeling (Star/Snowflake) with expertise in file types including Parquet, JSON, and XML .
- Integrate Microsoft Purview for enterprise cataloging, classification, and automated lineage across ADF, Fabric, SQL, and ADLS.
- Enforce robust data security practices including RBAC, column-level security, dynamic data masking, and alignment with enterprise governance policies.
Required
- Hands-on experience with Microsoft Fabric (Lakehouse, Warehouse, OneLake, Dataflows Gen2, Data Pipelines) and Azure Data Services (ADF, ADLS, Azure SQL, Synapse).
- Strong proficiency in PySpark and SparkSQL for building optimized, large-scale transformation pipelines.
- Proven experience developing enterprise ETL/ELT solutions using ADF, Fabric Data Pipelines, and SSIS (including Azure‑SSIS IR and migration from on‑prem).
- Expertise in Medallion architecture, dimensional modeling, and working with Parquet, JSON, XML.
- Experience working with healthcare, registry, clinical, or highly regulated data, with strong knowledge of privacy and compliance.
- Background implementing CI/CD pipelines (Azure DevOps/GitHub), IaC (Bicep, ARM, Terraform), and automated deployment of data or governance assets.
- Experience supporting MLOps pipelines or enabling AI/Advanced Analytics workloads in Azure/Fabric ecosystems.
- Demonstrated ability in Fabric capacity optimization, Spark performance tuning, and cloud cost management.
Bring your expertise, creativity, and ambition, and help us build the future of data. If you’re driven by innovation, energized by solving complex data challenges, and excited to work with the very best of Microsoft’s cloud ecosystem, apply today!
Please Share The Following
- Clearly communicate why you are the ideal candidate for this role, providing specific examples and experiences as proof points.
- Resumes must be accompanied by a cover letter with salary expectations to be considered.
JOB CODE: 1000154
About the company
Company website•Non-profit Organizations
Founded at Northwestern University as a not-for-profit organization in 1933, the AAOS has grown into the world's largest medical association of musculoskeletal specialists. The Academy serves over 39,000 members internationally.
Members of the AAOS, are orthopaedists concerned with the diagnosis, care, and treatment of musculoskeletal disorders. The orthopaedist's scope of practice includes disorders of the body's bones, joints, ligaments, muscles, and tendons. Fellows have completed four years of medical school and at least five years of an approved residency in orthopaedics. In addition, they must pass an oral and written examination, be certified by the American Board of Orthopaedic Surgery, and submit to stringent membership review processes prior to admittance.
Mission: Serving the orthopaedic profession to provide the highest quality musculoskeletal care.
Vision: The trusted leaders in advancing musculoskeletal health.
Core Values:
-Leading to serve
-Shaping our future
-Excellence together
To learn more about AAOS or its strategic plan, visit https://www.aaos.org/strategicplan