*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:- Designs, develops, and optimizes data pipelines and workflows for ingestion, transformation, and delivery of data across enterprise platforms.
- 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.
- Applies data cleansing, validation, enrichment, and quality controls to ensure accuracy, consistency, and trust in enterprise data.
- Monitors and tunes pipelines and storage solutions for scalability, performance, and cost-effectiveness.
- Implements governance, security, and compliance practices in alignment with enterprise standards.
- Collaborates with architects, analysts, and data scientists to deliver solutions that support Power BI analytics, reporting, AI/ML, and self-service use cases.
- Provides technical leadership by guiding best practices in pipeline design, coding standards, and system optimization.
- Mentors junior engineers and contributes to knowledge sharing across the Data & Analytics team.
- Evaluates and adopts emerging technologies, tools, and practices that strengthen the enterprise's data capabilities.
- 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 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.
