Management Information Systems Specialist

EDENIQ INC•Galt, CA

2d•$75,000 - $100,000

About The Position

Edeniq is looking for 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. This MIS Specialist position does not require previous industry experience.

Requirements

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.
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.
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.
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.
Ability to translate raw data into meaningful insights that support sales, analytics, and management teams.
Strong commitment to ensuring accuracy, consistency, and compliance of all data used for reporting and analysis.
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.
Strong analytical skills to diagnose and resolve data flow, reporting, and system integration issues.
Ability to identify process improvement opportunities and implement practical solutions.
Ability to manage multiple projects and priorities simultaneously.
Strong organizational skills with the ability to document processes and meet deadlines.
Bachelor’s degree in management information systems (MIS) or a closely related business/IT discipline.
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.).
Ability to understand lab workflows and data.
Ability to support cross-functional scientific teams (lab staff, engineers, sales, management) with standardized reporting.
Ability to sit for extended periods while performing computer-based work.
Ability to use a computer, keyboard, mouse, and standard office equipment.
Ability to communicate effectively in person, by phone, and through electronic communications.
Ability to occasionally stand, walk, and move within an office environment.

Nice To Haves

Experience with LIMS implementation, configuration, and integration into centralized databases preferred, but not required.
Experience with, or ability to learn, laboratory workflows and how lab data supports operational decision-making.
Experience with, or ability to learn, KPI development and consistent business reporting methodologies.
Familiarity with statistical tools such as JMP, R, or Python libraries for data validation and exploratory analysis.
A second degree or minor in Analytics, Business Intelligence, or Statistics is preferred.
Background knowledge of laboratory or scientific practices preferred, but not required.
Familiarity with the ethanol/biofuels and/or agricultural industry(-ies), including terminology, key processes, and common business drivers preferred, but not required.
Familiarity with LIMS platforms or other lab/ERP system integrations preferred, but not required.

Responsibilities

Build and maintain a centralized database (Access or similar software) consolidating data from multiple departments and systems.
Ensure data consistency, reliability, and availability for organizational reporting and analytics.
Design, develop, and maintain standardized reports and dashboards using Power BI, Tableau, Excel, and related tools.
Automate recurring reports and data workflows to improve efficiency and reduce manual processes.
Establish standardized data pipelines, templates, and best practices for company-wide reporting.
Ensure lab data is standardized and easily accessible for analysis and sales reporting.
Partner with analytics and sales teams to provide clean, standardized data for decision-making.
Support business development teams with accurate client-facing data packages.
Provide training and technical support to internal users on accessing and using standardized reports.
Write and maintain automation scripts (SQL, VBA, Python, R, etc.) to improve efficiency.
Troubleshoot database, reporting, and data integration issues.
Maintain documentation of data processes, reporting standards, and system configurations.
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.
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.
Perform other duties and special projects as assigned.