Corporate Trust Consultants Pvt Ltd.

Overview: Corporate Trust Consultants is working to hire a Financial Data Analyst for one of it's leading clients. The client is an aspirational sports goods brand, based in the United Kingdom area, committed to delivering top-quality products for athletes worldwide. They have recently established presence in India, via a joint venture and are recognised across multiple global markets including UK, Australia, New Zealand, South Africa and India. Role Overview We are seeking a highly capable Financial Data & Reporting Analyst to join the team in Gurgaon (Delhi NCR). This is a mission-critical, full-time role supporting global operations and working closely with the CEO and Finance Director (UK). A major focus of this role is building and enhancing Power BI dashboards to deliver real-time financial and operational insights. You will consolidate and transform data from multiple systems (ERP, e-commerce, finance) into structured, finance-driven outputs that directly support strategic decision-making. The role combines finance expertise with advanced Power BI and Excel skills , ensuring leadership has the right numbers, in the right format, at the right time. Key Responsibilities Extract, validate, and reconcile data from ERP, e-commerce, and finance platforms to ensure accurate financial reporting . Build, maintain, and optimise Excel-based MIS reports using advanced formulas, pivot tables, and macros. Lead the design, development, and maintenance of Power BI dashboards , delivering insights on: P&L and profitability Gross margin analysis Revenue and sales trends Variance analysis and reconciliations Translate raw financial data into actionable Power BI visualizations for Finance, Sales, Production, and Marketing teams. Ensure data integrity and accuracy across Power BI models and dashboards. Identify automation opportunities using Power BI and Power Query to reduce manual reporting effort. Support the UK Finance Director with ad hoc financial analysis and scenario modelling . Provide commentary and business insights along with reports, not just visualizations. Qualifications & Experience Bachelors degree in Finance, Commerce, Business Analytics, or related field (B.Com, CA Inter, MBA Finance preferred). 3+ years of experience in financial reporting, MIS, or FP&A roles , with proven Power BI dashboard development experience. Strong expertise in Power BI (DAX, data modelling, visualization best practices) and Excel (advanced formulas, macros, modelling) . Familiarity with ERP (SAP B1) and e-commerce platforms (Shopify, BigCommerce), with exposure to accounting/reconciliation processes. SQL knowledge or database query experience desirable. Analytical mindset with financial acumen ability to interpret Power BI outputs into clear business recommendations. Excellent communication skills to explain dashboards and reports to both finance and non-finance stakeholders. Proficiency in English Language : As the role is for a UK based company with a multi cultural team, ability to clearly communicate with the team is essential. Interest in sports or involvement in a sports team is preferable but not mandatory. What We Offer Competitive salary package aligned with expertise. Opportunity to be the Power BI champion for the business, working directly with international leadership. Career growth into FP&A, advanced analytics, and automation leadership roles . Collaborative, professional environment in a well-connected location in Gurgaon, Delhi NCR. Additional visit(s) to the UK to build knowledge and business understanding over time. (initial training may be UK based). Location: Gurgaon (Delhi) Full-Time, Office-Based Reporting to: Finance Director (UK) Please send your resume and a cover letter outlining your relevant experience and interest in the role to hiring@corporatetrust.in or directly via WhatsApp using this link: https://api.whatsapp.com/send?phone=918800975967&text=Hello,%20I%20want%20to%20enquire%20about%20