Data System Analyst

recruitAbility; Goleta (CA); On-site; USD 90,000 - 120,000; Full time

Job summary

RecruitAbility is seeking a Data & Systems Analyst in Goleta, CA to collaborate with Operations and Manufacturing to transform how data is collected, modeled, and reported. You will drive analytics, automate workflows, and design scalable data solutions that improve visibility into performance.

Responsibilities include building Power BI dashboards, integrating ERP data, and turning manual processes into standardized, repeatable data models. Strong SQL, Excel, and automation skills are essential.

Qualifications

• Bachelor's degree in data science, engineering, computer science, information systems, or related field, or equivalent experience.
• 6–10 years of experience in data analytics, business systems, operations, development, or similar roles.
• Strong proficiency with SQL, advanced Excel, and Power BI.
• Experience with ERP systems and operational data structures.
• Experience designing repeatable and scalable data workflows.
• Familiarity with Microsoft Fabric or similar data platforms.
• Experience with automation technologies such as Python, VBA, Power Automate, or other low-code/no-code solutions.
• Experience with process mapping and workflow redesign tools such as Visio.
• Strong communication skills with the ability to work with technical and non-technical stakeholders.
• Experience supporting manufacturing, production, supply chain, operations, or finance environments.

Responsibilities

• Partner with Manufacturing, Operations, and cross-functional teams to map workflows, reporting needs, and challenges.
• Extract, transform, and model data from ERP, legacy, and operational systems to support reporting and business analysis.
• Develop standardized and repeatable datasets for ongoing operational reporting.
• Build and maintain Power BI dashboards, reports, KPIs, and operational analytics.
• Develop automation scripts and workflows to reduce manual data entry and repetitive reporting tasks using Python, VBA, Power Automate, or similar platforms.
• Identify opportunities to replace manual Excel-based processes with scalable systems and workflows.
• Evaluate existing tools and processes and recommend improvements that increase efficiency, data accuracy, and visibility.
• Improve data integrity and reporting consistency through documentation, standardization, and data governance practices.
• Create and maintain process documentation, including process flows, SOPs, work instructions, and technical data documentation.
• Train and support cross-functional teams on reporting tools, data responsibilities, and new workflows.
• Serve as a consultative problem solver translating operational challenges into practical data solutions.

Skills

SQL

Advanced Excel

Power BI

Python

VBA

Power Automate

Visio

Data governance

Education

Bachelor's degree in Data Science, Engineering, Computer Science, Information Systems, or related field

Tools

ERP systems (Deltek ERP)

Microsoft Fabric

Visio

Job description

The Data & Systems Analyst will work closely with Operations and Manufacturing teams to improve how operational data is collected, organized, analyzed, and reported. This role combines data analytics, systems improvement, automation, and business process optimization to create more efficient and scalable workflows.

A major focus of the position will be transitioning existing manual and Excel-based processes into standardized data models, automated workflows, and dashboards that provide greater visibility into manufacturing and operational performance.

This is an ideal opportunity for someone who enjoys solving problems, working directly with operational teams, and turning inefficient or unclear processes into practical, scalable solutions.

Responsibilities

• Partner with Manufacturing, Operations, and other cross-functional teams to understand current workflows, reporting needs, and operational challenges.
• Extract, transform, and model data from ERP, legacy, and operational systems to support reporting and business analysis.
• Develop standardized and repeatable datasets for ongoing operational reporting.
• Build and maintain Power BI dashboards, reports, KPIs, and operational analytics.
• Develop automation scripts and workflows to reduce manual data entry and repetitive reporting tasks using tools such as Python, VBA, Power Automate, or similar automation platforms.
• Identify opportunities to replace manual Excel-based processes with more scalable systems and workflows.
• Evaluate existing tools and processes and recommend improvements that increase efficiency, data accuracy, and visibility.
• Improve data integrity and reporting consistency through documentation, standardization, and data governance practices.
• Create and maintain process documentation, including process flows, SOPs, work instructions, and technical data documentation.
• Train and support cross-functional teams on reporting tools, data responsibilities, and new workflows.
• Serve as a consultative problem solver who can translate operational challenges into practical systems and data solutions.

Qualifications

• Bachelor's degree in Data Science, Engineering, Computer Science, Information Systems, or a related field, or equivalent professional experience.
• Approximately 6–10 years of experience in data analytics, business systems, operations, development, or similar roles.
• Strong proficiency with SQL, advanced Excel, and Power BI.
• Experience working with ERP systems and operational data structures.
• Experience designing repeatable and scalable data workflows.
• Familiarity with Microsoft Fabric or similar modern data platforms.
• Experience with automation technologies such as Python, VBA, Power Automate, or other low-code/no-code solutions.
• Experience with process mapping and workflow redesign tools such as Visio.
• Strong communication skills with the ability to work directly with technical and non-technical stakeholders.
• Experience supporting manufacturing, production, supply chain, operations, or finance environments.

Preferred Experience

• Experience working with manufacturing or production data and workflows.
• Experience with Deltek ERP or comparable ERP platforms.
• Knowledge of data governance and data integrity best practices.
• Exposure to SOX requirements, controls, and compliance.
• Experience helping organizations modernize legacy or spreadsheet-driven reporting processes.