Senior Business Systems Analyst

ElectroCraft, Inc.; Northern (KY); Hybrid; USD 90,000 - 120,000; Full time

Job summary

ElectroCraft, Inc. is seeking a Senior Business Systems Analyst to optimize ERP applications, reporting platforms, SQL data solutions, and Power BI analytics across manufacturing, finance, and supply chain.

You will partner with leaders, users, and IT to deliver scalable system improvements and accurate reporting. The role emphasizes hands-on ERP support (Dynamics AX/D365 or similar), BI/reporting development, and data integration across multi-site operations, with a focus on driving performance

Qualifications

• 5+ years of progressive experience in business systems analysis and ERP support in manufacturing.
• Hands-on Power BI and SQL development, data modeling, query development, and troubleshooting.
• Experience supporting ERP applications such as Microsoft Dynamics AX/D365, SAP, Oracle, Epicor, Infor, or comparable systems.
• Strong understanding of manufacturing, inventory, purchasing, finance, supply chain, and operational business processes.
• Ability to gather requirements, document processes, analyze gaps, test solutions, and communicate clearly with technical and non-technical stakeholders.

Responsibilities

• Act as a primary ERP support and analysis resource for ERP applications, with a focus on Microsoft Dynamics AX/D365 or comparable ERP platforms.
• Design, develop, and maintain Power BI dashboards, SQL-based reports, SSRS reports, and recurring business reporting packages.
• Design and optimize SQL queries, views, stored procedures, datasets, and data models supporting reporting and analytics.
• Support data flows between ERP, reporting systems, manufacturing applications, EDI, shop-floor systems, inventory tools, and third-party apps.
• Identify and implement process improvements, controls, and user adoption strategies; mentor junior analysts.

Skills

Power BI

SQL development

ERP analysis

Business analysis

Stakeholder communication

Data modeling

Education

Bachelor's degree in Information Technology, Business Administration, Computer Science, or Data Analytics

Tools

SSRS

ETL concepts

EDI

APIs

Job description

Description

The Senior Business Systems Analyst is a senior-level business and technical role responsible for supporting and improving ElectroCraft's ERP applications, reporting platforms, SQL-based data solutions, and Power BI analytics. This position works with business leaders, functional users, and IT to turn operational needs into reliable system solutions, accurate reporting, and scalable improvements across manufacturing, finance, supply chain, operations, and leadership reporting.

Requirements

ERP Application Support & Business Systems Analysis

• Serve as a primary support and analysis resource for ERP applications, with a focus on Microsoft Dynamics AX/D365 or comparable ERP platforms.
• Partner with manufacturing, finance, supply chain, operations, and leadership teams to understand business needs, document requirements, and deliver practical system solutions.
• Troubleshoot ERP application issues, data inconsistencies, transaction errors, user access concerns, and process gaps; coordinate escalation when needed.
• Support ERP configuration, testing, upgrades, patches, integrations, and enhancements while minimizing business disruption.
• Maintain functional documentation, process maps, user guides, system standards, and support procedures.

Reporting, Power BI & SQL Analytics

• Design, develop, and maintain Power BI dashboards, SQL-based reports, SSRS reports, and recurring business reporting packages.
• Create and optimize SQL queries, views, stored procedures, datasets, and data models that support accurate reporting and analytics.
• Develop executive dashboards, operational reports, manufacturing KPIs, financial reporting, inventory visibility, and supply chain metrics.
• Validate report logic, reconcile data sources, and ensure reporting accuracy, consistency, performance, and scalability.
• Work with stakeholders to define report requirements, standardized metrics, KPI definitions, and reporting best practices.

Manufacturing Systems & Data Integration

• Support data flows between ERP, reporting systems, manufacturing applications, EDI, shop-floor systems, inventory tools, and third-party business applications.
• Assist with manufacturing data structures including items, BOMs, routings, work orders, labor reporting, inventory transactions, costing, and scheduling-related data.
• Research and resolve integration or transaction issues that affect production, inventory, costing, shipping, purchasing, or reporting accuracy.
• Support data migration, validation, cleanup, and master data improvement initiatives.

