Business Intelligence Developer

Location: Mt. Sterling, ILDepartment: Information TechnologyReports To: Director of Data & AISalary Range: $62,113 - $93,169 annually, with bonus opportunityAs Business Intelligence Developer, you are highly passionate about data. You have effective project management and planning skills. You will create/develop complex reports and dashboards within our business intelligence platform(s). You’ll create reporting data models to support the performant operation of OLAP data sources. You’ll work directly with business users and stakeholders to understand needs and translate them into technical requirements.WHAT YOU’LL DO• Create and maintain complex Cognos Analytics assets to translate problem solving needs into technical requirements• Build and automate analytical reports/dashboards to help track KPI’s, identify areas of opportunity, and increase metric visibility for all levels of the organization• Analyze data and provide recommendations where applicable to achieve company and department goals• Occasionally provides deep analytical insight into KPI’s for root-cause analysis and to guide/provide suggestions to key decision makers• Support and help administer functions of the Data & AI technology stack – data warehouse, data movement, data quality, and business intelligence• Work with vendors and consultants as appropriateYOU MUST HAVE• Bachelor’s degree in computer science, physics, math, or related• 24 months experience in business intelligence and data warehousing• Encompassing knowledge of core enterprise data warehousing (both technical and business aspects)• Familiarity with business analytics• Proficient at developing both ad-hoc and scheduled reports/dashboards for business user consumption• 24 months experience in system administration• Comprehensive understanding of IT system operations for troubleshooting performance monitoring and improvement, automation, and administration tasks• 12 months experience in effective project management and planning (ability to gather requirements, design solutions, and execute project plans while maintaining stakeholder engagement and delivering results that align with business expectationsROLE SPECIFICS• Full time• Remote work permissible• Occasional overnight travel required. Must have ability to independently travel as needed, without restriction, by all modes of transportation, including car, plane, or train for customer and vendor calls, training, or meetings.WHO WE AREDot Foods makes products more accessible and affordable to the food industry. We add efficiency to the supply chain and build strong partnerships with distributors, suppliers, and operators. Our company was created on a foundation of respect and dependability. People who are open to input, ask questions, embrace diversity, and seek innovative solutions thrive here.WHAT DOT CAN OFFER YOUAs a family-owned and -operated company since 1960, Dot Foods has created a strong family culture. We make everyone feel included and respected. In addition to an inclusive working environment, we will provide you with:• Competitive compensation package, including bonuses for successful performance• Extensive benefits including medical, dental, 401k, and profit-sharing• Significant advancement opportunitiesSafety: This position assumes responsibility for the workplace safety of self and co-workers, and for the safety conditions of the work locations, exercise and promotes safe behaviors and show unyielding support of programs, rules, and policies regarding safety.EOE/AA Employer: Dot believes all persons are entitled to equal employment opportunities. Dot will not discriminate against its employees or applicants for employment because of sex, race, color, religion, national origin, age, sexual orientation, disability, or veteran status or other basic classes protected by applicable federal or state law provided they are qualified for employment or for existing positions.