HR Information Systems Senior Advisor- SQL Expert with Power Bi Skills hybrid

3 weeks ago


Rosemead, California, United States Southern California Edison Full time

Become an HR Information Systems Senior Advisor at Southern California Edison (SCE) and build a better tomorrow. In this job you will be part of the People Operations, Workforce Analytics Team, reporting to the Manager of Workforce Analytics. You will support HR's journey to the Cloud, Digital Transformation and the overall optimization of SCE's HR Technology solutions. If you are passionate about leveraging data to drive strategic decision-making and make a meaningful impact on organizational performance, we invite you to join our dynamic team. As an SQL Expert with PowerBI skills in the Human Resources Workforce Analytics department, you will have the opportunity to innovate with technology, and contribute to the success of our organization.

As an HR Information Systems Senior Advisor, your work will help power our planet, reduce carbon emissions and create cleaner air for everyone. Are you ready to take on the challenge to help us build the future?

A day in the life - Get ready to think big, work smart and shine bright

  • Develop and maintain complex SQL queries to extract, manipulate, and analyze HR data from various sources, including HRIS systems, databases, and external sources.
  • Design, develop, and optimize reports and dashboards using PowerBI to visualize key HR metrics, trends
  • Conduct data validation, quality assurance, and performance tuning to ensure accuracy, reliability, and efficiency of HR data analysis and reporting processes.
  • Stay abreast of industry trends, best practices, and emerging technologies in SQL, PowerBI, and HR analytics to continuously enhance data capabilities and drive innovation in workforce analytics.
  • Maintain data models, ETL processes, dashboards, reports, and visualizations to ensure accuracy, reliability, and scalability of HR analytics solutions.
  • Identify important insights, trends, and patterns within HR data sets, deriving actionable recommendations to improve HR operations and drive strategic initiatives.
  • Code and develop PowerBI dashboards and SQL views to provide robust data visualization and analytical capabilities to support all of HR.
  • Collaborate with HR stakeholders to identify data needs and requirements, including understanding their challenges, objectives, and constraints, to deliver tailored analytical solutions.

The essentials

  • Ten or more years of experience designing, configuring, implementing, and managing analytics using Power BI and SQL server.

The preferred

  • Bachelors degree or higher in computer science, artificial intelligence, statistics, mathematics, or related fields.
  • Three or more years of experience in HR analytics.
  • Certification in Power BI and SQL.
  • Experience working in Human Resources department for fortune 500 company.
  • High-level understanding of third party integrations with HRIS applications.
  • Experience project managing moderate to complex projects on time and within budget.
  • Strong verbal and written communication skills, with the ability to distill complex information into clear, concise content
  • Interpersonal communication skills including the ability to deal with all levels of senior leadership.
