Location: Philadelphia, PA
Salary: $80.00 USD Hourly - $90.00 USD Hourly
Description: Our client is currently seeking a Analytics Engineer
This position requires you to go to Philadelphia, PA 1-2 times a week
This is a W2 contract position
Summary:The Analytics Engineer serves as a key connector between data engineers and data analysts, with a primary focus on refactoring existing data models and designing analytics-ready fact and dimension tables to support the migration of reports and dashboards to Power BI. This role transforms analytical datasets into curated, reusable, and trusted dimensional models that form the foundation for enterprise reporting and self-service analytics.
You will evaluate current-state models, recommend appropriate dimensional structures, and implement high-quality fact and dimension tables in Snowflake using dbt and SQL. This role partners closely with analytics engineers, data analysts, and BI developers to validate model design, metrics, and assumptions, ensuring analytical accuracy and performance.
Beyond model development, the Analytics Engineer supports data quality, testing, documentation, and performance optimization, with an emphasis on enabling reliable Power BI semantic models and dashboards. The role operates independently within a defined scope, contributes to Agile delivery, and ensures effective knowledge transfer at the conclusion of the contract.
Responsibilities:- Collaborate with analytics engineers, data analysts, and business stakeholders to assess existing data models and identify opportunities for fact and dimension refactoring for Power BI migration.
- Design and implement dimensional data models (facts, dimensions, conformed dimensions) aligned with best practices and reporting requirements.
- Recommend appropriate dimensional modeling approaches based on usage patterns, grain, and analytical needs.
- Develop and maintain analytics engineering pipelines in Snowflake using dbt, SQL, and established modeling standards.
- Refactor and extend existing data models to improve clarity, reuse, performance, and analytical correctness.
- Partner with analysts and BI developers to validate metrics, relationships, and grain to ensure accurate downstream reporting.
- Support Power BI semantic models by aligning table structures, relationships, and metric definitions with visualization and performance needs.
- Implement data quality checks, validation logic, and testing frameworks to ensure trusted and reliable datasets.
- Optimize SQL transformations and model structures to improve performance and manage warehouse compute usage.
- Document dimensional models, design decisions, assumptions, and usage guidance to support long-term sustainability.
- Participate in Agile or iterative delivery workflows and manage time effectively across multiple priorities.
- Collaborate with data engineers and architects to resolve upstream data issues and align modeling approaches.
- Utilize modern analytics development practices, including version control, code review, and documentation.
- Support knowledge transfer and handoff to internal teams to ensure continuity beyond the contract period.
Required Skills:- Advanced SQL for analytics engineering, including complex transformations, aggregations, and performance tuning.
- Strong dimensional data modeling skills, including fact and dimension table design.
- Hands-on experience with Snowflake for analytics workloads.
- Experience developing and maintaining analytics models using dbt, including testing and documentation.
- Proven ability to refactor analytical data models to support reporting and dashboard migrations.
- Experience supporting enterprise BI platforms, preferably Power BI, including semantic model alignment.
- Strong analytical and problem-solving skills with the ability to evaluate tradeoffs and recommend optimal modeling approaches.
Education: - Bachelor's degree in Computer Science, Information Systems, Data Science, Engineering, Mathematics, or a related field is helpful but not required.
- Candidates with equivalent practical experience in analytics engineering, data modeling, or BI development are strongly encouraged to apply.
- Relevant professional experience, demonstrated technical capability, and a track record of delivering analytics solutions will be weighted more heavily than formal education or certifications.
Preferred Qualifications: - Experience with Apache Airflow or similar workflow orchestration tools.
- Experience using Python for data transformation, validation, automation, or analytics workflows.
- Familiarity with Agile or iterative delivery practices.
- Experience with version control and modern analytics development practices (Git, pull requests, code reviews).
- Experience supporting BI platform migrations (e.g., Qlik, Business Objects, or similar to Power BI).
By providing your phone number, you consent to: (1) receive automated text messages and calls from the Judge Group, Inc. and its affiliates (collectively "Judge") to such phone number regarding job opportunities, your job application, and for other related purposes. Message & data rates apply and message frequency may vary. Consistent with Judge's Privacy Policy, information obtained from your consent will not be shared with third parties for marketing/promotional purposes. Reply STOP to opt out of receiving telephone calls and text messages from Judge and HELP for help.
Contact: This job and many more are available through The Judge Group. Please apply with us today! 
Never miss an opportunity! Create an alert based on the job you applied for.