Excel Pivot Table Power Query Jobs (NOW HIRING)

GENERAL JOB SUMMARY:

The Manufacturing Systems & Business Analytics Analyst is responsible for the administration, optimization, continuous improvement, and day-to-day support of TDI's manufacturing business systems, operational analytics, and enterprise reporting capabilities.

This position serves as TDI's primary business systems analyst for Deltek Costpoint, Manufacturing Resource Planning (MRP), manufacturing master data, operational reporting, dashboards, and business intelligence. The position partners closely with Engineering, Manufacturing, Supply Chain, Quality, Finance, Program Management, and Corporate IT to ensure manufacturing systems accurately support production planning, inventory control, product configuration, scheduling, quality, and executive decision making.

The Manufacturing Systems & Business Analytics Analyst is responsible for improving system utilization, reducing manual processes, increasing data integrity, developing business analytics, implementing automation, supporting future MES integration, and driving digital transformation initiatives throughout TDI.

Unlike transactional users of the ERP system, this position owns the continuous improvement of the business systems that enable the organization to operate efficiently and scale for future production growth.

ESSENTIAL DUTIES & RESPONSIBILITIES

ERP Administration & Continuous Improvement

• Serve as TDI's primary business systems analyst for Deltek Costpoint.
• Support ERP implementation, optimization, upgrades, testing, and validation.
• Troubleshoot ERP issues and coordinate solutions with Corporate IT.
• Maintain ERP configuration documentation.
• Evaluate new ERP capabilities and recommend implementation.
• Improve ERP utilization across all departments.
• Support user acceptance testing (UAT).

Manufacturing Master Data Management

Own and maintain integrity of:

• Item Master
• Engineering Bills of Material (EBOM)
• Manufacturing Bills of Material (MBOM)
• Manufacturing Routings
• Work Centers
• Warehouse Locations
• Units of Measure
• Inventory Parameters
• Product Structures
• Configuration Data

Coordinate Engineering Change implementation ensuring revisions are accurately reflected throughout Costpoint.

Manufacturing Reporting & Business Analytics

Develop executive dashboards and operational reports supporting:

• Safety
• Quality
• Delivery
• Cost
• Inventory
• Production
• Supply Chain
• Engineering
• Program Management
• Financial Performance

Develop reports using:

• Microsoft Excel
• Power Query
• Power Pivot
• Power BI
• SQL (preferred)

Develop automated KPI scorecards for all functional departments.

Microsoft Excel & Business Intelligence Development

Develop advanced business tools including:

• Executive dashboards
• Pivot Tables
• Power Query automation
• Power Pivot models
• Dynamic reports
• Forecasting models
• KPI scorecards
• Capacity planning models
• Inventory analysis
• Cost analysis
• Production reporting
• Supplier performance dashboards

Standardize reporting across the organization.

Manufacturing Systems Optimization

Continuously improve:

• Costpoint utilization
• MRP effectiveness
• ERP workflows
• Master Data quality
• Inventory transactions
• Production reporting
• Barcode implementation
• Digital work instructions
• Workflow automation
• Manufacturing analytics

Identify opportunities to eliminate manual processes.

Data Governance

Establish standards for:

• Part Number Management
• BOM accuracy
• Routing integrity
• Revision control
• Inventory accuracy
• User permissions
• Data ownership
• System documentation

Develop governance processes ensuring long-term data integrity.

Business Process Improvement

Lead improvement initiatives involving:

• Manufacturing workflows
• Supply Chain processes
• Inventory Management
• Production Planning
• Engineering Change Management
• KPI development
• Operational reporting
• Automation
• Digital transformation

Support Lean Manufacturing and Continuous Improvement initiatives.

Documentation & Training

Develop and maintain:

• Standard Operating Procedures
• Work Instructions
• Training Materials
• ERP User Guides
• Business Process Maps
• System Documentation

Provide role-based training for Costpoint users.

SYSTEMS OWNERSHIP

Primary ownership or administration support for:

• Deltek Costpoint ERP
• Manufacturing Resource Planning (MRP)
• Microsoft Excel
• Microsoft Power BI
• Microsoft Power Query
• Microsoft Power Pivot
• Microsoft Power Platform
• SharePoint
• Microsoft Teams
• Barcode Scanning Systems
• Future Manufacturing Execution Systems (MES)
• Manufacturing Reporting Database
• TIPQA integration support

PRIMARY BUSINESS PROCESS OWNERSHIP

Own or support:

• Master Data Governance
• Manufacturing Reporting
• Business Analytics
• KPI Development
• Dashboard Management
• ERP User Support
• Manufacturing Systems Administration
• BOM Governance
• Routing Governance
• Engineering Change Process
• System Documentation
• ERP Training
• Workflow Automation
• Continuous Improvement
• Digital Manufacturing Initiatives

KEY PERFORMANCE INDICATORS (KPIs)

Business Systems

• ERP system availability
• ERP user adoption
• ERP issue resolution time
• User satisfaction
• System utilization

