Senior Data Engineer at The Ohio State University

, , United States -

Full Time

Start Date

Immediate

Expiry Date

19 Jun, 26

Salary

0.0

Posted On

21 Mar, 26

Experience

2 year(s) or above

Remote Job

Yes

Telecommute

Yes

Sponsor Visa

Skills

SQL, Python, ETL/ELT, Azure Services, Databricks, Delta Lake, Medallion Architecture, dbt, Data Modeling, Kimball, Star Schemas, CI/CD, Data Quality Automation, Observability, Data Governance, Performance Optimization

Industry

Higher Education

Description

Screen reader users may encounter difficulty with this site. For assistance with applying, please contact hr-accessibleapplication@osu.edu. If you have questions while submitting an application, please review these frequently asked questions. Current Employees and Students: If you are currently employed or enrolled as a student at The Ohio State University, please log in to Workday to use the internal application process. Welcome to The Ohio State University's career site. We invite you to apply to positions of interest. In order to ensure your application is complete, you must complete the following: Ensure you have all necessary documents available when starting the application process. You can review the additional job description section on postings for documents that may be required. Prior to submitting your application, please review and update (if necessary) the information in your candidate profile as it will transfer to your application. Job Title: Senior Data Engineer Department: Health System Shared Services | Analytics Center of Excellence Position Summary The Senior Data Engineer serves as a top-level technical contributor and lead for complex data and analytics initiatives that align technology solutions with clinical, operational, and strategic priorities. This role designs, builds, and operates secure, scalable data pipelines and curated datasets that power analytics, reporting, and advanced AI/ML use cases supporting patient care, administrative decision-making, and improved outcomes. This position partners closely with clinical and operational leaders, analytics teams, vendors and IT stakeholders to translate business needs into reliable data products. The Senior Data Engineer leads the end-to-end development lifecycle - data ingestion, transformation, modeling, testing, deployment, and monitoring - while championing modern engineering practices (CI/CD, data quality automation, observability, documentation, and governance). Recognized across the organization for expertise in data architecture, engineering standards, and platform modernization. Key Responsibilities Lead design and delivery of enterprise-grade data pipelines (ETL/ELT) using SQL/Python, supporting high-volume, high-complexity healthcare data. Build and optimize a modern lakehouse architecture using Azure services and Databricks, including Delta Lake patterns and performance tuning. Implement and maintain medallion architecture (bronze/silver/gold): ingestion, standardization, and curated semantic datasets for analytics and downstream consumption. Develop scalable transformation and modeling layers using dbt (or equivalent) and data modeling best practices (Kimball, dimensional modeling, star schemas, conformed dimensions). Establish and enforce data quality and reliability standards (tests, reconciliation, SLA monitoring, anomaly detection, lineage/metadata). Implement CI/CD for data pipelines and dbt projects (Git-based workflows, automated testing, release pipelines via Azure DevOps/GitHub Actions). Collaborate with reporting & analytics, data science, data governance and platform systems & architecture teams to enable self-service access to trusted datasets and accelerate insight delivery. Provide technical leadership on architecture decisions, security/privacy considerations, performance optimization, and cost management. Create and maintain technical documentation, data contracts, and operational runbooks; contribute to engineering standards and patterns. Coordinate across medical center and university entities and evaluate external tools/partners to adopt innovative methods and improve delivery. Minimum Qualifications Bachelor’s degree in Computer Science, Information Systems, Data Analytics, Engineering, or related field (or equivalent practical experience). 4+ years of progressive experience in data engineering, data warehousing, or analytics engineering (healthcare required). Advanced proficiency with SQL and strong experience with Python for data engineering. Hands-on experience designing and operating ETL/ELT pipelines and building curated analytics datasets. Strong understanding of data modeling, warehousing/lakehouse concepts, and modern data management practices. Demonstrated ability to lead large, complex initiatives and deliver outcomes in high-impact environments. Additional Information: Our Comprehensive Employee Benefits Include: An array of retirement plan options, each with a generous employer contribution. Affordable health insurance options, including dental, vision and prescription coverage that begin on day one. Paid vacation and sick leave, including short and long-term disability and paid parental leave. Get the most out of the Public Service Loan Forgiveness program. And much more! Location: Ackerman Rd, 660 (0242) Position Type: Regular Scheduled Hours: 40 Shift: First Shift Final candidates are subject to successful completion of a background check. A drug screen or physical may be required during the post offer process. Thank you for your interest in positions at The Ohio State University and Wexner Medical Center. Once you have applied, the most updated information on the status of your application can be found by visiting the Candidate Home section of this site. Please view your submitted applications by logging in and reviewing your status. For answers to additional questions please review the frequently asked questions. The university is an equal opportunity employer, including veterans and disability. At Ohio State, you’ll find work that inspires you. We offer roles and growth opportunities in countless fields and specialties — including a job that’s right for you. Ohio State benefits give you options to take care of what matters most to you — and opportunities to make adjustments as your life and needs change, including: • Medical, dental and vision coverage, with Ohio State paying a significant portion of the cost. • Paid time off, including sick and vacation time and 11 holidays. • State retirement plan or an alternative retirement plan, both with generous employer contributions. As Buckeyes, we accomplish more together. No matter your role, you’ll be part of creating what people need now: pathways to education, research and health care. Working at Ohio State means you’re part of a team with a strong sense of community and an unwavering commitment to excellence — and, of course, incomparable Buckeye spirit. We bring out the best in people, help each other succeed and learn together. By joining Ohio State, you become part of a top-20 public university with one of America’s leading academic health centers. We’re a team of dedicated colleagues with access to boundless resources that support you. Review the Frequently Asked Questions for details on using Workday and submitting your application.

Responsibilities

The Senior Data Engineer leads the design and delivery of enterprise-grade data pipelines using SQL/Python, building and optimizing a modern lakehouse architecture on Azure/Databricks, including implementing the medallion architecture for curated datasets. This role champions modern engineering practices across the end-to-end development lifecycle, ensuring data quality, reliability, and governance for analytics and AI/ML use cases.