Sql data analyst Jobs in Stockton, CA

Job Title

What You'll Do:

• Partner with key department, project, and program stakeholders on developing & implementing controls measures to better manage project financials to mitigate financial losses.
• Partner with stakeholders in the development of project schedules to control cost plans, conduct ongoing cost plan analysis, and perform variance & earned value analysis for stakeholders.
• Collaborate with stakeholders on the development of project & annual budgets, budget forecast planning, reporting, performance management, account data requests, and provide financial tracking system management and support.
• Manage orders from inception through completion and all required documentation is entered in current software system
• Maintain scope change, contingency release, change order, and journal entry logs.
• Maintain written and electronic project documentation and records for required aspects of the project: Maintain project files in accordance with established guidelines and requirements
• Document change order requests, project status, key issues, risks and resolution, priority changes and approvals.
• Provide Project Manager with monthly report of project costs and/or schedule information including variance analysis according to an agreed upon level of detail and prioritization.
• Provide Project Team members with current status report containing schedule and cost information. Comply with Utility Operations Policies, Standards and Guidelines.
• Analyze financial results on a monthly basis, providing explanations of significant cost drivers to PM Leadership
• In coordination with Project Manager develop project schedule and cash flow/forecast plans with functional department input.
• Monitor financial progress and maintain Project Manager's order group.
• Experience with appropriate software tools, e.g., SAP Work Management, P6, Excel, PowerBI

This is a hybrid remote & onsite role that will regularly require support at project sites in California as well as visits to the client office

We're building a talent pipeline for future opportunities that occur regularly. While there may not be an immediate opening, we're excited to connect with motivated candidates.

Required Qualifications:

• Bachelor's Degree Required
• 5 years or more of Primavera P6 experience
• Experience functioning in a project controls capacity where you developed, implemented, and drove project controls measures for large-scale complex projects.
• Experience managing project cost, forecasts, budgets, and conducting financial reporting (developing, creating, analyzing, packaging, and presenting) for large-scale capital projects.
• Proficiency in Microsoft Office Suite Excel (formulas, macros, pivot tables, vlookup, dashboards, etc.), SAP, Power BI, Tableau.
• Must have a valid drivers license without restrictions

Preferred Qualifications:

• Experience working within construction, energy, utilities, engineering (civil, mechanical, electrical), consulting or related space.

ENTRUST Solutions Group offers:

• Generous paid time off and benefits
• 401(k) retirement program with a company match
• Career development programs
• Tuition reimbursement
• Flexible work schedule

This position pays between $98,000 and $106,000 annually and is an exempt position. The specific amount within this range will be influenced by the work location and various factors, such as internal equity, professional skills, work experience, and pertinent education or training.

Benefits offered include company sponsored medical, dental, vision, and 401(k) plan with company match. Also offered are tuition reimbursement, voluntary life, disability, critical illness, accident and hospitalization plans. HSA or FSA medical accounts and FSA dependent care and transportation/parking accounts are also available. These benefits are subject to employee contribution amounts generally set annually.

Full time employees are eligible to earn PTO hours.

May be eligible for discretionary bonus as determined by the company.

ENTRUST Solutions Group is proud to be an Equal Employment Opportunity employer. We celebrate diversity and do not discriminate based on race, religion, color, national origin, sex, sexual orientation, age, veteran status, disability status, or any other applicable characteristics protected by law.