The Cincinnati Insurance Companies - IT Developer II IV (Remote)

Developer is needed in United States.

Client: The Cincinnati Insurance Companies

Location: United States

Contract: undefined

Job Description

Make a difference with a career in insurance at The Cincinnati Insurance Companies. We prioritize people and apply the Golden Rule in our operations, aiming to protect families and businesses. We are seeking extraordinary individuals to join our talented team as we work towards success and deliver value to our communities. The role is within the IT Business Intelligence & Data Management department, looking for an experienced Python, SQL, and DBT developer.

Work flexibility varies based on business needs. Candidates may need to work in a hybrid capacity if within 50 miles of Headquarters or may be required to travel to Fairfield, OH occasionally if located further away. It is mandatory for all IT associates to keep their cameras on during meetings for effective communication.

The starting pay for this position ranges from $70,000 to $140,000 annually, determined by the applicant’s qualifications and experience. Eligible associates may receive additional bonuses and stock incentives based on performance.

Requirements

Be ready to:

• Continuously learn and improve skills.
• Listen to business needs and design data models that support business outcomes.
• Develop reliable, reusable, automated ETL code.
• Teach teammates and encourage mutual growth.
• Create reconciliation procedures and data checks for data quality.
• Build in automated audit, balancing, and controls.
• Provide production support, including on-call rotation and technical assistance.

Be equipped with:

• Experience translating business requirements into data warehouse design artifacts (e.g., Facts Qualifier Matrix, Source to Target Maps, star schema data models).
• Experience with Test Driven Development (TDD).
• Expertise in SQL, Data Modeling, and Dimensional Modeling.
• Experience designing and implementing ETL processes (preferred tools: Python, DBT, Snowflake, Postgres, FiveTran).
• Mentoring and teaching teammates; leading within the Kanban/Agile space.

Bring education or experience from:

• A bachelor’s degree or equivalent experience in computer science or a related discipline.

Other Information

Cincinnati Insurance Companies values outstanding service and strong relationships with independent agents. We promote a lifelong learning approach providing tools and training to help you succeed and become a respected insurance professional while enjoying a meaningful career.

We are dedicated to inclusivity and welcome a diverse workforce. We are an equal opportunity employer, valuing diversity without regard to race, creed, color, sex, religion, national origin, age, disability, military service, or any other basis prohibited by law.