Data Analyst

Operations Data Analyst 1 year contract Pay Range: $50.00 - $52.00 W2 Assignment is hybrid and will be onsite in Oakland 1 day per week TOP THINGS 1. Hands-on experience with SQL Server such as creating SSIS packages. 1. Having the “Debugger” Mindset – able to do root case analysis. 1. Cross-functional “translation” skills – The ability to explain a technical failure to a non-technical stakeholder. TOP SKILL SETS REQUIRED IN A CANDIDATE: -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 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 Required Qualifications: Minimum: • 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 Benefits: (employee contribution)  Health insurance  Health savings account  Dental insurance  Vision insurance  Flexible spending accounts  Life insurance  Retirement plan We also consider qualified applicants regardless of criminal histories, consistent with legal requirements. Pursuant to applicable state and municipal Fair Chance Laws and Ordinances, we will consider for employment-qualified applicants with arrest and conviction records. For Los Angeles, CA applicants: Qualified applications with arrest or conviction records will be considered for employment in accordance with the Los Angeles County Fair Chance Ordinance for Employers and the California Fair Chance Act.