Data Architect

The Data Architect will define solutions and processes for managing enterprise-wide data throughout the data lifecycle from capture to processing to usage across all layers of the architecture. The Data Architect will work with business users, I.T. delivery teams, and Project Managers to deliver solution architectures that align with the Enterprise data strategy and vision. Must develop a strong understanding of each business unit to include their business drivers for success, processes and approaches to business models. The role will focus on defining, developing and promoting the Solution Architectures that aid the organisation in building out the Enterprise Data vision.

Main duties and responsibilities:

• Define solution architectures for Data Warehouse, Master Data/Reference Data and integration for data.
• Contribute to the creation of an Enterprise Reference Data Architecture for the business.
• Participation in the definition of standard enterprise data management and enterprise data architecture processes and deliverables.
• Collaboration with the business, its applications, solutions, and with other IT architects to understand the implications of respective architectures on data architecture and to maximize the value of information across the organisation.
• The creation and implementation of processes to collect and maintain inventory of Data assets across the enterprise.
• Assist in maintaining the assessment and inventory of the existing enterprise-level data environment.
• Assist in defining MDM solution architecture and set technical direction, define component architecture, review detailed designs for accuracy and overall compliance to defined architecture.
• Analyse and define detailed MDM processes, tasks, data flows, and dependencies.
• Define the solution architecture and design for data management to ensure effective delivery of information that meets current and future requirements.
• Works with business process experts to help identify functional requirements.
• Analyse impact of future topology changes in the environment.
• Facilitate system feasibility studies, proof of concepts, pilot project, and testing while working with stakeholders to define business and systems requirements in a modern data architecture.
• Develop, implement, and maintain all data management policies and procedures, including those for enterprise data warehouse architecture, standards, monitoring, and service provision.
• Verify design of overall Infrastructure and support the build of the environments EA Compliance.
• Oversee the documentation of all architecture design and analysis work.
• Consult with infrastructure, project and product teams to ensure consistency with the enterprise architecture, as well as to identify when it is necessary to modify the enterprise architecture.

About You:

• Expert in Dimension Modelling.
• Good knowledge of Third Normal Form data modelling.
• Consistently demonstrate strong experience in Conceptual, Logical, and Physical Database architectures, design patterns, best practices, and programming techniques around relational modelling, dimensional modelling and data integration.
• Experience in driving Meta data architecture and Master Data Management Solutions.
• Experience in performing analysis and design for Data Management and Data Driven projects.
• Awareness of MDM trends, MDM concepts and other tools in the market.
• Strong understanding of activities within primary discipline such as Master Data management (MDM), Metadata Management and Data Governance (DG).
• Experience of Cloud Data technologies, solutions and future Cloud Data Strategies.
• Able to review designs independently, lead code reviews and ensure quality throughout the life of each project.
• Experience of enterprise systems data requirements and challenges would be beneficial, e.g. SAP, Salesforce.
• Ability to translate and clearly formulate technical issues and solutions to the issues.
• Excellent problem solving and analysis skills.
• Excellent communication skills - written and verbal.
• Excellent presentation skills.
• Intervenes if warning signs of problems occur within own area of responsibility.
• Forward thinking. Proactive rather than Reactive.
• Strong leadership and influence skills across Business and Technology organizations.

Desirable Skills:

• Hands on experience of Microsoft Azure technology stack, such as Azure Data Factory, Synapse Data Warehouse, Power BI, ADLS, Data Bricks, SSRS, Microsoft Fabric, etc.
• Hands on experience of SAP Data and BI technology stack, such as HANA database, SAP IQ database, Business Objects Data Services, SAP Data Intelligence, Business Objects, SAP Analytics Cloud, etc.