United Fire Group Business Intelligence Designer - Data Reporting in Cedar Rapids, Iowa


UFG offers you an award-winning workplace and a trustworthy, financially stable company. While we’ve always known our commitment to employees and financial stewardship, it is good to have others recognize our dedicated efforts. We've been named an Iowa Top Workplace by theDes Moines Registerfor four consecutive years, and included onForbes’“America’s Most Trustworthy Financial Companies” every year since 2014. Additionally, UFG is a super-regional property and casualty insurer rated “A” (Excellent) by A.M. Best Company.

UFG is looking to add a Business Intelligence Designer to our Data Reporting team.

The Business Intelligence Designer is responsible for full comprehension of UFG’s reporting systems and underlying databases/data infrastructure to ensure accurate, quality data is provided in our operational reports. They will also be responsible for creating technical specifications for each data query and report program in the system(s) as well as provide data modeling, flowcharts, and architecture diagrams for project teams to follow.



  • Analyze reporting processes/needs within UFG for inefficiencies, inadequacies, and/or redundancies, making recommendations for solutions/improvements that can be achieved and sustained via new technology or alternative uses of technology.

  • Document and evaluate required data and information needed for internal and external reporting.

  • Use business process modeling and data modeling to improve the flow of information through our organization.

  • Collaborate with database administrators, data scientists, and other data engineers to understand underlying database structures/tables, field definitions/uses, and data interrelations.

  • Collaborate with developers and subject matter experts to establish the technical vision and analyze tradeoffs between usability and performance needs.

  • Collaborate with Business Analysts, Project Managers, stakeholders, and IT teams to understand business needs and provide solution recommendations.

  • Define and write high-level and low-level design specifications for programmers and report writers. Should include, but is not limited to: all system inputs and outputs; all data sources, ranges of values, default values, and data format; all reporting calculations/algorithms.

  • Keep current in new technologies to stay current on new trends.

  • Other duties as assigned.


  • Four-year college degree in computer science, MIS, business administration, or related discipline

  • 5+ years of systems engineering, systems architecture/design experience

  • Demonstrated experience with reporting frameworks including IBM Cognos and SQL Server Reporting Services (SSRS).

  • Demonstrated experience with BI/information infrastructures including an Application Data Mart, Enterprise Data Warehouse (EDW), ETL, and/or others.

  • Demonstrated experience with data query programming such as SQL, DML, DQL, and/or others.

  • Demonstrated experience in writing technical requirements and/or design specifications.

  • Demonstrated experience in system/software architecture diagramming.

  • Strong knowledge and experience with data modeling and data visualization tools such as Visio.

  • Ability to work well with business leaders, project team members, vendors, application developers, and DBAs/data engineers.

  • Exceptional interpersonal skills; the ability to work well with people from many disciplines and with varying degrees of business and technical experience.

  • Ability to express complex technical concepts effectively, both verbally and in writing, to diverse groups of people.

  • Strong leadership, facilitation, negotiation, and analysis skills.

  • Adaptability and flexibility including ability to manage multiple priorities and work under deadlines.

  • 3+ years of insurance experience is desired

  • Insurance coursework or designations, which include AINS, API, AU, AIT, or CPCU, are desired.

Sorry the Share function is not working properly at this moment. Please refresh the page and try again later.

Connect With Us!

Not ready to apply?for general consideration.

Job ID2018-1822

of Openings1

Job LocationsUS-IA-Cedar Rapids

CategoryProject Management Office


Company Car Provided?No