Lead Data Engineer: Snowflake Data Platform

Priority Dispatch Corp.; Town of Florida, Northern (NY, KY); Hybrid; USD 120,000 - 170,000; Full time

Job summary

Priority Dispatch Corp. in the United States is seeking a Lead Data Engineer to design, build, and maintain an enterprise data platform powering analytics, reporting, and applications across the organization.

You will implement a Snowflake-based medallion architecture, develop data models with dbt Cloud, migrate legacy SQL Server/Azure SQL, and partner with Finance, Operations, Marketing, and Technology to deliver trusted insights and scalable data solutions.

Qualifications

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or related field, or equivalent experience.
• 5+ years of experience in data engineering, data warehousing, or analytics engineering.
• Strong experience with Snowflake, including warehouse management, security, and performance optimization.
• Experience with dbt and dbt Cloud for data modeling, testing, documentation, and deployment.
• Advanced SQL skills with experience optimizing and modernizing legacy SQL environments.
• Experience designing dimensional data models, including Kimball methodologies and Slowly Changing Dimensions (SCD Type 2).
• Experience building scalable ETL/ELT pipelines using Python and modern orchestration tools.
• Familiarity with Azure cloud services including Azure Data Lake Storage, Azure Data Factory, Key Vault, and related services.
• Experience with Git-based version control and CI/CD processes.
• Experience integrating multiple enterprise applications and APIs.
• Knowledge of business intelligence platforms such as Power BI or similar visualization tools.
• Experience supporting retail, hospitality, automotive, or multi-location businesses is preferred.
• Excellent analytical, problem-solving, communication, and stakeholder management skills.
• Ability to thrive in a fast-paced, high-growth environment and effectively manage multiple priorities.

Responsibilities

• Design, build, and maintain scalable data pipelines within the Snowflake data platform using a Bronze, Silver, and Gold (medallion) architecture.
• Develop and optimize data models using dbt Cloud to create reliable, business-ready datasets.
• Integrate and manage data from multiple enterprise systems including POS, HRIS, ERP, CRM, Finance, Marketing, and operational platforms.
• Lead the migration of legacy SQL Server and Azure SQL data environments into a modern cloud-based architecture.
• Develop and maintain a unified enterprise data model that standardizes information across multiple source systems and acquisitions.
• Build automated ingestion, transformation, and change-detection processes to support new business applications and acquisitions.
• Implement data quality standards, testing, documentation, monitoring, and governance best practices.
• Establish CI/CD processes and version control to support reliable, scalable data development.
• Partner with Finance, Operations, Marketing, and Technology teams to understand business requirements and deliver trusted reporting and analytics solutions.
• Support business intelligence, dashboards, self-service reporting, and future AI and automation initiatives.
• Troubleshoot data issues, optimize platform performance, and continuously improve the reliability and scalability of the data ecosystem.

Skills

Snowflake

dbt Cloud

SQL

ETL pipelines

Python

Azure cloud

Git/CI-CD

Dimensional modeling

Power BI

Stakeholder management

Education

Bachelor's degree in CS/IS or related field

Tools

Snowflake

SQL Server

Azure Data Factory

Azure Data Lake Storage

dbt Cloud

Power BI

Git

Job description

Priority Dispatch Corp. in the United States is seeking a Lead Data Engineer to design, build, and maintain an enterprise data platform powering analytics, reporting, and applications across the organization.

You will implement a Snowflake-based medallion architecture, develop data models with dbt Cloud, migrate legacy SQL Server/Azure SQL, and partner with Finance, Operations, Marketing, and Technology to deliver trusted insights and scalable data solutions.