It - Etl/Datastage Developer Ii-Iv (Remote)

IT - ETL/Datastage Developer II-IV (Remote) - (2300594) US-Remote

Description

Make a difference with a career in insurance

At The Cincinnati Insurance Companies, we put people first and apply the Golden Rule to our daily operations. To put this into action, we’re looking for extraordinary people to join our talented team. Our service-oriented, ethical, knowledgeable, caring associates are the heart of our vision to be the best company serving independent agents. We help protect families and businesses as they work to prevent or recover from a loss. Share your talents to help us reach for continued success as we bring value to the communities we serve and demonstrate that Actions Speak Louder in Person®.

If you’re ready to build productive relationships, collaborate within a diverse team, embrace challenges and develop your skills, then Cincinnati may be the place for you. We offer career opportunities where you can contribute and grow.

Start your journey with us

Our IT department is currently seeking a developer to build data pipelines that provide peace of mind for people by equipping them to make data-informed business decisions.

Salary: The pay range for this position is $65,000- $132,000 annually. The pay determination is based on the applicant’s education, experience, location, knowledge, skills, and abilities. Eligible associates may also receive an annual cash bonus and stock incentives based on company and individual performance.

Be ready to:

• Strive to continuously learn and hone your craft
• Develop reliable, reusable, automated and streamlined ETL code
• Teach teammates so that we all learn and grow together
• Provide production support, including on-call rotation and technical assistance to end-user and IT staff
• Build in automated audit, balancing and controls
• Design and develop BI data marts, reports and dashboards
• Listen to business needs and design data models that support business outcomes
• Create reconciliation procedures and data checks to ensure data quality

Be equipped with:

• Experience in designing and implementing ETL processes (preferred tools: IBM's DataStage, SQLSvr); creating data quality scorecards and data lineage; mentoring and teaching teammates; leading within the Kanban/ Agile space
• Proven experience distilling business requirements into data warehouse design artifacts such as a Facts Qualifier Matrix (FQM), Source to Target Maps and ultimately star schema data models
• Expert-level expertise with SQL, Data Modeling and Dimensional Modeling

You’ve earned: a bachelor's degree or have equivalent experience in computer science or related discipline.

Enhance your talents

Providing outstanding service and developing strong relationships with our independent agents are hallmarks of our company. Whether you have experience from another carrier or you’re new to the insurance industry, we promote a lifelong learning approach. Cincinnati provides you with the tools and training to be successful and to become a trusted, respected insurance professional – all while enjoying a meaningful career.

Enjoy benefits and amenities

Your commitment to providing strong service, sharing best practices and creating solutions that impact lives is appreciated. To increase the well-being and satisfaction of our associates, we offer a variety of benefits and amenities. Learn more about our benefits and amenities packages.

Embrace a diverse team

As a relationship-based organization, we welcome and value a diverse workforce. We grant equal employment opportunity to all qualified persons without regard to race; creed; color; sex, including sexual orientation; religion; national origin; age; disability; or any other basis prohibited by law.