Solution Expert -Datalake & Business warehouse

Apply now »

Date: 9 May 2024

Location: Bangalore, KA, IN

Company: Alstom

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 



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.


Organization Structure

      |-- 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




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.



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.

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




The candidate should demonstrate:
• Structured thought process and articulation Critical thinking and problem-solving skills
• Analytical bent of mind and be willing to question the status quo Possess excellent soft skills.
• Ability to create a strong network of relationships among peers, internal partners, and external constituencies
• Individual contributor and proactive and have leadership skills. Be able to guide and drive team from technical stand point.

• Excellent written, verbal, and interpersonal skills. Self-motivated, quick learner is a must.
• Be fluent in English
• Be able to influence and deliver


Alstom is the leading company in the mobility sector, solving the most interesting challenges for tomorrow’s mobility. That’s why we value inquisitive and innovative people who are passionate about working together to reinvent mobility, making it smarter and more sustainable. Day after day, we are building an agile, inclusive and responsible culture, where a diverse group of people are offered opportunities to learn, grow and advance in their careers, with options across functions and geographic locations. Are you ready to join a truly international community of great people on a challenging journey with a tangible impact and purpose?  


Equal opportunity statement:
Alstom is an equal opportunity employer committed to creating an inclusive working environment where all our employees are encouraged to reach their full potential, and individual differences are valued and respected.  All qualified applicants are considered for employment without regard to race, colour, religion, gender, sexual orientation, gender identity, age, national origin, disability status, or any other characteristic protected by local law. 


Job Segment: Information Technology, IT Architecture, Computer Science, Database, Business Process, Technology, Management

Apply now »