{"schemaVersion":"jobsearcher.job.v1","id":"9f5b1b327c64cd7b3522d9c3","url":"https://jobsearcher.com/jobs/9f5b1b327c64cd7b3522d9c3","canonicalUrl":"https://jobsearcher.com/jobs/9f5b1b327c64cd7b3522d9c3","title":"Data Architect Data Analytics","description":"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.Architect, 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 growsStrong 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 structureExperience in B2B distribution, manufacturing, eCommerce, HVAC, or another product/inventory-heavy environmentHubSpot API 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 platformThis 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.","company":"Engine","rawCompany":"engine","city":"Pittsburgh","state":"PA","isRemote":false,"isActive":false,"createdAt":"2026-10-26T11:42:27.606Z","occupations":[{"code":"15-1243.01","title":"Data Warehousing Specialists","slug":"data-warehousing-specialists"},{"code":"15-1243.00","title":"Database Architects","slug":"database-architects"},{"code":"15-1299.08","title":"Computer Systems Engineers/Architects","slug":"computer-systems-engineers-architects"}],"industries":[{"code":"541512","title":"Computer Systems Design Services","slug":"computer-systems-design-services"},{"code":"513210","title":"Software Publishers","slug":"software-publishers"},{"code":"541511","title":"Custom Computer Programming Services","slug":"custom-computer-programming-services"}],"jobPosting":{"@context":"https://schema.org","@type":"JobPosting","title":"Data Architect Data Analytics","description":"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.Architect, 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 growsStrong 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 structureExperience in B2B distribution, manufacturing, eCommerce, HVAC, or another product/inventory-heavy environmentHubSpot API 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 platformThis 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.","datePosted":"2026-10-26T11:42:27.606Z","dateModified":"2026-10-26T11:42:27.606Z","hiringOrganization":{"@type":"Organization","name":"Engine","sameAs":"https://jobsearcher.com"},"jobLocation":{"@type":"Place","address":{"@type":"PostalAddress","addressLocality":"Pittsburgh","addressRegion":"PA","addressCountry":"US"}},"identifier":{"@type":"PropertyValue","name":"JobSearcher","value":"9f5b1b327c64cd7b3522d9c3"},"url":"https://jobsearcher.com/jobs/9f5b1b327c64cd7b3522d9c3"}}