Onsite Data Engineer role in Pittsburgh, PA focused on building scalable pipelines and data systems for analytics and business intelligence.

Design, develop, and maintain scalable ETL pipelines using Informatica, Talend, or custom scripting in Python and Bash
Build and optimize data models for data warehouses using dimensional modeling aligned to business requirements
Manage and enhance cloud-based data storage, including Azure Data Lake and AWS cloud databases
Develop SQL queries and stored procedures for efficient query management in SQL Server, Oracle, and other relational databases
Implement big data systems using Hadoop ecosystem components such as Apache Hive and Spark
Collaborate with cross-functional teams to integrate linked data sources and maintain data flow across platforms
Support development of business intelligence dashboards using Looker or equivalent BI tools
Maintain data quality, security, and compliance standards across pipelines and models
Participate in Agile cycles to deliver iterative improvements
Assist with model training and analysis tasks supporting advanced analytics initiatives
Write shell scripts or VBA macros to automate routine tasks or facilitate analysis

Reside in Pittsburgh, PA to be considered
3–5 years of experience as a Data Engineer
Hands-on experience with Snowflake
Experience with schema design, warehouse sizing, clustering, time travel, and cost management in Snowflake
dbt core experience, including modular models, macros, packages, and incremental materialization
ELT experience
Experience configuring and operating Airbyte / Fivetran (or similar) for multi-source ingestion
Experience with Data Warehouse / Data Lakes
Azure/Cloud experience
Hands-on experience with Azure SQL Managed Instance, Storage, and DevOps pipelines
Python for data sync jobs, API clients, and FastAPI development
Reporting experience with Tableau or PowerBI
Education: Degree required; if no degree, then 7+ years of experience

Data Engineer

Job Description