Solution Architect(SAP Hana/native Hana)

Solution Architect

Role Profile

The Index Data Processing Platform (IDPS) is a program whose main purpose is to drive improvements across data collection, data management and data governance resulting in improved efficiencies, robustness, and the ability for our business to use our data as an asset by driving both cost savings and revenue opportunities. Some of the outcomes and benefits of this program include:
Provides a single, centralized version of the truth/data including standardized logical and physical data model

Data capabilities to build world class multi-asset indices and data & analytics services

Universal data quality profiling and checks as well as Data Policies and Governance

A platform for data discovery, management and cataloguing

Ability to on-board and integrate new business acquisitions more efficiently

Improve operational efficiency through automation

A customized bi-directional packaging and delivery capability

Role Description:
Key Responsibilities:
Lead the design, development, delivery and maintenance of solutions based on the latest SAP technology

Work with functional specialists, understand business processes and translate functional specifications into technical requirements

Provide technology guidance, roadmaps, principles, standards and best practices

Demonstrate strong and broad technical leadership, expert influence and help to drive change

Drive modern software design patterns, project methodologies and ability to design and document complex solution architectures from concept through deployment

Work closely with technical team members to ensure technical knowledge is maintained and that project work can be accurately scoped

Provide thought leadership on data processes and technology and how implementation of these can improve the effectiveness and accuracy of data

Identify key functional risks and issues ensuring mitigation plans are identified and project leadership is aware of implications

Provide proactive leadership around continuous process improvement and process adherence

Design and develop optimal code to maintain exceptional performance in processing large volumes of data across diverse sources

Design and Build solutions using native HANA ecosystem and components

Design, develop and test data models and ensure that data is correctly loaded into the system

Design and develop scalable, reusable data models in SAP HANA in line with architectural standards and best practices

HANA performance analysis and performance optimization

Develop SAP HANA information models (Graphical and SQL based Calculation views) for analyzing data and generating reports

Work Experience:
Cloud platform infrastructure and technology experience, preferably AWS or Azure

5+ years of SAP HANA experience

5+ years of architecture, direct development and support experience with the SAP Business Warehouse

Completed 2 or more large scale SAP ECC/HANA implementations

Experience with SAP HANA Database architecture, development and technologies such as: AMDP’s, ADBC, ABAP, HANA CDS, Calculation Views, Tables, synonyms, sequence, triggers, table functions and procedures using SQL/PL SQL scripts

Understanding of data transformation features such as: Preserving, Hierarchy Flattening, Match Transform, Data Cleansing Generator, Lookup, Fuzzy Lookup, etc.

Data provisioning in SAP HANA using various SAP HANA Techniques and External Tools

Working knowledge of and/or hands on experience with SAP HANA WEB IDE

Working knowledge of and/or hands on experience with SAP ETL Experience with BODS, SLT, SDI

Working knowledge of SAP HANA CDS

Good understanding of SAP HANA transport management

Knowledge of Analytical Privileges, Roles and Authorizations

Knowledge of SAP HANA Advanced Modelling (SAP HANA Text, SAP HANA Graph, SAP HANA Spatial, SAP HANA PAL) a plus

**Education**:
Bachelor’s Degree in MIS, Computer Science, or IT related field or equivalent IT related experience

SAP certifications a plus

IT Skills:
Experience with complex business projects

Demonstrated ability to understand business requirements and the implications of those requirements on current and future roadmaps

Understanding, at a detailed level, of all architectural dependencies of technologies in IT environments

Demonstrated behaviors of a curious, logical thinker and a strong systems aptitude

Proven ability to make and drive solution decisions

Experience with data migrations and coordination in a cross-project management team and business functions

Expertise with Data integration tools (including ETL and data replication tools)

Data Modelling concepts and tools

Continuous Integration and source control

Experience with scripting languages such as Python or javascript

Soft Skills:
Strong communication, presentation, documentation and interpersonal skills

Agile development processes (SCRUM and Kanban)

Experience with Jira a plus

At LSEG, we believe that creating a diverse and inclusive organisation