Group IT Controlling Internship – Finance, Data & AI

Pracovní nabídka

What will be your responsibilities?

• Support monthly closing, forecasting, budgeting and management reporting
• Perform data quality checks, reconciliations and variance investigation, including follow-up, clarification and alignment with local Finance and IT teams across countries
• Analyse IT OPEX, CAPEX, personnel expenses and key financial KPIs across multiple countries
• Run and improve automated first-level controls and investigate exceptions
• Support recurring Group IT reporting and management information in Power BI
• Uphold Group-wide reporting structures, definitions and data treatment across countries, ensuring deviations are identified and resolved so the Group view remains consistent and comparable
• Work with SQL to structure, transform and maintain financial and controlling data
• Support budgeting and forecasting processes in Microsoft Fabric Planning
• Identify repetitive activities suitable for automation and help improve them using Power Automate, AI agents and other tools
• Use enterprise AI tools in everyday analytical and controlling work

What do we expect from you?

• Basic understanding of OPEX, CAPEX and PEREX and their impact on EBITDA and net profit
• Some exposure to monthly closing, forecasting and/or budgeting
• Ability to understand and investigate financial variances
• Excel: good user knowledge, including modern functions (e.g. LET, FILTER, XLOOKUP; LAMBDA is an advantage)
• SQL: basic knowledge of SELECT (WHERE, AND/OR nested logic, CASE, aggregations and JOINs)
• Power Query: practical user knowledge; ability to understand and modify existing transformations
• Power BI, Power Automate, Microsoft Fabric Planning and Fabric PowerTable: nice to have, can be taught
• Long-term collaboration for 1 year; availability to work approximately 30 hours per week
• Advanced level of English, Czech/Slovak is an advantage

What do we offer?

• Working for the largest pharma retail company in Europe with great expansion plans
• A company with a meaningful purpose, an outstanding customer value proposition within an industry offering a resilient, non-cyclical growth pattern
• Global-level job within group headquarters with a group-wide impact
• Space for professional growth within a growing organization
• Hands-on experience across Finance, Data, IT and AI
• Access to Power BI, Microsoft Fabric, Power Automate and Microsoft Copilot; Claude Enterprise may be provided where justified by the use case
• Regular interaction with senior IT and Finance stakeholders, including the Group CIO
• Exposure to topics discussed at Group Board level
• VIP discount in Dr. Max pharmacies, meal allowance, Multisport card fully covered by employer, public transport contribution, pension insurance contribution, referral bonus etc.