$Not specified
The IT department is seeking an experienced BI developer to build data pipelines that support data-informed business decisions. Responsibilities include developing ETL code, designing BI data marts, and providing production support.
Candidates should have proven experience in data warehouse design and expertise in SQL and data modeling. A bachelor's degree or equivalent experience in computer science or a related discipline is required.
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 our communities 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 continue to grow. Build your future with us Our IT department is currently seeking an experienced BI developer to build data pipelines that provide peace of mind for people by equipping them to make data-informed business decisions. Work location and flexibility are subject to change based on evolving business needs, but generally, selected candidates who reside: within 50 miles of Headquarters may be expected to work in a hybrid capacity, combining remote and onsite work when business needs necessitate. more than 50 miles from Headquarters must be flexible and available to travel to Fairfield, OH, on an occasional basis for special events, training sessions, or key meetings. To ensure active engagement in meetings, it is mandatory for all IT associates to have cameras turned on for all interactions with other associates, customers, and stakeholders. Your camera must be on and positioned correctly to clearly show your face. This practice is crucial for maintaining connection and engagement, as non-verbal cues are essential for effective communication. Be ready to: strive to continuously learn and hone your craft listen to business needs and design data models that support business outcomes develop reliable, reusable, automated and streamlined ETL code design and develop BI data marts, reports and dashboards teach teammates so that we all learn and grow together 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 Be equipped with: 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 experience with Test Driven Development (TDD) expert-level expertise with SQL, Data Modeling and Dimensional Modeling experience in: designing and implementing ETL processes (preferred tools: IBM's DataStage, SQLSvr SSAS, SAS); developing BI dashboards (preferred tools: IBM's Cognos, Microsoft's Power BI); creating data quality scorecards and data lineage; mentoring and teaching teammates; leading within the Kanban/ Agile space Bring education or experience from: 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. Learn more about the Federal Employment Notices.
This job posting was last updated on 10/7/2025