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.
Why Holley Is a Great Place to Work At Holley, we’re more than a performance parts company - we’re a community of enthusiasts, innovators, and problem-solvers. We offer a competitive benefits package and a culture that values both performance and people.
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
Holley is an Equal Opportunity Employer committed to building a diverse and inclusive workforce. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, marital status, veteran status, disability, or any other legally protected status. If you require assistance or accommodation due to a disability during the application process, please contact human resources.