SPECTRAFORCE · 19 hours ago
Mid-Level Data Analyst (W2 contract)
SPECTRAFOR is seeking a Mid-Level Data Analyst for a hybrid role based in Oakland, CA. The analyst will manage standard data analysis projects, work with other Data Management Analysts, and ensure accurate data manipulation and reporting.
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
Qualification
Required
Only submit candidates currently residing in bay area/near work location-Oakland
Assignment is hybrid and required on-site at Oakland general office (ogo) three times a week
Client laptop & docking station will be issued
Microsoft teams will be used for calls and meetings
Equipment: Client's laptop will be provided. If there is a backlog, candidate can utilize a personal device with Citrix until the laptop is available
Dashboards and Reporting
Data governance
Records management
Audit
Tracker accuracy
Trend analysis
Root cause analysis
Folder structures
Data logging taxonomy
Audit-ready documentation
Logging automation
Problem solving, Critical thinking, Nimble, Tenacious, Curious, Ability to Navigate thru Ambiguity
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
BA/BS Degree in Marketing, Business, Computer Science, Engineering or other related field or equivalent work experience
2 years of related work experience
Preferred
Familiarity with utility operations
Skilled in Microsoft Excel/Access (complex formulas, graphing, VBA)
Skilled writing SQL queries using Oracle or Business Objects
Skilled developing dashboards (PowerBi)
Skilled developing and reporting metrics and KPIs
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
Company
SPECTRAFORCE
Welcome to SPECTRAFORCE, your gateway to NEWJOBPHORIA™! Established in 2004, SPECTRAFORCE is now one of the largest and fastest growing U.S.
H1B Sponsorship
SPECTRAFORCE has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Represents job field similar to this job
Trends of Total Sponsorships
2025 (3)
2024 (6)
2023 (1)
2022 (6)
2021 (8)
2020 (7)
Funding
Current Stage
Late StageCompany data provided by crunchbase