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

ETL Developer in Ames, IA at REG

Date Posted: 3/21/2019

Job Snapshot

Job Description

POSITION PURPOSE:

The ETL Developer will contribute to the design, configuration, testing and maintenance of the enterprise data warehouse (EDW) that helps the company report and visualize its operational, financial, and planning data with the aim of allowing the business to make better faster business decisions. The candidate will collaborate with IT BI Developers and IT Business Analysts to gather data and database architecture requirements, recommend the most effective database architecture solution based on experience and best practices, document test results, support in use reporting solutions and create simple project plans for solution implementation. 

ESSENTIAL FUNCTIONS:

System Design and Development

• Review requirements documentation, conduct interviews to eliminate ambiguity in requirements, and gain all information needed to finalize on an EDW design

• Document and articulate the proposed data structure design for storing data in the EDW

• Work closely with BI Developers and Business Analysts to identify efficient methods of pulling information from disparate transactional databases into the EDW to improve data visibility and decision making ability

• Manage the process for EDW population from refining requirements, documenting architecture, developing ETL code, and working with BI report developer to delivery of
the final solution

• Document test results

• Develop complex SQL queries and scripts for the creation of physical EDW tables and views

ETL Tools Administration

• Manage SQL databases associated with the Enterprise Data Warehouse

• Participate in selection, upgrades, and installations of technologies to support the growth and adoption of the EDW concept

• Perform, schedule, and maintain processes for a healthy EDW

• Monitor and troubleshoot ETL and system performance, including optimization and tuning of data loads

• Understand job and activity schedules to promote optimal performance, maximize availability and minimize data latency and data load duration

Project Management

• Create simple project plans

• Report on project progress, risks and issues

• Lead small projects or key components of large projects

• Maintain a positive work atmosphere by acting and communicating in a manner which facilitates the success of business operations in order to meet company demands and expectations

• Ability to multi-task, prioritize workload and communicate timelines clearly

Other frequent duties: 

Perform other duties as assigned 

JOB QUALIFICATIONS:

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

Experience Required: Two or more years as an ETL developer in data warehouse / business intelligence environment

Strong knowledge of data warehousing methodologies and concepts, including and not limited to: star schemas, snowflakes, ETL processes and dimensional modeling

Strong SQL development skills, including complex joins, aggregations, analytical functions, derived tables, stored procedures, triggers and macros

Experience Preferred:

MS SQL administration 

Oracle Data Integrator development 

Tableau development 

Oracle Business Intelligence development 

Worked with JD Edwards EnterpriseOne  

Skills Required:

Strong verbal and
written communication skills 

Microsoft Office
Suite (Excel, PowerPoint, Outlook) 

REG is committed to creating a diverse environment and is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, age, religion, gender, gender identity or expression, sexual orientation, national origin, disability, or veteran status.

CHECK OUT OUR SIMILAR JOBS

  1. Software Engineer Jobs
  2. Project Engineer Jobs