Data Warehouse Architect

vTech Solution, Inc.; Austin (TX); On-site; USD 90,000 - 120,000; Full time

Job summary

A leading technology solutions provider in Austin, Texas, is seeking a Data Warehouse Architect 2 to support their Enterprise Data Warehouse Project. The role requires hands-on data warehouse experience, skills in data architecture development, and familiarity with various RDBMS like DB2, SQLServer, and Oracle. The candidate will document current database processes, assist in strategy formulation, and perform technical analysis. The position promises a vital role within the organization, focusing on data management strategies.

Qualifications

• Hands-on experience in data warehouse projects is essential.
• Ability to document and define technical architecture.
• Experience in implementing data warehousing solutions.

Responsibilities

• Document existing schemas and data processing methods.
• Assist in establishing data warehousing strategy.
• Support TWC's Enterprise Data Warehouse Project.

Skills

Data architecture development

Data warehouse project experience

Technical requirements analysis

Software development

RDBMS implementation

Database tuning techniques

Tools

Enterprise Architect

DB2

SQLServer

Oracle

Job description

We pride ourselves for having one of the fastest growth rate and also the lowest turnover rates in the industry just 2.5 percent annually. We focus on the training and retaining qualified professionals with high personal and work ethics. With the help of our extensive database of internal candidates and CATS applicants tracking system, we can provide quality resources within the limited time frame.

We have also successfully placed hundreds of candidates in the areas related to Information Technology, Engineering, professional, Scientific & Clinical, etc. for both our commercial and government clients.

Our team follows strong policies and procedures concerning confidentiality and information security. Our team is fully aware of and complies with all applicable laws, regulations, policies, standards and guidelines concerning information technology projects. We adhere to and remain abreast of current, new, and revised laws, regulations, policies, standards, and guidelines impacting project execution.

Job Description

TWC is developing a data warehouse solution and requires a Data Warehouse Architect 2 with proven data warehouse experience to:

• Document the “as is” schemas currently in use at TWC.
• Document database process that currently extract the data from the existing system for reporting purposes.
• Assist in establishing the organization's data warehousing strategy.
• Define and document the technical architecture of the data warehouse, including the physical components and their functionality.
• Perform other analysis and documentation tasks as required to facilitate and support TWC’s Enterprise Data Warehouse Project.

Qualifications

• Developing a common data architecture
• Hands‑on data warehouse project experience
• Analyzing and generating technical requirements and design
• Software development experience
• Development experience in implementation of data warehousing utilizing RDBMS.
• Database tuning techniques

Preferences:

• Enterprise Architect from Sparx Systems or other equivalent data modeling tools
• More than one type of RDBMS (DB2, SQLServer, Oracle)
• Experience in data warehouse design and data modeling (both relational and dimensional).

Additional Information

Ans. To Below Pre Employment Questions would help us in prospecting your candidature against open positions with our clients.

1. Are you currently working on Project / Assignment?

2. Is your project coming to an end / Ended or in continuation?

3. Are you authorisedto work Independently for any employer in United States?

4. What is your expected hourly rate for the position being offered?

5. What is your current location?

6. Are you willing to relocate/travel for the open position with us?