{{jcity}}{{jstate}}
24-70556
Alternate Posting Locations
Job Title
Job Description
About Us
At SoCalGas, we believe that every Californian deserves a resilient energy future. We are working to achieve that future by empowering California to reach its sustainability goals through innovation, collaboration, and decarbonization. As our state’s energy needs change, we will be there providing reliable energy that is clean, safe, and affordable to our 22 million customers.
In addition to helping shape the future of hydrogen technology and clean energy, as an employee of SoCalGas you’ll also enjoy an aggressive total compensation plan, multiple upward mobility opportunities and the ability to find a true work-life balance. We also strive to reflect the communities we serve by attracting top talent and maintaining a diverse workforce. To discover more about how rewarding it is to work here, we invite you to visit these pages on our website: Our Mission, Diversity, Equity and Inclusion, Sustainability, In the Community, and Employee Benefits. Join SoCalGas today to share in our mission to build the cleanest, safest, and most innovative energy company in America!
Primary Purpose
Acts in a lead role in the design, development, implementation, maintenance, and enhancement of full cycle of data services – integration/transport, processing and/or visualization – and associated systems to support the analytics needs of data/business analysts or data scientists. Consults with and provides technical guidance to business partners, IT peer teams, regarding data requirements, design, processes and technical solutions. Leads analytics project workstreams and/or smaller integration or visualization projects. Works with multiple business subject areas/data domains, and applies expertise in multiple technology stacks and data services capabilities (integration, storage/processing, visualization).
Duties and Responsibilities
- Lead efforts to design, build, maintain, and troubleshoot data pipelines and processing systems to analytics applications. Lead small data analytics projects or initiatives. Manage the data catalog, metadata repository and any associated data management efforts. Work with vendor partners and/or coach junior IT staff to ensure data analytics solutions are designed and developed in a way that complies with architectural standards and established methodologies and practices.
- Solution development and support; Compile data requirements, perform data analysis and logical data modeling, define data and object elements. Build and scale data ingestion and transformation processes, to include batch (ETL, ELT), streaming, and/or virtualization. Build datasets, tools and documentation to enable analysts in all parts of the company to build their own analytics and reports. Design, build and implement applications to visualize performance data to enable actionable operational improvements. Provide after-hours support on a rotation basis.
- Collaboration/Continuous Improvement: Expand and continuously improve knowledge of business subject areas/data domain. Monitor and report to management on the status of project efforts, anticipating and identifying issues that inhibit the attainment of project goals and implementing corrective actions. Identify, design, and implement internal process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc. Lead and/or participate with IT staff, business/vendor partners, and other stakeholders in new product reviews, tests, and pilots. Foster and maintain good relationships with business partners, IT colleagues and vendor partners. Develop business knowledge and relationships to integrate activities with other IT departments to ensure successful implementation and support project efforts.
- Performs other duties as assigned (no more than 5% of duties).
Salary: $109,500 - $164,300 / year
Work Schedule: HYBRID: Work a combination of onsite and remote days each week, typically 2-3 days per week.
Qualifications
Education
- Requires a Bachelor's Degree in Computer Science, Information Systems, Statistics or another quantitative field, or equivalent experience.
Experience
- Requires 6+ years of professional experience as a data engineer or equivalent.
- Experience building and optimizing ‘big data’ pipelines, architectures and data sets.
- Experience with Object-oriented programming or scripting languages desired (e.g., Python, SQL).
- Experience working in an agile/scrum environment.
- Proven experience acting as a technical lead with ability to mentor and lead data engineers.
- Experience dealing with competing priorities in a fast-paced environment.
- Proven track record of translating technical objectives into engineering reality.
Knowledge, Skills and Abilities
- Expertise in several toolsets required such as big data tools: AWS Services, Athena, Quick sight, Hadoop, Spark, and Kafka.
- Proficient knowledge of data modeling, data architecture, data security and data governance practices.
- Working knowledge of Python, SQL and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases tools.
- Fundamental technical knowledge of infrastructure concepts, including configuration setup on servers, routers, switches, firewalls etc.
- Knowledge of Data Virtualization tools such as PowerBI, Business Objects, SAP Analytics Cloud, Cloud Services and Metadata Management tools.
- Strong analytic skills related to working with structured and unstructured datasets.
- Solid teamwork and interpersonal skills; ability to work well on cross-functional project teams and with vendor partners.
- Self-directed and comfortable supporting the data needs of multiple teams, systems and products.
- Strong verbal and written communications skills, with an ability to express complex technical concepts in business terms.
- Strong attention to detail with excellent analytical, problem-solving, and communication skills.
- Strong project management and organizational skills desired, operating as part of a team scoping, organizing, planning, and executing projects from the envisioning stage through implementation.
- Strong organizational and mentoring skills with experience in leading projects.
SoCalGas offers a comprehensive benefits program to help support employees both personally and professionally. These benefits include, but are not limited to:
- Medical, dental, and vision packages (plus free Mental Health resources/sessions)
- 401K company match & Company provided Pension Plan
- Wellness Programs/Classes
- Tuition/Education Reimbursement
- Career Development Tools & Resources through SoCalGas University