This site uses cookies. To find out more, see our Cookies Policy

Senior Analytics Analyst, IT - Data Warehousing in Ames, IA at REG

Date Posted: 7/22/2018

Job Snapshot

  • Employee Type:
  • Location:
    Ames, IA
  • Job Type:
  • Experience:
    Not Specified
  • Date Posted:

Job Description


The Analytics Analyst will contribute to the design, configuration, testing and maintenance of the business’s reporting systems or data warehouses that help the company manage its operational, financial, and planning data with the aim of allowing the business to make better faster business decisions.  The candidate will collaborate with business teams to gather reporting requirements, recommend most effective reporting solution based on experience and best practices, create test plans, document test results, train users on business intelligence reporting tools, support in use reporting solutions and create project plans for solution implementation.


System Analysis and Design

  • Capture business requirements in written documentation to ensure new IT services, modified IT services, or reporting solutions developed meet the expectations of the business
  • Work closely with business groups to identify efficient methods of pulling information from disparate transactional databases into the data warehouse to improve data visibility and decision making ability
  • Conduct interviews and workshops to define business requirements
  • Deliver requirements to development and work closely with developers during the ETL/ELT development phase.
Software Testing
  • Build and manage test plans
  • Document test results
  • Conduct user acceptance testing
Project Management
  • Create accurate and complete detailed project plans
  • Report on project progress, risks and issues
  • Facilitate project meetings and discussions
  • Direct and lead project teams
  • Lead small projects or key components of large projects
Other frequent duties:
  • Conduct train the trainer training and end user training
  • Perform other duties as assigned


Education Required: 4 year bachelor’s degree or equivalent work experience                               

Experience Required

Two or more years supporting a tier 1 ERP system

Two or more years working in business analytics, business intelligence software, and data warehousing

Strong understanding of SQL

Knowledge of ETL/ELT processes and best practices

Skills Required

Strong verbal and written communication skills

Microsoft Office Suite (Excel, PowerPoint, Outlook)


  1. Business Analyst Jobs
  2. Systems Analyst Jobs