Senior Data Engineer

Flow Control Group is hiring a Senior Data Engineer for the Central Data Platform team in Charlotte, NC (onsite), building end-to-end ELT in Snowflake using dbt and Fivetran.

Responsibilities

• Provide technical expertise across dbt and Snowflake capabilities
• Design, build, and manage data transformations in dbt
• Create reusable components, templates, and proof-of-concept solutions
• Develop and manage data pipelines as needed
• Implement required functionality within Snowflake
• Partner with the data team to analyze source data and define transformation requirements for data warehouse and data mart delivery
• Design systems that are robust, reliable, scalable, and performant for large-volume processing
• Support data architecture and engineering best-practice decisions
• Develop and enhance monitoring for workflows and engineering processes
• Collaborate with technical teams to deliver solutions aligned to business requirements and best practices
• Design security standards and ensure proper security implementation
• Optimize data warehouse processing for performance
• Ensure data loads and transformations flow through the system to meet requirements
• Provide comprehensive technical support for data warehouse processing
• Build testing frameworks so solutions meet requirements and perform as expected
• Work with business users, technical teams, and data stewards to produce documentation and metadata supporting data warehouse understanding
• Identify opportunities for process improvements and system enhancements to increase efficiency and effectiveness

Requirements

• 5+ years developing and scaling dbt projects
• 5+ years with Snowflake
• Proven experience designing and implementing dbt transformations in large-scale enterprise analytics environments
• Deep knowledge of the Snowflake environment, including databases, security, and AI capabilities
• Experience with Fivetran and data pipeline tools
• Proven experience designing and managing security requirements
• Experience supporting data engineering applications
• 5+ years working cross-functionally while managing multiple projects and priorities
• Expert in SQL and data analysis
• Experience with Python and AI
• Strong understanding of data integrations, data warehousing, data modeling, and data engineering
• Expert ability to create architecture diagrams and document requirements and design details
• Familiarity with Azure and cloud architectures
• Excellent problem-solving skills and attention to detail
• Ability to analyze complex business processes and translate them into technical requirements
• Evaluate designs for performance, traceability, and usability
• Expertise implementing data warehouses, data marts, and analytic datasets aligned to business objectives
• Ability to analyze data from disparate sources to identify gaps in data or definitions
• Ability to test data products and analyze data for patterns and anomalies impacting deliverables
• Ensure alignment with data standards and data governance
• Strong verbal and written communication skills
• Ability to communicate effectively with technical and non-technical stakeholders
• Ability to work collaboratively in a team environment
• Comfortable in a fast-paced, dynamic environment
• Proactive and able to work independently with minimal supervision
• Strong commitment to delivering high-quality service to internal and external customers

Technologies

• Snowflake
• dbt
• Fivetran
• SQL
• Python
• AI
• Azure

Benefits

• Medical, Dental, and Vision coverage
• Competitive 401(k) matching
• Paid time off
• Holidays
• Parental leave
• Wellness resources
• Employee referral programs
• Emergency assistance funds
• Earned wage access
• Financial coaching
• Low-cost loan options
• Retirement planning resources
• Opportunities to build long-term wealth through employee ownership
• FCG University access to more than 80,000 learning courses

Personal Attributes

• Ability to work collaboratively in a team environment
• Comfortable working in a fast-paced and dynamic environment
• Proactive and able to work independently with minimal supervision
• Strong commitment to delivering high-quality service to internal and external customers

Communication Skills

• Strong verbal and written communication skills
• Ability to effectively communicate with technical and non-technical stakeholders

Required Analytical Skills

• Excellent problem-solving skills and attention to detail
• Ability to analyze complex business processes and translate them into technical requirements
• Evaluate performance, traceability, and usability in all designs
• Expertise implementing data warehouses, data marts, and analytic datasets aligned with business objectives
• Ability to analyze data from disparate sources to identify gaps in data or definitions
• Ability to effectively test data products and analyze data for patterns and anomalies that impact deliverables
• Ensure alignment with data standards and data governance