Analytics Technical Analyst

At Alstom, we understand transport networks and what moves people. From high-speed trains, metros, monorails, and trams, to turnkey systems, services, infrastructure, signalling and digital mobility, we offer our diverse customers the broadest portfolio in the industry. Every day, 80,000 colleagues lead the way to greener and smarter mobility worldwide, connecting cities as we reduce carbon and replace cars.

OVERALL PURPOSE OF THE ROLE 
He/She will act as an Anaplan expert and ensure the Platform is suitable for user adoption as per the Business requirements and also compliant with security Alstom standards at all times. He/She will play a crucial role in implementing an architecture that is optimized for performance & storage. He/She is expected to lead/coordinate end to end Delivery on the Projects/demands.

In addition, He/She will be responsible for tracking the users and manage licenses to ensure compliance with the contractual objectives.

STRUCTURE, REPORTING, NETWORKS & LINKS 
Organization Structure  

CITO 
   |-- VP Data & AI Governance 
       |-- Enterprise Data Domain Director              

            |--Head of Analytics Platform

                |--Analytics Delivery Architect

                    |--Analytics Technical Analyst

 
Organizational Reporting: Reports to Head of Analytics Platform..

 
Networks & Links  Internally: Digital Platforms 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 

RESPONSIBILITIES: -

• Design, develop, and deploy interactive dashboards and reports using MS Fabric & Qlik Cloud (Good to Have), ensuring alignment with business requirements and goals.
• Implement and manage data integration workflows utilizing MS Fabric to ensure efficient data processing and accessibility.
• Use Python scripts to automate data cleaning and preprocessing tasks for Data models.
• Understand and integrate Power BI reports into other applications using embedded analytics like Power BI service (SaaS), Teams, SharePoint or by API automation.
• Will be responsible for access management of app workspaces and content.
• Integration of PowerBi servers with different data sources and timely upgradation/services of PowerBi
• Able to schedule and refresh jobs on Power BI On-premise data gateway.
• Configure standard system reports, as well as customized reports as required.
• Responsible in helping various kind of database connections (SQL, Oracle, Excel etc.) with Power BI Services
• Investigate and troubleshoot reporting issues and problems
• Maintain reporting schedule and document reporting procedures
• Monitor and troubleshoot data flow issues, optimizing the performance of MS Fabric applications as needed.
• Ensure collaboration with Functional & Technical 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.
• Ensure compliance with internal policies and regulations
• 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. 
• Good to have contribution to the integration and utilization of Denodo for data virtualization, enhancing data access across multiple sources.
• Facilitate effective communication with stakeholders regarding project updates, risks, and resolutions to ensure transparency and alignment.
• Participate in team meetings and contribute innovative ideas to improve reporting and analytics solutions.
  
  

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

Experience

• Minimum 3 and maximum 5 years of total experience
• Mandatory 2+ years of experience in MS Fabric Power BI End-to-End Development using Power BI Desktop connecting multiple data sources (SAP, SQL, Azure, REST APIs, etc.)
• Handson Experience in Python, R, and SQL for data manipulation, analysis, data pipeline and database interaction.
• Experience or Knowledge in using PySpark or Jupiter Notebook for data cleaning, transformation, exploration, visualization, and building data models on large datasets.

Technical competencies

• Proficient in using MS Fabric for data integration and automation of ETL processes.
• Knowlege in using Pyspark Modules for Data Modelling (Numpy, Panda)
• Handson &  in using Python , R Programming language for data processing. 
• Understanding of data governance principles for quality and security.
• Strong expertise in creating dashboards and reports using Power BI and Qlik.
• Knowledge of data modeling concepts in Qlik and Power BI.
• Proficient in writing complex SQL queries for data extraction and analysis.
• Skilled in utilizing analytical functions in Power BI and Qlik.
• Experience in Developing visual reports, dashboards and KPI scorecards using Power BI desktop & Qlik
• Hands on – PowerPivot, Role based data security, Power Query, Dax Query, Excel, Pivots/Charts/grid and Power View
• Good to have Power BI Services and Administration knowledge.

Important to note

As a global business, we’re an equal-opportunity employer that celebrates diversity across the 63 countries we operate in. We’re committed to creating an inclusive workplace for everyone.