Data Analytics Engineer

Kirkhill Inc.; Downtown Brea (CA); On-site; USD 140,000 - 170,000; Full time

Job summary

Kirkhill, Inc. is seeking a Senior Data Analytics Engineer to partner with Production, Supply Chain, and Quality, building analytics, data systems, and automation across the business.

You will design dashboards and data pipelines, optimize ERP data flows, and apply AI-enabled analytics. The role requires cross-functional collaboration and ownership from requirements to deployment, training, and ongoing support.

Qualifications

• Bachelor's degree in CS/IT/Engineering, Data Analytics, or related field.
• 6+ years in manufacturing systems, BI, data analytics, or related technical role.
• Advanced proficiency with Microsoft SQL Server and T-SQL.
• Strong experience with Power BI, data modeling, DAX, Power Query, Excel, and operational reporting.
• Experience developing data-processing, integration, and automation using Python, APIs, Power Platform, or similar technologies.
• Experience with ERP/MRP systems and manufacturing data (production planning, BOMs, routings, inventory).
• Understanding of manufacturing operations: WIP, capacity, throughput, lead time, on-time delivery.
• Ability to independently analyze complex operational problems and communicate with technical and non-technical stakeholders.

Responsibilities

• Partner with Operations and other stakeholders to understand manufacturing processes and identify data gaps; develop solutions for better factory performance.
• Design reporting, dashboards, and analytical tools to provide visibility into production, capacity, WIP, material availability, quality, backlog, and on-time delivery.
• Develop analytical and automation solutions around Infor CSI/Syteline ERP for production planning, APS/MRP, scheduling, jobs, BOMs, routings, inventory, and material transactions.
• Design and maintain SQL Server data models, queries, ETL processes, and data solutions supporting factory analytics and operational apps.
• Identify and implement AI/advanced analytics in manufacturing and business operations; evaluate value, security, and data quality.
• Own solutions from requirements and technical design through development, testing, deployment, documentation, training, and support.
• Contribute to long-term factory information systems strategy and provide technical leadership and best practices.

Education

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

Job description

Job Role

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.