Database Architect

Summary: The Database Architect will work remotely as part of the Data Governance team, managing multiple projects related to data warehouse development and ETL processes. Responsibilities include documenting existing data schemas, performing complex data modeling, and creating database standards. The role requires extensive experience with data management and ETL tools, particularly Informatica, and involves supporting TWC’s Enterprise Data Warehouse. Additional tasks may include defining technical architecture and assisting with data migration efforts.

Key Responsibilities:

• Oversee multiple projects related to data governance and data warehouse development.
• Test and document ETL processes for the data warehouse.
• Document existing data schemas and perform complex data modeling tasks.
• Create mapping documents from source to target databases.
• Establish database standards and best practices.
• Define and document the technical architecture.
• Assist with data migration from legacy databases to new target databases.
• Perform additional analysis and documentation tasks as required.

Key Skills:

• Minimum 8 years of experience with Informatica ETL processes and data management.
• Hands-on experience with data warehouse development and testing (relational and dimensional).
• Proficiency in databases like Oracle and SQL Server.
• Experience in analyzing and generating technical requirements and design.
• Hands-on experience with data modeling in a data warehouse environment.
• Experience with the Informatica product suite in the cloud.
• Ability to create source to target mapping documentation.
• Preferred experience with multiple RDBMS (DB2, SQL Server, Oracle) and data modeling tools.
• Experience in Amazon Web Services and Texas Workforce Commission.

Salary (Rate): undetermined

City: undetermined

Country: undetermined

Working Arrangements: remote

IR35 Status: outside IR35

Seniority Level: undetermined

Industry: IT