Enterprise Data Warehouse Architect

PSG Global Solutions; Austin (TX); On-site; USD 80,000 - 100,000; Full time

Job summary

A leading IT recruitment consultancy is seeking a data modeling expert to work on the IQ enterprise data warehouse in Austin, Texas. The role involves collaborating with ETL, BI, and DBA teams to develop data models and reporting structures while ensuring data quality and integrity. Candidates should possess strong SQL skills and experience with data modeling tools. This opportunity offers a dynamic environment to contribute to significant data initiatives.

Qualifications

• Experience with conceptual, logical and physical data model design.
• Experience designing tables and views for efficiency.
• Professional working experience modeling data requirements.
• Experience working with relational databases.
• Skilled in writing and maintaining complex SQL and PL/SQL scripts.

Responsibilities

• Work on the IQ enterprise data warehouse and modernization initiatives.
• Collaborate with the IQ team for data model creation and management.
• Identify and address data quality issues.
• Perform performance monitoring and query tuning.
• Document developed solutions for team continuity.

Skills

Data modeling

Metadata management

SQL

Analytical skills

Communication skills

Problem-solving

Attention to detail

Education

Relevant education or equivalent experience

Tools

ERwin

SQL Server

IBM Cognos

Tableau

Job description

A leading IT recruitment consultancy is seeking a data modeling expert to work on the IQ enterprise data warehouse in Austin, Texas. The role involves collaborating with ETL, BI, and DBA teams to develop data models and reporting structures while ensuring data quality and integrity. Candidates should possess strong SQL skills and experience with data modeling tools. This opportunity offers a dynamic environment to contribute to significant data initiatives.