Data Architect

Data ArchitectApex Systems has a Data Architect opening with a leading oil and gas client.Contract: 8 months, potential to extendLocation: Houston TX (will need to work onsite and remote)ResponsibilitiesPrepare 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 SkillsKnowledge of Design/Modeling tools (IBM Data Architect, etc.)Knowledge of Azure Data Lake and Azure SQL storage platformsUnderstanding of older storage platforms (MS SQL Server, Oracle, Teradata, ERP/SAP, etc.)Understanding of Azure Synapse, Azure DWHUnderstanding 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 SkillsKnowledge 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 partsAbility to communicate with both business SMEs and integration developersAbility to navigate and comprehend mapping documentsUnderstanding of CI/CD pipelines, branching strategies, & GIT for code managementExperience with Azure DevOps (ADO) tool for work managementPractitioner of Agile/SAFe practicesEducationBachelor's Degree