This position is no longer accepting applications
Closed on September 30, 2026.
This role is filled — get an email when new Data Analysis roles open on DataJobs.io:
Analytics Engineer
Get alerted when similar jobs are posted — set up a New Data Analysis jobs on DataJobs.io alert.
See other roles at COREHIRE.
Job Description
COREHIRE is looking for an Analytics Engineer II for a contract opportunity in Philadelphia, PA (onsite). In this role, you will build and maintain scalable data models, automated ELT pipelines, and trusted datasets that support enterprise analytics and self-service BI. You will collaborate closely with business stakeholders, analysts, data scientists, and engineering teams to help ensure data quality, performance, and reliability.
What you’ll do
- 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.
- Apply software development best practices using Git, code reviews, and CI/CD.
- Collaborate with Data Engineering, DevOps, and Architecture teams.
- Participate in Agile/Scrum ceremonies and provide production support.
What you bring
- 6+ years in Data Analytics, Analytics Engineering, BI, or Data Engineering.
- Advanced SQL experience, including complex transformations and performance tuning.
- Strong background in data warehousing and dimensional data modeling, including designing and maintaining Fact and Dimension tables.
- Hands-on experience with Snowflake.
- Experience building analytics models using dbt.
- Experience with data quality testing and validation.
- Working knowledge of Git, code reviews, and CI/CD.
- Experience with BI tools such as Power BI, Tableau, Qlik, or Business Objects.
- Experience with big data technologies including 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, plus experience working in Agile environments.
Nice to have
- 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.
Key skills: SQL, Snowflake, dbt, Dimensional Data Modeling, Fact Tables, Dimension Tables, Power BI.