Data Engineer
ProgenyHealth
Job Role
We are seeking a skilled and experienced Data Engineer to join our team. The ideal candidate will play a critical role in designing, developing, and maintaining our Claims Data Warehouse (CDW), which is built on Snowflake and fed by Azure-based data services. The role requires deep, hands-on expertise in Snowflake, strong working knowledge of the Azure data ecosystem, and extensive experience with medical claims data, including professional, institutional, and pharmacy claims, eligibility, and provider data. You will combine SQL, data modeling, and performance optimization skills with a solid understanding of how healthcare claims are adjudicated, adjusted, and reported, to ensure the efficiency, scalability, and reliability of our data infrastructure.
Description
We are seeking a skilled and experienced Data Engineer to join our team. The ideal candidate will play a critical role in designing, developing, and maintaining our Claims Data Warehouse (CDW), which is built on Snowflake and fed by Azure-based data services. The role requires deep, hands-on expertise in Snowflake, strong working knowledge of the Azure data ecosystem, and extensive experience with medical claims data, including professional, institutional, and pharmacy claims, eligibility, and provider data. You will combine SQL, data modeling, and performance optimization skills with a solid understanding of how healthcare claims are adjudicated, adjusted, and reported, to ensure the efficiency, scalability, and reliability of our data infrastructure.
Job Role
We are seeking a skilled and experienced Data Engineer to join our team. The ideal candidate will play a critical role in designing, developing, and maintaining our Claims Data Warehouse (CDW), which is built on Snowflake and fed by Azure-based data services. The role requires deep, hands-on expertise in Snowflake, strong working knowledge of the Azure data ecosystem, and extensive experience with medical claims data, including professional, institutional, and pharmacy claims, eligibility, and provider data. You will combine SQL, data modeling, and performance optimization skills with a solid understanding of how healthcare claims are adjudicated, adjusted, and reported, to ensure the efficiency, scalability, and reliability of our data infrastructure.
Responsibilities Include
- Design, build, and optimize the Claims Data Warehouse in Snowflake, including databases, schemas, tables, views, stages, file formats, and workloads for loading, transforming, and sharing data.
- Build continuous and batch ingestion into Snowflake using Snowpipe, COPY INTO, external stages, and Azure Blob Storage/ADLS Gen2 landing zones.
- Implement incremental and near-real-time processing with Snowflake Streams, Tasks, and Dynamic Tables, including change data capture (CDC), schema drift handling, and error-recovery patterns to keep pipelines reliable.
- Implement medallion architecture (Bronze, Silver, and Gold layers) in Snowflake, from raw claim file ingestion through standardized, deduplicated claim data to curated, analytics-ready marts.
- Tune Snowflake performance and cost by right-sizing virtual warehouses, using Query Profile, clustering keys, search optimization, materialized views, and resource monitors, and by resolving latency, queuing, and storage issues.
- Enforce Snowflake security and governance, including role-based access control (RBAC), dynamic data masking, row access policies, object tagging, and secure data sharing, to protect PHI and meet HIPAA requirements.
- Use Snowflake Time Travel, Fail-safe, zero-copy cloning, and replication to support backup, recovery, testing, and business continuity/disaster recovery (BCDR) strategies.
- Write efficient, well-documented SQL (and Snowpark or stored procedures where appropriate) to support extraction, transformation, and loading (ETL/ELT) of large claims data volumes.
- Model claim header and claim line structures and manage the full claim lifecycle, including adjudication status, adjustments, reversals, voids, resubmissions, denials, and coordination of benefits (COB), so that the most current and accurate version of each claim is always available.
- Apply and maintain healthcare code sets and reference data such as ICD-10-CM/PCS, CPT/HCPCS, revenue codes, DRG, NDC, place of service, type of bill, and modifiers, and map them accurately across source systems.
- Develop claims-based data products to support utilization management, case management, cost and trend analysis, PMPM reporting, provider and network analytics, quality measures (e.g., HEDIS), risk adjustment, and financial reporting such as incurred-but-not-reported (IBNR) and claim run-out analysis.
- Perform regular claims data quality and reconciliation checks, including financial balancing of billed, allowed, and paid amounts, duplicate claim detection, eligibility-to-claim matching, and completeness and timeliness validation against source systems.
- Partner with claims, medical management, actuarial, finance, and analytics stakeholders to translate business and clinical requirements into well-modeled, trusted data.
- Build, schedule, and monitor ETL/ELT pipelines using Azure Data Factory (ADF) to move claims and cases data from source systems, SFTP, and payer/vendor files into Snowflake, with parameterization, alerting, and retry logic.
- Use Azure services such as ADLS Gen2/Blob Storage, Azure Key Vault, Microsoft Entra ID, Azure Monitor, and Azure SQL/SQL Server to build secure, observable, and cost-effective data platform components.
- Maintain and migrate existing SQL Server Integration Services (SSIS) packages as needed, and help modernize them into ADF and Snowflake-based patterns.
- Contribute to CI/CD, version control (Git, Azure DevOps), and infrastructure-as-code practices for Snowflake objects and Azure data pipelines.
- Use AI tools such as Snowflake Cortex, GitHub Copilot, Microsoft Copilot in Fabric, and LLM-based assistants to speed up pipeline development, code generation, documentation, testing, and troubleshooting.
- Optimize database performance by analyzing, monitoring, and fine-tuning SQL queries and database structures across Snowflake and SQL Server environments.
- Develop and maintain data pipelines to ensure seamless data flow between various source systems and the EDW, and work with development teams to integrate data services with applications and business systems.
- Monitor and maintain the health of the platform, addressing issues related to performance, latency, data freshness, and storage, and manage database security, backup, and recovery strategies to ensure data integrity and availability.
- Keep up to date with emerging trends and best practices in Snowflake, cloud data engineering, healthcare data standards, and SQL optimization.
Requirements
- Bachelor's degree in computer science, Information Technology, or a related field.
- Proven experience as a Data or Database Engineer with 10 or more years of experience in a healthcare environment, with a focus on SQL and Enterprise Data Warehousing.
- Hands-on experience with Snowflake (Required), including Snowpipe, Streams and Tasks, Dynamic Tables, COPY INTO, RBAC, masking and row access policies, warehouse sizing and performance tuning, and secure data sharing.
- Experience implementing medallion architecture (Bronze, Silver, and Gold layers) in Snowflake or another cloud data warehouse/lakehouse environment.
- Extensive hands-on experience with medical claims data, including claim header/line structures, adjustments and reversals, and eligibility/enrollment data.
- Working knowledge of X12 EDI healthcare transactions (837, 835, 834, 270/271, 276/277) and claim forms (CMS-1500, UB-04).
- Strong command of healthcare code sets and reference data, including ICD-10, CPT/HCPCS, revenue codes, DRG, NDC, and place of service.
- Experience building claims-based analytics and reporting, such as utilization, cost and trend, PMPM, risk adjustment, and quality measures (e.g., HEDIS)
- Hands-on experience with Azure Data Factory (ADF) and Azure data services such as ADLS Gen2/Blob Storage, Key Vault, and Azure DevOps.
- Experience with SQL Server Integration Services (SSIS) and SQL Server (preferred), particularly in maintaining or migrating legacy packages.
- Strong knowledge of data modeling and database design principles, including dimensional modeling and handling slowly changing dimensions and claim versioning.
- Understanding of data security, privacy, backup, and recovery procedures (i.e., BCDR), including HIPAA and handling of PHI/PII.
- Experience with Git-based version control and CI/CD (Azure DevOps or similar).
- Strong problem-solving skills and attention to detail.
- Knowledge of Agile methodologies and experience working in Agile environments.
- Strong communication skills working across business functions, including clinical, claims, and finance teams.
- Manage multiple projects, issues, and deliverables in a fast-paced environment. Able to multi-task and prioritize work to meet deadlines.
- Excellent listening, critical thinking, written and verbal skills.
- Works well within a team environment.
- Experience working in a professional environment with clinical managed care concepts, practices, and procedures preferred (e.g., utilization management, case management, prior authorization, provider networks, capitation).
Benefits
- Paid Time Off
- Paid Parental Leave
- Medical, dental, vision benefits
- 401K with company match
- Short- and Long-Term Disability
- Group Life Insurance
- Tuition Reimbursement
- Pet InsuranceProfessional development opportunities
- Business Casual work environment
ProgenyHealth positively recruits people from diverse backgrounds, including individuals with disabilities - if you need an accommodation to interview, please contact us by email: View email address on click.appcast.io
All qualified applicants will receive consideration for employment without regard to race, color, sex, sexual orientation, gender identity, religion, national origin, disability, veteran status, or other legally protected status.
#J-18808-Ljbffr- ...Senior Data Engineer As a Senior Data Engineer, you will work with the team to build complex data pipelines using a new cutting-edge Data Ingestion Platform as well as several new and exciting products in the Big Data/Advanced Analytics space. You will operate in a...Suggested
- ...Job Description Job Description: Insight Global is seeking a Senior Consultant in Data Engineering for a top healthcare client. This individual will join a highly technical data engineering team working on advanced Microsoft Fabric and Azure initiatives, with a major...Suggested
- ...creating an exceptional place to work that is inclusive to all. Toll Brothers , America's leading luxury home builder, seeks an Data Analytics Engineer to join our team at our Corporate office in Fort Washington, Pennsylvania. What is the opportunity? The Data Analytics...SuggestedFull timeWork at officeLocal areaShift work3 days per week
- ...Job Description Job Description Title: Senior Data Architect / Migration Engineer Location: Remote ~ Platform: P3 multi-tenant CRM Role Overview Seeking a hands-on Data Architect / Migration Engineer to own data integrity and migration strategy for multi...SuggestedRemote work
- RESPONSIBILITIES: Kforce has a client that is seeking a Data Platform Engineer in Conshohocken, PA. Summary: We are seeking a hands-on Senior Data Platform Engineer to help build and evolve a modern cloud data platform. This is not a traditional ETL-focused role...SuggestedHourly payContract work
- ...living your life's work? Entity: Corporate Department: PennDNA Data Mgmt and Ops Location: Remote based out of 3535 Market Street... ..., PA Hours: 8hr Days Summary : The Lead Data Engineer- People will be responsible for leading the design, development,...Remote work
- ...Job Description Job Description Summary: The engineer in this position should have a wealth of experience engineering/installing... ...cohesive package. This would include the complete engineering of data centers including, but not limited to, infrastructure, overhead...For contractorsWork at officeLocal area
- ...pyspark, SQL programming Day-1 onsite Good to have Scala • Proven experience (6+ years) as a data engineer and data scientist, preferably in a fast-paced technology or analytics-driven environment. • Telecom Domain must. • Big Data / ETL Development...
- ...Data Engineer Employment Type: Full-Time, Mid-level CGS is seeking a passionate and driven Data Engineer to support a rapidly growing Data Analytics and Business Intelligence platform focused on providing solutions that empower our federal customers with the tools...Full timeFlexible hours
- ...Job DescriptionJob DescriptionJob Title: Data Engineer Location: Philadelphia, PA 19113 (Hybrid) Duration: 06 Months Job Details: Must Have : SQL (advanced), Big Query Good to have : Reporting - Tableau, Looker Vertica client tools (SQL Workbench, DBeaver, vsql, etc.)...
$100.79k - $160.26k
...DLA Piper is a place you can engage in meaningful work and grow your career. Let’s see what we can achieve. Together. Summary The Data Engineer, Solutions & Data role designs, builds, and operates data pipelines and data integration processes that translate raw data into...Full timeWork at officeRemote workVisa sponsorship- ...Overview We are hiring a Data Engineer to join our Data Technologies team. This team partners with middle-and back-office application teams to design, build, and support next-generation data platforms and pipelines that ingest, process, and transform large-scale data...
- ...Responsibilities Design of data solutions on Databricks including delta lake, data warehouse, data marts and other data solutions... ...and manage the pipelining (collection, storage, access), data engineering (data quality, ETL, Data Modelling) and understanding (documentation...
$113.1k - $185k
...optimism and focus. We don’t settle until we give our best and know that we’re making a difference. We're looking for a Voice Data Security Engineer in Conshohocken, PA/Cincinnati, OH/Indianapolis, IN/Cary, NC/Texas or Virginia area who is excited about working on...Full timeRemote work- ...through cutting-edge technology, quantitative research, and deep trading expertise. We are looking for an experienced Quantitative Data Engineer to join our Prediction Markets team. We specialize in geopolitical and sports analytics across the globe. This is an...
- ...Overview We are seeking a Data Engineer to join our Systematic Delta One desk, where engineers, researchers, and traders work side-by-side to develop scalable, fully automated trading strategies across liquid global products and venues. Susquehanna buys data from a...
- ...your life's work? Entity: Corporate Services Department: PennDNA Data Management and Ops Location: Remote based out of 3535 Market St Hours: 8hr Days Summary : This Senior Data Engineer role will be a key contributor to Penn Medicine's efforts to measure...Remote work
- ...and government agencies, a list that spans across the country. Job Description CapTech Machine Learning Engineers are responsible for designing and implementing data-driven solutions for our clients, with a specific focus on building and deploying scalable machine learning...Full timeWork at officeRemote workVisa sponsorshipWork visaFlexible hours
- ...Enterprise AI (EAI) builds the data foundations that GSKs AI systems depend our operating model digital workers do the hands-on data engineering. They generate pipelines test and deploy them monitor them in production and remediate failures. Our engineers direct that work...Permanent employmentFull timeLocal areaRemote workFlexible hours
- ...Sr. Big Data Data Engineer Horsham, PA/Remote/Hybrid C2H role Work hours (ex. 9am-5pm day/night shifts rotating shifts etc)? 9AM - 5PM EST Interview process – Initial Phone Screen – Team Interview – Hands-on Development Exercise Must have skills – Data Analysis...Remote workNight shiftRotating shiftDay shift
$95.61k
...and the return on the city’s technology investments; ensuring data security continuity; planning for continuing operations in the... ...department, board, commission and agency. Job Description Data Engineering at the City is a unique opportunity for meaningful, exciting...Work experience placementWork at office$32 - $48 per hour
...Job Description Job Description Data Center Operations Engineer Location: New York / New Jersey Business Area: Engineering & CTO Compensation: $32 $48 per hour Schedule: Rotating Shifts (Days, Evening, Nights, Weekends) Position Overview We are...Hourly payWork at officeNight shiftRotating shiftAfternoon shift- ...digital transformation firm focused on delivering solutions around data-driven enterprise, IT modernization, customer experience,... ...Qualifications Ability to create working environments for data engineers and scientists, and general knowledge of ML, AI, LLMs, and...
$150k
...Job Details: Data Engineer - Snowflake migration Onsite Hybrid (regional monthly) We are seeking a hands-on ETL Data Engineer to design, build, and optimize enterprise data solutions in a modern cloud environment. This role requires someone with strong experience...- OverviewLutron is seeking a Lead Data Engineer in Coopersburg, PA or Philadelphia, PA to help build and scale a modern, cloud-native data and AI platform powering analytics, real-time intelligence, and next-generation products. In this role, you will shape the architecture...Worldwide
$95k - $120k
...Senior Analytics Engineer Location: Philadelphia, PA Overview Position Type: Full Time Category: Information Technology Description... ...powers the first and largest community-based activation and data platform, transforming healthcare by providing unparalleled...Full timeSummer workWork at officeFlexible hours2 days per week$120.38k - $192.6k
...in a Lincoln officeRelocation assistance: is not available for this opportunity.Requisition #: 76901The Role at a GlanceThe Lead Data Engineer provides technical leadership for Lincoln’s Data & Analytics platform on AWS. This role designs, builds, and maintains scalable...Work experience placement3 days per week- ...& Bockius LLP, a leading global law firm with offices in major commercial, legal, and governmental hubs worldwide, is seeking a Data Engineer. Reporting to the Data Warehouse Manager, the Data Engineer is responsible for supporting the Firm’s data services, with a focus...Full timeLocal areaRemote workWorldwide
- ...expertise across Cybersecurity, Digital Core, Finance, Industry and Enterprise, Song, Supply Chain and Engineering, and Talent, with advanced capabilities in AI and Data, Industry and Process, and Technology. We serve approximately 9,000 clients and generated...Work experience placementLive inWork at officeLocal area
- ...all.Who You’ll Work WithAt Slalom, we co-create custom software, data, AI, and cloud solutions with clients who are ready to... ...products, experiences, and organizations.Our Data Architecture & Engineering team sees data as the foundation for decision-making, artificial...Temporary workWork at officeLocal area
Do you want to receive more vacancies?
Subscribe and receive similar vacancies to Data Engineer. Be the first to apply!
- data visualization Plymouth Meeting, PA
- data analysis part time Plymouth Meeting, PA
- data modeling Plymouth Meeting, PA
- data Plymouth Meeting, PA
- provider data management Plymouth Meeting, PA
- clinical data coordinator remote Plymouth Meeting, PA
- clinical data Plymouth Meeting, PA
- data network cabling Plymouth Meeting, PA
- health data Plymouth Meeting, PA
- ai data Plymouth Meeting, PA