Read the full posting.

  • Rosemead, California, United States Southern California Edison Full time

    Job DescriptionJoin the Clean Energy RevolutionBecome a Senior HR Business Partner at Southern California Edison (SCE) and build a better tomorrow. In this job, you will be the primary HR resource to an assigned set of Operating Units (OUs) providing thought leadership, guidance, and support to executives, leaders, and employees at all levels of the...


  • Rosemead, California, United States Southern California Edison Full time

    Job DescriptionJoin the Clean Energy RevolutionBecome an IT Systems Quality, Senior Advisor at Southern California Edison (SCE) and build a better tomorrow. In this job, you'll be responsible for aligning Southern California Edison's (SCE) business mission, strategy, and process to the IT landscape by establishing Products, Platforms, Services, Tools, or...


  • Rosemead, California, United States Southern California Edison Full time

    Job DescriptionJoin the Clean Energy RevolutionBecome an IT Systems Quality, Senior Advisor at Southern California Edison (SCE) and build a better tomorrow. In this job, you'll be responsible for aligning Southern California Edison's (SCE) business mission, strategy, and process to the IT landscape by establishing Products, Platforms, Services, Tools, or...


  • Rosemead, California, United States Southern California Edison Full time

    Job DescriptionJoin the Clean Energy RevolutionBecome a Supply Chain Senior Advisor at Southern California Edison (SCE) and build a better tomorrow. In this role you will be responsible for providing high-level counsel on complex policy issues, strategic planning, and implementation of programs including supplier management, qualification, and risk. The...


  • Rosemead, California, United States Southern California Edison Full time

    Job DescriptionJoin the Clean Energy RevolutionBecome a Supply Chain Senior Advisor at Southern California Edison (SCE) and build a better tomorrow. In this role you will be responsible for providing high-level counsel on complex policy issues, strategic planning, and implementation of programs including supplier management, qualification, and risk. The...


  • Rosemead, California, United States Southern California Edison Full time

    Become a Senior Advisor of Grid Technology Projects at Southern California Edison (SCE) and build a better tomorrow. The Operations Strategy, Reliability, and Performance Management (OSRPM) team integrates operational improvements, operations coordination, business services, outage validations, and the integration and business process ownership of new...


  • Rosemead, California, United States Southern California Edison Full time

    Job DescriptionJoin the Clean Energy RevolutionBecome an Energy Trading Senior Advisor at Southern California Edison (SCE) and build a better tomorrow. This position resides in the Trading and Market Operations (TMO) department within the Energy Procurement & Management (EPM) organization which manages SCE's $5 billion/year energy resource portfolio. In this...


  • Rosemead, California, United States Southern California Edison Full time

    Job DescriptionJoin the Clean Energy RevolutionBecome an Energy Trading Senior Advisor at Southern California Edison (SCE) and build a better tomorrow. This position resides in the Trading and Market Operations (TMO) department within the Energy Procurement & Management (EPM) organization which manages SCE's $5 billion/year energy resource portfolio. In this...


  • Rosemead, California, United States Southern California Edison Full time

    Job ID: Become an Energy Trading Senior Advisor at Southern California Edison (SCE) and build a better tomorrow. This position resides in the Trading and Market Operations (TMO) department within the Energy Procurement & Management (EPM) organization which manages SCE's $5 billion/year energy resource portfolio. In this job, you will lead the development,...


  • Rosemead, California, United States Southern California Edison Full time

    Job ID: Become an Energy Trading Senior Advisor at Southern California Edison (SCE) and build a better tomorrow. This position resides in the Trading and Market Operations (TMO) department within the Energy Procurement & Management (EPM) organization which manages SCE's $5 billion/year energy resource portfolio. In this job, you will lead the development,...


  • Rosemead, California, United States Southern California Edison Full time

    Job DescriptionJoin the Clean Energy RevolutionBecome a Senior Advisor, Employee Engagement and Process Improvement at Southern California Edison (SCE) and build a better tomorrow. In this job, you'll lead our employee engagement, lifecycle, and process improvement initiatives. 50% of the focus will be on employee engagement-related programs and the other...


  • Rosemead, California, United States Southern California Edison Full time

    Job DescriptionJoin the Clean Energy RevolutionBecome a Senior Advisor, Employee Engagement and Process Improvement at Southern California Edison (SCE) and build a better tomorrow. In this job, you'll lead our employee engagement, lifecycle, and process improvement initiatives. 50% of the focus will be on employee engagement-related programs and the other...


  • Rosemead, California, United States Southern California Edison Full time

    Job DescriptionJoin the Clean Energy RevolutionBecome a Senior Advisor, Corporate Philanthropy at Southern California Edison (SCE) and build a better tomorrow. In this job, you'll responsible for developing the strategic and programmatic needs related to the company's environmental and public safety grant portfolios, with a combined value of approximately $8...


  • Rosemead, California, United States Southern California Edison Full time

    Job DescriptionJoin the Clean Energy RevolutionBecome a Senior Advisor, Corporate Philanthropy at Southern California Edison (SCE) and build a better tomorrow. In this job, you'll responsible for developing the strategic and programmatic needs related to the company's environmental and public safety grant portfolios, with a combined value of approximately $8...


  • Rosemead, California, United States Southern California Edison Full time

    Job DescriptionJoin the Clean Energy RevolutionAre you looking to make a difference in your career? We're working on smarter grids, cleaner energy and tools to help people manage energy more efficiently.The Supply Chain Advisor leads moderately to highly complex projects to onboard suppliers and implement enhancements into SCE's SAP Ariba and Fieldglass...


  • Rosemead, California, United States Southern California Edison Full time

    Job DescriptionJoin the Clean Energy RevolutionAre you looking to make a difference in your career? We're working on smarter grids, cleaner energy and tools to help people manage energy more efficiently.The Supply Chain Advisor leads moderately to highly complex projects to onboard suppliers and implement enhancements into SCE's SAP Ariba and Fieldglass...


  • Rosemead, California, United States Southern California Edison Full time

    Job DescriptionJoin the Clean Energy RevolutionBecome a Data Analytics Advisor- Digital & Process Transformation at Southern California Edison (SCE) and build a better tomorrow. In this job, you'll be responsible for handling the Advanced Analytics portfolio in the Digital & Process Transformation department in IT, with direct responsibility for analytics...


  • Rosemead, California, United States Southern California Edison Full time

    Job DescriptionJoin the Clean Energy RevolutionBecome a Data Analytics Advisor- Digital & Process Transformation at Southern California Edison (SCE) and build a better tomorrow. In this job, you'll be responsible for handling the Advanced Analytics portfolio in the Digital & Process Transformation department in IT, with direct responsibility for analytics...


  • Rosemead, California, United States Southern California Edison Full time

    Job ID: Become an Aviation Safety Officer, Senior Advisor at Southern California Edison (SCE) and build a better tomorrow. In this job, you will manage and facilitate the Safety Management System (SMS) in SCE's utility aviation environment. As an Aviation Risk Management and Quality Assurance Senior Advisor, your work will help power our planet, reduce...


  • Rosemead, California, United States Southern California Edison Full time

    Job ID: Become an Aviation Safety Officer, Senior Advisor at Southern California Edison (SCE) and build a better tomorrow. In this job, you will manage and facilitate the Safety Management System (SMS) in SCE's utility aviation environment. As an Aviation Risk Management and Quality Assurance Senior Advisor, your work will help power our planet, reduce...