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


Sr. ETL Developer

:
2019-1977
:
1
:
US-IA-Cedar Rapids
:
3/20/2019
:
Information Technology
:
None
No
 
 

Overview:

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.

 

The Senior ETL Developer is responsible for leading technical design and development, aligning technical solutions with business design & Data Architect’s standards. 

 

INDHP

Responsibilities:
  • Work closely with Data Architect to understand the existing structure and recommend improvements based upon performance issues and data profiling.
  • Develop the data warehouse design to seamlessly accommodate both legacy and new policy and billing data
  • Work closely with Lead DBA to identify and implement performance tuning opportunities
  • Identify and execute the change data capture for each source object
  • Execute and test initial and delta loads
  • Extract, transform and load data from legacy systems into BI applications and end user data marts
  • Monitor and profile the ETL process for performance
  • Resolves conflicts and ensures technical deliverables are on track
  • Ensures technical tasks and risks are defined and incorporated into project plan

Qualifications:

Education:

  • Four year degree in Computer Science, Information Systems or related field preferred

Experience:

  • 5+ years of experience with ETL Development and data warehousing including:
    • Extracting, transforming, and loading data using SSIS and T-SQL
    • Experience with front end reporting tools such as Tableau and Cognos
    • Experience with data cleansing and masking routines
    • Developing end user interfaces to the warehouse and writing technical documentation
    • SQL query optimization
    • Powershell
  • Experience with SAP/Elixir/BODS is a plus.

Knowledge, skills & abilities:

  • Advanced knowledge of data warehousing processes, procedures and design concepts
  • In depth knowledge of ETL tools, concepts, and optimization
  • Advanced Microsoft SQL Server knowledge including the creations of complex SSIS packages, T-SQL scripting, and advanced process profiling and query optimization
  • Understanding of OLAP vs OLTP data processing
  • Expertise related to data management, modeling, scripting, data model rationalization and database products
  • Effective communication skills both written and verbal
  • Effective analytical, negotiation and problem solving skills
  • Proven team player


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 humanresource@unitedfiregroup.com 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)