Senior Data Engineer: Databricks & Cloud Pipelines (Remote)

Geisinger; Pennsylvania; Remote; USD 120,000 - 170,000; Full time

Job summary

Geisinger Research Data Core seeks a Senior Data Engineer to transform and manage clinical and genomic data for research use. You will design and maintain cloud-based data pipelines on Databricks, model clinical data, and modernize legacy ETL processes for scalable cloud environments.

You will collaborate with a multidisciplinary team, ensure data quality, and optimize Spark/SQL workloads while providing guidance across development life cycles and documentation.

Qualifications

• Proven experience with Databricks and cloud-based data engineering platforms.
• Strong experience with SQL and Python/PySpark for developing and optimizing data processing pipelines.
• Experience with Apache Spark or other distributed data processing technologies.
• Experience designing and implementing data models and data warehouse schemas for large-scale datasets.
• Experience developing, maintaining, or modernizing ETL processes and data pipelines.
• Experience working with relational databases and SQL Server.
• Familiarity with AWS cloud services and cloud-based data architectures.
• Experience with data quality, validation, monitoring, logging, and troubleshooting practices.
• Understanding of data pipeline performance optimization and scalable data processing.
• Excellent communication skills to convey progress, roadblocks, technical issues, and solutions to team members and management.
• Ability to work effectively as part of a multidisciplinary team and collaborate with technical and research stakeholders.

Responsibilities

• Designs, develops, and maintains PySpark and SQL data pipelines for transforming clinical data for research use.
• Develops and maintains data models for clinical and other research data within the Databricks environment.
• Reviews, analyzes, modifies, creates, debugs, designs, and tests data ingestion and processing pipelines using modern development methodologies and tools.
• Defines and optimizes data warehouse schemas and data models to support efficient querying, storage, and analytical workflows.
• Ensures scalability, reliability, and maintainability of data pipelines and data architecture supporting large clinical and research datasets.
• Implements and monitors data quality checks and validation processes to ensure accuracy, completeness, and integrity of data throughout the pipeline.
• Troubleshoots and optimizes Spark and SQL workloads, data pipelines, and Databricks compute resources to improve performance and reliability.
• Modernizes existing on-premises Microsoft SQL Server ETL processes by designing and implementing equivalent cloud-based data pipelines and workflows in Databricks.
• Provides general Databricks computing support, including assisting users with compute resource selection, troubleshooting, and optimization of Spark and SQL workloads.
• Participates in design and application architecture discussions and assists in the development and documentation of technical approaches and solutions for team stakeholders.
• Responsible for the process, life cycle and creation of the software to assist users in completing a computer task or program.
• Implements code and documents all system changes based on assignments and timelines.
• Develops and follows department coding and user interface guidelines.
• Provides code review, testing, debugging, technical documentation, general testing instructions, go-live planning, assistance in go-live moves, and post-live support.
• Communicates all progress, roadblocks, and issues to the team and management in a timely manner.
• Collaborates with team members to identify and resolve issues, improve system performance, and ensure code quality.
• Provides training and documentation to team members on new development assignments.
• Trains and mentors staff members.
• Assists in the development and documentation of a technical approach for a solution to the team stakeholders.

Skills

Databricks platform

PySpark

SQL

Python

Data modeling

Data quality

Performance optimization

Communication

Team collaboration

Cloud data engineering

Education

Bachelor's Degree (Technology Related)

High School Diploma or GED

Tools

Databricks

SQL Server

AWS

Job description

Geisinger Research Data Core seeks a Senior Data Engineer to transform and manage clinical and genomic data for research use. You will design and maintain cloud-based data pipelines on Databricks, model clinical data, and modernize legacy ETL processes for scalable cloud environments.

You will collaborate with a multidisciplinary team, ensure data quality, and optimize Spark/SQL workloads while providing guidance across development life cycles and documentation.