Analyst - Customer Master Data Reporting Technical
METRO/MAKRO · Pune, Maharashtra, India
Wholesale · 5,001-10,000 employees
About the role
The role involves designing dashboards, schemas, and cubes in MicroStrategy while writing complex SQL scripts for data reporting. The analyst is responsible for maintaining functional specifications and improving application performance for customer master data.
What they look for
Requirements
Candidates must have mandatory experience in MicroStrategy development and SQL scripting, with a degree in IT or Computer Science. Proficiency in data modeling and visualization, along with strong analytical and communication skills, is required.
Full description
Company Description
Metro Global Solution Center (MGSC) is internal solution partner for METRO, a €31 Billion international wholesaler with operations in more than 30 countries. The store network comprises a total of 623 stores in 21 countries, of which 522 offer out-of-store delivery (OOS), and 94 dedicated depots. In 12 countries, METRO runs only the delivery business by its delivery companies (Food Service Distribution, FSD). 
 
HoReCa and Traders are core customer groups of METRO. The HoReCa section includes hotels, restaurants, catering companies as well as bars, cafés and canteen operators. The Traders section includes small grocery stores and kiosks. The majority of all customer groups are small and medium-sized enterprises as well as sole traders. METRO helps them manage their business challenges more effectively. 
 
MGSC, location wise is present in Pune (India), Düsseldorf (Germany) and Szczecin (Poland). We provide HR, Finance, IT & Business operations support to 31 countries, speak 24+ languages and process over 18,000 transactions a day. We are setting tomorrow’s standards for customer focus, digital solutions, and sustainable business models. For over 10 years, we have been providing services and solutions from our two locations in Pune and Szczecin. This has allowed us to gain extensive experience in how we can best serve our internal customers with high quality and passion. We believe that we can add value, drive efficiency, and satisfy our customers.
Job Description
Preferred Work Experience - 
- Hands on experience in MicroStrategy development and SQL writing scripts are mandatory.
- VBA Development and Advance Excel would be add on advantage.
- Professional experience in Master Data Administration and Quality Controlling.
- Comprehensive knowledge in database structures, data modeling and visualization, relevant languages ​​(SQL, R, Python)
- Independent, structured and goal-oriented way of working as well as distinct analytical and conceptual competence.
- Google Cloud knowledge would be add on advantage.
- Excellent communication skills.
- Able to build Logic in scripting.
Qualifications
- Any Graduation  or higher in computer ,Information Technology, or any IT degree
- B.Sc(IT),MCA,B.Tech,B.Sc(Com)
- Good communication skills to communicate with customers, team members
- Good analytical and problem-solving skills.
Additional Information
Required Technical Competencies - 
- Designing dashboard in MicroStrategy.
- Design and develop schema/cubes in MicroStrategy.
- Writing Strong SQLs.
- Modification in script as and when required.
- Come up with new ideas to simplify the work.
- Improve present application performance.
- Maintain documentation and functional specs.
Behavioral Competencies-
- Attention to Detail – Ensures accuracy in data extraction, transformation, and reporting.
- Analytical Thinking – Ability to interpret data patterns and generate insights.
- Problem-Solving – Identifies and resolves data discrepancies and performance issues.
- Proactiveness & Initiative – Suggests improvements for automation and process optimization.
- Stakeholder Collaboration – Engages with internal teams for seamless data integration.
- Communication Skills – Effectively conveys complex data concepts to technical and non-technical audiences.
- Adaptability & Continuous Learning – Stays updated on new technologies and industry trends.
- Work Model: Hybrid
