Business Systems Analyst - I

Southern California Gas Company Los Angeles , CA 90009

Posted 2 weeks ago

Primary Purpose

Provides "Energy Efficiency Collaboration Platform" (EECP)* computer software system-based solutions and project support for Customer Programs & Assistance Projects. This support includes report and dashboard configuration, strategic data-mining, and statistical analysis with an objective of optimizing of program delivery and operations.

The candidate must work closely with their business clients to understand their requests, define business requirements and make recommendations concerning technology, data analytic and reporting solutions. Analyst works with Customer Programs Operations Technology, Customer Services CST, COT, and the Information Technology Systems Staff to provide client support.

Duties and Responsibilities

  • Analyzes routine issues/problems/data and recommends potential solutions.

  • Interprets business needs, translates them into requirements, and implements solutions to meet project objectives.

  • Serves as a coordinator or administrator of activities. - Possess specialized business and/or systems knowledge (e.g. revenue cycle, field services, customer programs or technology expertise.)

  • Works with clients/customers to identify & document their needs.

  • Builds software system-based dashboards and reports; compiles, analyzes and prepares data for various internal evaluations and external CPUC reports, often with short turnaround timeframes.

  • This includes supporting regulatory data requests, data analysis, program support forecasts, and reports and dashboards on the EECP software system server.

  • Provides support to several teams within the Customer Programs organization, including the Operations Strategy, EE Program Operations, EE software, and EM&V teams.

Qualifications

  • Successful candidate should have a bachelor's degree in Computer Science, information systems, Statistics, Engineering or Business Administration is required.

  • Master's degree in Statistics highly desired.

  • Proficiency in Microsoft Word, PowerPoint, Report Builder 3.0 and Visual Studio.

  • Excel and SQL skills required. Role will create reports and dashboards utilizing Report Builder 3.0 to query the EECP SQL Server database.

  • Working knowledge of SAP, SAS, Business Warehouse and web analytics software preferred.

  • Must have the ability to communicate and present (verbal and written) technical information in a clear and concise manner to both a technical and non-technical audience.

  • Must have the ability to identify issues, analyze data, develop, recommend, and implement solutions.

  • Must possess initiative, decision-making skills and problem-solving skills.

  • A demonstrated ability to understand the business needs in order to effectively apply new technologies and complete complex systems projects.

  • Experience with the Microsoft desktop applications, mainframe or client server programming experience, SAP enterprise systems, data warehouse or Internet experience is a plus.

  • The EECP software system manages and supports program management workflow, processes, vendor management, invoicing and reporting support for SoCalGas' Energy Efficiency programs.

  • 1-3 years - related experience is required.

This position can be filled at a different level based on the final scope of job responsibilities and job requirements.

icon no score

See how you match
to the job

Find your dream job anywhere
with the LiveCareer app.
Mobile App Icon
Download the
LiveCareer app and find
your dream job anywhere
App Store Icon Google Play Icon
lc_ad

Boost your job search productivity with our
free Chrome Extension!

lc_apply_tool GET EXTENSION

Similar Jobs

Want to see jobs matched to your resume? Upload One Now! Remove
Data Systems Analyst

Ucla Health

Posted 6 days ago

VIEW JOBS 11/18/2020 12:00:00 AM 2021-02-16T00:00 As the Data Systems Analyst for the Jonsson Comprehensive Cancer Center (JCCC), you will be responsible for a variety of mission-critical systems and processes on an array of platforms, ranging from SQL Server to Oracle. In this role, you will aggregate and provision data from multiple systems, such as the Clinical Research Management System (CRMS), Summary Accrual Reporting Application (SARA), Macadamia, CAFE, EVAL and the Electronic Medical Record (EMR). You will also serve a key function in gathering and provisioning data in support of the JCCC's Support Grant from the National Cancer Institute through the development, documentation and testing of various stored procedures, views and triggers within the Oracle database of the CRMS, as well as data collection forms within the application, to support the business and reporting for the JCCC. In addition, you will provide overall management and planning activities for the implementation of informatics projects across the JCCC. Responsibilities As the Data Systems Analyst for the Jonsson Comprehensive Cancer Center (JCCC), you will be responsible for a variety of mission-critical systems and processes on an array of platforms, ranging from SQL Server to Oracle. In this role, you will aggregate and provision data from multiple systems, such as the Clinical Research Management System (CRMS), Summary Accrual Reporting Application (SARA), Macadamia, CAFE, EVAL and the Electronic Medical Record (EMR). You will also serve a key function in gathering and provisioning data in support of the JCCC's Support Grant from the National Cancer Institute through the development, documentation and testing of various stored procedures, views and triggers within the Oracle database of the CRMS, as well as data collection forms within the application, to support the business and reporting for the JCCC. In addition, you will provide overall management and planning activities for the implementation of informatics projects across the JCCC. Qualifications * Bachelor's degree in Computer Science or related field required with minimum five years of relevant experience with Oracle development, or Master's degree with three years of relevant experience * 4+ years' experience with construction of complex queries, using SQL and MS Office programs and applications (e.g., Word, Excel, PowerPoint, Outlook and scheduler, etc.) * Preferred: Familiarity with eResearch applications, notably Oncore clinical trials system * Demonstrated experience using Oracle databases, including detailed knowledge of Database queries to improve system performance, data retrieval and customized reporting * Demonstrated experience gathering and writing detailed business and functional requirements for reporting * Detailed knowledge of good database design principles, and SQL and PL/SQL * In-depth experience of developing in an Oracle environment * Demonstrated experience in advanced concepts of Microsoft Excel (macros, pivots, autofilter, working with large datasets to identify patterns and/or anomalies) * Knowledge of Microsoft Windows operating systems for sporadic desktop support * Excellent demonstrated technical writing skills to draft standard operating procedures (SOP's) and ability to synthesize and process complex technical information and present in easy to understand terms to non-technical users utilizing documents and diagrams * Ability to frequently lift CPUs, printers, and monitors UCLA is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or protected Veteran status. Ucla Health Los Angeles CA

Business Systems Analyst - I

Southern California Gas Company