Excel power query

7 days ago

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

  • Data engineer

    2 days ago

    Aligarh, India Everise Full time

    Company OverviewJoin us on our mission to elevate customer experiences for people around the world. As a member of the Everise family, you will be part of a global experience company that believes in being people-first, celebrating diversity and incubating innovation. Our dedication to our purpose and people is being recognized by our employees and the...

  • Senior Data Engineer

    7 days ago

    Aligarh, India Amicon Hub Services Full time

    Must Have Skills:1. Strong expertise in SQL (complex queries, optimization, data modeling).2. Hands-on experience with SSAS (SQL Server Analysis Services).3. Deep understanding of OLAP cubes and multidimensional data models.4. Experience working with BI tools (e.g., Power BI, Tableau, or equivalent).

  • Store Incharge

    2 days ago

    Aligarh, Uttar Pradesh, India Aka Logistics Pvt Ltd Full time ₹ 4,00,000 - ₹ 8,00,000 per year

    Company DescriptionAka Logistics Pvt Ltd is a one-stop-shop offering comprehensive services to power plants. We specialize in Coal Supervision & Logistics and O&M support to Thermal Power plants. Our integrated coal logistic solutions serve as our competitive advantage, attracting and retaining customers. Leveraging a well-established network across various...

  • Lead Crystal Reports Developer

    3 weeks ago

    Aligarh, India Prasha Consultancy Services Private Limited Full time

    A US/Canadian Based IT MNC is hiring for Lead Crystal Reports Developer (v4.3).Work Location: RemoteShift Timings: 2:30 PM to 11:30 PMWe are seeking an experienced Senior Crystal Reports Developer with expertise in SAP Crystal Reports 4.3. The ideal candidate will be responsible for designing, developing, optimizing, and maintaining complex reports that...

  • Tele Calling Executive

    6 days ago

    Aligarh, Uttar Pradesh, India DIGIWORLD360SOLUTION Full time ₹ 48,000 - ₹ 96,000 per year

    As a Telecalling Sales Executive, your role involves contacting potential or existing customers over the phone to sell products or services. It requires a mix of communication, persuasion, and product knowledge. Your key responsibilities will include: - Calling customers from a given database or leads - Pitching products/services effectively - Understanding...

  • PowerShell Engineer

    7 days ago

    Aligarh, India People Prime Worldwide Full time

    About Company:- Our client is a Palo Alto–based AI infrastructure and talent platform founded in 2018. It helps companies connect with remote software developers using AI-powered vetting and matching technology. Originally branded as the “Intelligent Talent Cloud,” it enabled companies to “spin up their engineering dream team in the cloud” by...

  • Female Accountant

    7 days ago

    Aligarh, Uttar Pradesh, India K N Enterprises Full time ₹ 399 per year

    Job Description:We are seeking a dedicated and experienced female Accountant.The ideal candidate should have a strong background in accounting, proficiency in relevant software,and excellent customer handling skills.Key ResponsibilitiesMaintain day-to-day accounting records and transactionsHandle accounts payable and receivablePrepare GST returns, invoices,...

  • Design Engineer

    7 days ago

    Aligarh, India TIE-UPS Manpower Consultants Full time

    TIE-UPS is hiring for a leading Indian MNC - engaged in EPC Projects, Hi-Tech Manufacturing and Services. Operates in over 50 countries worldwide. Leaders in technology and Design. Excellent paymaster. Job descriptionHandle the design & engineering activity of electrical substations & Transmission Lines. Coordinate with internal teams, clients, &...

  • Microsoft Defender

    10 hours ago

    Aligarh, Uttar Pradesh, India P3sg Full time

    We're Hiring: Microsoft Defender XDR Lead SMELocation: Aligarh, India (Hybrid)Shift: Night-Mon-Fri from 6:00 IST to 3:00 IST Salary: 2,00,000 INR to 250,000 INR a MonthDepartment: Security Operations / Managed ServicesReports to: Director of Security Services Are you a Microsoft Defender expert ready to lead threat detection and response across...

  • Human Resources Payroll Assistant

    4 weeks ago

    Aligarh, India Curefoods Full time

    Company DescriptionCurefoods (EatFit) is a company that incubates food brands and operates state-of-the-art cloud kitchens & Dine-ins with a focus on making honest food that customers love. We aim to democratize access to good food in a sustainable manner by providing food that suits our customers' palettes and nutritional needs. Our current portfolio of...