Solution Expert -Datalake & Business warehouse

Req ID:447789 

Leading societies to a low carbon future, Alstom develops and markets mobility solutions that provide the sustainable foundations for the future of transportation. Our product portfolio ranges from high-speed trains, metros, monorail, and trams to integrated systems, customised services, infrastructure, signalling and digital mobility solutions. Joining us means joining a caring, responsible, and innovative company where more than 70,000 people lead the way to greener and smarter mobility, worldwide 

OVERALL PURPOSE OF THE ROLE

He/She will be responsible to provide business-driven end-to-end solutions to meet our customers’ needs in gaining insights from our enterprise data, Animate and reinforce BI and Data Analytics governance as well as designing technical architecture to ensure a stable solution for our customer centered around the BW and HANA platforms. He/She will also be responsible for demand management, Drive projects leading complex implementation, developing strategies, integration, enhancement, or audit projects. The Solution Expert -Data lake & Business warehouse reports to Delivery Manager.

STRUCTURE, REPORTING, NETWORKS & LINKS
Organization Structure

CITO
      |-- VP Business Solutions & Innovation
         |-- Digital Platforms & Enterprise Architecture Director
            |-- Analytics Platform Manager

               |--Domain lead - BI
                  |-- Senior Project Manager

                      |-- Solution Expert -Datalake & Business warehouse

Organizational Reporting: Reports to Senior Project Manager

Networks & Links
Internally: Shared Services Team, Digital Platform Team. Innovation Team ,Application Platform Owners, Business process owners, Infrastructure team
Externally: Third-party technology providers, Strategic Partners

Location: Position will be based in Bangalore
Willing to travel occasionally for onsite meetings and team workshops as required

RESPONSIBILITIES :-

1.As Solution Expert -Datalake & Business warehouse

Establish platform specific standards guidelines, checklists Best Practices for architectural development and compliance, Guidelines on Data refreshes, develop long term strategies, and roadmaps (12-36 months), in adherence to Enterprise standards.

Develop and Maintain Data Modelling and Data Management Architecture Strategies. Produce data Architectural design and guidance for complete application lifecycle design, development, deployment, support and Advanced Analytics solutions.

Provide data Solution Design for Complex Initiatives and perform data feasibility studies

Apply architectural and engineering concepts to design a solution that meets operational requirements, such as scalability, maintainability, security, reliability, extensibility, flexibility, availability and manageability.

Make recommendations and proposals for database optimization. Develop functional & technical design document to make SAP functional modules to Analytical systems as well as support business in pre-studies.

Strong ability to produce new technology specifications, solutions ,designed for optimal access. Demonstrate strong ability to gain buy-in on proposed solutions. Lead research and development efforts (proofs of concept, prototypes).

Ensure ADD (Architecture Design Document) are all up-to-date, complete the ADD for each new improvement of the Platform Maintain the CMDB and all the documents repository for all the platforms.

2. Plan and implement projects:

Develop a detailed project plan, define/validation of scope, objectives involving all relevant stakeholders ensuring technical feasibility. Monitor and track progress, Prepares action plans. Ensure that all projects are delivered on-time, within scope and within budget.

Provide technical expertise to propose effort estimates, work breakdown structures and technical resource planning for proposed and current work, to support the Demand Management process. Review the ongoing implementation solution for improvement opportunities.

Manage gates validations, Collaborate with the Shared Service Center on the scoping of complex uses cases delivered in Service Mode, Collaborate with the Project Delivery team on the scoping of complex uses cases delivered in Project Mode.

Provide assistance, coach ,mentor, on-the-job training with issues needing technical expertise or complex systems and/or programming knowledge.

Ensure collaboration Functional Architects as business cases are setup for each initiative, collaborate with other analytics team to drive and operationalize analytical deployment. Maintain clear and coherent communication, both verbal and written, to understand data needs and report results.

Strong ability to take the lead and be autonomous Proven planning, prioritization, and organizational skills. Ability to drive change through innovation & process improvement. Be able to report to management and stakeholders in a clear and concise manner.

TECHNICAL COMPETENCIES & EXPERIENCE

To be considered for this role, candidate need to demonstrate the following skills experience and attributes:

 Requisite Abilities and/or Skills:

• 10 + years of experience with SAP- Analytics and technologies like SAP HANA, SAP BW/BO,ETL, Data Analytics.
• Strong Experience in BW Security design & Administration / BW Analysis Authorization/Optimization and LSA++ architecture experience, modelling (ADSOs, Open ODS, Composite providers, HANA Calc views)
• Strong Experience in Info Provider Administration, Process Chain Administration, Administration, Working with the BW Trace Tool, Optimizing Performance for Info Providers, Data Acquisition Performance Through Partitioning, Managing Performance with BW Statistics
• With minimum 2+ years' experience on Native HANA 2.0 modelling (hands on), with deeper knowledge data integration with Data lake/data warehouse.
• BW on HANA 7.5 modelling (hands on), full lifecycle or green field implementations
• Experience to enable Data Provisioning by using standard SAP integration technologies (SDI, SLT, SDA & SDI)
• Strong Experience in SAP ECC extractors builds and enhancements using BADI and ABAP
• Strong techno-functional knowledge in one or more functional areas (Sales, Logistics, P2P, Production planning, Procurement, Finance(AR, AP, GL), Engineering and FI areas)
• Hands on experience in Designing, Developing & Maintaining advanced SAP BO reports using WEBI / Rich Client Experience in creating & maintaining advanced visualizations.
• Demonstrate ability to implement SAP security to prevent unauthorized access to data models. Strong knowledge on design and configuration of SAP HANA modelling Security authorization roles, use analytic privileges.
• SAP Certification : Application Associate - SAP HANA 2.0 SPS04 is a mandatory.
   
• Exposure to SOLMAN 7.2 charm tool is an added advantage.
• Build Report/Dashboards using SAC from different source systems is an added advantage.
• Have fair knowledge on Administrative maintenance tasks, Application Security, Patch updates and Upgrades is an added advantage.

 
EDUCATION
Bachelor’s/Master’s degree in Computer Science Engineering /Technology or related field