Share this Job

Business Intelligence Engineer II/III

Location: 

Boise, ID, US, 83702-6924

The J.R. Simplot Company is a diverse, privately held organization, with roots firmly planted in agriculture and agriculture-related businesses. The J.R. Simplot Company is a true farm-to-table company with operations that touch every aspect of agriculture, including seed production, farming and ranching, plant sciences, fertilizer manufacturing, food processing, commercial product development, and distribution.

Summary

Simplot is on a transformational journey focused on delivering value to our customers now and in the future. The Information Management and Analytics (IM&A) Team is responsible for creating and maintaining a modern data and analytics platform to support our company’s dynamic global needs.  In this position, you will contribute to building a complete value chain from source system to a Kimball-modeled Enterprise Data Warehouse and Business Intelligence (BI) Platform, providing insight across the entire organization.  We are currently looking for an innovative and driven collaborator interested in joining our Business Intelligence Team to provide solutions for our Business Partners and help inspire a data-driven culture.

Key Responsibilities

  • Contribute to the design, development, maintenance, and support of our Enterprise Data Warehouse and full-stack Microsoft BI Platform

  • Design, build, and maintain reliable pipelines to move and transform data accurately based on architectural standards (using SSIS, SQL, and Talend)

  • Build, test, and deploy new SSAS or Power BI data models

  • Understand Business needs to prototype and productionalize a data model that provides Business insights based on business process

  • Utilize Azure DevOps for work item management and Git source control to participate in design and code reviews, documentation, and subsequently contribute to company-wide standards

  • Cultivate cross-functional collaborative relationships with Product Owners and IT Professionals

  • Communicate technical and business topics to key Business Stakeholders

  • Manage time across project, support, and enhancement initiatives

  • Build future data and analytics environment for a diverse global enterprise

Typical Education

  • Bachelor's Degree (B.A. or B.S.) from 4 year college or university

Relevant Experience

  • Bachelor’s degree in computer science, engineering, business (or equivalent)

  • Strong experience writing advanced SQL queries

  • Strong experience designing and building in a star schema data warehouse using Kimball principles

  • Extensive experience developing business intelligence solutions using technologies such as SSIS or Talend

  • Experience building semantic layers with technologies such as SSAS, MDX, Power BI, or DAX

  • Knowledge of query performance tuning and index design (SQL Server preferred)

  • Working knowledge of Data Lake Technologies a plus\

  • Possesses a growth mind set and eager to learn new technologies/methods to contribute to a collaborative Team

Job Requisition ID: 4547

Travel Required: None

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.**

If you require technical assistance, please email us at careers.contact@simplot.com.