Excel Power Query

3 weeks ago

India JS Accounting Services Full time

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.

  • Excel Power Query

    3 weeks ago

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

  • Power Bi

    4 days ago

    India AES Technologies Pvt. Ltd. Full time

    Power BI Responsibilities - Recognize business requirements in the context of BI and create data models to transform raw data into relevant insights - Using Power BI, create dashboards and interactive visual reports - Define key performance indicators (KPIs) with specific objectives and track them regularly - Analyze data and display it in reports to aid...

  • Power Platform Developer

    3 weeks ago

    India canadainternationalprojects Full time

    Job Title: Power Platform Developer (Power Apps & Power Pages) Experience: 5+ Years Location: Remote Shift Timing: Must work on Eastern Time zone Job Summary We are seeking an experienced Power Platform Developer with expertise in Power Apps (Canvas & Model-Driven) and Power Pages to design, develop, and deploy scalable business applications using Microsoft...

  • Power Platform Developer

    3 weeks ago

    India canadainternationalprojects Full time

    Job Title: Power Platform Developer (Power Apps & Power Pages) Experience: 5+ Years Location: Remote Shift Timing: Must work on Eastern Time zone Job Summary We are seeking an experienced Power Platform Developer with expertise in Power Apps (Canvas & Model-Driven) and Power Pages to design, develop, and deploy scalable business applications using Microsoft...

  • Power BI Developer

    5 days ago

    Hyderabad, India Coforge Full time

    Job Description Role - Power BI Developer Required Qualifications: 1. Bachelors (or above) degree in Computer Science. 2. Information Systems, Engineering, or a related field. 5-7 years of experience with Power BI, Microsoft SQL Server programming, and Snowflake Integration. 3. Excellent communication and collaboration skills. 4. Technical Skills Very strong...

  • Power Platform Developer

    3 weeks ago

    india, IN canadainternationalprojects Full time

    Job Title: Power Platform Developer (Power Apps & Power Pages)Experience: 5+ YearsLocation: RemoteShift Timing: Must work on Eastern Time zoneJob SummaryWe are seeking an experienced Power Platform Developer with expertise in Power Apps (Canvas & Model-Driven) and Power Pages to design, develop, and deploy scalable business applications using Microsoft Power...

  • Power Platform Developer

    3 weeks ago

    India canadainternationalprojects Full time

    Job Title: Power Platform Developer (Power Apps & Power Pages)Experience: 5+ YearsLocation: RemoteShift Timing: Must work on Eastern Time zoneJob SummaryWe are seeking an experienced Power Platform Developer with expertise in Power Apps (Canvas & Model-Driven) and Power Pages to design, develop, and deploy scalable business applications using Microsoft Power...

  • Power BI Developer

    3 weeks ago

    India RED Global Full time

    RED is currently seeking a Power BI Developer for an initial 6-month + contract with one of our global consulting clients. Ideal candidates will have hands-on experience integrating Power BI with SAP S/4HANA and will be capable of delivering solutions that go beyond standard, out-of-the-box dashboards, and reports.Location REMOTE Suitable candidates will...

  • Power BI Developer

    3 weeks ago

    india Tata Consultancy Services Full time

    Role -Power BI Developer Required Technical Skill Set -Power BI, AWS/Azure, SQL, ETL, DAX Experience Range -4 to 8 Location -Kolkata,BengaluruRequired Technical Skill:Extensive hands-on experience in developing Intuitive visualization, Dashboards, KPI scorecards, Charts, Graphs using Power BI Experience in writing complex DAX queries and using M Query...

  • Power BI Developer

    4 weeks ago

    India Cube Hub Inc. Full time

    Job Description Job Title: Power BI Developer (SAP HANA to Snowflake ) Job Location: Position is 100% remote, offshore (India) Job Duration: 4 months Bachelor's degree in Computer Science, Information Systems, or a related field. 3+ years of experience in Power BI development. Strong knowledge of DAX, Power Query, and data modeling techniques. Experience...