Master Data

• BOM accuracy
• Routing accuracy
• Item Master integrity
• Inventory data accuracy
• Configuration accuracy

Reporting

• Dashboard availability
• Report accuracy
• Automated reporting utilization
• Executive reporting timeliness
• KPI accuracy

Continuous Improvement

• Manual process reduction
• Automation projects completed
• Cycle time improvements
• Productivity improvements
• Cost savings

User Support

• Training completion
• Support response time
• Documentation completion
• User competency improvements

DECISION AUTHORITY

The Manufacturing Systems & Business Analytics Analyst has the authority to:

• Recommend ERP process improvements.
• Recommend master data corrections.
• Develop and standardize reporting.
• Establish reporting standards.
• Recommend workflow automation.
• Recommend KPI development.
• Recommend ERP enhancements.
• Escalate system issues requiring Corporate support.
• Delay implementation of master data changes that could negatively impact system integrity.
• Recommend continuous improvement initiatives.

CROSS-FUNCTIONAL INTERFACE

Works closely with:

• Director of Operations
• Manufacturing Manager
• Engineering Manager
• Manufacturing Engineering
• Product Engineering
• Configuration Management
• Material Planning
• Buyers
• Inventory Control
• Shipping & Receiving
• Quality
• Finance
• Program Management
• Corporate IT
• Corporate Costpoint Administrators

SUPERVISORY RESPONSIBILITIES

• No direct supervisory responsibility.
• Functional owner of manufacturing business systems.
• Provide technical guidance to ERP users.
• Lead cross-functional improvement initiatives.
• Train new system users.
• Serve as TDI's primary manufacturing systems subject matter expert.

REQUIRED KNOWLEDGE, SKILLS & ABILITIES

Required

• Expert Microsoft Excel skills.
• Advanced Power Query and Power Pivot.
• Dashboard development.
• Business analytics.
• ERP/MRP systems.
• Manufacturing processes.
• Supply Chain fundamentals.
• Inventory Management.
• Production Planning.
• Excellent analytical skills.
• Process mapping.
• Project management.
• Strong written and verbal communication.
• High attention to detail.
• Ability to lead change across multiple departments.

Preferred

• Deltek Costpoint
• Power BI
• SQL
• Microsoft Power Platform
• VBA
• Manufacturing Execution Systems (MES)
• Aerospace or Defense manufacturing
• AS9100 Quality Management Systems
• Lean Manufacturing
• Six Sigma

EDUCATION & EXPERIENCE

Required

• Bachelor's degree in:
• Industrial Engineering
• Manufacturing Engineering
• Supply Chain Management
• Information Systems
• Operations Management
• Business Analytics
• Computer Science
• Related technical discipline
• Minimum 5 years of experience supporting manufacturing ERP/MRP systems.
• Minimum 5 years of advanced Microsoft Excel experience.
• Experience in manufacturing operations.

Preferred

• Deltek Costpoint implementation or administration.
• Aerospace or Defense industry.
• Government contract manufacturing.
• Power BI development.
• ERP implementation experience.
• Manufacturing digital transformation experience.

WORK ENVIRONMENT / PHYSICAL REQUIREMENTS

• Combination office and manufacturing environment.
• Frequent interaction with production personnel.
• Occasional travel throughout manufacturing and warehouse areas.
• Ability to sit for extended periods while developing reports and analytics.
• Ability to occasionally lift up to 25 pounds.

TRAVEL REQUIREMENTS

0-10% travel as required to support Corporate initiatives, ERP implementation activities, supplier visits, training, or other Kratos facilities.

THE ABOVE STATEMENTS ARE INTENDED TO DESCRIBE THE GENERAL NATURE AND LEVEL OF WORK BEING PERFORMED BY INDIVIDUALS ASSIGNED TO THIS CLASSIFICATION. THEY ARE NOT INTENDED TO BE CONSTRUED AS AN EXHAUSTIVE LIST OF ALL RESPONSIBILITIES, DUTIES AND SKILLS REQUIRED OF PERSONNEL SO CLASSIFIED.

A REVIEW OF THIS CLASSIFICATION HAS EXCLUDED THE MARGINAL FUNCTIONS OF THE CLASSIFICATION THAT ARE INCIDENTAL TO THE PERFORMANCE OF FUNDAMENTAL JOB JUTIES. ALL DUTIES AND RESPONSIBILITIES ARE ESSENTIAL JOB FUNCTIONS AND REQUIREMENTS AND ARE SUBJECT TO POSSIBLE MODIFICATION TO REASONABLY ACCOMMODATE INDIVIDUALS WITH DISABILITIES TO PERFORM THIS JOB PROFICIENTLY.   THE REQUIREMENTS LISTED IN THIS DOCUMENT ARE THE MINIMUM LEVELS OF KNOWLEDGE, SKILLS OR ABILITIES

EEO/M/F/D/V

#LI-Onsite