Data Engineer II (Enterprise Data Warehouse)
The J.R. Simplot Company is a diverse, privately held global food and agriculture company headquartered in Boise, Idaho. We are a true farm-to-table company with an integrated portfolio including food processing and food brands, phosphate mining, fertilizer manufacturing, farming, ranching and cattle production, and other enterprises related to agriculture.
Summary
This role provides hands-on database engineering and administration expertise to support the Enterprise Data Warehouse (EDW). The Database Engineer plays a critical role in maintaining reliability, performance, and scalability while partnering with multiple engineering teams to resolve issues and strengthen data processing practices across the organization.
This role is based onsite at the Simplot HQ office in Boise, ID.
Key Responsibilities
Database Administration & Engineering
- Support and maintain the Enterprise Data Warehouse (EDW) platform, ensuring uptime, performance, and data integrity.
- Collaborate closely with engineering and delivery teams responsible for SQL Server databases and SSIS workloads to ensure consistent and reliable processing and to ensure adherence to established standards.
- Perform deep analysis and troubleshooting of complex SQL Server processes to resolve failures, diagnose performance issues, and identify upstream data problems.
- Optimize existing database structures, queries, and ETL workflows to improve efficiency and reliability, with a focus on sustaining current business processes.
SSIS Development & Administration
- Develop, maintain, and administer SSIS packages supporting enterprise data pipelines.
- Lead and execute the transition from package-based deployment to project-based deployment, applying best practices for configuration, deployment, and monitoring.
- Provide training and support for engineering teams transitioning to project-based deployment
Technical Leadership & Collaboration
- Serve as a technical guide to teams with varying levels of experience, helping them troubleshoot issues and adopt improved SQL Server and SSIS practices.
- Share knowledge, provide mentorship, and promote consistent engineering approaches across teams.
- Apply broad technical expertise to support related infrastructure components and interconnected systems.
Typical Education
Bachelor’s Degree (B.A. or B.S.) or equivalent education and experience.
Relevant Experience
4+ years of experience in database administration, data engineering, and development in a Microsoft SQL Environment.
Required Skills & Expertise
Required Skills & Expertise
- Proficiency in SQL Server required, other database platform experience a plus.
- Proficiency in SSIS development and maintenance required.
- Strong coding experience (e.g., Java, C#) and familiarity with modern development tools would be a plus.
- Expertise in software testing methodologies and tools would be a plus.
- Very strong experience partnering with IT and business, combined with effective communication skills and the ability to provide technical across teams.
Job Requisition ID: 25814
Travel Required:
Location(s): Simplot Headquarters - Boise
Country: United States
**The J.R. Simplot Company is proud to be an Equal Opportunity Employer and will consider all qualified applicants for employment without regard to race, color, religion, national origin, ancestry, age, sex, gender, gender identity, gender expression, genetic information, physical or mental disability, medical condition, sexual orientation, military or veteran status, marital status, or any other protected status. **