Senior Data Engineer - Snowflake & dbt Platform Expert

Flow Control Group; Charlotte (NC); On-site; USD 110,000 - 170,000; Full time

Benefits offered by this job

Employee ownership

Medical, dental and vision insurance

401(k) matching

Career growth

Paid time off

Job summary

Flow Control Group is seeking a Senior Data Engineer to lead end-to-end ELT development on our Central Data Platform. You will ingest raw source data through Snowflake, build transformations with dbt, and manage data pipelines using Fivetran across a multi-brand data ecosystem.

You will document mappings, optimize performance, and partner with data stakeholders to ensure reliable, high-quality data for analytics across North America.

Qualifications

• Minimum 5+ years of experience developing and scaling dbt projects.
• Minimum 5+ years of experience with Snowflake.
• Proven experience designing and implementing dbt transformations in large-scale enterprise analytics environments.
• Deep knowledge of all aspects of the Snowflake environment, from databases to security and AI capabilities.
• Experience working with data pipeline tools like Fivetran.
• Proven experience designing and managing security requirements.
• Experience in supporting data engineering applications.
• Minimum of 5 years working with cross-functional teams and managing multiple projects and priorities.

Responsibilities

• Technical Expertise: Provide technical expertise in all capabilities of dbt and Snowflake.
• Development: Design, build, and manage data transformations in dbt. Create reusable components and templates and proof-of-concept solutions.
• Source to Target Mappings: Work with data team members to analyze source data and identify transformation requirements to move data to our data warehouse and data marts.
• Data Integration: Design robust, reliable, scalable, and performant systems for large-volume data processing.
• Data Observability: Develop and enhance monitoring of workflows and processes.
• Solution Design: Collaborate with technical teams to design and implement solutions that meet business requirements and align with best practices.
• Security: Design security standards and ensure proper implementation of security.
• Performance: Ensure our data warehouse processing is optimized for performance.
• Support: Provide comprehensive technical support for data warehouse processing.
• Testing and Validation: Develop testing frameworks for solutions to ensure that solutions meet requirements and perform as expected.
• Metadata: Work with business users, technical teams, and data stewards to create documentation and metadata to support understanding of data warehouse processing.
• Continuous Improvement: Identify opportunities for process improvements and system enhancements to increase efficiency and effectiveness.

Skills

SQL

Python

Data analysis

Cloud architectures

Problem solving

Cross-functional collaboration

Data governance

Team player

Tools

dbt

Snowflake

Fivetran

Azure

Job description

Flow Control Group is seeking a Senior Data Engineer to lead end-to-end ELT development on our Central Data Platform. You will ingest raw source data through Snowflake, build transformations with dbt, and manage data pipelines using Fivetran across a multi-brand data ecosystem.

You will document mappings, optimize performance, and partner with data stakeholders to ensure reliable, high-quality data for analytics across North America.