Kern Energy is hiring a Data Warehouse Engineer who will design, construct, install, and maintain scalable data management systems. Collaborating with the IT Architect, business analysts, and other stakeholders, the engineer will understand data requirements and implement solutions to support the organization's needs. This role is crucial for ensuring the availability, reliability, and performance of the data infrastructure. Additionally, the engineer will optimize the information flow within the company to ensure data is accessible and reliable for analysis. The ideal candidate will embody Kern’s core values: Teamwork, Safety, Excellence, Integrity, and Connection.
Job Function
- Design and implement robust, scalable, and efficient data pipelines and architectures.
-
Work closely with IT Architect, project champions, and end users to understand data requirements and translate them into technical specifications.
-
Develop and maintain data integration processes to collect, process, and transfer data between systems.
-
Implement ETL (Extract, Transform, Load) processes for efficient data movement.
-
Manage and optimize databases for performance, reliability, and scalability.
-
Implement and maintain database schemas, indexes, and queries.
-
Implement data quality standards and governance processes to ensure the accuracy and consistency of data.
-
Monitor and troubleshoot data issues, implementing corrective actions as needed.
-
Implement and maintain security protocols for data storage, transmission, and access.
-
Ensure compliance with data protection and privacy regulations.
-
Collaborate with cross-functional teams including data scientists, analysts, and business stakeholders to understand data requirements and deliver solutions.
-
Identify and implement optimizations to improve the performance of data processing and analytics.
-
Document data architecture, processes, and configurations for future reference and knowledge sharing.
Education/ Experience
- B.S. in Computer Science Engineering, Information Technology, or relevant degree
-
2+ years of proven experience as a Data Engineer or in a similar role.
- Background in data warehouse design and data mining, including an in-depth understanding of Relational database design, is preferred.