Talent.com
This job offer is not available in your country.
Excel Power Query & VBA Expert (Freelancer)

Excel Power Query & VBA Expert (Freelancer)

JS Accounting ServicesMeerut, IN
2 days ago
Job description

Excel Power Query & VBA Expert (Consolidation Template Developer)

Objective

We are seeking an experienced Excel Modeller and Power Query & VBA Expert on a contract / freelance basis for approx. 10-12 hours every week. Together with our group accounting experts, you will design, develop, and implement a dynamic, Power Query–driven Excel consolidation system that integrates local reporting packages into a centralized group consolidation model for multi-entity financial reporting.

The goal is to create an interactive, VBA-enhanced Excel application - a professional, audit-ready consolidation tool that automates data refreshes, validations, eliminations, and reporting across 10+ entities.

Key Responsibilities

  • Design the overall data architecture and file structure for the Excel-based consolidation environment.
  • Build the group consolidation workbook using Power Query, Power Pivot, VBA automation, and structured Excel tables through multiple iteration rounds together with our group accounting experts.
  • Implement dynamic data imports from all entity workbooks via Power Query.
  • Develop and automate consolidation logic (aggregation, FX conversion, intercompany elimination, equity consolidation) in collaboration with our group accounting experts.
  • Create VBA-driven workflows and control macros , e.g. one-click refresh, validation, consolidation, and reporting routines.
  • Develop reporting templates (P&L, Balance Sheet, Cash Flow, eliminations summary) and automate report generation (PDF / XLSX export).
  • Establish data quality controls and ensure a complete audit trail .
  • Prepare technical and user documentation and conduct training sessions with the finance team.

