Analyst - CRM & BI (Microstrategy)

Job description

As a CRM & BI Expert – Customer Analytics at METRO GSC, you will play a key role in driving data-driven customer engagement and commercial decision-making across METRO’s international markets. You will work closely with CRM, Marketing, Data Science, BI and country teams to analyze customer behavior, evaluate marketing campaigns, develop dashboards and reporting solutions, and translate complex customer data into actionable business insights. The role combines Customer/CRM Analytics, Advanced SQL & Big Query, BI reporting and marketing analytics, with opportunities to support automation and customer communication initiatives across multiple countries. Key Responsibilities: • Analyze large customers, marketing and transactional datasets across METRO markets to identify trends, customer behavior and business opportunities. • Perform customer segmentation, CRM analytics and campaign performance analysis to optimize customer engagement and marketing effectiveness. • Integrate and analyze data from multiple sources to create a holistic, cross-channel customer view. • Develop and maintain BI dashboards, reports and visualizations to support business and management decision-making. • Conduct complex ad-hoc analyses and translate findings into actionable business recommendations. • Support loyalty, tier-based rewards, membership, upselling and cross-selling initiatives through data-driven insights. • Collaborate with country CRM/Marketing, Data Science and other cross-functional teams to deliver analytical solutions and support business requirements. • Ensure data quality, accuracy and process documentation, while identifying opportunities for automation and continuous improvement. CRM & BI Expert Job Description As a CRM & BI Expert – Customer Analytics at METRO GSC, you will play a key role in driving data-driven customer engagement and commercial decision-making across METRO’s international markets. You will work closely with CRM, Marketing, Data Science, BI and country teams to analyze customer behavior, evaluate marketing campaigns, develop dashboards and reporting solutions, and translate complex customer data into actionable business insights. The role combines Customer/CRM Analytics, Advanced SQL & Big Query, BI reporting and marketing analytics, with opportunities to support automation and customer communication initiatives across multiple countries. Key Responsibilities: • Analyze large customers, marketing and transactional datasets across METRO markets to identify trends, customer behavior and business opportunities. • Perform customer segmentation, CRM analytics and campaign performance analysis to optimize customer engagement and marketing effectiveness. • Integrate and analyze data from multiple sources to create a holistic, cross-channel customer view. • Develop and maintain BI dashboards, reports and visualizations to support business and management decision-making. • Conduct complex ad-hoc analyses and translate findings into actionable business recommendations. • Support loyalty, tier-based rewards, membership, upselling and cross-selling initiatives through data-driven insights. • Collaborate with country CRM/Marketing, Data Science and other cross-functional teams to deliver analytical solutions and support business requirements. • Ensure data quality, accuracy and process documentation, while identifying opportunities for automation and continuous improvement. Skills & Competencies: • Advanced SQL & BigQuery: Strong hands-on experience with SQL, including complex joins, CTEs, window functions, aggregations and query optimization; experience working with large datasets. • Customer & CRM Analytics: Strong understanding of customer behaviour, segmentation, campaign performance, customer lifecycle and marketing analytics. • BI & Data Visualization: Proficiency in BI reporting and dashboard development; experience with Power BI/ MicroStrategy/ QlikView is an advantage. • CRM & Marketing Technology: Exposure to Adobe Journey Optimizer, Adobe Campaign, Salesforce Marketing Cloud or CRM/marketing automation platforms is an advantage. • Analytics & Automation: Experience with Python, reporting automation and processing/transformation of large datasets is an advantage. • Business & Stakeholder Management: Ability to translate business requirements into analytical solutions, communicate insights clearly and work effectively with international, cross-functional stakeholders. • Personal Competencies: Strong analytical and problem-solving mindset, structured approach, attention to detail, proactive attitude, strong communication skills and ability to manage multiple priorities. Bachelor’s or Master’s degree in Business, Economics, Statistics, Data Analytics, Marketing, Computer Science or a related field. • 4-6+ years of relevant experience in Customer Analytics, CRM Analytics, Marketing Analytics, BI or related commercial analytics functions. • Strong hands-on experience in Advanced SQL, BigQuery and customer/marketing data analysis. • Experience working with large datasets, BI reporting and dashboard development. • Experience working with international / multi-country stakeholders is an advantage. • Experience in Retail, FMCG, Wholesale or E-commerce is preferred. • Strong professional English communication skills. Metro Global Solution Center (MGSC) is internal solution partner for METRO, a €31.6 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. Website: Company Size: 1000-1100 Headquarters: Pune, Maharashtra, India Type: Privately Held Inception: 2011 Job Description Role Overview As a CRM & BI Expert at METRO GSC, you will play a key role in supporting METRO’s global customer relationship management and business intelligence initiatives. You will support the shift toward data-driven, automated CRM by analysing data, generating insights, and providing actionable recommendations to improve commercial performance. This position requires strong analytical skills, attention to detail, and the ability to work collaboratively across teams and countries.