Work in Iowa Manufacturing Jobs

Job Information

Randstad Data Warehouse Technical Lead in West Des Moines, Iowa

Data Warehouse Technical Lead

job details:

  • location:West Des Moines, IA

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

  • date posted:Friday, July 16, 2021

  • job type:Permanent

  • industry:Professional, Scientific, and Technical Services

  • reference:854917

job description

Data Warehouse Technical Lead

job summary:

Technical Lead (2 openings)

Location: Des Moines, IA

Salary: 115-130k

Position Details:

  • As a technical lead you would be responsible for design the technical solution and delivering on the data needs of the business stakeholders.

  • Technical ownership of ETL/ Data Warehouse projects and responsible for timely deliveries of work items.

  • Leads all technical and architectural aspect of ETL projects from requirements till Implementation.

  • Provide inputs to continuously improve ETL process discipline and resulting output quality.

  • Leads in Tuning of ETL performance.

  • Provides guidance to ETL developers.

  • Collaborate with the Architects on POC of new tools and technologies.

Technical Experience:

  • 9+ years of experience in designing and delivering Data Warehouses and reporting platforms.

  • High Level of SQL experience is must.

  • Experience with Database technologies such as Oracle, DB2, SQL server a must (Postgres and No SQL database is nice to have).

  • Experience with Extract, Transform and Load and ELT development is required.

  • 7+ years of hands on experience with ETL tools like Informatica Power Center.

  • Data modelling experience with relational and dimensional modeling is required.

  • Understanding of Metadata, Data Governance, Data Quality and Data security is required.

  • Should have experience with cloud based DW (Snowflakes experience highly preferred)

  • Exposure to BI tools like Power BI and Tableau good to have.

  • Exposure to CDC tools like Attunity Replicate, AWS DMS, Goldengate etc. is good to have.

  • Experience with Cloud Analytical platforms and tools good to have along with any exposure to Python.

Additional Experience:

  • 4+ years of experience of leading small to medium sized teams.

  • Excellent verbal and written communications.

  • Experience of working in Agile Environment.

  • Understanding of Life Insurance or Annuities business is good to have.

location: West Des Moines, Iowa

job type: Permanent

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

work hours: 8am to 5pm

education: Bachelors

responsibilities:

Position Details:

  • As a technical lead you would be responsible for design the technical solution and delivering on the data needs of the business stakeholders.

  • Technical ownership of ETL/ Data Warehouse projects and responsible for timely deliveries of work items.

  • Leads all technical and architectural aspect of ETL projects from requirements till Implementation.

  • Provide inputs to continuously improve ETL process discipline and resulting output quality.

  • Leads in Tuning of ETL performance.

  • Provides guidance to ETL developers.

  • Collaborate with the Architects on POC of new tools and technologies.

qualifications:

  • Experience level: Manager

  • Minimum 8 years of experience

  • Education: Bachelors

skills:

  • ETL

  • Data Warehouse

  • SQL

  • DB2

  • Oracle

  • metadata

  • AWS

  • Attunity Replicate

  • Agile Methodology

  • Leadership

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.

DirectEmployers