Data Engineer
Engine · Pittsburgh, Pennsylvania, United States
FULL TIMEpermanent
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.
Do you have the right skills and experience for this role Read on to find out, and make your application.
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 DoArchitect, build, and own a modern data platform centered around Snowflake and a Bronze/Silver/Gold Medallion ArchitectureDevelop ELT pipelines using Airbyte, Fivetran, or similar technologies to ingest data from Salesforce, HubSpot, Acumatica, Dialpad, SQL databases, GA4, and additional operational systemsBuild and maintain dbt Core models across staging, transformation, and business-facing Gold layersCreate unified customer, product, revenue, pipeline, inventory, and margin data modelsDevelop Python-based data synchronization jobs between operational platformsIntegrate with Salesforce REST/Bulk APIs, HubSpot APIs, and other enterprise applicationsOwn pipeline monitoring, alerting, failure recovery, data freshness, and reconciliationEstablish data quality standards, automated testing, lineage, documentation, and governance practicesBuild APIs using Python/FastAPI to expose Snowflake data to internal applicationsDesign data access controls, including role-based and row-level securityBuild and support executive and operational dashboards using tools such as Streamlit, Sigma, Tableau, Power BI, or LookerPartner directly with engineering and business leadership to translate business requirements into scalable data solutionsSupport the migration away from legacy Azure SQL dependencies while maintaining continuity of existing systemsDocument architectural decisions and establish repeatable engineering standards as the data environment growsWhat We’re Looking ForStrong hands-on experience with Snowflake, including schema design, performance optimization, warehouse sizing, clustering, and cost managementProduction experience with dbt Core, including modular models, macros, incremental models, packages, testing, and documentationExperience building multi-source ELT pipelines with Airbyte, Fivetran, or similar toolsStrong Python development experience for data pipelines, integrations, API clients, and automationExpert-level SQL, including complex joins, CTEs, window functions, and data modelingExperience working with Azure, particularly Azure SQL, storage, and deployment pipelinesExperience integrating with Salesforce APIs, including REST/Bulk APIs, SOQL, and external IDsExperience implementing automated data quality checks, monitoring, and reconciliationAbility to operate with a high level of ownership in a fast-moving environment with limited existing structureStrong documentation habits and the ability to communicate technical decisions to both engineering and business stakeholdersNice to HaveExperience in B2B distribution, manufacturing, eCommerce, HVAC, or another product/inventory-heavy environmentHubSpot API experienceGA4 and BigQuery experienceFastAPI experienceStreamlit or Snowflake-native application developmentExperience with Tableau, Sigma, Power BI, or LookerCI/CD experience for data pipelines using GitHub Actions, Bitbucket Pipelines, or similarExperience migrating from SQL Server or Azure SQL Managed Instance into a modern cloud data platformExperience working through a Strangler Fig or parallel-run migration strategyExperience designing executive-facing dashboards and KPI reportingWhy 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.No C2C candidates will be considered. xzbcwsv Apply today to learn more.
Do you have the right skills and experience for this role Read on to find out, and make your application.
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 DoArchitect, build, and own a modern data platform centered around Snowflake and a Bronze/Silver/Gold Medallion ArchitectureDevelop ELT pipelines using Airbyte, Fivetran, or similar technologies to ingest data from Salesforce, HubSpot, Acumatica, Dialpad, SQL databases, GA4, and additional operational systemsBuild and maintain dbt Core models across staging, transformation, and business-facing Gold layersCreate unified customer, product, revenue, pipeline, inventory, and margin data modelsDevelop Python-based data synchronization jobs between operational platformsIntegrate with Salesforce REST/Bulk APIs, HubSpot APIs, and other enterprise applicationsOwn pipeline monitoring, alerting, failure recovery, data freshness, and reconciliationEstablish data quality standards, automated testing, lineage, documentation, and governance practicesBuild APIs using Python/FastAPI to expose Snowflake data to internal applicationsDesign data access controls, including role-based and row-level securityBuild and support executive and operational dashboards using tools such as Streamlit, Sigma, Tableau, Power BI, or LookerPartner directly with engineering and business leadership to translate business requirements into scalable data solutionsSupport the migration away from legacy Azure SQL dependencies while maintaining continuity of existing systemsDocument architectural decisions and establish repeatable engineering standards as the data environment growsWhat We’re Looking ForStrong hands-on experience with Snowflake, including schema design, performance optimization, warehouse sizing, clustering, and cost managementProduction experience with dbt Core, including modular models, macros, incremental models, packages, testing, and documentationExperience building multi-source ELT pipelines with Airbyte, Fivetran, or similar toolsStrong Python development experience for data pipelines, integrations, API clients, and automationExpert-level SQL, including complex joins, CTEs, window functions, and data modelingExperience working with Azure, particularly Azure SQL, storage, and deployment pipelinesExperience integrating with Salesforce APIs, including REST/Bulk APIs, SOQL, and external IDsExperience implementing automated data quality checks, monitoring, and reconciliationAbility to operate with a high level of ownership in a fast-moving environment with limited existing structureStrong documentation habits and the ability to communicate technical decisions to both engineering and business stakeholdersNice to HaveExperience in B2B distribution, manufacturing, eCommerce, HVAC, or another product/inventory-heavy environmentHubSpot API experienceGA4 and BigQuery experienceFastAPI experienceStreamlit or Snowflake-native application developmentExperience with Tableau, Sigma, Power BI, or LookerCI/CD experience for data pipelines using GitHub Actions, Bitbucket Pipelines, or similarExperience migrating from SQL Server or Azure SQL Managed Instance into a modern cloud data platformExperience working through a Strangler Fig or parallel-run migration strategyExperience designing executive-facing dashboards and KPI reportingWhy 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.No C2C candidates will be considered. xzbcwsv Apply today to learn more.
Details
| Company | Engine |
| Location | Pittsburgh, Pennsylvania, United States |
| Type | FULL TIME |
| Niche | general |
| Experience | permanent |

