Overview:
This role focuses on backend development and integrations for building and maintaining enterprise data warehouses and data lakes. The ideal candidate will possess a deep understanding of data architecture, ETL pipelines, and integration technologies, ensuring seamless data flow and accessibility across the organization.
Key Responsibilities:
• Data integration: Build and maintain Fivetran pipelines that ingest data from ERP systems, databases, and business applications into Snowflake. Monitor synchronization, troubleshoot failures, and manage source schema changes.
• Data transformation: Develop modular dbt models using SQL, including staging, intermediate, and business consumption layers. Implement incremental processing, reusable logic, testing, and documentation.
• Snowflake development: Design and optimize tables, views, schemas, and warehouses to support performance, scalability, and cost efficiency.
• Data modeling: Create dimensional models and enterprise data marts that provide consistent business definitions for reporting, analytics, and integrations.
• Data quality: Implement automated validation, reconciliation, freshness checks, and monitoring to improve data accuracy and reliability.
• Governance and security: Apply access controls, data classification, lineage, and established architecture standards across data solutions.
• Deployment and change management: Use Git, code reviews, and CI/CD practices to manage changes across development, testing, and production environments.
• Production support: Investigate pipeline and data issues, perform root cause analysis, and implement corrective actions to prevent recurrence.
• Business collaboration: Translate requirements into technical solutions and deliver governed datasets for Power BI, operational applications, and AI agents.
• Documentation: Maintain source mappings, transformation rules, technical designs, and support procedures.
Qualifications:
• Bachelor's degree in computer science, Information Systems, Engineering, or a related field, or equivalent practical experience.
• Three or more years of experience in data engineering, data warehousing, or enterprise data integration.
• Hands-on experience with Snowflake, dbt, and FiveTran.
• Strong SQL skills, including complex transformations, query optimization, and troubleshooting.
• Experience with ELT pipelines, dimensional modeling, incremental loading, and historical data management.
• Experience developing dbt models, tests, documentation, and reusable macros.
• Working knowledge of Git, deployment automation, and software development practices.
• Understanding of data governance, access management, and production support.
• Strong analytical, communication, and problem-solving skills.
Preferred Qualifications:
• Python experience for automation, validation, and integration.
• Experience integrating ERP data, particularly Infor LN, Infor SyteLine, or similar platforms.
• Familiarity with Power BI semantic models and enterprise reporting requirements.
• Experience supporting manufacturing, supply chain, sales, inventory, customer, or finance data.
• Familiarity with AWS or Azure environments.
• Exposure to Snowflake Cortex AI or other AI solutions using governed enterprise data.
• Relevant Snowflake, dbt, or cloud certifications.
Benefits:
- Competitive medical, dental, and vision coverage starting day one.
- 401(k) with company match
- Paid time off and 9 paid holidays
- Employee Assistance Program (EAP)
- Company-paid life and short-term disability insurance
- Employee discounts on Holley Performance Brands products, events, and partnerships
- Education Assistance program