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 80000 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 & LinksInternally: Digital Platforms Team InnovationTeam ApplicationPlatform 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 Architectsasbusiness cases are setup for each initiativecollaborate 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 to drive change through innovation & process improvement. Be able to report to management and stakeholders in a clear and concise manner.
• Good to havecontribution 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
Bachelors/Masters 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 were an equal-opportunity employer that celebrates diversity across the 63 countries we operate in. Were committed to creating an inclusive workplace for everyone.