Data Architect, No 3rd parties, w2 only, Must live in Houston

No 3rd parties, W2 onlyClient in Houston is seeking a contractor to help Model, Design, Build, and Verify/Troubleshoot the tables, files, etc. and their data that is stored in the Chevron Microsoft Cloud environment (Data Lake, Azure SQL, Azure DWH) leveraging Chevron’s common/standard architecture design tools, design patterns, and languages integration, and the means to get to the data. WORK LOCATION-The selected candidate must be located in Houston as they will work a hybrid schedule onsite RESPONSIBILITIES-Prepare business unit data for ingestion to Modern data warehouse through supporting data management, data mapping, and data modeling activities.-Play a key workflow management & communications role between our team, IT BUDM team, Digital Platform teams & the Business.-Provide oversight and help troubleshoot data quality and integrity during BU Modernization. REQUIRED TECHNICAL SKILLS-Knowledge of Design/Modeling tools (IBM Data Architect, etc.)-Knowledge of Azure Data Lake and Azure SQL storage platforms-Understanding of older storage platforms (MS SQL Server, Oracle, Teradata, ERP/SAP, etc.)-Understanding of Azure Synapse, Azure DWH-Understanding of Integration tools within Azure (Azure Data Factory (ADF), Azure Data Brick, Python, Spark SQL)-Understanding of older integration is beneficial (MS SQL Server, MS SSIS, IBM DataStage, etc.) REQUIRED SOFT SKILLS-Knowledge in Data Modeling best practices (Star Schema, Time-Series, CI/CD, Cube)-Ability to analyze various data set, resolve data relationships, and data troubleshooting, & dissect complex calculation into actionable smaller parts-Ability to communicate with both business SMEs and integration developers-Ability to navigate and comprehend mapping documents-Understanding of CI/CD pipelines, branching strategies, & GIT for code management-Experience with Azure DevOps (ADO) tool for work management-Practitioner of Agile/SAFe practices EDUCATION-Bachelor's Degree INTERVIEW PROCESS-Teams video meeting Thank you,