Financial Data Analyst

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 acumenability 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 or directly via WhatsApp using this link:

,%20I%20want%20to%20enquire%20about%20