Prepare timely MIS reports, perform variance and trend analysis, support budgeting/forecasting, build financial models, extract and reconcile data using SQL, automate reports with VBA/Python, and create dashboards for stakeholders.
Job Summary
We are looking for a Finance Analyst to support end-to-end finance and accounting operations, ensure accurate financial reporting, MIS, Data Models, ERP, Advance Excel, VBA, Macros, Support Budgeting and Forecasting, for a fast-paces media and publishing house.
Key Responsibilities:
1. Financial Analysis & Reporting
- Prepare and publish daily, weekly, and monthly MIS reports, ensuring 100% accuracy and timeliness.
- Conduct Variance analysis (Actual vs. Budget/Forecast) and provide commentary on financial performance, revenue, and cost trends.
- Support budgeting, forecasting estimates in collaboration with cross-functional teams.
- Create financial models to predict future performance and evaluate investment opportunities or risks.
2. Data Management & SQL
- Extract, clean, and manipulate large datasets from multiple sources (ERP, CRM, Data Warehouses) using SQL queries.
- Validate data integrity and investigate financial discrepancies by writing complex SQL scripts and reconciling data across systems.
- Handle data transformation tasks including data cleansing, merging, and formatting to prepare it for final reporting.
3. Excel & Automation
- Utilize Advanced excel functions (Index-Match, Nested VLOOKUP, Pivot Tables) to manage complex financial data models.
- Automate repetitive reporting tasks using VBA/Macros or Python to reduce turnaround time (TAT) and manual errors.
- Design and maintain interactive dashboards (using Excel or Power BI) to visualize KPIs for non-technical stakeholders.
4. Process Improvement
- Identify bottlenecks in current reporting processes and re-engineer spreadsheets for better efficiency.
- Collaborate with the IT/Data team to automate data pipelines and enhance system performance for finance workflows.
Skills Required: (Must Have)
Technical Skills
- Excel Mastery: Expert - level knowledge of Macros (VBA), Power Query, and advanced formulas.
- Database Management: Strong command of SQL (Select, Join, Group By, Sub-queries) for data extraction and validation.
- MIS Reporting: Proven experience in preparing Management information systems (MIS) reports and dashboards.
- Visualization: Basic to Intermediate knowledge of Power BI or Tableau.
Preferred Skills:
- Analytical and problem-solving mindset
- Ability to work in a fast-paced environment
- Strong attention to detail and process orientation
- Experience handling audits and compliance independently
- Strong Communication, interpersonal and team management skills
Qualification & Experience
- Bachelor’s degree in commerce, Finance, Accounting, or related discipline.
- 3–5 years of relevant experience in financial reporting, MIS, Data Models, ERP, Advance Excel, VBA, Macros, Support Budgeting and Forecasting
- Experience in media, publishing, advertising, digital media, or service industries will be an added advantage.
About us: https://www.burdaluxury.com/
BurdaLuxury is one of Asia’s most vibrant and progressive independent media houses. Our portfolio includes a variety of successful regional publishing brands in lifestyle and luxury markets across Hong Kong, India, Malaysia, Singapore, and Thailand. Print publications include AUGUSTMAN, HELLO! Magazine Thailand, Prestige, and PIN Prestige. Digital offerings include Lifestyleasia.com, Augustman.com, PrestigeOnline.com, and PinPrestige.com.
Similar Jobs
Aerospace • Information Technology • Software • Cybersecurity • Design • Defense • Manufacturing
Support program finance for Boeing Defense India by maintaining program financials, forecasts, variance analysis, and planning systems. Partner with program, supply chain, FP&A and accounting teams to produce reports, dashboards, estimates, and rates. Identify drivers of variance, recommend actions, support long-range planning, and pursue automation opportunities. Provide timely, accurate financial information and back up team members as needed.
Top Skills:
MacrosExcelMs PowerpointMs WordPower BISAPTableau
Big Data • Food • Hardware • Machine Learning • Retail • Automation • Manufacturing
The Analyst will manage financial performance for external manufacturing sites, conduct cost analysis, support procurement negotiations, and ensure compliance with financial policies.
Top Skills:
ExcelSAP
Information Technology • Insurance • Professional Services • Consulting
Prepare, analyze, and present daily, weekly, and monthly financial reports for credit control. Perform trend analysis with commentary, ensure reporting accuracy through cross-team collaboration, build stakeholder relationships, and support audit activities in a dynamic environment.
Top Skills:
Aged Debt SystemsIrisExcelMicrosoft WordPower BI
What you need to know about the Delhi Tech Scene
Delhi, India's capital city, is a place where tradition and progress co-exist. While Old Delhi is known for its rich history and bustling markets, New Delhi is defined by its modern architecture. It's clear the region places a strong emphasis on preserving its cultural heritage while embracing technological advancements, particularly in artificial intelligence, which plays a central role in shaping the city's tech landscape, fueled by investments in research and development.
