Title: Business Intelligence Analyst Department: ITReports To: Refer to location organizational chart.SUMMARY: This position identifies, monitors, plans, develops, and implements and administers the databaseneeds of the company. The business intelligence analyst also acts as a liaison and advisor to the organization's Data Analytics team and assists with facilitating initiatives across the organization. This position will sustain the Mission and Motto and Food Safety and Quality Statement of the Mennel Milling Company. PRIMARY WORK SHIFT: Monday through Friday 8AM - 5PM. Will vary, depending on workload. ESSENTIAL DUTIES AND RESPONSIBILITIES: To perform this job successfully, an individual must be able to perform each essential duty satisfactorily with or without accommodation.
- Follow all food and personal safety rules and regulations in respect to GMP's, OSHA, HACCP, the Global Food Safety Initiative, the US FDA Food Safety Modernization Act as stated in the FS&Q Statement, and sanitation guidelines as set forth by the company as listed in Corporate Health, Safety & Environmental (HSE) and attend all required training sessions. Maintain the department/facility in an everyday audit ready condition.
- Design and create database structures & data warehouse to align with business needs and objectives.
- Connect and integrate data from various sources, including Azure Synapse and DB2 into Jet Data Manager.
- Create, optimize, and manage interactive dashboards and reports using multiple toolsets to provide actionable insights by utilizing semantic models and creating measures with DAX.
- Maintain, optimize, and ensure the efficiency and security of databases.
- Perform data analysis, data modeling, and create reports using various reporting toolsets.
- Work closely with both technical and non-technical stakeholders to gather requirements, provide updates, and deliver solutions that meet business needs.
- Support database structure changes and data changes for application development/testing/deployment
- Develop and implement database recovery plans and procedures
- Support data architecture initiatives for primary application redesign, reporting needs, and new features and functions
- Plan, prepare, test and perform database patches and upgrades
- Other duties may be assigned.
SUPERVISORY RESPONSIBILITIES:This position has no supervisory duties.QUALIFICATIONS: The requirements listed below are representative of the knowledge, skill, and/or ability required to perform this job.
- A bachelor's degree in computer science/information technology or other related fields preferred.
- Proven experience as a Business Intelligence Analyst or in a similar role.
- Ability to travel up to 40%.
- Strong analytical skills.
- Strong Powerquery and DAX knowledge.
- Experience using Jet Data Manager, Jet Reports, PowerBI Azure Datawarehouse.
- Understanding of Microsoft SQL Server, MYSQL, Oracle, Azure Datalake, Synapse and DB2 database engines[AV8]
- Proven experience writing Queries, Stored Procedures, Functions.
- Excellent verbal and written communication skills.
- Extremely organized and detail oriented.
LANGUAGE SKILLS:Ability to read and comprehend simple instructions, short correspondence, memos, procedures, and plans. Ability to write, complete checklists and other basic documentation and correspondence. Ability to effectively present information or data in one-on-one and small group situations to co-workers, supervisors, and managers.MATHEMATICAL SKILLS: Ability to add, subtract, multiply, and divide in all units of measure, using whole numbers, common fractions, and decimals. Proficient in statistics and scientific method REASONING ABILITY:Must use solid judgment when making decisions. Must have ability to quickly recognize and plan for changing work duties and events.PHYSICAL DEMANDS:The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job:While performing the duties of this job, the employee is regularly required to stand; walk; use hands to perform maintenance tasks, reach with hands and arms; climb or balance; stoop, kneel, twist, crouch, or crawl, and talk or hear. The employee must occasionally lift and/or move up to 50 pounds or more. Specific vision abilities required by this job include close vision, distance vision, peripheral vision, depth perception, and ability to adjust focus.WORK ENVIRONMENT: The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job:While performing the duties of this job, the employee is regularly exposed to conditions that are typical of an office environment.