Work in Iowa Jobs

Job Information

Randstad Data Warehouse Architect (Azure) in west des moines, Iowa

Data Warehouse Architect (Azure)

job details:

  • location:West Des Moines, IA (remote)

  • salary:$130,000 - $155,000 per year

  • date posted:Tuesday, March 16, 2021

  • job type:Permanent

  • industry:Finance and Insurance

  • reference:827056

job description

Data Warehouse Architect (Azure)

job summary:

The Data Solution Architect analyzes, designs, develops, tests, implements, troubleshoots, optimizes and/or maintains enterprise level data solutions which include source data structures, ETL jobs implementing complex ETL processes and/or targeted data lake/operational data store/centralized data warehouse/data mart designs. The architect utilizes SQL, tools, and/or technology to implement robust, maintainable data solutions meeting business and technical requirements. Provides data architectural and modeling expertise in creating, refining and implementing lightly to moderately complex data model designs.

location: WEST DES MOINES, Iowa

job type: Permanent

salary: $130,000 - 155,000 per year

work hours: 8am to 4pm

education: Bachelors


  • Leverages Data Modeling and ETL tools performing mapping design, architectural design, modeling, coding, implementation, performance tuning and debugging tasks.

  • Develops data extracts, applications and ad-hoc queries using Informatica Power Center, Informatica Cloud and/or SSIS.

  • Applies understanding of the relationship between different data warehouse architectural layers, constructs and data design concepts.

  • Creates moderately complex SQL queries required to access tabular structures in Relational Database Management Systems (RDBMS).

  • Provides technical feedback in the ongoing development of best practices for data movement, data quality, data cleansing and other ETL-related activities.

  • Transforms functional specifications into ETL technical specifications and source to target mappings.

  • Communicates effectively with Business Analysts, Data Modelers and Solution Architects to convert the ETL design into specific development activities.

  • Constructs/refines ETL processes related to loading data into warehouse and provides.

  • Demonstrates proficiency in ETL methodology in performing Data Profiling, Data Migration, and Data Conversion.

  • Documents ETL process thoroughly, including steps needed to migrate ETL/database objects between various environments including Development, UAT, Staging, and Production.

  • Plans Unit and Integration Testing activities and assist in User Acceptance Testing as needed.

  • Performs other related work as assigned.


  • Experience level: Experienced

  • Minimum 7 years of experience

  • Education: Bachelors


  • Data Warehouse

  • ETL

  • design

  • architect

Equal Opportunity Employer: Race, Color, Religion, Sex, Sexual Orientation, Gender Identity, National Origin, Age, Genetic Information, Disability, Protected Veteran Status, or any other legally protected group status.