A Day in the Life:

• Work cross-functionality to understand data opportunities and build pipelines and dictionaries for potential data sources

• Evaluate integration capabilities and opportunities to leverage and automate 3rd party data

• Design, develop, test, deploy, support, enhance data integration solutions to connect and integrate enterprise systems

• Follow agile development methodologies to deliver solutions and product features by following DevOps practices.

• Assist with implementing standard operating procedures, facilitate requirements gathering and  review sessions with functional owners and end-user representatives, and leverage technical knowledge and expertise to drive improvements.

• Support standard processes for defining, designing and documenting reference architecture and leading the implementation of BI and analytical solutions.

Minimum Requirements:

• 4-year degree with a major in computer science engineering (or equivalent) from an accredited university plus at least one year of relevant experience or a minimum of 8-10 years professional IT experience

• Strong prior technical, development background in either data Services or Engineering

• Proven experience in Databricks/Spark-based Data Engineering Pipeline development and Data/Delta Lake, Oracle, or AWS Redshift type relational databases.

Preferred Requirements:

• 3+ years working experience in Python-based data integration and pipeline development.

• Data lake and Delta Lake experience with AWS Glue and Athena.

• Proven experience with AWS Cloud on data integration with various ecosystems.

• Strong experience in python development especially in AWS Cloud environment with knowledge of common python libraries

• Strong experience with source control systems such as Git and Jenkins

• Demonstrated experience resolving complex data integration problems.

Knowledge, Skills, Abilities

• Ability to work multi-functionally and present solutions to variety of technical and non-technical audiences

• Highly determined, execution-focused, with ability to balance multiple priorities in an effective manner

• Adept at debugging and solving problems

• Ability to design, develop test, deploy, maintain, and improve data integration pipeline

• Strong analytical experience with database in query optimization, debugging, user defined functions, views, indexes etc.

• Excellent verbal and written communication skills

Compensation and Benefits

The salary range estimated for this position based in Pennsylvania is $75,800.00–$113,675.00.

This position may also be eligible to receive a variable annual bonus based on company, team, and/or individual performance results in accordance with company policy. We offer a comprehensive Total Rewards package that our U.S. colleagues and their families can count on, which includes:

• A choice of national medical and dental plans, and a national vision plan, including health incentive programs

• Employee assistance and family support programs, including commuter benefits and tuition reimbursement

• At least 120 hours paid time off (PTO), 10 paid holidays annually, paid parental leave (3 weeks for bonding and 8 weeks for caregiver leave), accident and life insurance, and short- and long-term disability in accordance with company policy

• Retirement and savings programs, such as our competitive 401(k) U.S. retirement savings plan

• Employees’ Stock Purchase Plan (ESPP) offers eligible colleagues the opportunity to purchase company stock at a discount