Analytics Engineer II — ELT & Data Modeling Lead

Partner's Consulting, Inc.; Philadelphia, Northern (Philadelphia County, KY); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Partner's Consulting, Inc. is seeking an Analytics Engineer II in Philadelphia, PA. The role bridges a data engineer and a data analyst to model raw data into curated, reusable data sets that power enterprise analytics.

Responsibilities include building scalable ELT pipelines, implementing data quality checks and collaborating with data scientists to scale advanced algorithms for health care and operational analytics.

Qualifications

• 6–8 years of experience in data and analytics landscape.
• Strong SQL, data modeling and data warehousing fundamentals.
• Experience with software development practices: version control, CI/CD.

Responsibilities

• Collaborate with analysts and scientists to create integrated, reusable data sets.
• Build automated, scalable ELT pipelines and data products.
• Implement data quality checks and monitor data pipelines.

Skills

SQL

Data modeling

ELT

Python

CI/CD

Big data

BI tools

Streaming

Education

Bachelor's degree in CS/IT or related field

Tools

DBT

Informatica

SSIS

Hadoop

Spark

Kafka

Power BI/Tableau/BO

Snowflake

Job description

Partner's Consulting, Inc. is seeking an Analytics Engineer II in Philadelphia, PA. The role bridges a data engineer and a data analyst to model raw data into curated, reusable data sets that power enterprise analytics.

Responsibilities include building scalable ELT pipelines, implementing data quality checks and collaborating with data scientists to scale advanced algorithms for health care and operational analytics.