Senior Data Engineer

Senior Data Engineer role on Flow Control Group’s Central Data Platform team, focused on end-to-end ELT development in Snowflake using dbt and Fivetran.

Responsibilities

• Provide technical expertise across dbt and Snowflake capabilities
• Design, build, and manage dbt data transformations
• Create reusable dbt components, templates, and proof-of-concept solutions
• Develop and manage data pipelines as needed
• Implement required functionality in Snowflake
• Partner with the data team to analyze source data and identify transformation requirements to support movement into the data warehouse and data marts
• Design robust, reliable, scalable, and performant systems for large-volume data processing
• Contribute to decisions on data architecture and engineering best practices
• Develop and enhance monitoring for workflows and processes
• Collaborate with technical teams to deliver solutions that meet business requirements and align with best practices
• Design security standards and ensure correct security implementation
• Optimize data warehouse processing for performance
• Coordinate with team members to ensure data loads and transformations flow through the system to deliver required data
• Provide comprehensive technical support for data warehouse processing
• Develop testing frameworks to confirm solutions meet requirements and perform as expected
• Work with business users, technical teams, and data stewards to create documentation and metadata supporting understanding of data warehouse processing
• Identify opportunities to improve processes and enhance systems to increase efficiency and effectiveness

Requirements

• Minimum 5+ years experience developing and scaling dbt projects
• Minimum 5+ years experience with Snowflake
• Proven experience designing and implementing dbt transformations in large-scale enterprise analytics environments
• Deep knowledge of Snowflake environment areas including databases, security, and AI capabilities
• Experience using data pipeline tools such as Fivetran
• Proven experience designing and managing security requirements
• Experience supporting data engineering applications
• Minimum of 5 years working with cross-functional teams and 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
• Expertise creating architecture diagrams and documenting 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
• Ability to evaluate performance, traceability, and usability in 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 test data products and analyze data for patterns and anomalies that affect deliverables
• Ensure alignment with data standards and data governance
• Strong verbal and written communication skills, including communicating with technical and non-technical stakeholders
• Ability to work collaboratively in a team environment
• Comfortable in a fast-paced, dynamic environment
• Proactive approach with ability 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 impacting deliverables
• Ensure alignment with data standards and data governance

Location: Charlotte, NC (onsite)

Experience: Minimum 5 years