Analytics Engineer
Analytics
Big Data
Bigdata
Business Analytics
Business Intelligence
CI/CD
Cloud
Cloud Data Warehouse
Cloud Platform
Cloud Platforms
Data
Data Analysis
Data Analytics
Data Architecture
Data Build Tool
Data Engineer
Data Engineering
Data Integration
Data Management
Data Modeling
Data Operations
Data Pipeline
Data Pipelines
Data Platform
Data Processing
Data Visualization
Data Viz
Data Warehouse
Data Warehousing
Database
Databases
Dataviz
Desktop Support
DevOps
Devops Tools
Digital Marketing
End User Support
ETL
Hadoop
Informatica
Information Technology (IT)
Integration
Kafka
Microsoft
Power BI
Power Platform
Programming
Programming Languages
Reporting and Analytics
Snowflake
Software Development
Spark
SQL
Systems
Tableau
Technical Support
Visual Design
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.
Similar Jobs
