Data Warehouse Engineer

Explore an exciting and rewarding career journey with Darigold! We are seeking an experienced and motivated Data Warehouse Engineer to join our growing Data Warehousing team to design, develop and maintain our data warehousing solutions.

The ideal candidate will have a deep understanding of data architecture, data modeling, ETL processes and data governance and a deep passion for transformation, innovation and optimization. You will work closely and collaborate with diverse stakeholders to ensure that data is accessible, reliable and structured for optimal analysis across our growing, dynamic and evolving business.

Darigold is the fifth largest dairy cooperative in the United States based on milk volume and one of the largest privately held organizations headquartered in the state of Washington. Since 1918, our producers have taken pride in producing dairy products with unsurpassed quality. Today, we are one of the nation's largest agricultural cooperatives, producing over 8.5 billion pounds of milk every year.

Through innovative technology and our efficient and flexible production capabilities, we deliver value-added products and customer-driven solutions. Darigold is now known throughout the world for bringing fresh, wholesome dairy products and ingredients from the Northwest to people all around the globe.

What You Will Do:

• Design and Architecture
• Develop and implement the overall data warehouse architecture.
• Create data models, including conceptual, logical and physical models.
• Design data integration solutions to ensure seamless data flow from various sources.
• Design and implement data pipelines and architectures leveraging Microsoft Fabric services (e.g., Data Factory, Data Warehousing, Synapse Real-Time Analytics, Power BI).
• ETL Development
• Develop end-to-end ETL/ELT pipelines in Microsoft Databricks to process data from various sources, including Oracle Cloud ERP.
• Design scalable data transformations to cleanse, aggregate and enrich datasets for analytics and reporting.
• Utilize Spark-based technologies to optimize data processing performance and ensure efficient resource utilization.
• Build and optimize ETL processes to extract, transform and load data efficiently.
• Collaborate with data engineers to ensure best practice in data processing and storage.
• Performance Tuning
• Monitor and optimize the performance of data warehouse systems.
• Implement indexing, partitioning, and other performance enhancement techniques.
• Data Governance
• Establish data governance frameworks to ensure data quality, consistency and security.
• Work with compliance teams to ensure adherence to data regulations.
• Collaboration
• Collaborate with business analysts, data scientists and other stakeholders to understand data requirements.
• Provide technical guidance and mentorship to junior data team members.
• Documentation
• Create and maintain comprehensive documentation for data models, ETL processes and system configurations.
• Prepare reports and dashboards for stakeholders.

What You Bring:

• Bachelor's degree in Computer Science, Information Technology, or a related field; Master's degree preferred.
• 5+ years of experience in data warehousing, data architecture, or related fields.
• Demonstrated experience in data mining, ETL ADF, Python and data warehousing solutions using Oracle Analytics Cloud, Azure Databricks and Azure Fabric in a business environment with large-scale, complex datasets.
• Demonstrated experience with Oracle ERP Cloud preferred.
• Proficiency in SQL and experience with relational databases (e.g., PostgreSQL, Oracle, SQL Server).
• Knowledge of big data technologies Azure Databricks.
• Familiarity with data visualization tools Power BI is desirable.
• Strong analytical and problem-solving skills.
• Excellent communication and collaboration abilities.
• Ability to manage multiple projects and meet deadlines.

Benefits of Working at Darigold:

We understand that as an employee, benefits that support you and your family in and out of work are important. We're proud to offer eligible positions a competitive total rewards package that includes:

• 401k competitive employer matching
• Comprehensive medical, dental & vision benefits
• Employer paid life & disability coverage
• Paid time off and paid holidays
• 8 weeks paid parental leave
• Education assistance
• Employee assistance program
• Flexible hybrid working arrangement where applies (up to 2 days/week after initial 90 days and approval by hiring manager and HR)
• Compensation range: $124,875 - $187,313 (individual wage based on previous experience, knowledge and skills)

Our Commitment to Diversity:

Achieving our vision to Lead Dairy Forward requires cultivating and supporting a team with varying backgrounds, experiences, and perspectives. We are committed to providing a workplace based on mutual respect where all employees feel included and can bring their best and authentic selves to work every day. We are proud to be an Equal Opportunity Employer and Affirmative Action Employer. We welcome all qualified applicants without regard to race, color, national origin, sex, gender identity and expression, age, sexual orientation, veteran status, disability, marital status, creed, religion, genetic information or any other characteristic protected by federal, state, or local law. As a condition of employment applicants offered a role will be required to successfully pass our pre-employment background screen, receive a negative drug screen result & confirm eligibility to work in the U.S. We participate in E-Verify - please follow the links for details, English / Spanish & view our Right to Work Statement, English / Spanish.