A Brief Overview We are seeking a motivated and eager-to-learn Data Engineer to join our dynamic team. This role offers a unique opportunity to work across multiple disciplines and directly with our IT team. Manage projects from inception to completion, ensuring all deliverables are met.

Develop, maintain, and optimize data pipelines that ingest, process, and transform data from various sources into usable formats for analysis.

Strong team player Must have experience with SQL and Python   **Candidates must have valid authorization to work in the US. Visa sponsorship is unavailable.  

This role is eligible to participate in Zenith’s hybrid work schedule which provides the flexibility to work from home on select days of the week according to the in-office schedule established by regional executive leadership. Selected candidate must be able to report into the Woodland Hills, CA office on a weekly basis.

 

The essential responsibilities of this position include, but are not limited to, the following:

Understand general assignments and work independently for the entire sprint. Solve complex problems and utilize standard problem-solving techniques (e.g. brainstorming). Communicate and document technical aspects of work in a manner that is easily understood and actionable by peers. Articulate thoughts/design/idea/specs to IT managers and product owners. Apply principles of logical thinking to define problems, collect data, establish facts, and draw valid conclusions. Utilize Python to build data processing applications, automate tasks, and implement data transformations. Design and manage relational databases, ensuring data integrity and performance. Proficiency in SQL is essential for this role. Lead efforts to modernize and optimize existing ETL pipelines for improved performance, scalability, and maintainability. Collaborate with data analysts to create and maintain data models that support business reporting and analytics. Maintain comprehensive documentation of data pipelines, databases, and processes for knowledge sharing and troubleshooting. Develop comprehensive unit and integration tests for data pipelines and ETL processes to ensure robustness and data quality. Perform other duties/projects as assigned.

Education, Skills, and Requirements

2-3 Years related experience required. Minimum 1-3 year's experience as a Data Engineer, with a focus on Python, SQL, and relational databases. Independently work and deliver on an assignment in an Agile team environment Bachelor’s Degree Or equivalent combination of training/experience required. Strong SQL skills and experience with database design and optimization. Proficiency in Python programming Familiarity with Linux and shell scripting. Well-versed in modern development practices (Git, CI/CD). Cloud and AI experience is a plus. Strong analytical and problems solving skills. Excellent written and verbal communication skills. Collaborative Team player, self-starter, motivated, and multi-task oriented. Ability to prioritize work requirements. Good interpersonal and communication skills. Work with other departments and other groups within IT to resolve issues

 The expected salary range for this position is $87,896 to $109,870. Actual pay will be adjusted based on experience, geographic location, and other job-related factors as permitted by law. Qualifications may warrant placement in a different job level.

Benefits

• Medical, Dental and Vision Insurance
• Flexible Spending Accounts
• Paid Parental Leave
• Life, AD&D and Disability Insurance
• 401(k), Employee Share Purchase Plan (ESPP)
• Education and Training Reimbursement
• Paid Leave: 3 weeks/year Vacation, 2 weeks/year Sick Leave
• 10 paid Company Holidays, 2 Personal Days, 2 Floating Holidays
• Employee Assistance Program (EAP)
• For more information, review details on the Benefits page of our Career Site: https://www.thezenith.com/careers/benefits/

Zenith typically posts jobs for a minimum of 8 to 14 calendar days. If you are interested in any of our open positions, we encourage you to submit your application promptly.

Zenith Insurance Company is an equal opportunity employer and considers all qualified applicants for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other legally protected characteristic. In compliance with California law, we are committed to fair hiring practices. Pursuant to the California Fair Chance Act (AB 1008), we will consider qualified applicants with criminal histories in a manner consistent with the law. Additionally, in accordance with the Los Angeles Fair Chance Initiative for Hiring Ordinance, we will not inquire about an applicant’s criminal history until after a conditional offer of employment has been made.

If you are a qualified individual with a disability or a disabled veteran and need assistance accessing our career center or applying for a position due to your disability, you are entitled to request an accommodation. To make a request, please contact a Human resources representative at Zenith Insurance Company.

#LI-EF1
#LI-Hybrid