Darigold is seeking an experienced Data Warehouse Engineer and Architect 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. You will work closely with stakeholders to ensure that data is accessible, reliable and structured for optimal analysis.
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, 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:
Oracle Cloud ERP Integration & Configuration
- Configure and maintain data extraction processes from Oracle Cloud ERP modules (e.g., Financials, Supply Chain, Procurement).
- Monitor data integrity and troubleshoot issues within Oracle Cloud ERP to ensure accurate financial and operational reporting.
- Collaborate with ERP functional leads to optimize system functionality and data flows.
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 practices 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 with ETL tools (e.g., Talend, Informatica, Apache NiFi, ODI, ADF, Python) and data warehousing solutions using Oracle Analytics Cloud or Azure Databricks.
- Proficiency in SQL and experience with relational databases (e.g., PostgreSQL, Oracle, SQL Server).
- Knowledge of big data technologies Azure Databricks is preferred.
- Familiarity with data visualization tools Power BI is preferred.
- 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: $118,929 - $178,393 (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.
Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities
The contractor will not discharge or in any other manner discriminate against employees or applicants because they have inquired about, discussed, or disclosed their own pay or the pay of another employee or applicant. However, employees who have access to the compensation information of other employees or applicants as a part of their essential job functions cannot disclose the pay of other employees or applicants to individuals who do not otherwise have access to compensation information, unless the disclosure is (a) in response to a formal complaint or charge, (b) in furtherance of an investigation, proceeding, hearing, or action, including an investigation conducted by the employer, or (c) consistent with the contractor’s legal duty to furnish information. 41 CFR 60-1.35(c)
