Roles & Responsibilities:
- Liaise closely with the Architecture team to ensure delivery is in accordance with the agreed architecture, High Level Solution Designs and Information Strategy.
- Liaise with the Operations teams very early to ensure aspects of quality, performance and stability are considered before a solution is designed.
- Understand our customers core business objectives.
- Lead and participate in the definition, execution, and communication of technical solution.
- Cooperate with business, security, and operational teams to ensure adherence to company guidelines.
- Deliver high quality detail design for CDO projects in alignment with group reference architecture.
- Ensuring that the design meets customer’s short- and long-term business needs aligned to governance.
- Provide technical design services which may include dimensional modelling, staging areas, Business Access Layers, semantic layer design, ETL design, data labs considerations, table and view optimisation, aggregation, materialisation and performance considerations.
- Design decisions may include choice of reporting tool or cubes, static delivery vs interactive reports, extracts vs runtime look ups, security methods, archiving methods, on-platform execution vs data shipping to platforms such as Pega for deaccessioning, BI Tools like tableau, OBIEE.
- Provide functional and technical direction for Analytics and BI projects and influence on appropriate solution design.
- Promote and embed design patterns, standards and guidelines across projects and programmes in CDO.
- Work closely with project managers, Business analysts, developers and testing team to ensure that approved designs are implemented.
- Provide design patterns that are re-useable, simple and robust that comply with CDO and Information architecture principles and standards. Gain approval of the design patterns at the appropriate ES councils.
- Participate in BI and Information Architecture forums and councils to advise and influence in the formulation of design principles and standards
- Effectively develop and manage relationships for CDO projects with Solution Designers from other Enterprise Services teams.
Essential Skills:
- 12 - 18 years’ experience in design, architecture or development in Analytics and Data Warehousing.
- Cloud experience and knowledge on Data pipeline, design.
- 5-8 years for experience in Data Modelling, Dimensional, Star and Non-Dimensional Schemas. Exposure to industry standard model like BIAN, FSLDM / IBM IFW DW.
- Experience in creating reusable group data asset.
- Hands on experience on developing Data pipelines in Spark / mapreduce / Abinitio.
Education Qualifications: Bachelor’s degree/Master’s degree in Engineering in Computer Science/Information Technology