FairfieldOHRecruiter Since 2001
the smart solution for Fairfield jobs

IT - Data Engineer I -IV - 100% Remote

Company: Cincinnati Insurance Company, Inc.
Location: Fairfield
Posted on: October 12, 2021

Job 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 an experienced data engineer to build data pipelines that provide peace of mind for people by equipping them to make data-informed business decisions.

Be Ready To\:

  • develop reliable, reusable, automated and streamlined ETL code
  • design and develop BI data marts, reports and dashboards
  • create reconciliation procedures and data checks to ensure data quality
  • build in automated audit, balancing and controls 
  • provide production support, including on-call rotation and technical assistance to end-user and IT staff
  • lead user requirements gathering and documentation designs
  • proactively conduct data investigations and assist business partners with complex data analysis and ad-hoc queries
  • lead application and technical architecture analysis, design and implementation, and ensure BI product fulfills requirements
  • develop BI application products and deliverables throughout development life cycle, including model prototype design in Framework Manager and other design and development activities with the Cognos toolset at an expert level
  • lead efforts with Data Management and database specialists to troubleshoot and report issues
  • design new reporting applications to ensure reporting requests can be supported by the underlying data source
  • adhere to all metadata management and data quality standards by leading quality management reviews
  • expertly understand configuration dependencies and interrelationships between Cognos and other data warehouse and business intelligence tools and designs; troubleshoot in the area with this knowledge
  • provide alternatives based on best practices for business intelligence and Cognos toolset functionality leading conversion of legacy artifacts
  • proactively identify, build and maintain relationships with business process owners and colleagues
  • identify changes in scope or work effort that could result in budgetary overrun or missing of delivery date, design and implement contingency
  • demonstrate expert problem solving capabilities                                                                                                                                                                                                                                                                                                                                                                        

Be Equipped With\:

  • expert-level expertise with SQL, Data Modeling and Dimensional Modeling

  • proven experience distilling business requirements into data warehouse design artifacts such as a Facts Qualifier Matrix (FQM), source to target maps and star/snowflake schema data models

  • experience with Test Driven Development (TDD)

  • experience in\: designing and implementing ETL processes (preferred tools\:  IBM's DataStage, SQLSvr SSRS, SAS); developing BI dashboards (preferred tools\:  IBM's Cognos, Microsoft's Power BI); creating data quality scorecards and data lineage

  • experience leading agile teams

  • mentor development team members in design and development of BI solutions

  • strong team working skills, an analytical nature, self-motivated and excellent written and oral communication skills

  • ability to comprehend complex technical and logical concepts and adapt quickly to changes

  • ability to maintain own workflow and meet deadlines while managing parallel project deliverables with minimal direction

  • ability to create effective visual models to enable collective understanding of processes, data flow, user interaction and others as needed

  • prior reporting application support experience

  • track record of successfully architecting small, medium and enterprise-scale solutions

  • preferred three or more years of business requirements experience

  • preferred three or more years of hands-on experience developing and supporting a BI/reporting application like Cognos, Hyperion, Business Objects 

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 






Many departments at our Headquarters in Fairfield, Ohio, offer hybrid work options, empowering associates to work from home several days a week. Depending on your IT role and responsibilities, hybrid and fully remote options are available.  


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. 

Learn more about the Federal Employment Notices

Keywords: Cincinnati Insurance Company, Inc., Fairfield , IT - Data Engineer I -IV - 100% Remote, Other , Fairfield, Ohio

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Log In or Create An Account

Get the latest Ohio jobs by following @recnetOH on Twitter!

Fairfield RSS job feeds