Sign upLog in
See more jobs

Analytics Engineer II

Partners Consulting, Inc.
  • Philadelphia, PA
  • Quick Apply
1 day ago

Job Description

Title: Analytics Engineer II
Location:Philadelphia, PA
Type: Contract

Our direct client is seeking an Analytics Engineer II who will act as a bridge between a data engineer and a data analyst.

This position is primarily responsible for modeling raw data sets into curated, reusable, trusted data sets which power analytics across the enterprise. These data sets will serve as the single source of truth for data and enable self-service analytics. In addition to the development of data models, this role is responsible for maintaining data quality within these data sets via the use of monitoring, testing, and automation. This role will improve the effectiveness of data analysts and data scientists by providing technical expertise in query development, extending data models via the addition of new metrics, and / or consulting on software development practices. The Analytics Engineer owns the entire workflow of data associated with their domain; data pipeline development, ELT performance, timely loading of data sets, and maintenance.

Key Accountabilities:
  • Collaborate with business subject matter experts, data analysts, and data scientists to understand / identify the opportunities to develop well-defined, integrated, re-usable data sets which power analytics.
  • Codify reusable data access patterns to speed up time to insights.
  • Perform logical and physical data modeling with an agile mindset.
  • Build automated, scalable, test-driven ELT pipelines.
  • Utilize software development practices such as version control via Git, CI/CD, and release management.
  • Build data products using various visualization, BI tools and data science tools.
  • Collaborate with Data Engineers, DevOps engineers and architects on improvement opportunities for DataOps tools and frameworks.
  • Implement data quality frameworks and data quality checks.
  • Help define analytical product roadmap to drive the business goals and superior quality outcomes.
  • Work with Data Scientists, Statisticians and Machine learning engineers to implement / scale advanced algorithms to solve health care, operational and quality challenges.
  • Work independently and effectively manage one's time across multiple priorities and projects.
  • Make recommendations about platform adoption, including technology integrations, application servers, libraries, and frameworks.
  • Participate in a shared production on-call support model.
  • Serve as a critical part of a scrum team in an agile environment, ensuring the team successfully meets its deliverables each sprint.

Required Skills:
  • Bachelor's Degree in Computer Science, Computer / Software, Engineering, Information Technology or related fields. In lieu of degree an equivalent work experience or training will be considered.
  • Six (6) to eight (8) years of experience working in data and analytics landscape.
  • Strong SQL, Data Modeling and Data Warehousing fundamentals.
  • Experience with software development practices; version control, code review, CI/CD.
  • Experience with data integration tools: DBT, Informatica, MS Integration Services etc.
  • Experience with big data toolset: Hadoop, Spark, Kafka, Hive, Sqoop, etc.
  • Experience working with Business Intelligence Tools (Business Objects) or Visualization tools such as Qlik, Tableau, Power BI, etc.
  • Experience with stream-processing systems: IBM Streams, Flume, Storm, Spark-Streaming, etc.
  • Good hands-on experience with Linux (RHEL / Debian) operating system.
  • Ability to code with other scripting languages such as Python, Bash, groovy etc.
  • Experience consuming and building APIs.
  • Experience utilizing Agile methodology for development.


Preferred Qualifications:
  • One (1) year of experience working with at least one of the public cloud platforms such AWS / Azure / GCP.
  • Experience with Apache Airflow or similar workflow orchestration tools for scheduling and managing analytics pipelines.
  • 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 (e.g., Git, pull requests, code reviews).
  • Experience supporting BI platform migrations (e.g., Qlik, Business Objects, or similar to Power BI).
  • Advanced SQL for analytics engineering, including complex transformations, aggregations, and performance tuning.
  • Strong dimensional data modeling skills, including design and implementation of fact and dimension tables.
  • Hands-on experience with Snowflake as a cloud data warehouse for analytics workloads.
  • Experience developing and maintaining analytics models using dbt, including testing and documentation.
  • Proven ability to refactor existing analytical data models to support reporting and dashboard migrations.
  • Experience supporting enterprise BI platforms, preferably Power BI, including semantic model alignment.
  • Strong analytical and problemsolving skills, with the ability to evaluate tradeoffs and recommend optimal modeling approaches.


Partner's Consulting is an award-winning IT Consulting and Recruiting firm based in the Philadelphia area. We've built personal relationships with our clients over many years and work directly with decision makers on all open positions. Our core values are focused on the highest level of professional dedication to our client's requirements coupled with our desire to partner with highly qualified talent for joint success.


37599050

Numbers & Facts

LocationPhiladelphia, PA

Skills

  • Agile Programming Methodologiesunmatched
  • Algorithmsunmatched
  • Amazon Web Services (AWS)unmatched
  • Analysis Skillsunmatched
  • Apacheunmatched
  • Apache Hadoopunmatched
  • Apache Hiveunmatched
  • Apache Sparkunmatched
  • Apache Sqoopunmatched
  • Application Integrationunmatched
  • Application Programming Interface (API)unmatched
  • Application Serversunmatched
  • Automationunmatched
  • Bash Scriptingunmatched
  • Big Dataunmatched
  • Bridge Buildingunmatched
  • Business Intelligenceunmatched
  • Business Intelligence Softwareunmatched
  • Civil Engineeringunmatched
  • Cloud Computingunmatched
  • Code Reviewsunmatched
  • Computer Scienceunmatched
  • Computer Softwareunmatched
  • Consultingunmatched
  • Continuous Deployment/Deliveryunmatched
  • Continuous Integrationunmatched
  • Customer Relationsunmatched
  • Data Analysisunmatched
  • Data Managementunmatched
  • Data Modelingunmatched
  • Data Qualityunmatched
  • Data Scienceunmatched
  • Data Setsunmatched
  • Data Warehousingunmatched
  • Debian Linuxunmatched
  • DevOpsunmatched
  • Develop Methodologiesunmatched
  • Dimensional Modelingunmatched
  • Documentationunmatched
  • GCP (Good Clinical Practices)unmatched
  • Gitunmatched
  • Groovy Programming Languageunmatched
  • Healthcareunmatched
  • IBM Systemsunmatched
  • Informaticaunmatched
  • Information Technology & Information Systemsunmatched
  • Information Technology Consultingunmatched
  • Linux Operating Systemunmatched
  • Machine Learningunmatched
  • Metricsunmatched
  • Microsoft Windows Azureunmatched
  • Multitaskingunmatched
  • On Callunmatched
  • Operating Systemsunmatched
  • Performance Tuning/Optimizationunmatched
  • Power BIunmatched
  • Product Developmentunmatched
  • Product Planningunmatched
  • Public Cloudunmatched
  • Python Programming/Scripting Languageunmatched
  • Qlikunmatched
  • Quality Managementunmatched
  • Red Hat Linux Operating Systemunmatched
  • Refactoringunmatched
  • Release Management/Engineeringunmatched
  • Reporting Dashboardsunmatched
  • SAP BusinessObjectsunmatched
  • SQL (Structured Query Language)unmatched
  • Sales Pipelineunmatched
  • Scalable System Developmentunmatched
  • Scripting (Scripting Languages)unmatched
  • Scrum Project Management and Software Developmentunmatched
  • Snowflake Schemaunmatched
  • Software Developmentunmatched
  • Software Engineeringunmatched
  • Source Code/Configuration Management (SCM)unmatched
  • Tableauunmatched
  • Test Automationunmatched
  • Testingunmatched
  • Time Managementunmatched
  • Trade-Off Analysisunmatched
  • Workflow Analysisunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder