US|Data Architect III

Data Architect III

Location: Houston, TX

Duration: 12 months

Job Responsibilities:

• Model, design, build, and verify/troubleshoot the tables, files, etc. and their data that is stored in Microsoft Cloud environment (Data Lake, Azure SQL, Azure DWH) leveraging Chevrons common/standard architecture design tools, design patterns, and languages
• Test programs or databases, correct errors and make necessary modifications.
• Modify existing databases and database management systems.
• Write and code logical and physical database descriptions and specify identifiers of database to management system.

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 of Upstream business & Upstream data patterns (DIAL, OSDU, Microsoft Energy Design Patterns, etc.)
• 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: