Analytics Engineer II: Build Scalable Data Pipelines & BI

COREHIRE; Philadelphia (Philadelphia County); On-site; USD 120,000 - 150,000; Full time

Job summary

COREHIRE is seeking an Analytics Engineer II to design and maintain scalable data models, ELT pipelines, and trusted datasets for enterprise analytics. You will partner with analysts, data scientists, and engineers to deliver high-quality data products and ensure data quality, performance, and reliability.

This is an onsite, 6-month contract in Philadelphia, with potential to convert to FTE. Your responsibilities include dimensional modeling, building automated pipelines, and supporting BI

Qualifications

• 6 years in Data Analytics, Analytics Engineering, BI, or Data Engineering.
• Advanced SQL skills with complex transformations and performance tuning.
• Strong Data Warehousing and Dimensional Data Modeling experience.

Responsibilities

• Design and maintain dimensional data models and curated datasets.
• Develop automated, scalable ELT pipelines.
• Implement data quality monitoring, testing, and automation.
• Partner with business users, analysts, and data scientists to deliver analytics solutions.
• Support BI platforms, reporting, and dashboard migrations.
• Use software development best practices including Git, code reviews, and CI/CD.
• Collaborate with Data Engineering, DevOps, and Architecture teams.
• Participate in Agile/Scrum ceremonies and production support.

Skills

Advanced SQL

Data Warehousing

Dimensional Data Modeling

APIs

Python

Git

CI/CD

Analytical thinking

Education

Bachelor's degree in Computer Science, Information Systems, Data Science, Engineering, Mathematics, or related field

Tools

Snowflake

dbt

Power BI

Git

CI/CD

APIs

Python

Job description

COREHIRE is seeking an Analytics Engineer II to design and maintain scalable data models, ELT pipelines, and trusted datasets for enterprise analytics. You will partner with analysts, data scientists, and engineers to deliver high-quality data products and ensure data quality, performance, and reliability.

This is an onsite, 6-month contract in Philadelphia, with potential to convert to FTE. Your responsibilities include dimensional modeling, building automated pipelines, and supporting BI