Operations Data Analyst

Spectraforce Technologies; Dublin (CA); Hybrid; USD 70,000 - 95,000; Full time

Job summary

Spectraforce Technologies is seeking an Operations Data Analyst for a 5-month hybrid role in Dublin, CA. The position involves handling data analysis projects with limited supervision, collaborating with Data Management Analysts, and delivering accurate results.

A strong background in Excel, SAP, and Power BI/Power Apps is required. The ideal candidate will also contribute to data processing, reporting, and data cleansing across sources, ensuring timely delivery and clear communication of

Qualifications

• BA/BS degree or equivalent work experience.
• 2 years of related work experience.

Responsibilities

• Manage standard data analysis projects from request to results, on-time and within budget.
• Process data with teammates, create automated routines for reporting and data delivery.
• Transfer data from databases to analysts to support operational analysis.
• Analyze data using statistical tools to develop ad hoc reports, trends and profiles.
• Develop clear, actionable data analyses for clients.

Skills

Excel/VBA

Data analysis

SQL queries

UNIX shell scripting

Programming (VB, Perl, C)

Communication of findings

Education

BA/BS Degree in Marketing, Business, CS, Eng or related

Tools

SAP

Power BI/Power Apps

Oracle/Business Objects

Job description

Operations Data Analyst

5 months

Dublin, CA

Hybrid (One day a week in office on Wednesday)

Notes:

• Open to candidates that are non-local to Dublin. However, the HM would like candidates who are open to one day per week (Wednesday) in Dublin. The role is expected to be fully remote. If the successful candidate is located near Dublin, there may be the opportunity to visit the office on occasion.

TOP THINGS:

• Deep proficiency with Excel, Experience with SAP, Experience with Power BI/Power Apps.

EQUIPMENT:

• Client laptop will be provided at the start. Any other tools must be vendor provided.

Responsibilities:

• Manage standard, routine data analysis projects with limited supervision from initial request to presenting data results ensuring that the project is completed within budget and on-time.
• Work with other Data Management Analysts to process data, analyze data and report findings. Creates automated data routines and processes for reporting and data delivery ensuring accurate data manipulation and data cleansing.
• Manages standard data extracts and list pulls ensuring accurate data. Transfers the data from databases to various analysts to support operational analysis efforts.
• Demonstrates full understanding of data processing and analysis techniques. Analyzes data using various statistical tools to develop ad hoc reports, statistics, trends and profiles.
• Develops and communicates clear, concise and actionable data analyses for clients.

Education Minimum:

• BA/BS Degree in Marketing, Business, Computer Science, Engineering or other related field or equivalent work experience

Minimum Experience:

• 2 years of related work experience

Knowledge, Skills, and Abilities (Desired)

• Familiarity with utility operations.
• Skilled in Microsoft Excel/Access (complex formulas, graphing, VBA)
• Skilled writing SQL queries using Oracle or Business Objects
• Experience in UNIX shell programming (csh, awk, sed, vi).
• Knowledge of base-SAS and programming language such as Visual Basic, Perl, C
• Able to analyze and interpret data and effectively communicate findings.