Senior Business Analyst
20 days ago
Oakland
Job Description ** Job Title: Senior Business Analyst Location - DCPP, Avila Beach (Onsite, CA) ID# SEDAA3582 Pay $30 - 38/hour Description: LOOKING FOR CANDIDATES CURRENTLY RESIDING AND LOCAL TO DCPP IN AVILA BEACH, CA AREA/WITHIN CLIENT'S SERVICE TERRITORY. WITH MANAGER PRIOR APPROVAL CAN SUBMIT MONTHLY EXPENSE FOR PERSONAL CELL PHONE USE FOR A PRE-DETERMINED AMOUNT. ROLE WILL HAVE UNESCORTED ACCESS BADGING THEREFORE PG&E WILL PERFORM THE BACKGROUND CHECK AND DRUG SCREENING. The position will be on-site at DCPP and require an Alternate Work Schedule (AWS) please confirm and ensure internally you can support this role and are able to move forward with this schedule before submitting any candidate(s). If yes, an AWS Acknowledgement Form will need to be completed by the worker and kept on record internally(supplier to provide applicable form to sign and not provided by MSP). *Client laptop will be provided. Other tools will be provided as needed. TOP THINGS LOOKING FOR: • Strong working knowledge of relevant Microsoft applications, including Visio, Power BI and/ or Tableau., • Create reports, dashboards and visualizations to help others understand business performance. Business Analyst transform data into insight that can help to improve the value of the Project Services Department at DCPP. Other duties and responsibilities of a Business Analyst include developing and managing business intelligence solutions for the organization, providing reports through office applications to improve business processes. Collaborate with cross-functional teams to transform data into meaningful analysis and support data-driven strategies for the purpose of executing the department’s mission. The Business Analyst will leverage data to provide actionable insights that drive strategic decision-making and enhance operational efficiencies across the organization. Desired: • Experience with designing and developing customizable and interactive dashboards and reports using BI tools to visualize key performance indicators (KPIs) and metrics, • Expert builder of automated reports and dashboards with the help of Power BI and other reporting tools, • Perform in-depth data analysis to identify trends, correlations, and opportunities for improvement, resulting in actionable recommendations., • Collaborate with stakeholders to gather requirements and define reporting needs, ensuring alignment with business objectives., • Execute data quality assessments and cleansing processes, maintaining data integrity and accuracy across all reporting outputs., • Support strategic initiatives by providing analytical insights and recommendations, including forecasting and trend analysis., • Present findings and insights to stakeholders, translating complex data into understandable and actionable formats., • Experience in tools and systems on MS SQL Server BI Stack, including SSRS and TSQL, Power Query, MDX, PowerBI, and DAX, • Expert-level MS Office skills including Word, Excel, PowerPoint and MS Project, • Have knowledge of database fundamentals such as multidimensional database design, relational database design, and more, • Demonstrated experience in metrics development and deployment, • Experience with deployment flow charts and/or &swim lane; tools for visualizing procedures and roles, • Bachelor's degree in business management, project management or other related fields, and or equivalent work experience 3+ years of experience in business intelligence, data analysis, or a related field., • Proficient in SQL and experienced with data visualization tools such as Tableau, Power BI, or similar., • Strong analytical and problem-solving skills with a proven ability to translate data into actionable insights., • Excellent communication skills, with the ability to present complex information clearly and concisely., • Experience in an agile environment or with Agile methodologies., • Familiarity with programming languages such as Python or R for data analysis., • Knowledge of database management systems (e.g., MySQL, PostgreSQL) and data warehousing concepts., • Strong team collaborator with the ability to work effectively in cross-functional teams., • Detail-oriented mindset with a passion for data and a commitment to excellence., • Ability to adapt to changing priorities and a fast-paced environment., • Proactive approach to identifying opportunities for improvement and problem-solving., • Utility industry experience, • Technical Skills and Relevant Technologies, • Deep expertise in SQL for querying and manipulating data., • Hands-on experience with data visualization tools (Tableau, Power BI, etc.) for creating dashboards and reports., • Familiarity with ETL processes and data integration techniques. Job Title: Senior Business Analyst Location - Remote, candidate needs to be local (to Oakland, CA) ID# SEDAA3577 Pay $40 - 56/hour Description: LOCAL CANDIDATES ONLY The role is remote. TOP THINGS: Experience in Power BI and Power Automate Job Responsibilities • Performs analysis on complex data models requiring customized reports and data., • Develops new or revises existing data analysis to predict business outcomes selecting from various complex variables., • Develops and uses metrics to develop recommendations related to business strategy and operations. Presents findings and recommendations to leaders. Knowledge, Skills, and Abilities (Desired) • Broad knowledge of different analytical methods, approaches and tactics, • Advanced understanding of fundamental analysis and what-if modeling concepts, methods and techniques and analysis of how different factors affect business outcomes, • Creative problem skills to develop solutions, • Qualitative and quantitative analytical skills to justify any business changes, • Strong presentation and communication skills to deliver findings and recommendations to various levels of management, • Knowledge and understanding of key drivers affecting business results, • Strong project management knowledge and skills to lead project teams, • Excellent organizational, prioritization and multi-tasking skills, • Adaptable to changing business conditions and ambiguity, • Advanced in Information Analysis, Market Research, Metrics and KPI Tracking, Consulting Skills, Project Management skills. Job Title: Senior Business Analyst Location - Hybrid (Oakland, CA) JP 3462 Description: LOOKING FOR CANDIDATES CURRENTLY RESIDING LOCAL IN BAY AREA/NEAR WORK LOCATION - OAKLAND GENERAL OFFICE. ASSIGNMENT IS MAINLY REMOTE BUT REQUIRED ON-SITE IN OAKLAND 4-5 TIMES PER MONTH AT MANAGER REQUEST. LAPTOP WILL BE ISSUED. A PRE-DETERMINED AMOUNT FOR CELL AND INTERNET MAY BE EXPENSED MONTHLY WITH MANAGER PRIOR APPROVAL. TOP THINGS LOOKING FOR: • Advanced SQL, Excel, and Power BI knowledge, • Years of experience in Data Analytics, • Expert communicator, • Advanced Power BI, Excel, and SQL experience, • Performs analysis on complex data models requiring customized reports and data., • Develops new or revises existing data analysis to predict business outcomes selecting from various complex variables., • Develops and uses metrics to develop recommendations related to business strategy and operations. Presents findings and recommendations to leaders., • Manages small to mid-size projects., • Strong working experience in data warehousing and business intelligence technologies including good knowledge of Relational Database/SQL, SAS and Business Objects., • Strong project management, analytical, and problem-solving experience., • Responds to internal and external data requests, and ensures deadlines are met and stakeholders are satisfied. Knowledge, Skills, and Abilities (Desired) • Broad knowledge of different analytical methods, approaches and tactics, • Advanced understanding of fundamental analysis and what-if modeling concepts, methods and techniques and analysis of how different factors affect business outcomes, • Creative problem skills to develop solutions, • Qualitative and quantitative analytical skills to justify any business changes, • Strong presentation and communication skills to deliver findings and recommendations to various levels of management, • Knowledge and understanding of key drivers affecting business results, • Strong project management knowledge and skills to lead project teams, • Excellent organizational, prioritization and multi-tasking skills, • Adaptable to changing business conditions and ambiguity, • Advanced in Information Analysis, Market Research, Metrics and KPI Tracking, Consulting Skills, Project Management skills., • Proficient in Operational Monitoring & Analysis, Advocacy and Persuasion, Presentation Skills, • Advanced Excel and highly proficient with SQL database queries and modeling