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 ServicesTiruppur, IN
22 hours 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 • Tiruppur, IN

    Related jobs
    • 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)

    NovafyErode, 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
    Guidewire Developer

    Guidewire Developer

    CBTSCoimbatore, IN
    Over 5 years of hands-on experience working as a Guidewire Developers.Experience with guidewire development language – GOSU. Experience with Guidewire Billing Integration or Guidewire Billing Integr...Show moreLast updated: 30+ days ago
    • Promoted
    Remote US Recruiter ( IT & non-IT ) - Freelance Only

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

    SnapX.aiErode, 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
    US IT Recruiter - BFSI

    US IT Recruiter - BFSI

    PTR GlobalCoimbatore, IN
    Banking, Financial Services, and Insurance (BFSI).The ideal candidate should be familiar with end-to-end recruitment processes and have a strong understanding of technical roles and hiring practice...Show moreLast updated: 15 days ago
    • Promoted
    • New!
    Excel Power Query & VBA Expert (Freelancer)

    Excel Power Query & VBA Expert (Freelancer)

    JS Accounting ServicesCoimbatore, IN
    Excel Power Query & VBA Expert (Consolidation Template Developer).Together with our group accounting experts, you will design, develop, and implement a. Power Query–driven Excel consolidation system...Show moreLast updated: 22 hours ago
    • Promoted
    Senior Technical Analyst

    Senior Technical Analyst

    Insight GlobalTiruppur, 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: 11 days ago
    • Promoted
    Guidewire Billing Developer

    Guidewire Billing Developer

    The AES GroupErode, 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: 11 days ago
    • Promoted
    Freelance Consultant (Remote)

    Freelance Consultant (Remote)

    TaskifyTiruppur, 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!
    Vibe Coder

    Vibe Coder

    Evangelist AppsTiruppur, IN
    And we’re investing heavily in AI automation to change how engineering teams work across the world.If you're an AI-powered builder who ships fast and learns even faster — let’s talk.Build AI-powere...Show moreLast updated: 22 hours ago
    • Promoted
    SAP BRIM (CM)

    SAP BRIM (CM)

    Radiansys Inc.Tiruppur, 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: 1 day ago
    • Promoted
    OpenLink Endur Findur QA (Consultant / Senior / Principal Consultant)

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

    KWA AnalyticsTiruppur, 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
    SAP BODS

    SAP BODS

    Tata Consultancy ServicesTiruppur, 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: 1 day ago
    • Promoted
    • New!
    Freelancer | ServiceNow LLM Trainer | 8$-10$ / Hr

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

    PGC Digital (India) : CMMI Level 3 CompanyErode, 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: 22 hours ago
    • Promoted
    IAM Analyst

    IAM Analyst

    Dexian IndiaErode, 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: 16 days ago
    • Promoted
    • New!
    SAP CPI Consultant

    SAP CPI Consultant

    K&K Talents - IndiaCoimbatore, 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: 22 hours ago
    • Promoted
    Power Apps Lead

    Power Apps Lead

    Exult GlobalErode, 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
    • New!
    Freelancer-SAP FICO S / 4 HANA

    Freelancer-SAP FICO S / 4 HANA

    YASH TechnologiesTiruppur, IN
    YASH Technologies is looking for.If you're passionate about SAP and ready to take on exciting projects, we’d love to hear from you!.Show moreLast updated: 22 hours ago
    • Promoted
    Dashboard Engineer – Datadog & Power BI

    Dashboard Engineer – Datadog & Power BI

    Mogra.aiCoimbatore, 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: 1 day ago
    • Promoted
    Guidewire Billing Center Developer

    Guidewire Billing Center Developer

    TechDoQuestTiruppur, 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: 11 days ago
    • Promoted
    US IT RECRUITER-W2 Recruiters

    US IT RECRUITER-W2 Recruiters

    QUALIS1 INCErode, 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: 6 days ago