Business Intelligence Analyst

The Mennel Milling Company - Fostoria, OH

Full-time

Fostoria, OH

Food Manufacturing

About the position

The Business Intelligence Analyst position is responsible for identifying, monitoring, planning, developing, and implementing the database needs of the company. This role acts as a liaison and advisor to the Data Analytics team, facilitating initiatives across the organization while ensuring compliance with food safety and quality standards.

Responsibilities

• Follow all food and personal safety rules and regulations in respect to GMP's, OSHA, HACCP, and sanitation guidelines.
• Maintain the department/facility in an everyday audit ready condition.
• Design and create database structures to align with business needs and objectives.
• Write SQL scripts, procedures, functions, and triggers for various database tasks and activities.
• Maintain, optimize, and ensure the efficiency and security of SQL databases.
• Perform data analysis, data modeling, and create reports using SQL Server Reporting Services (SSRS).
• Work closely with other developers, data analysts, and project managers to ensure the database aligns with overall project requirements.
• Support SQL database structure changes and data changes for application development/testing/deployment.
• Develop and implement SQL database recovery plans and procedures.
• Support SQL data architecture initiatives for primary application redesign, reporting needs, and new features and functions.
• Plan, prepare, test, and perform SQL database patches and upgrades.

Requirements

• A bachelor's degree in computer science/information technology or other related fields preferred.
• Proven experience as a Database Administrator or in a similar role.
• Ability to travel up to 40%.
• Strong analytical skills.
• Understanding of SQL Server, MYSQL, Oracle, and DB2 database engines.
• Proven experience writing SQL Scripts, Stored Procedures, Functions.
• Excellent verbal and written communication skills.
• Extremely organized and detail oriented.