Analytics Engineer II: Build Scalable Data Models & BI

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

Job summary

COREHIRE is seeking an Analytics Engineer II in Philadelphia, onsite, to develop and maintain scalable data models, ELT pipelines, and trusted datasets supporting enterprise analytics, reporting, and self-service BI. This role collaborates with business stakeholders, analysts, data scientists, and engineers to deliver high-quality data products.

The role emphasizes data quality, performance, reliability, and hands-on Snowflake, dbt, SQL, and BI tooling experience.

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.
• Experience designing and maintaining Fact and Dimension tables.
• Hands-on Snowflake experience.
• Experience developing analytics models using dbt.
• Experience with data quality testing and validation.
• Experience with Git, code reviews, and CI/CD.
• Experience with BI tools such as Power BI, Tableau, Qlik, or Business Objects.
• Experience with big data technologies such as Spark, Hadoop, Kafka, Hive, or Sqoop.
• Experience building and consuming APIs.
• Linux experience (RHEL/Debian).
• Scripting with Python or Bash.
• Strong analytical and problem-solving skills.
• Experience working in Agile environments.

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 Git, code reviews, and CI/CD practices.
• Collaborate with Data Engineering, DevOps, and Architecture teams.
• Participate in Agile/Scrum ceremonies and production support.

Education

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

Tools

Snowflake

dbt

Git

CI/CD

Power BI

Tableau

Qlik

Business Objects

Airflow

Spark

Hadoop

Kafka

Hive

Sqoop

Linux

Job description

COREHIRE is seeking an Analytics Engineer II in Philadelphia, onsite, to develop and maintain scalable data models, ELT pipelines, and trusted datasets supporting enterprise analytics, reporting, and self-service BI. This role collaborates with business stakeholders, analysts, data scientists, and engineers to deliver high-quality data products.

The role emphasizes data quality, performance, reliability, and hands-on Snowflake, dbt, SQL, and BI tooling experience.