Senior Data Engineer

Hunter Industries is seeking a Senior Data Engineer who designs, develops, and maintains enterprise data systems and pipelines that enable the organization to use data as a strategic asset. This role provides technical leadership and expertise in building scalable, efficient, and governed data solutions that support analytics, reporting, and advanced use cases such as AI and machine learning. The Senior Data Engineer acts as a bridge between business needs and technology implementation, ensuring data systems are reliable, performant, and aligned with enterprise standards.

*This role can be performed onsite or hybrid (3 days in office) at our campus in San Marcos, CA.  Candidates must be located within a commutable distance from campus. 

Essential Job Functions/Tasks:

1. Designs, develops, and optimizes data pipelines and workflows for ingestion, transformation, and delivery of data across enterprise platforms.
2. Integrates structured and semi-structured data from diverse sources—Oracle Fusion (ERP/EPM), on-premises databases, and cloud applications (APIs, external systems)—into the Snowflake data platform.
3. Applies data cleansing, validation, enrichment, and quality controls to ensure accuracy, consistency, and trust in enterprise data.
4. Monitors and tunes pipelines and storage solutions for scalability, performance, and cost-effectiveness.
5. Implements governance, security, and compliance practices in alignment with enterprise standards.
6. Collaborates with architects, analysts, and data scientists to deliver solutions that support Power BI analytics, reporting, AI/ML, and self-service use cases.
7. Provides technical leadership by guiding best practices in pipeline design, coding standards, and system optimization.
8. Mentors junior engineers and contributes to knowledge sharing across the Data & Analytics team.
9. Evaluates and adopts emerging technologies, tools, and practices that strengthen the enterprise’s data capabilities.
10. Partners with business stakeholders to understand use cases, translate requirements, and deliver practical, sustainable solutions.

Education/Training Required and Preferred:

• Bachelor’s degree in Computer Science, Data Science, Software Engineering, or related quantitative field required or a combination of education and relevant work experience.
• Master’s degree or advanced training in data engineering, cloud platforms, or analytics preferred.

Experience Required and Preferred:

• Minimum five years’ experience in data engineering, data integration, and optimization.
• Proven experience developing and maintaining enterprise-scale data solutions on Snowflake, with Power BI as the primary reporting and semantic layer.
• Experience integrating data from Oracle Fusion (ERP/EPM) and other on-premises and cloud applications. Experience working with business stakeholders and senior leadership to deliver data-driven outcomes.
• Demonstrated experience migrating data from legacy and enterprise source systems to modern cloud data platforms, including source-to-target mapping, data validation, and reconciliation.

What You Bring:

• Expertise in building and optimizing scalable data pipelines and architectures on Snowflake, using ELT/ETL orchestration tools such as Azure Data Factory, and cloud object storage (e.g., OCI Object Storage, Azure Blob).
• Proficiency in SQL and Python, with strong experience in Snowflake SQL, dbt for transformation, and pipeline orchestration tools such as Azure Data Factory or Airflow.
• Strong knowledge of relational databases and enterprise source systems, including Oracle Fusion (ERP/EPM) and SQL Server.
• Experience planning and executing source system migrations, including source-to-target mapping, historical data conversion, validation and reconciliation, and cutover planning to minimize business disruption.
• Familiarity with data governance and security frameworks, including metadata, lineage, role-based access controls, and privacy-by-design, applied within Snowflake and the Power BI semantic model.
• Ability to collaborate across technical and business teams and translate requirements into sustainable solutions.
• Skill in diagnosing and resolving performance issues in cloud-based data environments, including Snowflake query and warehouse optimization, and Power BI semantic model/refresh tuning.
• Strong communication and leadership skills with the ability to mentor peers and influence best practices.
• Strategic mindset with curiosity for emerging technologies, particularly AI and ML applications in data engineering, including Snowflake Cortex and Power BI Copilot.

What We Offer:

• Amazing corporate culture - we walk the walk when it comes to our values!
• Beautiful 20 acre park like campus with creek and walking trails
• On site wellness center with personal training, fitness classes and massage
• FUN company events!
• Company donation matching and volunteer rewards
• Career development opportunities and profit sharing bonus

Follow us on LinkedIn, check out our rave reviews on Glassdoor, and learn more about our company culture on our career site: http://corporate.hunterindustries.com/careers 

Hunter is a global leader in the irrigation, outdoor lighting, dispensing technology, and custom manufacturing industries. Driving our continued success is the combined energy and talents of the nearly 4,000 people on our team. Together, we create a diverse array of products that can be seen all over the world, from residential landscapes to national landmarks, stadiums, parks, hotels, and municipal buildings. 

Hunter Industries and its Family of Companies is an Equal Opportunity Employer. All qualified applicants will receive consideration for employment without regard to age, ancestry, color, disability, gender, gender identity or expression, military and veteran status, national origin, race, religion, sexual orientation, or any other applicable legally protected status or characteristic.

The annual salary for this opportunity ranges from $130,000 - $145,000.

The Company complies with all federal/local/state regulations in regard to pay. The above represents the expected hourly range for this job requisition. Compensation offered to the successful candidate will be determined by qualifications, prior experience, other job-related factors, and geographic location.