Southern California Edison Data Visualization Engineering, Specialist [HYBRID] in Rosemead, California
Join the Clean Energy Revolution
Become a Data Visualization Engineering, Specialist at Southern California Edison (SCE) and build a better tomorrow. In this job, you’ll be part of the Digital and Process Transformation team in IT and drive the evaluation, development, prototyping and implementing technology solutions in response to business needs and requirements. You'll support our Advanced Analytics Experts by crafting and developing data visualizations and dashboards using data sets from various sources.
You are a skilled in data and storytelling and in the use of business intelligence (BI) tools (ex. MS Power BI), often crafting user-friendly dashboards for business teams. You possess core data engineering skills to design and develop data collection from heterogeneous sources, normalizing and harmonizing data, transform and organize as necessary for data visualization supporting advanced analytics. We’re looking for talent that is not only accomplished in developing visualizations to tell a story and provide insights, but an experienced data pipeline builder and data wrangler who enjoys building data solutions from the ground up.
As a Data Visualization Engineering, Specialist , 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!
You will have a meaningful impact, providing input on recommendations and decisions based on financial or operational impact, including: 1) discovery processes with SCE collaborators to identify the business requirements; 2) modeling & framing business scenarios that impact critical business decisions; 3) assisting with strategic recommendations on standard methodologies; 4) contributing to the development of innovative and effective approaches to solve analytics problems; and 5) contributing to the ongoing tracking and monitoring of the performance of decision systems and statistical models.
You will support advanced analytics experts on sophisticated use cases and will ensure optimal visualization for insights. You will apply your understanding business requirements and use cases, developing data requirements, performing comprehensive data analysis, design and delivery of visualization solutions. This includes identification of enterprise data sources, data ingestion, normalize and harmonize data from disparate data sources, data mining and analysis, and developing data insights through visualization.
Use Case Understanding : Works with Data Scientists and SCE collaborators to understand the business problems, goals, and objectives of the data science use cases and in particular the associated data needed to design & develop data engineering and visualization solutions to provide optimal insights. Collaborates with others in IT and the business to test and validate to ensure understanding. Prepares reports and presentations to communicate understanding, approach and results as required.
Data Requirements and Design : Collaborate with a data scientist and a data engineer, define the data requirements including identifying what data is available and relevant from both internal and external data sources; leverage new data collection processes; Collaborate with information architects and Data Stewards/SME’s to select appropriate sources of information; Plan data acquisition/collection, preparation, integration, quality, transformation in preparation for exploration and analysis. Assist data scientists with validations and analysis of very large datasets; design, build and deploy data pipelines in collaboration with SCE data architects.
Data Preparation and Engineering : Collaborate with a data engineer, select and prepare data to be used for specific use cases. Perform acquisition, integration, cleansing, labeling, transformation, management, and manipulation of large and complex data sets to enable the visualization of data science use cases. Develop and complete data cleaning approaches. Detect and evaluate defects including missing & incorrect values, formatting issues, outliers, etc, and apply data treatments as needed.
Visualization Solution Development : Design, build and deploy data visualization solutions on large scale data sets. Explore, mine, and experiment with data to assist in answering critical business questions. Maintain data pipelines in support of use cases. Visualize data to facilitate insights and understanding.
Data Engineering and Visualization Methods : Stay on top of new and current data engineering, big data, data science and visualization techniques. Research methods, techniques, and new practices. Develop relationships with individuals at other utilities and participate in relevant industry forums and groups. Develop relationships with external data and analytics vendors and interact with as needed.
Three (3) or more years of hands-on experience in data visualization design, development and implementation of solutions
Three (3) or more years of experience in data engineering, data mining, large scale data acquisition, transformation, and cleaning both structured and unstructured data
Ability to handle multiple projects and workstreams
Communicate effectively (written and verbally) with analytics/data experts, business leaders, and management to assess opportunities and develop data driven solutions
Experience supporting and working with multi-functional teams in a dynamic environment.
Translate business objectives into data and analytics solutions using appropriate data engineering, analytics, visualization & dashboard applications.
Experience with business intelligence tools like MS Power BI, Tableau, SAS, etc.
Experience with cloud-based data pipeline and workflow management tools
Experience in data mining, large scale data acquisition, transformation, and cleaning both structured and unstructured data (Preferred)
Experience gathering data from different sources and formats (MS Excel, Access, Oracle, SQL, XML, etc.) and compiling it for the ease of analysis.
Knowledge and experience in building data solutions
Bachelor’s degree or higher in a quantitative subject area such as Statistics, Mathematics, Engineering, Computer Science, or Information Sciences(such as Business Analytics or Informatics) or a related field
Broad understanding of the electric utility industry and its regulatory environment.
Specialized understanding of one or more electric utility business areas such as Customer Services, Transmission & Distribution, Power Supply, Generation, system operations or planning.
Experience working with big data tools and data storage such as SAP HANA, Hadoop, Snowflake, etc.
Experience with cloud computing (ex. Azure, Google GCP, AWS)
Advanced SQL working knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases.
Experience performing root cause analysis on internal and external data and processes to answer specific business questions and find opportunities for improvement.
Strong analytic skills related to working with unstructured datasets.
Build processes supporting data transformation, data structures, metadata, dependency, and workload management.
Experience in manipulating, processing, and extracting value from large, disconnected datasets.
You should know
When a return-to-office date has been determined, this position’s work mode is hybrid. The employee will report to an SCE facility for a set number of days with the option to work remotely on the remaining days. Unless otherwise noted, employees are required to reside in the state of California. Further details of this work mode will be discussed at the interview stage.
Visit ourCandidate Resource (https://www.edisoncareers.com/page/show/Candidate-Resources) page get meaningful information related to benefits, perks, resources, testing information, and hiring process, and more!
This position requires testing and applicants who are identified to continue through the selection process will be invited to test via email. We invite you to visit our Candidate Resource page for further information and to access information guides. For information guides (https://www.edisoncareers.com/page/show/SCE-Pre-Employment-Study-guides) , please reference test #8203 (Edison Individual Contributor Workstyles Assessment). Candidates who have previously passed these assessment(s), in some cases, may not need to retest again for this position.
Relocation mayapply to this position.
About Southern California Edison
The people at SCE don't just keep the lights on. Our mission is so much bigger. We’re fueling the kind of innovation that’s changing an entire industry, and quite possibly the planet. Join us and create a future with cleaner energy, while providing our customers with the safety and reliability they demand. At SCE, you’ll have a chance to grow personally and professionally, making a real impact in Southern California and around the world.
At SCE, we celebrate our differences. We are a proud Equal Opportunity Employer and will not discriminate based on race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status or any other protected status.
We are committed to ensuring that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Please contact us to request accommodations at (833) 343-0727.