Excel Power Query

4 days ago

Bengaluru, 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 Developer

    5 days ago

    Bengaluru, India Growel Softech Pvt. Ltd. Full time

    Exp : 6 to 8 yearsLocation : BangaloreSkill : Power BI report and DAX experienceNote : Candidate to be flexible to work in shifts(2PM to 11 PM) 70% support, 30% Development AX queries and have experienceResponsibilities :- Develop and manage Power BI reports and dashboards to provide insights to stakeholders.- Collaborate with business analysts to understand...

  • Senior Power BI Developer

    5 days ago

    Bengaluru, India TekIT Software Solutions Pvt. Ltd. Full time

    Exp : 5 Years.Candidate must be local to Bangalore and Face to Face Interview.Notice Period : Immediate Joiner.Primary Tech Stack (Mandatory) :- Power BI.- Microsoft Fabric (One Lake, Lakehouse, Direct Lake mode).Secondary Tech Stack (Preferred) :- Dynamics 365 (D365).Job Description :We are seeking a highly skilled Senior Power BI Developer to lead the...

  • Visionet Systems

    5 days ago

    Bengaluru, India Visionet Systems Private Limited. Full time

    Key Responsibilities : - Design and develop interactive dashboards and reports in Power BI.- Connect to multiple data sources (SQL Server, Excel, APIs, etc.) and ensure accurate data modeling.- Collaborate with stakeholders to gather requirements and translate them into technical solutions.- Optimize data models for performance and scalability.- Implement...

  • Power BI Developer

    3 weeks ago

    Bengaluru, India EduRun Full time

    Key Responsibilities : - Design, develop, and maintain interactive Power BI dashboards and reports tailored to business needs.- Collaborate with stakeholders to gather and understand business requirements and translate them into technical specifications.- Build and optimize data models, write efficient DAX measures, and implement advanced analytics within...

  • Intern - Gas Power

    2 weeks ago

    Bengaluru, India GE Gas Power Full time

    **Job Description Summary**: If you love technology, sustainability, and want a career in engineering, an internship at GE Gas Power is for you! Assignments are engineering projects taking on the world’s toughest challenges - clean and affordable energy - and motivated by real business priorities. GE Gas Power Engineering Interns experience technically...

  • Power BI

    2 weeks ago

    Bengaluru, India Alp Consulting Ltd. Full time

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

  • Power BI

    2 weeks ago

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

  • Advanced Excel Specialist

    2 weeks ago

    Bengaluru, India Trigent Software Private Limited Full time

    Advanced Excel Specialist Location: Bangalore Exp: 2+Yrs About the Role We are seeking a highly skilled Advanced Excel Specialist to drive efficiency and insight through expert-level spreadsheet solutions. This role focuses on advanced formula development, dashboard creation, and process automation using Excel, Power Query, and VBA. The...

  • Advanced Excel Specialist

    2 weeks ago

    Bengaluru, India Trigent Software Private Limited Full time

    Advanced Excel Specialist Location: Bangalore Exp: 2+Yrs About the Role We are seeking a highly skilled Advanced Excel Specialist to drive efficiency and insight through expert-level spreadsheet solutions. This role focuses on advanced formula development, dashboard creation, and process automation using Excel, Power Query, and VBA. The ideal...

  • Power BI Developer

    12 hours ago

    Bengaluru, Karnataka, India Pradeepit Global Consulting Private Limited Full time ₹ 20,00,000 - ₹ 25,00,000 per year

    Power BI Developer Job Description: We are seeking a skilled Power BI Developer with 4-6 years of experience to join our dynamic team. The ideal candidate will have strong expertise in Power BI, SQL, and DAX queries, with a proven ability to work with semantic models and layers. Key Responsibilities:Develop, design, and maintain Power BI dashboards,...