Excel Power Query

1 day ago

Kozhikode, 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

    1 day ago

    Kozhikode, 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 Engineer

    2 weeks ago

    Kozhikode, India Talogy Full time

    About the RoleThe Power BI Engineer will be responsible for building insightful Power BI reports that transform assessment data into actionable intelligence for both internal teams and external clients. Working with data from Talogy's Talent Measurement platform – a suite of applications that our clients use to manage their hiring process and deliver...

  • Principal electrical

    21 hours ago

    Kozhikode, India CareerXperts Consulting Full time

    Principal Electrical / Power System Engineer (Remote – Work with UK Clients!) We’re looking for a seasoned Power System Engineer to take the lead on grid connections, compliance, and network analysis for cutting-edge renewable and digital infrastructure projects.This remote role offers the chance to collaborate with UK-based clients and make a real...

  • Solar Technical Support Engineer

    1 week ago

    Kozhikode, Kerala, India Axis Power Full time ₹ 2,10,000 - ₹ 4,20,000 per year

    Education: B.Tech or Diploma in Electrical Engineering.Candidates should be located in keralaTechnical Expertise: Strong knowledge of electrical circuit design, switch gear components, and fabrication processes.Hands-on knowledge of Enphase microinverters, Envoy gateway, and Enlighten portal preferred.Strong understanding of AC/DC circuits, wiring, and...

  • Principal analytics consultant

    4 weeks ago

    Kozhikode, India Prospection Full time

    Are you passionate about turning real-world healthcare data into actionable insights that improve patient outcomes? At Prospection, we empower better healthcare decisions by uncovering meaning from large-scale health data sets and delivering powerful, data-driven strategies.We’re looking for an Principal Analytics Consultant to join our fast-growing team....

  • Data Science tranier

    1 week ago

    Kozhikode, Kerala, India Dataspark Full time ₹ 2,40,000 per year

    Data Manipulation: Proficiency in working with data using tools like SQL, Python, or R to extract, transform, and load data from various sources. This includes skills in data cleaning, data wrangling, and data integration.Statistical Analysis: Understanding of statistical concepts and techniques such as hypothesis testing, regression analysis, correlation,...

  • Regional technical sales Manager

    4 weeks ago

    Kozhikode, India SPECTRUM SOLAR POWER Full time

    Job Title: Technical Regional Sales Manager -MaleLocation: Calicut (Candidates must handle Kozhikode, Wayanad, Palakkad & Malappuram regions) About the Role:We are looking for a Technical Regional Sales Manager to lead and manage our sales operations across North Kerala. The ideal candidate should have strong technical knowledge in the Electrical /...

  • Senior Data Engineer

    3 days ago

    Kozhikode, India The Mastermind Group Full time

    Senior Data Engineer Location: Remote (India) – Occasional travel to Riyadh, KSAContract Type: 12-Month ContractWork Week: Sunday–Thursday preferred (9 AM – 5 PM IST)Start Date: As soon as possibleAbout The Mastermind Group (TMG)TMG is a global leader in IT Spend Optimisation, helping enterprises take control of their tech investments across software,...

  • Junior Data Analyst

    2 days ago

    Kozhikode, Kerala, India Odyssia Full time ₹ 1,80,000 - ₹ 2,40,000 per year

    IMMEDIATE JOINERS ONLYJob Summary:The Data Analyst will be responsible for collecting, analyzing, and managing data across approximately 10 production units to support business decision-making. This role requires expert-level Excel skills to create dashboards, reports, and actionable insights while ensuring accurate coordination between sales and production...

  • Area Manager

    6 days ago

    Kozhikode, Kerala, India Brainwire Analytics Full time ₹ 4,32,000 - ₹ 7,20,000 per year

    Max Salary upto 6LPAWe are seeking aproactive and driven Area Sales Managerto join ourfast-growing AI-powered FMCG platformthat connects retailers, manufacturers, wholesalers, and consumers on a single platform. This role offers the flexibility of remote work combined with customer visits, along with afixed salary, attractive incentives, and travel...