Business Intelligence Designer - Data Reporting

  • United Fire Group
  • Cedar Rapids, Iowa
  • Nov 22, 2018
General Business

Job Description

Job ID 2018-1822
# of Openings 1
Job Locations US-IA-Cedar Rapids
Posted Date 2018-08-15
Category Project Management Office
Travel None
Company Car Provided No


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 the Des Moines Register for four consecutive years, and included on Forbes' "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.