| Location | Houston, Texas |
VERY URGENT AND IMMEDIATE NEED.
Note: Need Only US Citizen, Green Card, EAD-GC, J2 EAD, H4 EAD, L2 EAD, and TN Visa.
Job Title: Data Architect
Location: Houston, Texas
Duration: 06+ Months Contract
Description:
Looking to help Model, Design, Build, and Verify/Troubleshoot the tables, files, etc. and their data that is stored in the MS Cloud environment (Data Lake, Azure SQL, Azure DWH) leveraging common/standard architecture design tools, design patterns, and languages integration, and the means to get to the data.
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 TECHNIAL 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.