DW Architect - Location - Austin - Rate - $80-$85 - public sector experience is a must

NFOLKS LLC; Austin (TX); On-site; USD 110,208 - 117,096; Full time

Job summary

NFOLKS LLC is seeking a Data Warehouse Architect in Austin, Texas, with deep expertise in ETL strategies and architecture required for a public sector project. Candidates should have a minimum of 12 years of experience in ETL architecture, data quality, and hands-on work with databases like Oracle, DB2, and SQL Server.

This full-time role involves documenting schemas, developing ETL processes, and collaborating with both technical and non-technical teams. The position offers a competitive rate of $80-$85 per hour.

Qualifications

• 12 years of experience with ETL architecture design.
• 10 years of architecture experience in Reference Data and Data Quality.
• 6 years of recent experience with Data Vault 2.0 architecture using Oracle.
• Strong technical writing skills and ability to work with diverse teams.

Responsibilities

• Establish ETL strategies and technical architecture for the data warehouse.
• Design, develop, and test ETL processes.
• Document existing schemas and support the enterprise data warehouse project.

Skills

ETL architecture design

Data quality assurance

Data modeling

Informatica expertise

Technical writing

Communication skills

Tools

Informatica

Oracle

DB2

SQL Server

Sparx Systems

Job description

DW Architect - Location - Austin - Rate - $80-$85 - public sector experience is a must

Full-time

nFolks

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

Responsibilities

• Establish Extraction, Transformation and Load (ETL) strategies, architecture, and design for the project.
• Establish standards for all ETL processes for the data warehouse.
• Design, develop, and test ETL processes for the data warehouse.
• Develop and document ETL processes to extract data from existing systems into the data warehouse.
• 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.
• Document the “as-is” schemas currently in use at TWC.
• Perform other analysis and documentation tasks as required to facilitate and support TWC’s Enterprise Data Warehouse Project.

Qualifications and Experience

• 12 years – Design and develop Extraction, Transformation, Load (ETL) architecture for enterprise data warehouse; deep hands‑on expertise with ETL processes, development, data management, data flows, data relationships, and data quality standards and processes.
• 10 years – Extensive architecture experience and knowledge in the areas of Reference Data, Data Quality, Metadata Management with hands‑on solution implementation.
• 6 years – Hands‑on experience with data warehouse modeling, design and development (relational and dimensional) including recent experience with Data Vault 2.0 architecture and proven evidence of implementation using Oracle.
• 6 years – Recent hands‑on experience with Informatica product suite, including those relevant to data quality, master data, and management of enterprise metadata.
• 3 years – Experience performing data quality and data tool implementation.
• Proven ability to work successfully with technical and non-technical groups and manage multiple responsibilities.
• Strong communication, analytical and interpersonal skills at all levels.
• Strong technical writing skills.

Preferred Qualifications

• 4 years – Enterprise Architect experience from Sparx Systems or other equivalent data modeling tools.
• 4 years – Experience with more than one type of RDBMS (DB2, SQL Server, Oracle).
• 4 years – Experience in public sector delivery.
• Certified Data Management Professional (CDMP).
• Experience with Informatica in the cloud.

All your information will be kept confidential according to EEO guidelines.