Python/ SQL Data Engineer

Zenith Insurance Company (United States) • Full-time • Los Angeles, CA, US • $87.90k - $109.87k / year • 4d ago

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.

Own 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 useable formats for analysis.
Strong team player
Must have experience with SQL and Python
Candidates must have valid authorization to work in the United States. Visa sponsorship, including for those on OPT, is not available at any time

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 / $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.