Úta architect

The Data Architect provides architectural leadership across the WPB Operations portfolio of change. Primary stakeholders are IT Leads/CIOs, fellow Architects (Enterprise, Platform and Solution), Programme Managers and Business / Transformation colleagues. They are accountable for assuring the architecture and design deliverables across the portfolio of change. Core deliverables are: Providing architectural leadership to guide architecture and design activities across the change portfolios Ensuring alignment to architecture strategy and roadmaps and meeting the desired business outcomes, through collaboration with Enterprise Architects and Business / Transformation colleagues Troubleshooting the delivery of strategic and high-priority programmes to achieve desired cost, timescale and quality outcomes Ensuring the coherence and integrity of architectural deliverables within the portfolios of change and where applicable promoting consumption of shared services to achieve re-use. Essential experience Solid experience on MSSQL, Azure SQL, Oracle, Data Migration, Database Programming Experienced on the concepts of Azure Cloud (DB/SQL) and implementation of any one Data warehouse or Database Understand complex SQL Server designs to share ownership and optimize a mix of on-prem physical and Azure IaaS/Paas SQL Server environments Support extensive DTS, SSIS and Azure Data Factory Integrations and other industry leading integrations Create highly scalable transactional database schemas utilizing data modelling discipline with an understanding of normalization, de-normalization, and the difference between the two. Sound knowledge on various Azure services like ADLS, Synapse analytics, Azure Functions, Logic Apps etc., Define the current business operating model and design for future data governance, data engineering and BI. Design blueprints to realize data related aspects of the business strategy including architecture capabilities and high level solution architectures for current and proposed business services and lead proof of concepts. Provide technical leadership in transforming requirements to solutions and technical designs, while working as a key member of cross functional product team(s); distributed across multiple geographies and organizations Provide advice and support in performance tuning, troubleshooting, cost optimization and other implementation and operational challenges. Experience of working in Agile environment is a must Strong attention to detail and a positive attitude Self-motivated individual with excellent written and verbal communication skills. Knowledge of Energy industry and domain is a added advantage Database Consulting