Excel Power Query

2 days ago

bangalore, 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 ResponsibilitiesDesign 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. QualificationsAdvanced 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. 

  • Power BI

    16 hours ago

    bangalore, India Relevance Lab Full time

    Key Responsibilities Design and develop interactive dashboards and reports in Power BI using DAX, Power Query (M), and data modeling best practices. Build and manage Power Automate flows to streamline business processes and automate recurring data operations. Use Python for advanced data wrangling, API integrations, and custom analytics not natively...

  • Power BI

    2 days ago

    bangalore, India Relevance Lab Full time

    Key ResponsibilitiesDesign and develop interactive dashboards and reports in Power BI using DAX, Power Query (M), and data modeling best practices.Build and manage Power Automate flows to streamline business processes and automate recurring data operations.Use Python for advanced data wrangling, API integrations, and custom analytics not natively supported...

  • Power BI

    1 week ago

    Bangalore, India Alp Consulting Ltd. Full time

    Experiance 4+ Years in Power BI Technical Skills: Proficiency with Power BI tools, Data Analysis Expressions (DAX), Power Query , SQL , and basic ETL processes. Analytical Skills: Strong analytical and logical reasoning skills to analyze complex datasets and derive meaningful insights. Communication: Excellent verbal and written communication skills to...

  • Power BI Lead

    4 days ago

    bangalore, India Ascendion Full time

    🚀 We’re Hiring: Power BI Tech Lead | Immediate Joiners Only (0–15 Days)💡 Are you a Power BI expert ready to lead high-impact BI initiatives?Join Ascendion, where innovation meets opportunity — work on cutting-edge technologies, lead impactful BI solutions, and grow with a team that values excellence. 🚀💼 Key Highlights:Role: Power BI Tech...

  • Power Platform Developer

    4 days ago

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

  • Looker (SQL Query + ETL)

    2 days ago

    bangalore, India Tata Consultancy Services Full time

    SNRequired InformationDetailsRole-Looker TSR (Technical Support Representative)Required Technical Skill SetL1-L2 Looker, L1-L2 Data Visualization ETL tools, L1-L2 Cloud OpsDesired Experience Range3 to 7 yearsLocation of Requirement-Chennai, Gandhinagar,BangaloreDesired Competencies (Technical/Behavioral Competency)Must-Have(Ideally should be at least 3 years...

  • Power BI

    2 weeks ago

    bangalore, India Alp Consulting Ltd. Full time

    Experiance 4+ Years in Power BITechnical Skills:Proficiency with Power BI tools, Data Analysis Expressions (DAX), Power Query, SQL, and basic ETL processes. Analytical Skills:Strong analytical and logical reasoning skills to analyze complex datasets and derive meaningful insights. Communication:Excellent verbal and written communication skills to effectively...

  • Power BI Developer

    4 days ago

    bangalore, 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 8Location - Kolkata, Bengaluru Required 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 days ago

    bangalore, India Tredence Inc. Full time

    Role - PowerBI DeveloperExperiance Level - 6 - 8 YearsMandatory Skills - Power BI , SQL , Semantic Models, DAX Queries , PowerBI ServicesJoining Time - Immediate to 15 Days (Oct 2025 Joiners)ResponsibilitiesOwnership to ensure the proposed design/ architecture, deliverables meets the client expectation and solves the business problem with high degree of...

  • Power bi developer

    1 week ago

    Bangalore, India Nityo Infotech Full time

    Job Title: Power BI Developer Location: Bangalore (ITPL) Experience: 3–6 years (with minimum 2 years in Power BI development) Employment Type: Full-time Job Summary We are seeking a skilled Power BI Developer to design, develop, and maintain business intelligence solutions that transform raw data into actionable insights. The ideal...