Analytics Engineer — Data Pipelines, Dashboards & KPIs

Life in Pittsburgh

Pittsburgh (Allegheny County)

On-site

USD 100,000 - 150,000

Full time

8 days ago

Get a reply from this employer

Your resume and cover letter, tailored to exactly what they’re hiring for.

Get past ATS filters

Benefits offered by this job

Medical benefits
401(k) plan

Job summary

Pittsburgh Tomorrow is seeking an Analytics Engineer to join a growing team in the Pittsburgh metro area. The role focuses on building data pipelines, transforming data, and delivering trusted analytics for business insights.

You will design dimensional models, establish KPI logic, and collaborate with partners to translate reporting needs into scalable solutions. This is a hands-on, data-driven role in a cloud-based environment.

Qualifications

  • 3+ years in enterprise data warehouses or large-scale analytical environments.
  • Experience designing dashboards and analytical solutions for business users.
  • Solid understanding of dimensional modeling and scalable data architecture.
  • Knowledge of data governance and access control within reporting environments.
  • Ability to create KPIs, calculated measures, and data-driven insights.

Responsibilities

  • Build and maintain data pipelines in a cloud-based ecosystem for analytics and reporting.
  • Consolidate data from multiple sources into unified datasets for insights.
  • Create and optimize dimensional structures to boost reporting performance.
  • Write and troubleshoot advanced queries to improve data quality and efficiency.
  • Develop dashboards and BI reports for operational, financial, sales, and leadership use.
  • Establish semantic models, metrics, and reusable reporting components.
  • Configure KPI logic, trend reporting, and forecasting calculations in reporting platforms.
  • Enforce data access controls and RBAC to protect sensitive information.
  • Collaborate with business partners to translate reporting needs into technical solutions.
  • Document data rules, models, and processes for long-term maintainability.

Skills

Advanced SQL
Data transformation
Performance tuning
KPI design
Data governance

Education

Bachelor's degree or equivalent

Tools

Python
Apache Spark
Apache Hadoop
Apache Kafka
ETL processes

Job description

Pittsburgh Tomorrow is seeking an Analytics Engineer to join a growing team in the Pittsburgh metro area. The role focuses on building data pipelines, transforming data, and delivering trusted analytics for business insights.

You will design dimensional models, establish KPI logic, and collaborate with partners to translate reporting needs into scalable solutions. This is a hands-on, data-driven role in a cloud-based environment.

Get your free, confidential resume review.

or drag and drop your file here.

Similar jobs

Similar jobs worth comparing

Data Engineer - Real-Time Enterprise Pipelines (Pittsburgh)
Data Engineer - Real-Time Enterprise Pipelines (Pittsburgh)

Air • Pittsburgh

On-site
USD 110,000 - 150,000
Data Engineer: ETL Pipelines for Industrial Analytics (Pittsburgh)
Data Engineer: ETL Pipelines for Industrial Analytics (Pittsburgh)

MedTeam Staffing Inc. • Pittsburgh

Hybrid
USD 100,000 - 140,000
Senior Data Engineer — AWS Data Pipelines (Hybrid PA)
Senior Data Engineer — AWS Data Pipelines (Hybrid PA)

Pittsburgh Tomorrow • Pittsburgh

Hybrid
USD 140,000 - 180,000
Comprehensive benefits
Paid time off
401(k) plan
Data Engineer: Build Industrial Data Pipelines (Pittsburgh)
Data Engineer: Build Industrial Data Pipelines (Pittsburgh)

Talent With Heart • Pittsburgh

Hybrid
USD 120,000 - 150,000
Data Engineer: Industrial Pipelines & Analytics (On-Site)
Data Engineer: Industrial Pipelines & Analytics (On-Site)

CareerNerds, LLC • Pittsburgh

Hybrid
USD 100,000 - 140,000
Analytics Engineering Lead
Analytics Engineering Lead

Tata Consultancy Services Limited • Pittsburgh

On-site
USD 110,000 - 120,000
Discretionary Annual Incentive
Comprehensive Medical Coverage
Family Support: Leaves
+5
Data Engineer On-site ETL Pipelines for Industrial Analytics
Data Engineer On-site ETL Pipelines for Industrial Analytics

Client Growth Resources, Inc • Pittsburgh

Hybrid
USD 100,000 - 150,000
Data Engineer — Scalable Pipelines & Growth Impact
Data Engineer — Scalable Pipelines & Growth Impact

Archer • Pittsburgh

On-site
USD 100,000 - 140,000
Data Engineer: Build Enterprise Data Pipelines (On-Site)
Data Engineer: Build Enterprise Data Pipelines (On-Site)

Professional Recruiting Consultants, Inc. • Pittsburgh

Hybrid
USD 90,000 - 140,000
Data Engineer: Build Robust Pipelines & Analytics (On-Site)
Data Engineer: Build Robust Pipelines & Analytics (On-Site)

Your Talent Team • Pittsburgh

Hybrid
USD 95,000 - 125,000