Business Intelligence Engineer II, III, or IV – Simplot Technology (Boise, ID)
The J.R. Simplot Company is a diverse, privately held organization with roots firmly planted in agriculture and agriculture-related businesses.
As one of the largest privately held food and agribusiness companies in the nation, we pioneer innovations in plant nutrition and food processing, and strive to feed a growing global population. These endeavors have been around for centuries and will continue to be a vital part of the global economy.
At Simplot, we're in the business of Bringing Earth's Resources to Life. We currently have an Business Intelligence Engineer position available at Simplot's headquarters in Boise, ID. SUMMARYThe BI Data Warehouse and Advanced Analytics team is responsible for the full lifecycle of BI development including requirements gathering, design, development, testing, and providing end user support for a full stack Microsoft BI Platform.
We are currently looking for a BI/Data Warehouse Developer to add to our team.
The successful candidate will be responsible for full stack BI development (dimensional modeling, SQL, SSIS, SSAS) and must possess strong interpersonal skills with the ability to work effectively alone or as part of a project or program team and foster team cooperation. RESPONSIBILITIESGather user requirements and perform basic business analysis to ensure proper design working in an agile environmentDesign and develop data extracts and integration processes using SSIS, T-SQL and C#Design analytical solutions in SSASPerform Dimensional Modeling in an integrated star schema environmentDevelop detailed test conditions and test cases to ensure quality of queries and dataResearch and troubleshoot data questionsCollaborate on problem resolution, team decisions and project planningParticipate in design and code reviews, following coding, documentation and design standardsMay participate in multiple projects simultaneously as a senior development team memberPerform all other assigned tasks and requirements as needed REQUIREMENTSBachelor's degree in computer science, engineering, business or equivalent years of experience.0-5 years of experience (Bus Intelligence Engineer II)4-10 years of experience (Bus Intelligence Engineer III)10+ years of experience (Bus Intelligence Engineer IV)2+ years of T-SQL query writing (MS SQL Server 2012 and above) or equivalent technology2+ years' experience designing and building in a star schema data warehouse using Kimball principles2+ years business intelligence development experience with SSIS, SSAS and SSMS or equivalent technologyKnowledge of query performance tuning and basic DBA skills including database file system understanding and table partitioning (preferably in SQL Server)Working knowledge of Big Data technologies (Hadoop), a plus
HOW TO APPLYExternal Candidates:Visit www.simplot.com/careersSelect Job SearchSelect Current OpportunitiesSelect All Open PositionsApply to Job ID #6450Please prepare a cover letter outlining your interest and qualifications and submit with your resume via our online application process described above.
For best results, please upload your resume as a Microsoft Word or Adobe PDF document.
This process includes additional job-relevant questions, so plan on at least 20 minutes when you apply. When a position is in the interview stage or has been filled, it will no longer appear on our Simplot Careers website.
If you experience any technical difficulties when applying through our online system, please contact the JRS Talent and Culture department for assistance at firstname.lastname@example.org. **The J.R. Simplot Company is proud to be an Equal Opportunity Employer and all qualified applicants will receive consideration 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.**