(Agile1)Operations Data Analyst, Career

(Agile)Operations Data Analyst, Career
Oakland, CA - Hybrid
Months

ONLY SUBMIT CANDIDATES CURRENTLY LOCAL AND RESIDING NEAR WORK LOCATION-OAKLAND/BAY AREA. ASSIGNMENT IS HYBRID AND REQUIRED AT OAKLAND GO DAY A WEEK. LAPTOP WILL BE ISSUED. . WITH MANAGER PRIOR APPROVAL A PRE-DETERMINED AMOUNT FOR CELL AND INTERNET CAN BE EXPENSED MONTHLY.

TOP THINGS LOOKING 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 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 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

Required Qualifications: Minimum: • BA/BS Degree in Computer Science/Information Systems, Business, Engineering or other related field or equivalent work experience • At least years’ hands-on experience with relational databases (SQL Server preferred) • Advanced proficiency in T-SQL, including compl