ERP Systems & Business Intelligence Analyst

Description:

Magnum Venus Products (MVP) is a global manufacturer of fluid movement and production solutions for industrial applications in composites and adhesives markets. MVP collaborates with its customers to offer tailored production solutions to meter, mix, dispense, and apply materials. For over 80 years, MVP has been a leading equipment provider for the marine, infrastructure, pool and bath, oil & gas, transportation, aerospace, and wind industries.

As a family-owned business, MVP serves its customers and communities with integrity and respect to create a better experience. Our same core values with which the company was founded on 80 years ago continue to guide us today as we create a better experience for our employees, customers, and communities.

MVP proudly offers a competitive medical (partially Company-paid), dental, vision, life and disability plan; 401k retirement plan with a 3% match; Paid Time Off (starting at 13 days per year); 9 Company-paid holidays; 2 Floating holidays.

Overview:

A growing manufacturing organization utilizing Epicor ERP (10.2) with plans to move to Kinetic is seeking an ERP Systems & Business Intelligence Analyst to support ERP administration while leading data modeling and analytics initiatives across the organization.

This role combines ERP functional expertise with advanced Power BI data modeling and cross-system integration. The ideal candidate understands manufacturing operations and can transform ERP and external data into structured, reliable business intelligence.

Work Description:

Power BI & Data Modeling (Ownership Responsibility)

• Design and maintain Power BI semantic models using proper star-schema principles
• Create and manage fact and dimension tables from ERP transactional data
• Ensure proper relationships, cardinality, and filter direction
• Develop efficient, relevant, and accurate DAX measures for operational and financial reporting
• Optimize models for scalability and refresh performance
• Establish data governance and naming standards

Data Integration & Analytics

• Combine ERP data with external data sources including: CRM Systems, Excel-based business data, SQL databases, & Flay files/APIs
• Perform data cleansing, normalization, and transformation
• Ensure data consistency across systems
• Support executive KPI dashboards and operational reporting
• Develop standardized reporting frameworks across departments

ERP Administration & Support

• Provide ERP end-user support and issue resolution
• Maintain user accounts, security roles, and configurations
• Develop and support: BAQs, BPMs, Dashboards, and Custom Reports
• Support MRP, costing, and production data integrity
• Assist with upgrades, module integrations, and testing
• Serve as liaison between consultants and internal stakeholders

Requirements:

Minimum Qualifications:

• Bachelor’s degree in Information Systems, Data Analytics, Engineering, Business, or related field
• 3+ years ERP administration and/or business analytics experience (manufacturing environment required)
• Strong SQL proficiency
• Demonstrated experience designing Power BI data models and schemas
• Experience combining ERP data with external data sources
• Understanding of manufacturing concepts: BOM structurers, MRP, Inventory transactions, and costing structures.

Preferred Qualifications:

• Epicor experience (10.x or Kinetic preferred)
• Experience with BAQs and BPMs
• ERP implementation or upgrade experience
• Experience with data governance frameworks

Physical Demands:

• Ability to navigate manufacturing floor.
• Ability to use PPE in a manufacturing environment where safety is priority.
• Travel – up to 20%.

Magnum Venus Products, Inc. is committed to compliance with its obligations under all applicable state and federal laws prohibiting employment discrimination. In keeping with this commitment, it attempts to reasonably accommodate applicants and employees in accordance with the requirements of the disability discrimination laws. It also invites individuals with disabilities to participate in a good faith, interactive process to identify reasonable accommodations that can be made without imposing an undue hardship. Magnum Venus Products, Inc. is an Equal Opportunity Employer.