Python/ SQL Data Engineer

Company: Zenith Insurance Company
Location: Los Angeles
Posted on: February 1, 2025

Job Description:

Woodland Hills CorpWoodland Hills Corp21255 Califa StreetWoodland Hills, CA 91367, USAWe 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.Essential Responsibilities:

• 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.
• 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 problem-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.Salary and Benefits: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)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.
    #J-18808-Ljbffr

Keywords: Zenith Insurance Company, Los Angeles , Python/ SQL Data Engineer, IT / Software / Systems , Los Angeles, California