Data Engineer

A.C.Coy Company; Pittsburgh (Allegheny County); On-site; USD 120,000 - 150,000; Full time

Benefits offered by this job

401(k)

Dental insurance

Flexible schedule

Job summary

A.C.Coy Company in Pittsburgh, PA is seeking an onsite Data Engineer to design, build, and maintain scalable data systems supporting analytics and business intelligence. You will work across the data pipeline lifecycle, from ETL/ELT and modeling to query development and data quality, partnering with engineering and leadership on data strategy.

You will design and optimize ETL pipelines, data models for data warehouses, and cloud storage across Azure and AWS, with Snowflake and dbt core in

Qualifications

• Must reside in Pittsburgh, PA.
• 3 to 5 years of Data Engineering experience.
• Snowflake experience with schema design, warehouse sizing, clustering, time travel, cost management.
• dbt core production experience with modular models, macros, packages, incremental materialization.
• ELT experience.
• Configure and operate Airbyte, Fivetran for multi-source ingestion.
• Data Warehouse/Data Lakes experience including Azure/Cloud.
• Azure SQL Managed Instance, Azure Storage, and DevOps pipelines.
• Strong Python for data sync, API clients, and FastAPI.
• Reporting tools Tableau or PowerBI.
• Education: Degree required; if no degree, then 7+ years.

Responsibilities

• Design, develop, and maintain scalable ETL pipelines and data models across platforms.
• Build data warehouses and optimize cloud-based storage (Azure/AWS).
• Develop SQL queries and stored procedures for multiple relational engines.
• Implement big data systems with Hive, Spark, and Hadoop ecosystem tools.
• Collaborate to integrate linked data sources and ensure data flow consistency.
• Support BI dashboards with Looker or equivalent tools and ensure data quality.
• Participate in Agile cycles and contribute to analytics initiatives.
• Support model training and analytics tasks as needed.

Skills

ETL pipelines

Python

Bash

Data models

Data warehouses

Cloud storage

Azure Data Lake

AWS

SQL queries

Stored procedures

Snowflake

dbt core

Airbyte

Fivetran

Azure SQL Managed Instance

Azure

Looker

PowerBI

Tableau

Hadoop

Spark

Hive

SQL Server

Oracle

DevOps pipelines

FastAPI

Informatica

Talend

Education

Bachelor's degree

Tools

Informatica

Talend

Airbyte

Fivetran

dbt core

Job description

A.C.Coy Company is hiring an onsite Data Engineer in Pittsburgh, PA to help build and maintain reliable, scalable data systems that support analytics and business intelligence. In this role, you will work across the data pipeline lifecycle, from ETL/ELT and modeling to query development and data quality, while partnering with engineering and business leadership on data strategy.

What you’ll do

• 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 across SQL Server, Oracle, and other relational databases.
• Implement big data systems using the Hadoop ecosystem, including Apache Hive, Spark, and related technologies.
• Collaborate with cross-functional teams to integrate linked data sources and ensure consistent data flow across platforms.
• Support business intelligence dashboard development using Looker or equivalent BI platforms.
• Maintain data quality, security, and compliance standards across all processes.
• Participate in Agile cycles to deliver iterative improvements.
• Assist with model training and analysis tasks that support advanced analytics initiatives.
• Write shell scripts or VBA macros to automate routine tasks or facilitate analysis when needed.

Required experience and qualifications

• Candidates must reside in Pittsburgh, PA to be considered.
• 3 to 5 years of Data Engineering experience.
• Experience with Snowflake, including hands-on work with schema design, warehouse sizing, clustering, time travel, and cost management.
• Experience with dbt core, including production use of 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/Cloud.
• Practical experience with Azure SQL Managed Instance, Azure Storage, and DevOps pipelines.
• Strong Python for data synchronization jobs, API clients, and FastAPI development.
• Reporting tool experience with Tableau or PowerBI.
• Education: Degree required; if no degree, then 7+ years of experience.

Location and work mode

• Work location: In person
• Preferred location: Pittsburgh, PA 15120

Compensation and benefits

• Salary: USD $120,000 to $150,000 per year
• Benefits: 401(k), Dental insurance, Flexible schedule

Technologies you may work with

• Informatica, Talend, Python, Bash
• SQL Server, Oracle, SQL
• Azure Data Lake, AWS
• Apache Hive, Spark, Hadoop ecosystem components
• Looker
• Snowflake, dbt core, ELT
• Airbyte, Fivetran
• Azure SQL Managed Instance, Azure, FastAPI
• Tableau, PowerBI, VBA