Analytics Engineer

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

Analytics Engineer II

Location: Philadelphia, PA (Onsite)
Duration: 6+ Months – possible conversion to FTE
Type: W2

Overview

The Analytics Engineer develops and maintains scalable data models, ELT pipelines, and trusted datasets that support enterprise analytics, reporting, and self-service BI. This role partners with business stakeholders, analysts, data scientists, and engineers to deliver high-quality data products and ensure data quality, performance, and reliability.

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.

Required Experience

• 6+ years in Data Analytics, Analytics Engineering, BI, or Data Engineering.
• Advanced SQL skills, including complex transformations and performance tuning.
• Strong Data Warehousing and Dimensional Data Modeling experience.
• Experience designing and maintaining Fact and Dimension tables.
• Hands-on experience with Snowflake.
• 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 experience using Python, Bash, or similar languages.
• Strong analytical and problem-solving skills.
• Experience working in Agile environments.

Preferred Experience

• 8+ years in data and analytics.
• Experience with Cloud platforms (AWS, Azure, or GCP).
• Experience with Apache Airflow or similar orchestration tools.
• Experience supporting BI migrations to Power BI.
• Experience with semantic models and analytics engineering best practices.

Education

Bachelor's degree in Computer Science, Information Systems, Data Science, Engineering, Mathematics, or a related field preferred. Equivalent professional experience will be considered.

Must-Have Keywords

SQL, Snowflake, dbt, Dimensional Data Modeling, Fact Tables, Dimension Tables, Power BI