Process Improvement, Controls & User Adoption

• Identify and recommend process improvements, automation opportunities, report standardization, and system enhancements.
• Support internal controls, security roles, audit requests, segregation-of-duties reviews, and data governance activities related to ERP and reporting systems.
• Train and support users with varying technical skill levels; promote adoption of system improvements and reporting tools.
• Collaborate with vendors, consultants, and internal IT resources to troubleshoot issues and deliver approved projects.
• Mentor junior analysts or support resources as needed and help strengthen team documentation and cross-training.

Education Requirements

• Bachelor's degree in information technology, Business Administration, Computer Science, Data Analytics, or a related field; equivalent experience may be considered.

Required Experience and Skills

• 5+ years of progressive experience in business systems analysis, ERP application support, reporting, SQL development, or business intelligence in a manufacturing or multi-site business environment.
• Hands-on experience with Power BI and SQL, including report development, data modeling, query development, and troubleshooting.
• Experience supporting ERP applications such as Microsoft Dynamics AX/D365, SAP, Oracle, Epicor, Infor, or comparable systems.
• Strong understanding of manufacturing, inventory, purchasing, finance, supply chain, and operational business processes.
• Ability to gather requirements, document processes, analyze gaps, test solutions, and communicate clearly with technical and non-technical stakeholders.
• Strong analytical, problem-solving, documentation, prioritization, and customer service skills.

Preferred Experience and Skills

• Experience with Microsoft Dynamics AX/D365 in a manufacturing environment.
• Experience with SSRS, data warehousing, ETL concepts, APIs, EDI, MES, or shop-floor system integrations.
• Advanced SQL development, performance tuning, and data validation experience.
• Experience building executive dashboards, operational scorecards, manufacturing KPIs, and standardized reporting templates.
• Experience supporting multi-site or global manufacturing operations.
• Experience mentoring other analysts, report writers, or ERP support team members.

Core Competencies

• Business Partnership: Builds trust with stakeholders and translates business needs into effective systems and reporting solutions.
• Technical Ownership: Takes accountability for issue resolution, documentation, data quality, and long-term reliability.
• Analytical Thinking: Uses structured analysis to identify root causes, improve processes, and support data-driven decisions.
• Communication: Explains technical topics clearly and professionally to users, leadership, vendors, and IT peers.
• Continuous Improvement: Looks for opportunities to improve ERP processes, reporting standards, automation, and user adoption.
• Confidentiality and Integrity: Handles business data, system access, and user support responsibilities with professionalism and discretion.

Physical Requirements

• Ability to stand or sit for prolonged periods of time.
• Ability to occasionally climb, stoop, bend, kneel, crouch, reach, and twist.
• Ability to lift and carry office or IT equipment required for responsibilities, typically up to 25 lbs.
• Ability to work in climate-controlled and non-controlled environments as needed.

What We Offer

• Competitive salary based on experience.
• Health, dental, and vision insurance.
• 401(k) with company match.
• Paid time off and holidays.
• Opportunity to grow in a dynamic, technology-driven manufacturing environment.
• A respectful and inclusive workplace culture.

Equal Employment Opportunity Statement

ElectroCraft is an Equal Opportunity Employer. We are committed to creating a diverse environment and are proud to be an employer of choice. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, sexual orientation, gender identity or expression, national origin, age, disability, veteran status, or any other legally protected status.

Harassment Policy

ElectroCraft maintains a strict policy prohibiting harassment of any kind in the workplace. We are committed to fostering a professional and respectful work environment where all individuals are treated with dignity and fairness. Violations of this policy are taken seriously and addressed in accordance with internal complaints and disciplinary procedures.

The above statements are intended to describe the general nature and level of work being performed by people assigned to the job. They are not intended to be an all-encompassing list of all responsibilities, duties, and skills required of personnel so classified.