Qualifications

  • Advanced Excel skills : Power Query, Power Pivot, structured tables, and dynamic named ranges.
  • Strong VBA programming skills and ability to build automation routines that make the workbook operate like a small application.
  • Basic understanding of group accounting and consolidation principles
  • Experience building multi-entity consolidation models in Excel, including FX conversion and intercompany eliminations.
  • Knowledge of data structures , chart of accounts mapping , and foreign currency translation .
  • Strong analytical, testing, and documentation skills with attention to detail and audit-readiness.
  • Excellent communication and stakeholder management skills in English.
  • Why Join Us?

  • Fully remote position : Work from anywhere that suits you.
  • Flexible engagement : You manage your own schedule (contractor arrangement; you are responsible for local taxes and social security) and workload is approx. 10-12 hours every week and you can set your schedule (contractor work arrangement, you are responsible for local tax and social security)
  • Freedom and autonomy : We value independence and trust our team to manage their work effectively. A minimum of 5 hours of overlap with CEST (Switzerland) time zone is required.
  • Competitive rate : Up to USD 25 / hour (or local equivalent) , depending on experience.
  • Create a job alert for this search

    Excel Expert • Meerut, IN

    Related jobs
    • Promoted
    Remote US Recruiter ( IT & non-IT ) - Freelance Only

    Remote US Recruiter ( IT & non-IT ) - Freelance Only

    SnapX.aiMeerut, IN
    Remote
    Looking for a seasoned recruiter who can source, call and verify salaries of candidates for all IT and non-IT roles - with a focus on senior-level engineering positions. The roles span across IT, E...Show moreLast updated: 30+ days ago
    • Promoted
    Freelance Recruiter

    Freelance Recruiter

    upGrad RekrutMeerut, IN
    Job Description : Freelancer Recruiter.We are seeking an experienced and dynamic Freelance Recruiter to help identify, attract, and hire top talent for various freelance and contract roles across di...Show moreLast updated: 30+ days ago
    • Promoted
    OpenLink Endur Findur QA (Consultant / Senior / Principal Consultant)

    OpenLink Endur Findur QA (Consultant / Senior / Principal Consultant)

    KWA AnalyticsMeerut, IN
    About KWA Analytics : We are a global organisation offering a comprehensive range of consulting services for trade lifecycle management to clients involved in energy, commodities, shipping, treasury...Show moreLast updated: 30+ days ago
    • Promoted
    100% Remote - Microsoft Power Platform Developer (Model Driven Power Apps / Dynamics 365 CRM)

    100% Remote - Microsoft Power Platform Developer (Model Driven Power Apps / Dynamics 365 CRM)

    NovafyMeerut, IN
    Remote
    Microsoft Power Platform Developer.Microsoft Dynamics 365 ecosystem.The ideal candidate will be capable of designing and developing innovative solutions using tools such as Power Apps, Power Automa...Show moreLast updated: 30+ days ago
    • Promoted
    Senior Technical Analyst

    Senior Technical Analyst

    Insight GlobalMeerut, IN
    Strong experience within data validation, data testing and data accuracy.Fluent in English and ability to communicate with internal / external stakeholders. Experience with ETL Development.This role w...Show moreLast updated: 13 days ago
    • Promoted
    Excel Power Query & VBA Expert (Freelancer)

    Excel Power Query & VBA Expert (Freelancer)

    JS Accounting ServicesDelhi, Delhi, India
    Excel Power Query & VBA Expert (Consolidation Template Developer)ObjectiveWe are seeking an experienced Excel Modeller and Power Query & VBA Expert on a contract / freelance basis for approx.Together...Show moreLast updated: 1 day ago
    • Promoted
    US IT RECRUITER-W2 Recruiters

    US IT RECRUITER-W2 Recruiters

    QUALIS1 INCMeerut, IN
    W2 US IT Recruiter / W2 Recruiter / W2 Core Technical IT Recruiter.Job Description but not limited to : .Hands-on experience in end-to-end recruitment processes across various IT Technologies & Busin...Show moreLast updated: 8 days ago
    • Promoted
    SAP CPI Consultant

    SAP CPI Consultant

    K&K Talents - IndiaMeerut, IN
    This position is with one of our.Employment Type : Full-time Permanent.Experience Required : 8 Years in SAP CPI only.Working Experience on Groovy scripts & XSLT for writing custom scenarios.Strong kn...Show moreLast updated: 2 days ago
    • Promoted
    Power Apps Lead

    Power Apps Lead

    Exult GlobalMeerut, IN
    Bachelor's degree in Computer Science, Information Technology, or a related field.Power Apps development (both canvas and model-driven apps). Proficiency in Power Pages, Power Automate, Copilot Stud...Show moreLast updated: 30+ days ago
    • Promoted
    Freelance Consultant (Remote)

    Freelance Consultant (Remote)

    TaskifyMeerut, IN
    Remote
    We're Hiring "Freelance Consultant (Freelance / Remote)" | Earn up to $2500 per month.Contribute to training and refining cutting-edge AI systems. Adopt a “user mindset” to produce natural and realist...Show moreLast updated: 30+ days ago
    • Promoted
    • New!
    Excel Power Query

    Excel Power Query

    JS Accounting ServicesGhaziabad, Uttar Pradesh, India
    Excel Power Query & VBA Expert (Consolidation Template Developer).We are seeking an experienced Excel Modeller and Power Query & VBA Expert on a contract / freelance basis for approx.Together with ou...Show moreLast updated: 4 hours ago
    • Promoted
    US IT Recruiter

    US IT Recruiter

    Qualis1 Inc.Meerut, IN
    We are seeking a highly motivated.US IT recruitment process, with a proven track record of successfully placing candidates—especially with. You must be proactive, detail-oriented, and comfortable wo...Show moreLast updated: 16 days ago
    • Promoted
    Guidewire Billing Developer

    Guidewire Billing Developer

    The AES GroupMeerut, IN
    If you are passionate about Guidewire Billing and have strong hands-on development skills, this could be the right fit for you!. Guidewire development, including 3+ years in Guidewire Billing (Billi...Show moreLast updated: 13 days ago
    • Promoted
    Freelancer | ServiceNow LLM Trainer | 8$-10$ / Hr

    Freelancer | ServiceNow LLM Trainer | 8$-10$ / Hr

    PGC Digital (India) : CMMI Level 3 CompanyMeerut, IN
    We are seeking a ServiceNow Product Owner with deep functional expertise in relevant products - few of them being Customer Service Management (CSM), IT Service Management (ITSM), or HR Service Deli...Show moreLast updated: 2 days ago
    • Promoted
    IAM Analyst

    IAM Analyst

    Dexian IndiaMeerut, IN
    Contractual Role / Freelancer-3 Months.Skills-IAM, Data analysis or validation (Excel, VLookup, Macro), Query Language (SQL or PowerShell) , Python (Good-to-Have). Need basic IAM conceptual Knowledge....Show moreLast updated: 17 days ago
    • Promoted
    Dashboard Engineer – Datadog & Power BI

    Dashboard Engineer – Datadog & Power BI

    Mogra.aiMeerut, IN
    Month (with possibility of extension).You’ll work with senior engineers and business analysts, participating in live sessions to. UX design, clarity, and storytelling with data.Datadog and Power BI ...Show moreLast updated: 2 days ago
    • Promoted
    Information Technology Recruiter

    Information Technology Recruiter

    Best Infosystems Ltd.Meerut, IN
    IT Recruiter / Senior IT Recruiter – India (Work from Home) | Preference for Birlasoft Experience (Full-time / Contract). We are seeking a highly skilled and experienced Senior IT Recruiter with hands...Show moreLast updated: 16 days ago
    • Promoted
    SAP BODS

    SAP BODS

    Tata Consultancy ServicesMeerut, IN
    Excellent work experience with data migration using SAP BODS including experience on interface, IDocs, Batch Jobs, basic knowledge of ABAP debugging and very good understanding on SAP function modu...Show moreLast updated: 2 days ago
    • Promoted
    Guidewire Billing Center Developer

    Guidewire Billing Center Developer

    TechDoQuestMeerut, IN
    Over 7-8 years of hands on experience working as a Guidewire Developers.Experience with guidewire development language – GOSU. Experience with Guidewire Billing Integration.Show moreLast updated: 12 days ago
    • Promoted
    SAP BRIM (CM)

    SAP BRIM (CM)

    Radiansys Inc.Meerut, IN
    Location : Hyderabad / PAN India Wipro Location.Long term Contract To Hire(C2H).Experience 10 - 12 years of IT experience. S / 4 BRIM Billing Consultant, will be defining components of SAI Mediation CM W...Show moreLast updated: 2 days ago