CedarRapidsRecruiter
the smart solution for Cedar Rapids jobs

Sr. ETL Developer

Company: United Fire Group
Location: Cedar Rapids
Posted on: April 14, 2019

Job Description:

Job ID 2019-1977# of Openings 1Job Locations US-IA-Cedar RapidsPosted Date 2019-03-20Category Information TechnologyTravel NoneCompany Car Provided NoOverview

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

            PI109139861

Keywords: United Fire Group, Cedar Rapids , Sr. ETL Developer, IT / Software / Systems , Cedar Rapids, Iowa

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other IT / Software / Systems Jobs


Technical Support Representative
Description: Position Overview: Provide world-class customer support for Employers ISP partners within a 24x7x365 environment. Answer inbound calls, chats, and emails in a professional manner that adheres to company (more...)
Company: SecurityCoverage
Location: Cedar Rapids
Posted on: 04/23/2019

Junior Software Engineer
Description: Employer is the fastest growing employer of emerging technology talent in the US and we are currently looking to hire over 100 new Software Engineers.Our Software Engineers design, analyze and build next-gen (more...)
Company: Revature
Location: Cedar Rapids
Posted on: 04/22/2019

Junior C++ Developer
Description: Revature is the fastest growing employer of emerging technology talent in the US and we are currently looking to hire over 100 new Software Engineers. Our Software Engineers design, analyze and build (more...)
Company: Revature
Location: Cedar Rapids
Posted on: 04/22/2019


LINUX Administrator
Description: Job Title Infrastructure Analyst - UNIXLINUX System Administration Duration 02 year Location Moline, IL Specific Position Requirements bull This position serves as a key member of the Identity Management (more...)
Company: Sunrise Systems, Inc.
Location: Moline
Posted on: 04/22/2019

.NET Web Developer
Description: .NET Web Developer Primary Location Waterloo, Iowa V-Soft Consulting is currently seeking a .NET Web Developer for our premier client in Waterloo, Iowa. This is a full-time, direct-hire position in the (more...)
Company: V-Soft Consulting Group, Inc
Location: Waterloo
Posted on: 04/23/2019

Software Development Manager
Description: CRST International, Inc., is seeking a software development expert with strong leadership qualities to join our team as a Manager - Software Development located in our Cedar Rapids, IA facility.Job Summary: (more...)
Company: CRST International
Location: Cedar Rapids
Posted on: 04/22/2019

Entry Level .Net Software Developer
Description: Employer is the fastest growing employer of emerging technology talent in the US and we are currently looking to hire over 100 new Software Engineers. Our Software Engineers design, analyze and build (more...)
Company: Revature
Location: Dubuque
Posted on: 04/23/2019

Entry Level Software Engineer - Cedar Rapids
Description: Revature is the fastest growing employer of emerging technology talent in the US and we are currently looking to hire over 100 new Software Engineers.Our Software Engineers design, analyze and build next-gen (more...)
Company: Revature
Location: Cedar Rapids
Posted on: 04/22/2019

Entry Level Java Developer
Description: Revature is the fastest growing employer of emerging technology talent in the US and we are currently looking to hire over 100 new Software Engineers.Our Software Engineers design, analyze and build next-gen (more...)
Company: Revature
Location: Moline
Posted on: 04/22/2019

Junior Software Developer
Description: Employer is the fastest growing employer of emerging technology talent in the US and we are currently looking to hire over 100 new Software Engineers. Our Software Engineers design, analyze and build (more...)
Company: Revature
Location: Iowa City
Posted on: 04/23/2019

Log In or Create An Account

Get the latest Iowa jobs by following @recnetIA on Twitter!

Cedar Rapids RSS job feeds