Data Engineer

SOMERSET STAFFING; Center Square (PA); On-site; USD 120,000 - 180,000; Full time

Job summary

SOMERSET STAFFING is seeking a Senior Data Engineer to build complex data pipelines on a cutting-edge Data Ingestion Platform and supporting Big Data/Analytics products. You will ensure timely data delivery across products to enable revenue in a fast-paced environment.

The role requires strong experience with Hadoop, Spark, SQL, Linux, and shell scripting, plus healthcare data knowledge. You will mentor juniors and help drive SAFe-aligned delivery in a collaborative team.

Qualifications

• 5+ years experience with data aggregation, standardization, linking, quality check mechanisms, and reporting.
• 5+ years experience with Hadoop and Spark.
• 5+ years experience with Oracle or MS SQL Server and SQL or ETL tools.
• Strong Linux understanding; shell scripting and file systems knowledge.
• Bachelor's degree in Computer Science, Engineering, or related field with 8–10 years' experience.

Responsibilities

• Build data pipelines to load source data into data lake on the proprietary platform.
• Support and improve data ingestion processes for healthcare data applications.
• Develop and maintain data engineering processes using T-SQL, Spark, Scala, and shell scripting.
• Improve process efficiencies and data performance.
• Review and test data for accuracy before loading into data lake.
• Perform data analysis, data mining, and root-cause investigations.
• Collaborate with Technical Operations to troubleshoot database issues including OS and storage.
• Provide off-hours support for production issues.
• Mentor junior team members on data engineering and quality best practices.
• Oversee delivery of business priorities in SAFe environment.

Skills

Data aggregation

Hadoop

Spark

SQL & RDBMS

Linux

Shell scripting

Education

Bachelor's degree in Computer Science or Engineering

Tools

T-SQL

Spark

Scala

Shell scripting

Job description

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 fast-paced environment where multiple project deliverables are coordinated within specified deadlines. The primary responsibility of this role is to deliver accurate and timely data across various products to enable revenue for the company. The ideal candidate would have data analysis and data pipeline development experience using big data tools (like Spark, Scala, Hive), relational databases, intermediate SQL skills. Healthcare knowledge is a plus.

Required Skills

• MUST: 5+ years experience with data aggregation, standardization, linking, quality check mechanisms, and reporting.
• MUST: 5+ years experience with big data technologies like Hadoop and Spark.
• MUST: 5+ years experience with RDBMS (Oracle, MS SQL Server) and using SQL or other data integration/ETL tools.
• MUST: Solid understanding of Linux environments; strong knowledge of shell scripting and file systems.
• Bachelor's degree in relevant field such as Computer Science, Engineering, a related field, with 8-10 years of industry experience.

Job Duties

• Build data pipelines as per data transformation specifications to convert source data to be loaded into data lake using proprietary big data processing platform
• Supports and improves current data ingestion processes for our proprietary healthcare data applications and systems
• Develop and maintain data engineering processes using a variety of tools including T-SQL, Spark and Scala, and shell scripting. Generally focused on data ingestion for healthcare data management, data validation, statistical report generation, and program validation.
• Develop tools and techniques for improving process efficiencies and data performance.
• Review & test the data to ensure accuracy & validity of the data prior to uploading the data to the data lake.
• Data Troubleshooting and Analysis
• Perform data analysis, data mining and investigations and identify root cause of issues using several cutting-edge data analysis tools.
• Work with Technical Operations to troubleshoot complex database issues related to the entire environment including OS, storage, and servers. Provide off hours support to resolve production issues when necessary
• Mentor junior team members in data engineering and quality best practices
• Oversees the delivery of business priorities in a Scaled Agile Framework (SAFe) environment

Job Requirements

• SQL Queries ETL Process
• End to End Linux experience Healthcare experience preferred Hadoop
• nice to have Spark Advanced SQL experience EST preferred time zone

Desired Skills & Experience

• Experience with healthcare data preferably in a data operations role.
• Data expert with the ability to debug data issues, identify root causes and fix the data issues in a fast-paced environment.
• Experience operating in an Agile environment.

Background Check : No

Drug Screen : No