Data Engineer

About the Role The San Diego Community Power (SDCP) is seeking a seasoned Data Engineer to join our growing team of analytics experts who will be responsible for designing, maintaining, expanding, and optimizing our data infrastructure for data collection, management, transformation, and access. A key priority of this role will be to assist in SDCP’s development of centralizing its data eco‑system to allow for the creation of pipelines that convert raw data into usable formats for data analysts and other data consumers to utilize. The Data Engineer will handle the core data aspects of software engineering and data science and will utilize software engineering principles to develop algorithms that automate the data flow process. They will collaborate with data and system analysts to build machine learning and analytics infrastructure from testing to deployment. Equal Employment Opportunity At SDCP, we value diversity and are committed to creating an inclusive environment for all employees. We provide equal employment opportunities to all applicants for employment and prohibit discrimination and harassment of any type without regard to race, color, religion, age, sex, national origin, disability status genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws. Responsibilities Building and maintaining a centralized cloud‑based data infrastructure for optimal extraction, transformation, and loading of data from a wide variety of sources. Assembling large, complex data sets that meet functional/non‑functional business requirements. Developing data tools and APIs for data analysis. Deploying and monitoring machine learning algorithms and statistical methods in production environments to solve organizational needs. Ensuring data accessibility and security and implementing company data policies regarding data privacy and confidentiality. Improving data systems reliability, speed, and performance. Building analytics tools that utilize the data pipeline to provide actionable insights into customer trends, operational efficiency, and other key business performance metrics. Collaborating with other internal teams, data analysts, and stakeholders to understand and optimize how data can be leveraged to meet business needs. Assisting in drafting data and analytics solicitations and in the selection of consultants. Assisting with drafting staff reports and presentations for Board and Committee meetings. Performing other related duties and responsibilities as required. Qualifications Advanced working knowledge of SQL, experience working with relational databases and query authoring. Demonstrated experience in developing APIs and integrations to support analytics in a cloud environment. Experience building and optimizing big‑data pipelines, architectures, and data sets. Experience performing root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement. Strong analytic skills related to working with unstructured datasets. Ability to build processes supporting data transformation, data structures, metadata, dependency, and workload management. A successful history of manipulating, processing, and extracting value from large, disconnected datasets. Working knowledge of message queuing, stream processing, and highly scalable big‑data data stores. Good understanding of data architecture, data design, data warehousing and data modeling concepts. Strong project management and organizational skills. Experience supporting and working with cross‑functional teams in a dynamic environment. Preferred Qualifications Experience in the energy sector and/or supporting the implementation of programs funded by California state agencies (e.g., California Public Utilities Commission, California Energy Commission, California Air Resources Board). Ability to strongly represent the organization in various professional engagement settings from local to national convenings (conferences, workshops, executive meetings, etc.). Minimum of two to three years of professional experience in a Data Engineer role, preferably in the energy industry with a graduate degree in Computer Science, Statistics, Informatics, Information Systems, or another quantitative field. Experience with big‑data tools: Hadoop, Spark, PowerBI, Kafka, etc. Experience with AWS, Azure, and Google Cloud services. Experience with relational SQL and NoSQL databases. Experience with data pipeline and workflow management tools: Azkaban, Luigi, Airflow, etc. Experience with open‑source technologies: Python, Pytorch, Flask, Tensorflow or Keras. Experience with stream‑processing systems: Storm, Spark‑Streaming, etc. Experience with object‑oriented/object‑function scripting languages: Java, C++ etc. Experience with batch, micro‑batching and real‑time data ingestion methodologies. Experience with GitHub or similar code repositories. Work Environment & Conditions Prolonged periods sitting at a desk and working on a computer. The position requires occasional carrying, lifting and/or moving objects up to 25 pounds. Occasional local travel required and reliable transportation is expected to attend SDCP events, meetings, and workshops as needed. SDCP works in the communities it serves and in the office. SDCP ensures a safe and healthy workplace for employees. SDCP requires employees to be fully vaccinated for COVID‑19. SDCP is an agency required to adopt and promulgate a Conflict‑of‑Interest Code (“COI”). The COI code requires employees in designated positions, including those identified under the interim disclosure process, to file a Statement of Economic Interests (Form 700) annually. A successful candidate accepting this position may be required to file Conflict of Interest forms subject to regulations of the Fair Political Practices Commission. #J-18808-Ljbffr