Data & Systems Analyst - Automate Ops & Power BI

recruitAbility

Goleta (CA)

On-site

USD 90,000 - 120,000

Full time

4 hours ago

Be an early applicant

Get more replies from employers

Send a job-specific resume in minutes.

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.