Data Warehouse Architect

Data warehouse, ERwin, Cloud, Shell scripting, Modeling, Amazon Web Services, Data warehouse architecture, PL/SQL, ETL, Oracle
Contract W2, Contract Corp-To-Corp, 6 Months
Depends on Experience
Work from home not available Travel not required

Job Description

The Tri-Com Consulting Group
A Full Service IT Employment Consulting Firm

is seeking qualified candidates for the following opening:

Data Warehouse Architect

The Data Warehouse Architect, DWA, will be responsible for analysis, design, coding, and testing of moderate to extremely complex data extraction routines and report development. The DWA will analyze and develop data warehouse schematic solutions to support business requirements as outlined by a Business Analyst. The DWA will also support existing warehouse infrastructure and provide input on best practices and potential efficiencies. The DWA will work on multiple assignments concurrently and be required to complete work by aggressive due dates. This DWA / Developer role may work in both the Architect capacity as well as an ETL Developer capacity. This role uses a range of expert technical skills based on a keen knowledge of data warehouse concepts and must be highly proficient with Oracle SQL. The Architect will help identify and implement continuous improvement opportunities. The Architect is responsible for regular peer code reviews and frequently mentors others. The ideal candidate must demonstrate that they have relevant experience, creativity, a keen problem-solving ability along with collaboration and facilitation skills to work with a broad range of people while keeping projects on track.


  • Creates data models and designs to meet specific business needs
  • Determines appropriate sourcing and storage of data from multiple source systems
  • Understands and is able to translate business requirements into Data Warehouse solutions
  • Codes Oracle ETL scripts that will extract data from an operational database and populate the staging and target data warehouse schemas
  • Documents code and processes for distribution to all interested parties
  • Documents design using industry standards including ERWIN diagramming
  • Provides query writing support and tuning expertise to analysts and end users
  • Develops shell scripts for production job automation
  • Work in a 24x7 environment which requires on-call rotation


  • 5+ years of experience in database architecture and development including analyzing, designing, documenting, coding, testing and implementing primarily SQL code
  • Thorough knowledge of data warehouse principles and techniques, specifically dimensional data architecture modeling
  • Exceptional Oracle SQL skills and PL/SQL skills
  • Hands on experience with set based operations, analytic functions and query hints
  • Command of data warehouse modeling concepts is required
  • Strong problem solving and analytical skills
  • Strong ERD modeling
  • Proficiency with Linux and shell scripting
  • Experience working with a large, multi-terabyte data warehouse

ADDITIONAL EXPERIENCE which will distinguish candidates:

  • BS in Computer Science or related degree, or equivalent experience
  • Medicaid or other healthcare or claims processing experience
  • AWS (Cloud) Experience
  • Informatica ETL experience

Qualified Candidates should apply to this job posting with their resume, compensation requirements and references.

~Tri-Com is an Affirmative Action/Equal Opportunity Employer~

As a condition of employment you will be required to pass a drug screening and other background checks.

Dice Id : tricomcg
Position Id : 6313730
Originally Posted : 4 weeks ago
Have a Job? Post it