Data Analytics Engineer

Kirkhill, Inc.; Brea (CA); On-site; USD 85,000 - 200,000; Full time

Job summary

Kirkhill, Inc. seeks a Senior Data Analytics Engineer to partner across the organization, translating manufacturing requirements into data-driven solutions. You will design dashboards, optimize ERP/MRP processes, and build automation using SQL Server, Python, and Power Platform.

The role emphasizes production, supply chain, and quality, with AI and advanced analytics capabilities to improve performance and decision support across the enterprise.

Qualifications

• Bachelor's degree or equivalent in a technical field.
• Experience with manufacturing analytics and BI tools.
• Strong SQL and data modeling capabilities.

Responsibilities

• Partner with Operations to understand processes and improve factory performance.
• Design dashboards and tools for visibility into production, capacity, WIP, material availability, quality, backlog, and on-time delivery.
• Develop analytics around ERP/MRP systems and scheduling.

Skills

SQL Server

Power BI

Python

Excel

Power Platform

APIs

DAX

ETL

Automation

ERP/MRP

Manufacturing

Infor CSI

Education

Bachelor's degree in Computer Science, Information Technology, Engineering, Data Analytics, or related technical discipline

Tools

Infor CSI/Syteline

Job description

The Senior Data Analytics Engineer serves as a key technical and analytical partner within Kirkhill, developing and optimizing systems, data, analytics, and automation. This position supports all of Kirkhill, with an emphasis on Production, Supply Chain, and Quality.

The Senior Data Analytics Engineer serves as a key technical and analytical partner within Kirkhill, developing and optimizing systems, data, analytics, and automation. This position supports all of Kirkhill, with an emphasis on Production, Supply Chain, and Quality. Working cross-functionally across the organization, this role translates complex manufacturing and business requirements into practical technical solutions. The position combines manufacturing and ERP expertise with strong capabilities in SQL Server, Power BI, Python, Excel, Microsoft Power Platform, and emerging AI technologies.

Responsibilities

Manufacturing Systems & Analytics

Partner with Operations and other stakeholders to understand manufacturing processes, identify system and data gaps, and develop solutions that improve factory performance. Design reporting, dashboards, and analytical tools that provide actionable visibility into production, capacity, WIP, material availability, quality, backlog, and on-time delivery.

ERP, Planning & Decision Support

Develop analytical and automation solutions around Infor CSI/Syteline ERP, including production planning, APS/MRP, scheduling, jobs, BOMs, routings, inventory, purchasing, and material transactions. Develop data-driven scheduling and decision-support solutions that improve production priorities, material visibility, capacity planning, and projected completion dates.

Data Engineering, Integration & Automation

Design and maintain SQL Server data models, queries, stored procedures, ETL processes, and other data solutions supporting factory analytics and operational applications. Integrate and automate business processes using SQL, Python, REST APIs, Power Automate, Power Apps, Excel/VBA, and related technologies.

Artificial Intelligence & Advanced Analytics

Identify and implement practical applications of AI and advanced analytics within manufacturing and business operations, including document intelligence, large language models, intelligent workflow automation, anomaly detection, and predictive analytics. Evaluate solutions based on measurable business value, accuracy, security, maintainability, and data quality.

Continuous Improvement & Solution Ownership

Use operational data to identify bottlenecks, production risks, data-quality issues, and opportunities for process improvement. Own solutions from requirements and technical design through development, testing, deployment, documentation, training, and ongoing support.

Technical Leadership & Strategy

Contribute to the long-term factory information systems strategy, including integration of ERP, manufacturing, quality, BI, automation, and AI technologies. Provide technical leadership, mentorship, standards, and best practices for analysts, engineers, and business users.

Requirements

• Bachelor's degree in Computer Science, Information Technology, Engineering, Data Analytics, or a related technical discipline.
• 6+ years of experience in manufacturing systems, business intelligence, data analytics, business systems analysis, or a related technical role.
• Advanced proficiency with Microsoft SQL Server and T-SQL, including complex query development and optimization.
• Strong experience with Power BI, data modeling, DAX, Power Query, Excel, and operational reporting.
• Experience developing data-processing, integration, and automation solutions using Python, APIs, Microsoft Power Platform, or similar technologies.
• Experience with ERP/MRP systems and manufacturing data, including production planning, BOMs, routings, inventory, materials, and scheduling.
• Strong understanding of manufacturing operations and concepts such as WIP, capacity, throughput, material availability, lead time, and on-time delivery.
• Demonstrated ability to independently analyze complex operational problems, develop practical technical solutions, and communicate effectively with technical and non-technical stakeholders.

Preferred Qualifications

• Strong experience with Infor CSI/Syteline, including its SQL data model and APS/MRP functionality.
• Experience developing factory scheduling, capacity planning, WIP, material-planning, and production-performance solutions.
• Experience integrating ERP, MES, quality, planning, or other manufacturing systems.
• Practical experience implementing AI-enabled business or manufacturing solutions, predictive analytics, or intelligent workflow automation.

Kirkhill, Inc. is proud to be an equal opportunity employer, and all qualified applicants will receive consideration for employment without regard to race, color, age, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any other characteristic protected by law. All successful candidates must submit to post offer pre-employment physical examination, drug/alcohol screen and background check as a condition of employment.

Salary: $85000.00 - $200000.00 per year