Business Systems Analyst

JBC Technologies, Inc.; North Ridgeville (OH); On-site; USD 70,000 - 110,000; Full time

Job summary

JBC Technologies, Inc. in North Ridgeville, OH is seeking a Business Systems Analyst to bridge manufacturing operations with our Microsoft Dynamics 365 Business Central ERP and Power BI reporting.

You will map production workflows, analyze data sources, build and maintain BI data models, and collaborate with IT to optimize shop-floor processes while ensuring data accuracy for decision-makers.

Qualifications

• Hands-on manufacturing experience requested.
• Advanced Power BI skills including data modeling and DAX.
• Experience connecting BI tools to ERP/SQL data sources.
• Strong analytical and process-improvement capabilities.

Responsibilities

• Audit and migrate reporting to Power BI from NAV 2018 and other data sources.
• Develop and maintain Power BI data models and dashboards.
• Collaborate with IT to retire legacy reporting and ensure data accuracy.
• Translate operational issues into system and process improvements.
• Maintain knowledge of BC configuration and data structures.
• Coordinate updates with partners and support.
• Document configurations and processes.

Skills

Hands-on manufacturing experience

Advanced Power BI skills

Experience connecting BI tools to ERP/

Analytical and process improvement

Effective communication across org.

Self-starter

Education

Bachelor's degree in Information Systems, Business, Industrial Engineering, or related field

Tools

Power BI

DAX

Power Query

SQL

Microsoft Dynamics 365 Business Central

ASP.NET/C#

Job description

Purpose: We are looking for a Business Systems Analyst with hands-on manufacturing experience to take a central role in how we use technology on the shop floor and across the business. This position connects our ERP platform (Microsoft Dynamics 365 Business Central), our reporting infrastructure (Power BI), and the people who depend on accurate, timely information to make decisions.

Essential Duties and Responsibilities:

Reporting Migration

• Audit and catalog existing NAV 2018 reports and dashboards
• Rebuild reports in Power BI using Business Central data sources
• Collaborate with IT to retire legacy ASP.NET/C#/SQL reporting
• Validate reports with stakeholders prior to go-live

Shop Floor Process Optimization

• Learn and analyze production workflows, inventory, scheduling, and quality processes
• Identify gaps between current BC usage and optimal system capabilities
• Evaluate and recommend third-party add-ons or custom solutions
• Define and prioritize system improvements and extensions
• Drive consistent, correct system usage across teams
• Translate operational issues into system and process improvements

Reporting & Analytics

• Develop and maintain Power BI data models and reports
• Write DAX and use Power Query (M) for data transformation
• Design user-friendly dashboards backed by robust data models
• Partner with leadership on KPIs and executive dashboards
• Manage Power BI environment (publishing, refresh, security)
• Document models and train users to support self-service reporting

Business Central Administration

• Maintain knowledge of BC configuration and data structures
• Coordinate with partners/support for updates and issue resolution
• Document system configurations and processes
• Monitor BC releases for relevant enhancements

Education and Experience:

• Bachelor’s degree in Information Systems, Business, Industrial Engineering, or a related field, or equivalent practical experience

Job Knowledge, Skills and Abilities:

Required

• Hands-on manufacturing experience
• Advanced Power BI skills (data modeling, DAX, Power Query)
• Experience connecting BI tools to ERP/SQL data sources
• Strong analytical and process improvement capabilities
• Effective communication across all organizational levels
• Self-starter comfortable working independently

Preferred

• Microsoft Dynamics 365 Business Central experience
• Power BI integration with BC (OData, connectors)
• SQL Server / T-SQL experience
• Exposure to ASP.NET/C# environments
• Experience with ERP customizations or add-ons
• Knowledge of manufacturing ERP modules (BOMs, routings, inventory, etc.)
• Familiarity with CMMC, NIST SP 800-171, or CUI handling
• Understanding of data security, access controls, and audit logging
• Experience in regulated or compliant environments

Physical Demands:

• Light to moderate physical effort required on a constant basis

Personal Protective Equipment:

• Steel or Composite Toe shoes are required for the production floor

Work Schedule:

• Monday-Friday 8AM-5PM; May vary with business need
• Work performed in an office and plant environment