Data Warehouse Architect/DBA (Hybrid)

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

14902 – Data Warehouse Architect/DBA (Hybrid) – Austin,TX
Start Date: ASAP
Type: Temporary Project
Estimated Duration: 12 months with possible extensions
Work Setting: Hybrid - On Site and Telework. Position will be 2 days remote with 3 days (Wed, Thurs & Fri) required to be onsite
Only local candidates as required should apply to avoid removal from future consideration.
Our client is filling this contract position exclusively through approved staffing partners, so this opportunity is not available by applying directly with the client.

Required:

• Experience with database management systems, as well as data warehouse management and decision support tools (5 years)
• Experience in business objects and in building the data dictionary (5 years)
• Experience with data base access tools for application delivery (5 years)
• Experience with analysis, planning and management reporting functions (5 years)
• Well-developed oral and written communications skills (5 years)
• Strong teamwork and interpersonal skills (5 years)
• Extremely high level of analytical ability where problems are very unusual and extremely difficult (5 year)
• Experience with benchmarking processes and techniques (5 years)
• Very high level of interpersonal skills to work effectively with others, motivate employees, and elicit work output (5 years)
• Experience with Data Warehousing data population and data modeling techniques for target structures such as Star Schemas, Snowflake Schemas, and highly normalized data models (5 years)
• Experience with GUI based ETL tools such as Informatica, IBM WebSphere DataStage, or similar tools. (5 years)
• Experience with enterprise class databases e.g. Teradata, Oracle, SQL Server, etc. or similar technologies. (5 years)
• Experience with analytical and reporting tools e.g. Business Objects, Cognos, Hyperion, MicroStrategy or similar tools. (5 years)
• Experience with data warehouse implementation process, from business requirements through logical modeling, physical database design, data sourcing and data transformation, data loading, Structured Query Language (SQL), end-user tools, database and SQL pe (5 years)
• Experience with analytical and reporting tools e.g. Business Objects, Cognos, Hyperion, MicroStrategy or similar tools. (5 years)
• Excellent analytical; problem-solving; team playing; and oral and written communication skills. (5 years)
• Experience working with technical and non-technical groups and managing multiple responsibilities. (5 years)

Preferred:

• Oracle Database experience (5 years)
• Experience in the development, implementation and maintenance of data warehouses and data marts (5 years)
• PowerBI report creation (5 years)

Responsibilities

• Lead the end-to-end data warehouse implementation lifecycle, translating business requirements into logical models, physical database designs, and deployed data marts using Star, Snowflake, and normalized schemas
• Develop and optimize ETL pipelines using enterprise tools (e.g., Informatica, DataStage) and administer enterprise-class databases (Oracle, SQL Server, Teradata) to ensure efficient data sourcing, transformation, and loading
• Design, build, and deliver advanced analytical reports and dashboards using Power BI, Business Objects, Cognos, or MicroStrategy to support management reporting and strategic decision-making
• Administer database management systems and maintain comprehensive data dictionaries and metadata standards to ensure data integrity, governance, and optimal query performance
• Apply advanced analytical and problem-solving skills to resolve highly complex, unusual data challenges, utilizing benchmarking techniques to optimize system performance and data delivery
• Drive analysis, planning, and management reporting functions by leveraging database access tools and decision support systems to translate complex data into actionable business insights
• Collaborate effectively with both technical and non-technical stakeholders, motivating team members and facilitating cross-functional efforts to manage multiple priorities and deliver high-quality data solutions