IT - Developer I - V (Remote)

Cincinnati Financial

18h•Remote

About The Position

Our IT Business Intelligence & Automation team seeks curious individuals who embrace uncertainty, take risks, and learn quickly from experiences. Professionals who demonstrate respect and humility, value collaboration and believe better solutions come from working together may be a great fit for our team. To ensure active engagement, all associates are expected to appear on camera during virtual meetings with other associates, customers and stakeholders. This practice is important for maintaining connection, as non-verbal cues are essential for effective communication and building relationships. 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.

Requirements

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

Nice To Haves

proven experience in designing and implementing ELT processes (preferred tools: dbt, SQL, Jinja, Python)
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
two or more years of experience with SQL, data modeling, and dimensional modeling
experience with modern cloud data platforms and technologies, including Azure, Snowflake, and dbt
experience designing, developing, and supporting business intelligence dashboards and reports using Microsoft Power BI, including data quality scorecards, KPI reporting, and data lineage
experience supporting data, analytics, or reporting solutions for regulatory, financial, operational, or compliance reporting requirements
experience working within Agile teams and delivery methodologies

Responsibilities

develop reliable, reusable, automated and streamlined ELT code
analyze and organize raw data from multiple sources to produce requested or required data elements
design table structures and ELT to build performant data solutions that are scalable in a fast-growing data ecosystem
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
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
understand configuration dependencies and interrelationships between data warehouse and business intelligence tools and designs; troubleshoot in the area with this knowledge
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
mentor development team members in design and development of BI solutions