For more information on COVID-19 and how we are responding, click here.

Architect, ETL

Job Details
Posted Date:
April 3, 2022

Job ID:

St. Louis , MO

5 years

Job Description
  • Location: St. Louis, MO
  • Type: Contract
  • Job #8327

Technology Partners is currently seeking a talented Architect, ETL – 146400. Do you have experience with ETL? Let us help you make your next big career move a reality!

What You Will Be Doing:
You will work closely with business partners to help translate functional requirements into technical approach, design, and decisions. Consult, design, and build solutions to address the client’s business intelligence and data management challenges by following industry best practices. Understand requirements, data models, and source to target mappings. Conduct impact assessment and determine size of implementation efforts. Design the ETL application architecture based on the documented requirements. Perform ETL application development and data transformation efforts. Perform QA functions for the ETL application, including ensuring that unit and integration test plans are developed and executed. Perform root cause analysis/troubleshooting on any code issues. Provide code migration instructions in standard documentation. Perform code reviews to ensure code meets standards and guidelines. Coach and guide the development team.

Required Skills & Experience:

  • 3+ years of experience as ETL Architect and/or Lead role
  • 5+ years of experience in Teradata or equivalent SQL-based development, especially writing stored procedures
  • Expertise in Business Intelligence
  • Deep knowledge in data warehouse concepts, architecture, and ETL
  • Ability to tune and optimize query performance for large datasets
  • Knowledge and experience in data architecture, dimensional modeling, and solution design
  • Experience in multi-tier development environments and stringent migration process
  • Understanding of:
  • Reporting (front-end) needs like table aggregation and performance tuning
  • ETL scheduling and dependency concepts
  • Incremental change design concepts
  • How the reporting and ETL layers interact
  • Solid communication skills
  • Strong testing skills

We are interested in every qualified candidate who is eligible to work in the United States. However, we are not able to provide sponsorship at this time or accept candidates who would require a corp-to-corp agreement.

If this position sounds like you, WE SHOULD TALK!

We realize our people are our most valuable asset, that is why we offer the following benefits:

  • Health, Dental, and Vision insurance
  • 401(k) retirement plan
  • Long and Short-Term disability
  • Life insurance
  • Direct deposit
  • Referral program

Your better future is ready, and we want to put the right tools in your hands to get you there. Let’s go!

Keywords: ETL, extraction transformation and loading, business intelligence, Teradata, data warehouse

Looking for more opportunities with Technology Partners? Check out!

Technology Partners is an Equal Opportunity Employer. Technology Partners does not discriminate on the basis of race, color, religion, sex, national origin, age, disability or any other characteristic protected by applicable state or federal civil rights laws.

Share this Job!

Apply Now!

Attach a resume file. Accepted file types are DOC, DOCX, PDF, HTML, and TXT.

We are uploading your application. It may take a few moments to read your resume. Please wait!

Know someone who you think would be a great fit for Technology Partners or one of our many clients? Send them our way!