Business Intelligence (BI) Developer/Data Analyst (In-Person – Frankenmuth, MI)
About The Position
Duties include but are not limited to the following: Design and develop dashboards, reports, and KPI scorecards using tools like Power BI or Tableau Build and maintain data models, data warehouses, and ETL pipelines Integrate and analyze data from D365 F&O, agronomy systems, IoT devices, and external sources Support traceability, quality, and food safety reporting across operations Perform ad-hoc analysis and communicate findings to business stakeholders Ensure data accuracy, consistency, and performance across systems Collaborate with Operations, Finance, Agronomy, and IT teams to support data-driven decisions Provide backup IT technical support and basic troubleshooting to personnel, ensuring minimal downtime when primary IT services are unavailable
Requirements
- Bachelor’s degree in Data Analytics, Information Systems, Computer Science, or a related field
- Experience in business intelligence, data analytics, or data engineering
- Proficiency in SQL and BI tools such as Power BI or Tableau
- Experience with data warehousing concepts, ETL processes, and cloud-based data platforms
- Experience working with ERP systems, preferably Microsoft Dynamics 365 Finance & Operations
- Strong analytical, problem-solving, and communication skills
- Strong analytical and problem-solving skills with the ability to interpret data and provide actionable insights
- Ability to develop dashboards, reports, and data visualizations to support business decisions
- Proficiency in data management, including validation, cleansing, and transformation
- Effective communication skills to translate technical information to non-technical stakeholders
- High attention to detail with a focus on data accuracy and integrity
- Collaborative mindset with the ability to work across departments
- Basic troubleshooting and technical support capabilities
- Ability to communicate effectively, including speaking, listening, and collaborating with team members in person, by phone, and through virtual platforms
- Ability to remain in a stationary position for extended periods while working on computers, analyzing data, and developing reports or dashboards
- Frequent use of hands and fingers to operate a computer, keyboard, and other office equipment
- Ability to move about office and operational environments, including occasional walking and standing during meetings or site visits
- Ability to occasionally reach, bend, or navigate production or facility areas when gathering information or supporting operations
- Ability to lift and/or move items up to 15–20 pounds on an occasional basis (e.g., laptops, documents, or equipment)
- Vision abilities required include close vision, distance vision, and the ability to adjust focus for reviewing data, reports, and system outputs
Nice To Haves
- Experience with D365 F&O data entities, BYOD (Bring Your Own Database), or Azure-based integrations (preferred but not required)
- Proficiency in Python or R for data analysis, automation, or scripting (preferred but not required)
- Background or experience in agriculture, food processing, or supply chain analytics (preferred but not required)
Responsibilities
- Design and develop dashboards, reports, and KPI scorecards using tools like Power BI or Tableau
- Build and maintain data models, data warehouses, and ETL pipelines
- Integrate and analyze data from D365 F&O, agronomy systems, IoT devices, and external sources
- Support traceability, quality, and food safety reporting across operations
- Perform ad-hoc analysis and communicate findings to business stakeholders
- Ensure data accuracy, consistency, and performance across systems
- Collaborate with Operations, Finance, Agronomy, and IT teams to support data-driven decisions
- Provide backup IT technical support and basic troubleshooting to personnel, ensuring minimal downtime when primary IT services are unavailable
Stand Out From the Crowd
Upload your resume and get instant feedback on how well it matches this job.
What This Job Offers
Job Type
Full-time
Career Level
Entry Level
Number of Employees
11-50 employees
