Ruby Capital - Internal Auditor Cum Data Analyst

EXECUTION / CLIENT-FIELD WORK:

BOOK-KEEPING, ACCOUNTING, COSTING

- Review of end-to-end book-keeping to Trial Balance to the preparation of Financial Statements to management reports (MIS) including various additional data sources

- Review of functions like Sales, Collections & AR/AP, Operations & Logistics, BD & Marketing, Human Resources, Compliance, Training etc.

- Obtain, analyse and evaluate accounting documentation, previous reports, data, flowcharts etc

- Actual review of ledgers (ledger scrutiny), sample testing, data-entry process including (maker-checker system), subsidiary books vs. GLs, internal controls, checks & reconciliation processes etc

- Review of new ledgers created, backdated entries, adhering to entering data in correct entities, branches, ledgers and cost centres

- Evaluating the closing process (Evaluating calculations of closing JV entries like accruing / deferment of revenues and expenses for comprehensiveness, accuracy, consistency etc, ensuring the impact of accounting entries)

- Understanding larger objectives of the management & investors (such as operating & financial ratios, profitability margins and returns, cash flow, working capital cycle etc)

- Review of the compliance processes (such as TDS, GST calculations, filing, payments etc)

- Evaluating, correcting cost centres, Bill of materials (BOM), cost allocation and apportionment methodology etc.

ACTUAL DATA ANALYSIS, GUIDANCE ON DATA PREPARATION

- Evaluating data models, guiding on maintenance of transaction tables & master tables, and designing / redesigning of masters

- Data preparation, based data analysis, working with BI systems, identifying trends, outliers, errors in data, guidance on proper course-correction / process remap

- Identifying gaps and loopholes in data-entry (digitalization)

- guiding on revision of formats in MS Excel or Google Sheet environment

- Guidance on best practices, propose practical and value-added recommendations to address control weaknesses and / or process inefficiencies

- Participate in closing meetings with client at the end of fieldwork, providing clear explanations for identified issues

EDUCATIONAL BACKGROUND, WORK EXPERIENCE & KEY SKILLS:

EDUCATION & WORK EXPERIENCE

- Chartered Accountant with at least 5 years of proven work experience (in the above areas) across diverse industries such as services, manufacturing, technology, retail / trading, construction & infrastructure, financial services etc.

- Preferably worked in a Big 4 International firm or larger domestic internal audit firms

- Additional Qualification Preferred: MBA (Majors in Data Science, Finance) or MSc (Finance / Control) or Certified Internal Auditor or CIMA

COMFORT WITH SOFTWARE APPLICATIONS

- Tally, QuickBooks, PowerBI, MS Excel, Pivot Tables (PowerPivots), Google sheets, additional knowledge of ERP like SAP etc preferred

OTHER ATTRIBUTES

- Functional Excellence | Organizational understanding | Service mindset

- High level of communication and people management skills

- Define tasks for team, delegation, project management

- High attention to detail and excellent analytical skills

- Superlative report-writing / editing skills

- Ability to work in unstructured environment (where processes don- t exist / need to be defined), continuously learning

- Working independently with minimum supervision

- Willingness to travel to client locations

ABOUT RUBY CONSULTING

We are a 10-years old financial advisory and management consulting firm, offering

- Management reporting (MIS) and Business & Data Analytics

- Transaction Advisory for fund-raising, M&A and JVs

- Transaction support in the form of Financial Modeling, Investor presentations, valuation and Due-diligence

We work with an array of clients right from dynamic startups to mid-sized and large enterprises as well as Investment and private equity funds. We have offices in Mumbai and Pune.