Excel Power Query

2 days ago

Delhi, India JS Accounting Services Full time

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. 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.

  • Excel Power Query

    3 days ago

    Delhi, India JS Accounting Services Full time

    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. 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...

  • Excel Power Query

    2 days ago

    New Delhi, India JS Accounting Services Full time

    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. 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...

  • Mis Executive

    3 days ago

    Delhi, Delhi, India CHAMP EXCEL PRIVATE LIMITED Full time

    **Excel & Power BI Expert - MIS Executive** Are you an Expert in Microsoft **Excel**, **Power Query** & **Power BI? **Are you proficient in Excel Formulas, Automation & Dashboard creation? Do you also have exceptional people skills to thrive in client-facing roles? If so, Join Us. **Role Overview**: As the Automation Project Manager, you will be automating...

  • Power System Analyst

    1 day ago

    Delhi, Delhi, India Tata Power DDL Full time ₹ 15,00,000 - ₹ 35,00,000 per year

    Position: Power System Analyst Tata Power Delhi Distribution Limited (TPDDL) has collaborated with FSR Global on advancing energy transition research, capacity building, and regulatory excellence. Our aim is to work in areas of sustainable development of power sector, which include, but not limited to, regulatory and policy-based research, innovation in...

  • Power BI

    2 weeks ago

    Delhi, Delhi, India Tecnoprism Pvt Ltd Full time ₹ 1,20,000 - ₹ 3,00,000 per year

    Job Role:Power BI , Power App, SQL ExpertLocation:Delhi NCR / KolkataExperience:8+ YearsNotice:Immediate to 15 DaysRequired Skills :Proficiency in Power BI & Power App.Minimum 5+ years of experience in Power BI.Minimum 3+ years of experience in Power App.Experience in business analysis and requirement gathering.Excellent communication and documentation...

  • Power BI Developer

    1 week ago

    New Delhi, India Kanerika Inc Full time

    Role We are looking for a Power BI Developer with over 0-2 years of experience in building dashboards, reports, and data models. The candidate should have solid knowledge of DAX, Power Query (M), and SQL, and be capable of delivering insightful and interactive business reports based on requirements from business stakeholders.Job Location– HyderabadKey...

  • Power BI Developer

    2 days ago

    New Delhi, India Kanerika Inc Full time

    RoleWe are looking for a Power BI Developer with over 1-2 years of experience in building dashboards, reports, and data models. The candidate should have solid knowledge of DAX, Power Query (M), and SQL, and be capable of delivering insightful and interactive business reports based on requirements from business stakeholders.Job Location – HyderabadKey...

  • Excel Expert

    6 days ago

    Delhi, Delhi, India Beagle Full time ₹ 15,00,000 - ₹ 25,00,000 per year

    Develop and maintain complex Excel models for financial forecasting, budgeting, and variance analysis, ensuring data accuracy and integrity.Create dynamic dashboards and reports using advanced Excel features like Power Query, Power Pivot, and VBA to visualize key performance indicators (KPIs) and trends.Automate repetitive data entry and manipulation tasks...

  • Power BI Developer

    4 days ago

    New Delhi, India Coforge Full time

    Power BI DeveloperJob Location: Greater NoidaExperience Required: 04 to 07 YearsMandatory Skills: Power BI, Business Intelligence, DAX Query, SQL Queries, Power Query, Insurance, P&C, Property & CasualtyJob Description:- Develop, design & implement interactive Power BI dashboards and reports based on business requirements and data insights. - Collaborate...

  • Power BI Developer

    2 days ago

    New Delhi, India Coforge Full time

    Power BI DeveloperJob Location:Greater NoidaExperience Required:04 to 07 YearsMandatory Skills:Power BI, Business Intelligence, DAX Query, SQL Queries, Power Query, Insurance, P&C, Property & CasualtyJob Description: Develop, design & implement interactive Power BI dashboards and reports based on business requirements and data insights. Collaborate with...