11+ Excel Modeling Jobs in Delhi, NCR and Gurgaon | Excel Modeling Job openings in Delhi, NCR and Gurgaon
Apply to 11+ Excel Modeling Jobs in Delhi, NCR and Gurgaon on CutShort.io. Explore the latest Excel Modeling Job opportunities across top companies like Google, Amazon & Adobe.
What you will do:
- Creating and updating proprietary models/spreadsheets for the prospective investments
- Analysing financial information and conducting analytic and strategic research.
- Inputting data into proprietary financial models and ensuring the accuracy of data and output based on the data.
- Creating Automations using VBA and other tools wherever needed.
- Compiling historical data in respect of stocks and companies from publicly available sources.
- Updating and maintaining databases to track relevant financial, economic or other indicators which may be relevant to the sector and/or region under coverage
- Assisting with other company and industry related analysis as may be required by the Fund Manager
- Monitoring relevant market news and information
- Assisting with the preparation and development of research reports, industry primers and marketing presentations.
- Financial Modelling Experience is a must and a person should be excellent at this. This is the main part of the job along with research on the Financial Numbers
- Excellent understanding of Financial Statements and Accounting Standards.
- Qualified CA
- Financial Statements Audit experience preferred
- The ability to work independently and proactively
- Person should be passionate for Equities
- Strong proficiency in Advanced Excel, VBA.
- Proficiency in data science tools and languages (SQL and Python) will be considered as a great positive but not a necessary requirement
About Company
Our client is an integrated workforce management software platform offering intelligent automation for daily work orders management, Housekeeping activities, facility maintenance, scheduling & labour management, and time & attendance purpose built for the hospitality market and other dynamic scheduling environment.
About the job
As an Assistant Manager – Finance & Accounts, you would be responsible for managing Accounts payable, Banking & Payments, Monthly Closing and Reconciliations, Statutory Filings - Audit & Secretarial and other related activities.
Roles & Responsibilities:
• Daily & Weekly review - Vendor bills, employee expense reimbursement & other transactions according to stipulated guidelines.
• Preparation of weekly payment tracker file and weekly payment uploads in different banking portals
• Corporate Card transactions review & reconciliations.
• Maintain Fixed Assets Register.
• Coordinating with Account Executives, Vendors & Internal teams on routine stuff
• Weekly & Monthly bank reconciliations in Intacct for all the 5 entities.
• Petty Cash Management & Payouts.
• Imprest Accounts reconciliations.
• Monthly TDS - transaction verification and payments.
• Accruals and Prepaid Exp Tracker - Booking of accounting transactions & completion of reconciliation statement on monthly basis.
• AP Ageing reconciliation with Trial Balance.
• Inter Company reconciliations – monthly.
• Statutory Monthly & Quarterly Tax Returns - Overseas & India (VAT & GST).
• TDS, GST & VAT Returns - Data validation and coordination with consultants for filing
• Foreign Lability & Assets Report (FLA), MSME Returns, MCA filings, APR filings, ROC and other related filings
• Board Minutes - Data sharing and coordination with consultants.
• Tax Returns filings verification.
• Assistance to Internal teams in Annual Audits.
• Project assigned by Finance Head & Finance Manager.
Requirements:
• Master’s Degree in of Commerce (M. Com)
• 7-9 years of relevant experience
• Robust oral and written communication and presentation skills
• High degree of computer literacy, working knowledge of Microsoft Office suite, especially MS Excel
• Experience in any ERP like Quickbooks, Intacct, Tally, Expensify etc.
• Strong attention to deadlines and detail – ability to handle multiple tasks simultaneously.
About Company
One of the India's leading Renewable Energy Consultants, working with large commercial and Industrial clients and helping them choose right Renewable Energy solution for them.
Roles & responsibilities:
• Research and Analysis in the Renewable Energy Sector of the regulations,policies, market competitors, key developers
• Creating and maintaining Financial Models and Financial Calculators as per the Customer’s and Company’s requirements
• Supporting in the Transaction Execution and in signing the PPA documents with the customers
• Preparation of Financial Modeling, corporate presentations, and information memorandum, RFS
Requirements:
MBA in Finance or comparable qualification with 8 -16 months of experience and excellent knowledge of Microsoft Excel
• You must have excellent knowledge and hands on for Ms Excel.
• You must have strong analytical (quantitative as well as qualitative) skills including building financial models
• You should have a strong financial statement analysis foundation
• You should have great research capabilities and understanding of the power and utility sector with a focus on solar, wind, and new upcoming technologies
• You should have excellent communication, writing skills, report-writing, and presentation skills
About Us
Classplus is India's largest B2B ed-tech start-up, enabling 1 Lac+ educators and content creators to create their digital identity with their own branded apps. Starting in 2018, we have grown more than 10x in the last year, into India's fastest-growing video learning platform.
Over the years, marquee investors like Tiger Global, Surge, GSV Ventures, Blume, Falcon, Capital, RTP Global, and Chimera Ventures have supported our vision. Thanks to our awesome and dedicated team, we achieved a major milestone in March this year when we secured a “Series-D” funding.
Now as we go global, we are super excited to have new folks on board who can take the rocketship higher🚀. Do you think you have what it takes to help us achieve this? Find Out Below!
What you will do
Need a process and a detail-oriented candidate for our Account payable department in the Finance function
- Establish and maintain financial controls, internal financial controls, and procedures for the company. Eg P2P, R2R, etc.
- Ensure that payments are processed as per the internal controls with all the proper support.
- Account the expenses properly in the corresponding GLs.
- Implement timely payment to the vendors as well as timely booking and processing of the payment.
- Work with the business team and close all escalations.
- Prepare monthly MIS with schedules of all the expenses and balance sheet items as well as Month-end closure (M+1) and provision of the expense.
- Investigate reasons of creditors outstanding > 60 days, advance standing > 30 days & provision > 30 days.
- Ensure that there are no debit balances in sundry creditors and advances > 30 days.
- Spearhead the validating, booking, and processing of the salary, F&Fs & business reimbursements.
- Forecast the working capital requirement.
- Supervise accounting and validation of Fixed assets and maintaining FAR.
- Close the internal audit, statutory audit, and due diligence as well as daily BRS.
- Accurately calculate and pay the monthly TDS and monthly GST
- Assist the consultant with filing the TDS return and GST return
- Ensure the payroll compliance is done as per the relevant act.
You should apply if you
- Bring your Financial A-game: Should be well versed with Accounting Standard and IndAS, TDS, GST, Foreign Payments, and Payroll compliance (PF, ESIC, Gratuity, PT, LWF)
- Are good with the ‘toys’: Proficient in Excel & Powerpoint. Working knowledge of Zoho & SAP.
- Are a seasoned veteran: CA with 5-6 years of experience and should have worked with a startup
- Can cut a good deal: Always eager to cut short the operating expenses.
Early joiners preferred.
Being a Part of the Clan!
At Classplus, you’re not an “employee” but a part of our “Clan”. So, you can forget about being bound by the clock as long as you’re crushing it workwise😎. Add to that some passionate people working with and around you, and what you get is the perfect work vibe you’ve been looking for!
It doesn’t matter how long your journey has been or your position in the hierarchy (we don’t do Sirs and Ma’ams); you’ll be heard, appreciated, and rewarded. One can say, we have a special place in our hearts for the Doers! ✊🏼❤️
Are you a go-getter with the chops to nail what you do? Then this is the place for you.
Do you wish to be a part of a disruptive team, passionate towards democratizing education for students across India? Then read more.
Our client is an expert in education financing and counselling related to higher studies abroad. They help students to understand about scholarships in various colleges abroad, whether they are eligible and how to apply for such esteemed institutions. Their dedicated page enlists every scholarship available across the globe, apart from other facilities required by students like visa counselling, forex, accommodation, Peer contacts etc.
They also offer the best resources for exams like IELTS, TOEFL and GRE apart from organising webinars and events to connect with industry experts, alumni and fellow students - that helps to prepare for these travels, loans and more. Partnered with the most prominent Banking and non-banking financiers, the team is led by FinTech-experienced IIT Kanpur alumni, passionate about offering sustainable financial offerings.
As an Audit Analyst, you will be responsible for preparing and updating audit plan, audit strategy, managing allocation of work, weekly work updates and guiding and reviewing work done by team.
What you will do:
- Preparing of schedules, cash flow statement, notes to the accounts, accounting policy and financial statements
- Preparing of tax audit annexures for tax audit including Form 3 CD
- Independently leading statutory and tax audit of private limited company
- Preparing or updating Internal Financial Control documents, risk control matrix etc as per company process
- Performing book closure activity as per audited financial statements
- Preparing or updating fixed asset register
- Reconciling fixed asset register, reserves and critical accounts as per IGAAP and US GAAP
- Representing as the primary contact point and supporting company assigned for audit to resolving internal/ external and escalated queries
- Collating and where necessary producing / analyzing statistical data/ reports as required
- Keeping up-to-date with key business changes and process/ technical.
- Preparing and value adding audit plan, tracker and supporting any process improvements
What you need to have:
- Core accounting and audit knowledge
- Thorough knowledge of accounting entries for all areas in financial statements, its impact on financials and audit as well.
- Basic understanding of significant process, flow of transactions of significant process
- Independently work of lead the audit
- Honor timelines and commitment towards deliverables
- Good MS Excel and MS word knowledge
- Good communication skills for handling internal teams, peers, supervisors, controller and external auditors
Our client is a unique hygiene products manufacturing and distribution company. They provide easy to use, portable and disposable items for women and babies that are required during travel or on a day-to-day basis.
Founded in 2014, this company aims to enhance the quality of life and make it easier for women across the country. Recommended by best of doctors, their products are available across wellness stores and e-commerce websites, and selling like hotcakes - having sold over 20000 packs in their first year itself.
- Monitoring and analyzing accounting data and producing financial reports or statements
- Managing and overseeing the daily operations of the accounting department including:
- month and end-year process
- accounts payable/ receivable
- cash receipts
- general ledger
- payroll and utilities
- treasury, budgeting
- cash forecasting
- revenue and expenditure variance analysis
- capital assets reconciliations
- trust account statement reconciliations,
- check runs
- fixed asset activity
- debt activity
- Establishing and enforcing proper accounting methods, policies and principles
- Coordinating and completing annual audits
- Providing recommendations
- Improving systems and procedures and initiating corrective actions
- Assigning projects and directing staff to ensure compliance and accuracy
- Meeting financial accounting objectives
- Establishing and maintaining fiscal files and records to document transactions
- Must have working experience on tally ERP.
- Having good knowledge of GST TDS is a must
- Should be able to create and maintain Balance sheet and P&L Accounts
- Must be able to join immediately
They are currently providing 800 beds in 13 locations, and plan to add another 1600 in the next few months, with the aim to add at least a lac bed in the near future. The spaces offered by them are highly rated by their customers and are preferred over other competitors for the location and services offered within a decent budget. Invested by some very well known names across Asia, it provides their team with a work culture that thrives on modern yet social and explorative values.
What you will do:
- Leading in finance initiatives like ERP transition
- Leading financial close review with controllership team including month-end close call, finalization of P&L accounts, balance sheet and trial balance
- Responsible for reviewing the balance sheet and P&L schedules for the controllership review
- Highlighting and driving the necessary action points
- Leading the team to prepare and understand the month end flux analysis for all P&L and balance sheet accounts with the in depth analysis
- Understanding and influencing the design of financial systems
- Ensuring appropriate financial policies, procedures and internal controls are in place, documented and driving process improvements
- Interacting and working closely with the internal and external auditors on audit related queries and ensuring timely completion of the audits
Desired Candidate Profile
What you need to have:- CA with more than 8 years of experience in Finance, Accounts, Tax, Budgeting, Liaising, Purchase, Data Analysis and Fund Management
- Demonstrative excellence in conceptualizing and implementing effective management systems to improve financial controls and financial discipline in the organisation
- Expert in analyzing existing systems and procedures, designing internal control systems, facilitating and influencing effective decision-making based on intensive financial analysis of facts and figures
- Excellent in managing the business continuity and disaster recovery plans
- Track record in managing the equity transactions, guiding and advising management on operations, business structuring, financial planning, etc
- Expertise at streamlining processes, identifying unprofitable functions, evaluating control procedures thereby facilitating effective and disciplined performance
- Excellent relationship building and interpersonal skills
- Ability to connect, inspire, influence, confront and challenge people in order to improve process, systems and eventually achieve operational efficiency
- Exceptional interpersonal skills and analytical bent of mind thus being able to comprehend and explain complex financial data easily with a track record of high achievement
Our Client is the world's largest FMCG brand manufacturer and exporter with a legacy spanning over 120 years.They are India's first integrated company with a comprehensive product chain. Our client is a billion dollar top line company holding 45% market share in India and 50% share in export market.
- Presenting the monthly and quarterly financial reports of various oversees distributors
- Checking International Trade Marketing expenses inline of approval provided
- Preparing and checking Quarterly TME approval to be provided to distributors
- Creating Analysis report on budgeted expenditure and actual expenditure of TME
- Maintaining dialogues and working relationship with overseas distributors
- Managing receipts & vendor payments for exports receivables (AR)
- Implementing a Business Intelligence tool and dashboard reports
- Supporting management team and the Heads of Department with data-driven analysis
- Supporting legal team from commercial side on international commercial disputes.
- Evaluating and advicing on the Letters of credit
- Ensuring Timely and Accurate MIS, AR/ AP, variance analysis and various other periodical reports to Management and overseas distributors.
What you need to have:
- CA;ICWA(CMA);MBA / PGDM
- Preferably from FMCG Export and Manufacturing companies
- Experience of Financial Control Mechanisms
- Significant analytical skillset, including the utilization of BI and reporting tools
- Strong Quantative abilities, advanced excel skills, including writing macros in Excel and other
- Experience with Global Financial Planning & Analysis and Audit
- Adaptive, willing and able to work with different time zones to get the work completed
experience- 1-5 years of experience in CA firm
knowledge - filing GST and TDS returns, bookkeeping, exposure in audits.
Almost a decade old, it is a venture committed to bring together a varied range of traditional crafts and techniques of dyeing, weaving, printing and hand embroidery. The founders have dedicated their life to promote Indian Block Prints and provide employment and Hand-Embroidery training to women so that numerous underprivileged women can be empowered.
As a Finance Executive, you will be responsible for handling accounts and finance of the company.
What you will do:
- Accounting Entries/Book Keeping
- Reconciliating Credit Card
- Utility Payment and its accounting
- Invoicing
- Reconciliating Bank/Loan
- Preparing Debit Note and credit note
- Confirming with Vendor
- Coordinating with inter departments
- Branch Accounting
What you must have:
- Commerce Graduate having 6-7 Plus years of Experience
- Good in Excel
- Candidate with good working knowledge and TDS Knowledge
- Candidate from manufacturing background preferred
Role of a Quantitative Trader
Role and Responsibilities:
*Candidate is expected to have a rigorous quantitative aptitude and go-get attitude.
*Candidate will be monitoring closely quantitative models in Derivatives markets and manage the Risk of its open Positions
Requirements:
Education (Candidate should satisfy one of the following)
B.Sc./M.Sc. Mathematics or B.Sc./M.Sc. Statistics from a reputed college with good grades
B.Tech with good grades and strong quantitative aptitude
CFA/FRM Level 1 cleared
Any other degree with Financial Derivatives as a subject and through knowledge of Options Greeks (Portfolio Level, Risk Management, Hedging)
Preferences:
Following skill sets are not required but candidate will get preference if he/she possesses any of the following:
Working knowledge of python for historical data analysis or working on real-time analytics getting feed from a web API (Data structures, numpy, scikit-learn, tensor flow)
MATLAB/R for Time series analysis
Knowledge of AFL ( Amibroker Formula Language)
Benefits and Advantages for Candidate:
Steep learning curve
Extensive training on mathematics of derivatives market
Dynamic work environment.
Merit based growth
Quarterly bonuses Based on Performance post training period (where bonus can surpass the base salary)
Pay Structure:
Extensive training period(probation period) of 3 months(Stipend Paid during training period INR 20,000)
Pay Structure post the training period:
Base Salary of 5 Lacs p.a + Performance Bonuses
Working Hours:
We neither believe in staying unnecessary in office if there's nothing productive to be done nor do we believe in long unproductive lunch breaks.
Standard Market Hours : 8:45 – 5.00 p.m
Training Pre and Post market hours