Business Intelligence / Data Advisor

Southern California Gas Company Los Angeles , CA 90009

Posted 2 months ago

Primary Purpose:

This position provides data analytics and data consultation for several areas of the Company, such as Energy Efficiency, Commercial & Industrial, Energy Markets and Demand Forecasting, etc. This position works to understand Company policies, customer databases and customer data systems (e.g. Customer Information System, Integrated Customer Data Warehouse) for SoCalGas' residential, businesses, and industrial customers. This position also provides strategic insights on consumer segments and industries and Company programs and services. Frequently handles high priority, time sensitive regulatory data requests. Responsible for data modeling and other complex data analytics.

Duties & Responsibilities:

  • Analyzes and incorporates customer demographics, segment data and primary & secondary research into marketing strategies to maximize results

  • Develops complex data modeling to support Customer Communications, Strategy, Customer Programs, Customer Research, etc. using data from various channels (e.g. IVR, Web) to provide customer and program insights

  • Uses program languages (e.g. SQL, SAS, Python) to provide data and reports from internal customer database like CIS to support various department needs

  • Provides time sensitive data and reports mandated by government agencies, like California Public Utilities Commission (CPUC) and California Energy Commission (CEC), etc.

  • Meets regularly & maintains strong relationships with internal business partners, like Energy Efficiency, Demand Forecasting and Customer Communications, etc.

  • Works to understand regulatory requirements for customer programs and analyzes implications of new legislation and tariff mandates on market segments, billing, programs and services.

Minimum Requirements (Experience & Education):

  • Bachelor Degree in statics, math, business analytics or related field of study is required.

  • 5 years of professional experience related to employee, consumer, or marketing research activities, statistics, math, business analytics or related areas is required.

  • Experience with Company internal databases & data systems (e.g. CIS, ICDW), data analytic tools (e.g. SAS, SPSS), and program languages (e.g. SQL, SAS, Python).

  • Proficiency in online survey programming tools, statistical software and MS Word, Excel and PowerPoint.

Preferred Requirements (Experience & Education):

  • Advanced degree in in statics, math, business analytics or related field of study is preferred.

  • Experience in moderating and group facilitation is preferred.

  • Experience working in the energy industry is preferred.

Attributes, Skills and Abilities:

  • Demonstrated effective project management, negotiation and organizational abilities.

  • Excellent oral and written communication skills.

  • Must be detail oriented, driven by data, but able to effectively communicate/interpret data to tell a story to upper management/executives and those with less familiarity with market research and data analytics.

  • Demonstrated Interpersonal skills - including skills of persuasion.

  • Ability to quickly assimilate industry information and communicate this to internal organizations.

  • Strong Written and oral presentation skills.

  • Ability to effectively discern and prioritize demands to manage time.

  • Conceptual thinker with exceptional analytical skills.

  • Demonstrated diplomacy and tact when dealing with others; ability to positively influence others and gain their respect, cooperation and support.

  • Ability to manage multiple projects simultaneously, strong work ethic, adherence to deadlines, and adaptability to handle additional urgent requests.

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

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
Financial Business Intelligence Analyst

Loyola Marymount University

Posted 7 days ago

VIEW JOBS 11/26/2020 12:00:00 AM 2021-02-24T00:00 Full-time Regular Hours Per Week: 40 Days of Week: M-F Shift Schedule: Specific Work Schedule: Posting Options: Internal and External Position Summary: The position reports to the Associate Vice President for Financial Planning and Budget and provides support for the University's financial planning and annual budget development, implementation, and management. This position will focus on support and expansion of the University's operational reporting capabilities of the university's business processes, data-informed decision-making, and strategic planning activities. This position is responsible for the design and development of complex financial models and business intelligence dashboards utilizing the University's budget and planning system (Adaptive Insights). This position will serve on several University committees including the Enterprise Technology Committee. Position Specific Responsibilities: * Design, develop and/or modify reports in Workday and Adaptive Insights. * Collaborate with end-users throughout the university to capture end-user requirements and produce accurate reports and budget models according to their specifications. * Research data and data relationships, both internal operating data and external market data. * Interact with end-users as a technical resource to troubleshoot problems with reports and applications. * Analyze existing financial models for performance improvements. * Train end users in the use of Adaptive Insights and Workday, when needed. * Manage the access given to users of the budget reporting environment and other applications as required. * Collaborate with the Data Warehouse and Analytics Manager to create improvements to current processes and develop new data sources. * Performs other special projects and duties as assigned by the AVP for Financial Planning. Experience/Qualifications: * Minimum three years with accounting/finance databases or information systems. Higher education administration experience highly desired. * Minimum of three years of experience in developing reports, dashboards, data visualizations, and scorecards using business intelligence and visualization software. * Demonstrated knowledge of databases and proficiency with SQL language * Experience in visualizing data to illustrate business intelligence goals * Demonstrated knowledge of accounting and financial planning software programs, such as Adaptive Insights and Workday. * Demonstrated knowledge of data science. * Significant experience in a leadership responsibility in finance, budget, or related function in a complex organization, preferably a college or university, is required. * Exemplary communication skills (both written and oral) evidenced by a background in preparing comprehensive reports and executive summaries incorporating complex, highly technical information. * Exemplary critical thinking and problem-solving skills. Attention to detail and commitment to exceptional work quality standards. * Demonstrated organizational, negotiation, and presentation skills. * Demonstrated computer competency. Required Education: * Typically a Bachelor's Degree or equivalent experience in accounting, management, or finance. The incumbent will be expected to continue upgrading the knowledge, skills, and abilities needed to keep abreast of regulation/policy changes. License/Certification/Registration Requirements: Physical Demands (if applicable) Special Instructions Exemption Status: Exempt Salary Grade Minimum: Salary Grade Midpoint: Posting Date 09/16/2020 Application Deadline Date: Loyola Marymount University Los Angeles CA

Business Intelligence / Data Advisor

Southern California Gas Company