Career Opportunities

Career Opportunities

Current Openings

Whether you are a recent college graduate or an experienced industry professional, we’re confident that you’ll find your desired career path within UFG. So, take the next step and apply for a position today.

UFG @ Work

Watch our video series to learn about the different career paths at UFG

Business Intelligence Designer - Data Reporting

US-IA-Cedar Rapids
Project Management Office


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.

UFG Career Opportunities

Connect With Us

Join our talent network and receive UFG job alerts

If we don’t currently have any job openings that interest you or match your skill set, we encourage you to connect with us to receive updates on job openings and recruiting events at UFG.

Equal Opportunity Employer

UFG is an equal opportunity employer. All qualified applicants will receive consideration and will not be discriminated against on the basis of race, gender, sexual orientation, gender identity, disability, protected veteran or any other protected status. If you need a reasonable accommodation for any part of the employment process, please email to provide the nature of your request. Only inquires for an accommodation will be responded to. For more information on rights protecting job applicants, click here: Equal Employment Opportunity (EEO), Employee Polygraph Protection Act (EPPA), Family and Medical Leave Act (FMLA).

To maintain integrity in our hiring process, UFG voluntarily participates in E-Verify. Click here for more information: E-Verify (English) E-Verify (Español)