The Cincinnati Insurance Companies' IT department is 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.
Requirements
- 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
Responsibilities
- 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
Other
- strive to continuously learn and hone your craft
- Work location and flexibility are subject to change based on evolving business needs
- it is mandatory for all IT associates to have cameras turned on for all interactions
- a bachelor's degree or have equivalent experience in computer science or related discipline.
- Providing outstanding service and developing strong relationships with our independent agents are hallmarks of our company.
