Python/ SQL Data Engineer

• 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 Zeniths hybrid work schedule which provides the flexibility to work from home on select days of the week according to the inoffice 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 problemsolving 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

• 23 Years related experience required.
• Minimum 13 years 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
• Bachelors 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.
• Wellversed 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 selfstarter motivated and multitask 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 $87896 / $109870. Actual pay will be adjusted based on experience geographic location and other jobrelated 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: 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 applicants 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.

#LIEF1
#LIhybrid