Hybrid Data Warehouse Architect & DBA—Enterprise Analytics

Vitaver & Associates, Inc; Austin (TX); Hybrid; USD 120,000 - 180,000; Part time

Job summary

Vitaver & Associates, Inc. seeks a Data Warehouse Architect/DBA for a 12-month project in Austin with a hybrid work setup. The role involves leading end-to-end data warehouse implementation, building data models, ETL pipelines, and delivering advanced analytics and BI dashboards.

Required are extensive experience with data warehousing, ETL tools, and enterprise databases (Oracle/SQL Server/Teradata) and strong communication and collaboration skills for cross-functional teams.

Qualifications

• Experience with database management systems, data warehouse management and decision support tools (5 years).
• Experience in building the data dictionary (5 years).
• Experience with database access tools for application delivery (5 years).
• Experience with analysis, planning and management reporting functions (5 years).
• Strong oral and written communications skills (5 years).
• Strong teamwork and interpersonal skills (5 years).
• High analytical ability for unusual and difficult problems (5 years).
• Experience with benchmarking processes and techniques (5 years).
• Interpersonal skills to work with others and motivate employees (5 years).
• Experience with data warehousing population and modeling (5 years).
• Experience with GUI based ETL tools (5 years).
• Experience with enterprise databases (Oracle, SQL Server, Teradata) (5 years).
• Experience with analytical and reporting tools (Business Objects, Cognos, Hyperion, MicroStrategy) (5 years).
• Experience with data warehouse implementation process from requirements to design and transformation (5 years).
• Excellent analytical; problem-solving; and communication skills (5 years).
• Experience working with technical and non-technical groups and managing priorities (5 years).

Responsibilities

• Lead end-to-end data warehouse implementation lifecycle from requirements to deployed data marts.
• Develop and optimize ETL pipelines and administer enterprise databases to ensure data sourcing and loading.
• Design and deliver analytical reports and dashboards to support management decisions.
• Administer DBMS and maintain data dictionaries and metadata standards for data integrity.
• Apply advanced analytical skills to resolve complex data challenges and optimize performance.
• Drive analysis and reporting functions to translate data into actionable insights.
• Collaborate with technical and non-technical stakeholders to manage multiple priorities.

Skills

Data warehousing

ETL tools

Data modeling

SQL

Oracle

Teradata

SQL Server

Business Objects

Cognos

Hyperion

MicroStrategy

Teamwork

Communication

Analytical thinking

Benchmarking

Tools

Informatica

DataStage

Power BI

Business Objects

Cognos

Hyperion

MicroStrategy

Oracle database

SQL Server

Teradata

Job description

Vitaver & Associates, Inc. seeks a Data Warehouse Architect/DBA for a 12-month project in Austin with a hybrid work setup. The role involves leading end-to-end data warehouse implementation, building data models, ETL pipelines, and delivering advanced analytics and BI dashboards.

Required are extensive experience with data warehousing, ETL tools, and enterprise databases (Oracle/SQL Server/Teradata) and strong communication and collaboration skills for cross-functional teams.