Onsite in Pittsburgh, PA, this Data Engineer role focuses on building and maintaining scalable data systems that power analytics, business intelligence, and data-driven decisions. You will work directly with engineering and business leadership to shape data strategy while developing robust ETL/ELT pipelines, warehouse models, and cloud-based storage solutions.
What youβll do
- Design, develop, and maintain scalable ETL pipelines using tools such as Informatica, Talend, or custom scripting in Python and Bash.
- Build and optimize dimensional data models for data warehouses, aligning structures with business requirements.
- Manage and enhance cloud-based data storage solutions including Azure Data Lake and AWS cloud databases.
- Develop SQL queries and stored procedures for efficient query management across SQL Server, Oracle, and other relational databases.
- Implement big data systems using components from the Hadoop ecosystem, including Apache Hive and Spark.
- Collaborate with cross-functional teams to integrate linked data sources and ensure data flows smoothly across platforms.
- Support business intelligence dashboard development using Looker or equivalent BI platforms.
- Maintain data quality, security, and compliance standards throughout pipeline and modeling work.
- Participate in Agile development cycles to deliver iterative improvements.
- Assist with model training and analysis tasks that support advanced analytics initiatives.
- Write shell scripts or VBA macros as needed to automate routine tasks or support analysis.
What you bring
- Must reside in Pittsburgh, PA to be considered.
- 3 to 5 years of Data Engineer experience.
- Hands-on experience with Snowflake, including schema design, warehouse sizing, clustering, time travel, and cost management.
- dbt core production experience, including modular models, macros, packages, and incremental materialization.
- Experience with ELT.
- Experience configuring and operating Airbyte / Fivetran or similar tools for multi-source ingestion.
- Experience with Data Warehouse and Data Lakes, including Azure and cloud platforms.
- Practical experience with Azure SQL Managed Instance, Storage, and DevOps pipelines.
- Strong 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.
Tools youβll work with
Informatica, Talend, Python, Bash, SQL Server, Oracle, Azure Data Lake, AWS, Apache Hive, Spark, Looker, SQL, Snowflake, dbt core, ELT, Airbyte, Fivetran, Azure SQL Managed Instance, Azure, FastAPI, Tableau, PowerBI, VBA, Hadoop.
Compensation and benefits
Pay: $120,000 - $150,000 per year.
- 401(k)
- Dental insurance
- Flexible schedule
Work location: In person. Preferred location: Pittsburgh, PA 15120.