This website uses cookies to ensure you get the best experience on our website. By continuing to use this site, you agree to our cookie  & privacy policy.Accept

checked This is a sample alert

Consultant - Excel Modelling Analyst

  • Full Time
  • On-Site - Mumbai
  • 6 months
  • Project posted on: 16/09/2026
add_new View Project Details

Consultant - Excel Modelling Analyst

  • Data and Analytics
  • Data Visualization & Reporting/Dashboarding
  • Database Management & SQL

On-Site - Mumbai

Full Time

6 months

 16/09/2026

Assignment Details

Our client, a leading real estate private equity firm, is looking for an Excel Modelling Analyst to support the development of structured data models, standardized templates, automated workflows, and reporting dashboards using Excel and Power BI. 

 

Key Responsibilities


1. Excel Modelling & Templatization

  • Build and maintain structured Excel models for reporting and analysis.
  • Convert manual and ad-hoc files into standardized, reusable templates.
  • Apply consistent formulas, formatting, and layout structures.
  • Ensure models are accurate, scalable, and error-free.


2. Data Structuring & Preparation

  • Clean, organize, and standardize raw data into structured formats.
  • Create lookup/mapping tables and normalized data structures to support automation.
  • Prepare data inputs and outputs for dashboards, reports, and recurring processes.
  • Ensure data is organized with consistent headers, formats, and data types.


3. Automation – VBA & Power Query

  • Develop and maintain VBA macros to automate repetitive tasks and reduce manual effort.
  • Troubleshoot, update, and optimize existing macro-enabled Excel files.
  • Use Power Query to import, clean, merge, and transform data.
  • Build refreshable data processes for periodic and month-end reporting.


4. Dashboarding & Reporting

  • Support the development of dashboards in Excel and Power BI.
  • Build charts, pivot tables, slicers, KPI summaries, and other visualizations.
  • Ensure dashboards have clear layouts, consistent formatting, and effective data presentation.
  • Convert structured data into business-ready reports and insights.


5. Power BI Support

  • Prepare datasets, relationships, and basic transformations using Power Query.
  • Support the development of Power BI visuals under guidance.
  • Develop familiarity with basic DAX formulas for calculated fields and measures.
  • Support data refresh cycles and basic troubleshooting.


6. Collaboration & Coordination

  • Work with internal teams to understand data and reporting requirements.
  • Support end-users with Excel templates, macros, and dashboards.
  • Document processes, workflows, and automation logic clearly.
  • Proactively communicate data issues and potential process improvements.

Note
Duration: 6 months
Location: Mumbai 
Nature: Full-Time (on-site)

Skills Required

  • Strong proficiency in Microsoft Excel, including formulas, pivot tables, charts, and formatting.
  •  Working knowledge of VBA, including writing/editing macros, debugging, and task automation.
  • Familiarity with Power Query 
  • Understanding of clean and structured data formats, including Excel tables and normalized layouts.
  • Good understanding of report formatting and data visualization.
  • Strong attention to detail and analytical mindset.
  • Eagerness to learn and work across Excel, automation, and BI tools.

Industry

Professional Services - Data Analytics

Experience Required:

3+ years

Additional Skills:

  • Database design and normalization
  • Data wrangling
  • Dashboard creation
  • Data analytics
  • Power Query
  • KPI definition and tracking
  • MySQL

No of open positions:

1

Similar Freelance Projects you can apply to

View More Projects btn btn

How it works

  • 1

    Build your
    skill profile

  • 2

    Strengthen it
    with feedback

  • 3

    Determine your
    optimal fee level

  • 4

    Apply for matching
    projects

  • 5

    Get finalized

  • 6

    Stay Engaged

Build your skill prodile

Project
step1
shape_step

Request feedback from prior projects and/or work stints

shape_step

Determine your optimal fee level

  • starFeeBee helps consultants understand how to price their services.
  • starEnter your skill & location to get ranges for what similar professionals have charged on projects.
  • starUnlock more details e.g., best paying sub-skills, ranges by projects durations, by simply adding a benchmark from a orior projects.
graph_step2
shape_step

Apply for matching projects

shape_step

Get finalized!

Project
step5
shape_step

Stay Engaged!

Project
step6
shape_step

More than 3000 clients rely on Flexing It today

Frequently asked questions.

We host both full-time & part-time projects from top clients for 100+ skill categories. We also help connect experts like you with clients for short consultation calls called Flexperts

You just need to create a ‘boutique firm’ account during the registration process. The rest of the application process remains the same.

Our freelancers fee benchmarking tool, FeeBee helps our freelancers and consultants find out what their peers charged for similar projects. Built on 600K+ verified benchmarks, registered users get unlimited access to it.

As a freelancing platform, we do not provide permanent positions or full-time job to our consultant network.

Flexing It will be involved end to end right from contracts to invoicing. Once you are finalized, your payment details are transparently laid out in your contract terms with your client and our team actively liaises with the client finance team to ensure timely payments.

We do not charge any fee or commission from you. Your fee quote will be paid out to you in full as per your project contract.

planGet alerts for new project opportunities.