Management Information Systems Specialist
Reports to: Vice President
Location: Twin Cities - Metro area Minnesota
Seeking a Management Information Systems (MIS) Specialist to take ownership of our data infrastructure and reporting workflows. This role will focus on building and maintaining a centralized system (Access or similar software) and creating standardized reports and dashboards that support our data analytics and sales teams. The ideal candidate will have strong MIS expertise, excellent database and reporting skills, and the ability to enable analysts and business users with reliable, consistent data outputs. This individual will report to our Vice President of Sales and work alongside our Business Data Analyst, Business and Sales Directors, and our Vice President of Corporate Affairs and Marketing.
ESSENTIAL FUNCTIONS:
1. Build and maintain a centralized database (Access or similar software) consolidating data from multiple departments and systems.
2. Ensure data consistency, reliability, and availability for organizational reporting and analytics.
3. Design, develop, and maintain standardized reports and dashboards using Power BI, Tableau, Excel, and related tools.
4. Automate recurring reports and data workflows to improve efficiency and reduce manual processes.
5. Establish standardized data pipelines, templates, and best practices for company-wide reporting.
6. Ensure lab data is standardized and easily accessible for analysis and sales reporting.
7. Partner with analytics and sales teams to provide clean, standardized data for decision-making.
8. Support business development teams with accurate client-facing data packages.
9. Provide training and technical support to internal users on accessing and using standardized reports.
10. Write and maintain automation scripts (SQL, VBA, Python, R, etc.) to improve efficiency.
11. Troubleshoot database, reporting, and data integration issues.
12. Maintain documentation of data processes, reporting standards, and system configurations.
13. If needed and at the direction of the Company’s Lab Operations team, assist with the implementation and configuration of the company’s Laboratory Information Management System (LIMS) platform.
14. Upon its launch, and with direction from the Company’s Lab Operations team, support the connection, integration and maintenance of the LIMS data connections with other database and business reporting tools.
15. Perform other duties and special projects as assigned.
KNOWLEDGE, SKILLS AND ABILITIES:
Management Information Systems and Database Expertise
· Strong understanding of MIS principles, relational database structures, and enterprise data workflows.
· Proficiency with Microsoft Access and SQL for database design, maintenance, and querying.
· Ability to manage and support centralized data environments that consolidate information from multiple business systems.
Data Integration and Systems Management
· Ability to integrate and standardize data from multiple sources, including LIMS platforms, ERP systems, and spreadsheets.
· Knowledge of data pipelines, templates, and best practices to support consistent company-wide reporting.
· Understanding of processes required to ensure data accuracy, reliability, and availability.
LIMS and Laboratory Data Systems
· Experience with LIMS implementation, configuration, and integration into centralized databases preferred, but not required.
· Ability to connect laboratory data with business reporting tools for analysis and sales reporting.
· Experience with, or ability to learn, laboratory workflows and how lab data supports operational decision-making.
Reporting and Visualization Tools
· Expertise in Power BI, Tableau, and Microsoft Excel, including Power Query, pivot tables, and VBA macros.
· Ability to design and maintain standardized dashboards and automated reports.
· Experience with, or ability to learn, KPI development and consistent business reporting methodologies.
Programming and Automation
· Working knowledge of SQL, Python, R, or VBA scripting to streamline reporting processes and improve efficiency.
· Ability to support automation initiatives and reduce manual reporting effort.
Analytics and Business Intelligence
· Ability to translate raw data into meaningful insights that support sales, analytics, and management teams.
· Familiarity with statistical tools such as JMP, R, or Python libraries for data validation and exploratory analysis.
Data Governance and Quality Control
· Strong commitment to ensuring accuracy, consistency, and compliance of all data used for reporting and analysis.
· Detail-oriented approach to maintaining data integrity and standardized definitions.
Communication and Collaboration
· Excellent written and verbal communication skills with the ability to explain technical concepts to non-technical audiences.
· Ability to collaborate effectively with sales, analytics, laboratory, and operations teams.
Problem Solving and Troubleshooting
· Strong analytical skills to diagnose and resolve data flow, reporting, and system integration issues.
· Ability to identify process improvement opportunities and implement practical solutions.
Organizational and Project Management Skills
· Ability to manage multiple projects and priorities simultaneously.
· Strong organizational skills with the ability to document processes and meet deadlines.
EDUCATION:
Bachelor’s degree in Management Information Systems (MIS) or a closely related business/IT discipline.
A second degree or minor in Analytics, Business Intelligence, or Statistics is preferred.
EXPERIENCE:
2+ years of experience or training in MIS, reporting, or business intelligence.
Hands-on experience with Microsoft Access, Power BI, Tableau, Excel (required).
Strong SQL/database knowledge with experience standardizing data from multiple sources.
Exposure to automation/programming tools (Python, R, VBA, etc.).
Background knowledge of laboratory or scientific practices preferred, but not required.
Ability to understand lab workflows and data.
Familiarity with the ethanol/biofuels and/or agricultural industry(-ies), including terminology, key processes, and common business drivers preferred, but not required.
Ability to support cross-functional scientific teams (lab staff, engineers, sales, management) with standardized reporting.
Familiarity with LIMS platforms or other lab/ERP system integrations preferred, but not required.
PHYSICAL REQUIREMENTS:
The physical demands and work environment characteristics described below are representative of those that must be met by an employee to successfully perform the essential functions of this position, with or without reasonable accommodation.
Physical Demands
Work Environment
·
TRAVEL REQUIREMENTS:
Minimal travel may be required for meetings, training, or business needs. Position may require occasional travel to other company or customer locations as needed.