ERP Systems & Business Intelligence Analyst

Magnum Venus Products • Knoxville, TN

17h

About The Position

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.

Requirements

• 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.

Nice To Haves

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

Responsibilities

• 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
• 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
• 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

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level
• Number of Employees: 11-50 employees