Operations Data Analyst (Local Candidates Only)

Dice is the leading career destination for tech experts at every stage of their careers. Our client, SPECTRAFORCE TECHNOLOGIES Inc., is seeking the following. Apply via Dice today! Operations Data Analyst Oakland, CA-Hybrid (one day in a week) 12 months+ contract • Need local candidates to Oakland/ Bay Area, CA only • • • • • • ONLY SUBMIT CANDIDATES CURRENTLY LOCAL AND RESIDING NEAR WORK LOCATION-OAKLAND/BAY AREA. ASSIGNMENT IS HYBRID AND REQUIRED AT OAKLAND GO 1 DAY A WEEK. LAPTOP WILL BE ISSUED. ANY OTHER EQUIPMENT REQUIRED IS RESPONSIBILITY OF SUPPLIER. WITH MANAGER PRIOR APPROVAL A PRE-DETERMINED AMOUNT FOR CELL AND INTERNET CAN BE EXPENSED MONTHLY. Top things to look for: • Hands-on experience with SQL Server such as creating SSIS packages. • Having the “Debugger” Mindset – able to do root case analysis. • Cross-functional “translation” skills – The ability to explain a technical failure to a non-technical stakeholder. Top Skills Required: • SQL , SSIS packages, data cleaning, PowerBI • Desire: PowerAutomate, Power App, Python Position Summary: The Senior Data Analyst reports to the manager of Smart Meter Programs. This individual extracts data develops insights into analysis, initiatives, and leadership support, and responds to ad hoc data requests. This role also maintains operational tools and databases to ensure that they are kept up to date using data from various client systems. In this role, you will work with a diverse group of professionals including accounting, program management, resource planning, field operations, and IT – to deliver business solutions, automate workflows, and drive project success across multiple domains. Job Responsibilities: • Manage, monitor, and optimize ETL processes, primarily using SQL Server Integration Services (SSIS) • Create complex automated data routines and processes for reporting and data delivery ensuring accurate data manipulation and data cleansing • Anticipate client concerns and questions, and provide proactive, timely and professional client-focused communications • Provide timely and professional responses to client inquiries or escalate as appropriate. • Analysis of current processes and recommendations for process improvements • Maintain and enhance existing Power BI reports and dashboards for various business units. • Review, update, and organize data solution documents for knowledge sharing and compliance • Collaborate with stakeholders to understand requirements, translate them into technical solutions, and communicate results effectively • Assist in database administration, performance tuning, and troubleshooting complex SQL queries • Support data integrity, data quality, and data governance initiatives Minimum Required Qualifications: • BA/BS Degree in Computer Science/Information Systems, Business, Engineering or other related field or equivalent work experience • At least 3 years’ hands-on experience with relational databases (SQL Server preferred) • Advanced proficiency in T-SQL. Applicant Notices & Disclaimers • For information on benefits, equal opportunity employment, and location-specific applicant notices, click At SPECTRAFORCE, we are committed to maintaining a workplace that ensures fair compensation and wage transparency in adherence with all applicable state and local laws. This position's starting pay is: $40.00/hr.