Data Engineer

eNGINE; Pittsburgh (Allegheny County); On-site; USD 110,000 - 170,000; Full time

Benefits offered by this job

401(k) match

Profit sharing after 1 year

Job summary

eNGINE is hiring a founding Data Engineer to build a modern data platform for an HVAC-focused online marketplace. You will work directly with the VP of Engineering to design a Snowflake-based architecture, implement ELT pipelines, and establish data governance and quality standards as the team grows.

The role offers ownership over data strategy, modeling standards, and reporting infrastructure, with startup-like autonomy in a growth-focused environment.

Qualifications

• Hands-on Snowflake experience including schema design, performance, and cost management.
• dbt Core production experience with modular models, macros, and tests.
• Experience building multi-source ELT pipelines with Airbyte/Fivetran or similar tools.
• Strong Python development for data pipelines, integrations, API clients, and automation.
• Advanced SQL with complex joins, CTEs, window functions, and data modeling.
• Experience with Azure, especially Azure SQL and deployment pipelines.
• Experience integrating Salesforce REST/Bulk APIs and HubSpot APIs.
• Automated data quality checks, monitoring, and reconciliation.
• Ability to own architecture and communicate decisions to engineering and business stakeholders.

Responsibilities

• Architect and own a modern data platform centered on Snowflake.
• Develop ELT pipelines ingesting data from Salesforce, HubSpot, and more.
• Build and maintain dbt Core models across staging, transformation, and gold layers.
• Create unified data models for customers, products, revenue, and inventory.
• Develop Python-based data synchronization jobs between systems.
• Integrate with Salesforce and HubSpot APIs and other enterprise apps.
• Own pipeline monitoring, data freshness, and reconciliation.
• Establish data quality, testing, lineage, and governance practices.
• Build APIs with Python/FastAPI to expose Snowflake data.
• Design data access controls including RBAC and row-level security.
• Develop dashboards using Streamlit, Tableau, Power BI, or Looker.
• Collaborate with engineering to translate requirements into scalable solutions.
• Migrate away from legacy Azure SQL dependencies while maintaining continuity.
• Document architectural decisions and establish repeatable engineering standards.

Skills

Snowflake

dbt Core

Python

SQL

Azure

APIs

Data modeling

Data governance

Data quality

Documentation

Dashboards

Tools

Airbyte

Fivetran

Streamlit

Sigma

Tableau

Power BI

Looker

FastAPI

GitHub Actions

Job description

eNGINE builds Technical Teams. We are a Solutions and Placement firm shaped by decades of interaction with Technical professionals. Our inspiration is continuous learning and engagement with the markets we serve, the talent we represent, and the teams we build.

We are hiring a Data Engineer for a growing organization that operates an online marketplace and digital distribution platform supporting the HVAC and building automation industry.

This is a greenfield opportunity and a chance to become the company’s founding Data Engineer. You will work directly with the VP of Engineering to modernize the company’s data infrastructure, establish its data strategy, and build a scalable Snowflake-based platform from the ground up.

What You’ll Do

• Architect, build, and own a modern data platform centered around Snowflake and a Bronze/Silver/Gold Medallion Architecture
• Develop ELT pipelines using Airbyte, Fivetran, or similar technologies to ingest data from Salesforce, HubSpot, Acumatica, Dialpad, SQL databases, GA4, and additional operational systems
• Build and maintain dbt Core models across staging, transformation, and business-facing Gold layers
• Create unified customer, product, revenue, pipeline, inventory, and margin data models
• Develop Python-based data synchronization jobs between operational platforms
• Integrate with Salesforce REST/Bulk APIs, HubSpot APIs, and other enterprise applications
• Own pipeline monitoring, alerting, failure recovery, data freshness, and reconciliation
• Establish data quality standards, automated testing, lineage, documentation, and governance practices
• Build APIs using Python/FastAPI to expose Snowflake data to internal applications
• Design data access controls, including role-based and row-level security
• Build and support executive and operational dashboards using tools such as Streamlit, Sigma, Tableau, Power BI, or Looker
• Partner directly with engineering and business leadership to translate business requirements into scalable data solutions
• Support the migration away from legacy Azure SQL dependencies while maintaining continuity of existing systems
• Document architectural decisions and establish repeatable engineering standards as the data environment grows

What We’re Looking For

• Strong hands-on experience with Snowflake, including schema design, performance optimization, warehouse sizing, clustering, and cost management
• Production experience with dbt Core, including modular models, macros, incremental models, packages, testing, and documentation
• Experience building multi-source ELT pipelines with Airbyte, Fivetran, or similar tools
• Strong Python development experience for data pipelines, integrations, API clients, and automation
• Expert-level SQL, including complex joins, CTEs, window functions, and data modeling
• Experience working with Azure, particularly Azure SQL, storage, and deployment pipelines
• Experience integrating with Salesforce APIs, including REST/Bulk APIs, SOQL, and external IDs
• Experience implementing automated data quality checks, monitoring, and reconciliation
• Ability to operate with a high level of ownership in a fast-moving environment with limited existing structure
• Strong documentation habits and the ability to communicate technical decisions to both engineering and business stakeholders

Nice to Have

• Experience in B2B distribution, manufacturing, eCommerce, HVAC, or another product/inventory-heavy environment
• HubSpot API experience
• GA4 and BigQuery experience
• FastAPI experience
• Streamlit or Snowflake-native application development
• Experience with Tableau, Sigma, Power BI, or Looker
• CI/CD experience for data pipelines using GitHub Actions, Bitbucket Pipelines, or similar
• Experience migrating from SQL Server or Azure SQL Managed Instance into a modern cloud data platform
• Experience working through a Strangler Fig or parallel-run migration strategy
• Experience designing executive-facing dashboards and KPI reporting

Why This Opportunity?

This is not a maintenance-focused Data Engineer position. You will be joining an organization that is investing heavily in technology and modernization and will have the opportunity to establish how data engineering is done across the company.

As the first Data Engineer on the team, you will have significant ownership over architecture, tooling, modeling standards, governance, integrations, and reporting infrastructure. The ideal candidate brings a startup mentality — someone who is naturally curious, comfortable working without a predefined playbook, willing to solve problems outside a narrow job description, and motivated by building something from the ground up.

The company offers a 5% 401(k) match, with an additional 4% profit-sharing contribution after one year.