Senior Consultant - IT & e-Governance

Key Responsibilities

• Collect, consolidate and manage data from various internal systems, SaaS platforms, CRM/ERP modules, logs, and databases.
• Generate daily, weekly, monthly, and ad-hoc MIS reports and dashboards for operations, sales, finance, customer-support or other relevant teams.
• Use advanced Excel to build, maintain, and manage complex spreadsheets — including pivot tables, VLOOKUP / HLOOKUP / INDEX-MATCH, SUMIF/COUNTIF, conditional formatting, charts/graphs, macros/VBA (if needed) to automate routine reporting tasks.
• Validate and clean data — ensure data integrity, consistency; identify and rectify discrepancies or anomalies.
• Collaborate with cross-functional teams (product, operations, support, finance, sales) to understand their data/reporting needs and deliver appropriate reports/insights.
• Provide ad-hoc data analysis or custom reporting as required by management or US stakeholders.
• Maintain documentation of reporting processes, data definitions/SOPs, report templates, and standard workflows.
• Ensure timely delivery of reports — especially considering night-shift schedule — so that US-based stakeholders receive data at start of their business day.
• Identify opportunities for process improvement and automation to make MIS reporting more efficient and reliable.

Required Skills & Qualifications

• Bachelor’s degree (in IT, Computer Science, Business, Statistics, or related field) or equivalent.

• Strong proficiency in Microsoft Excel — including advanced formulas/functions (VLOOKUP/HLOOKUP/INDEX-MATCH), pivot tables, charts/graphs, conditional formatting, data cleaning, data validation.
• Ability to build and maintain dashboards/reports; comfortable using Excel for recurring and ad-hoc reports.
• Strong analytical and problem-solving skills; ability to work with large datasets, identify trends, anomalies, and draw insights.
• Good communication skills — ability to coordinate with different teams/stakeholders, understand requirements, and present data/insights clearly.
• Readiness for night-shift work from office; ability to work independently, meet deadlines and manage time effectively.

About the Role

Work at the intersection of business and technology, supporting operations, data analysis, automation, and digital tools to improve efficiency and growth. 

 Responsibilities 

• Support business operations using tech tools (Excel, CRM, dashboards)  
• Analyze data and generate insights for decision-making  
• Assist in automation workflows and process improvements  
• Coordinate between tech and business teams  
• Help in implementing digital solutions and tools  

 Skills Required 

• Basic knowledge of Excel / Google Sheets  
• Good analytical and problem-solving skills  
• Understanding of business processes  
• Interest in technology and automation  

 Details 

• Duration: 3–6 months  
• Mode: Remote  
• Certificate + PPO based on performance 

We are looking for a detail-oriented and analytical Data Analyst to join our team. The ideal candidate will be responsible for collecting, analyzing, and interpreting data to identify trends, generate insights, and support business decision-making.

The candidate should be comfortable working with large datasets, creating reports and dashboards, and communicating findings clearly to business stakeholders.

Key Responsibilities

• Collect, clean, organize, and analyze data from multiple sources.
• Identify trends, patterns, anomalies, and business opportunities from data.
• Create dashboards, reports, and visualizations for business teams.
• Track and report key performance indicators (KPIs).
• Perform ad-hoc analysis to support business and management decisions.
• Develop and maintain automated reports where possible.
• Work with stakeholders to understand reporting and analytical requirements.
• Ensure data accuracy, consistency, and quality.
• Present analytical findings in a clear and actionable manner.
• Maintain documentation for reports, dashboards, and data processes.

Job Title: Technical Business Analyst| B2B

Work Location: Work from Home

Job Type: Full-time

Experience: 1+ year

Company Location : Work from Home

Website : https://www.mayuraconsultancy.com/careers/mcs-business-systems-analyst-opening?r=jlp

Skills:

• Proficiency in business analysis tools (e.g., Microsoft Excel) and documentation tools (e.g., JIRA, Confluence).
• Strong understanding of business processes and requirement gathering
• Excellent communication and stakeholder management skills.
• Experience with Agile methodologies is a plus.

About Us:

Mayura Consultancy Services (MCS) is a leading software consultancy and development company, serving a customer base in more than 25 countries. Specializing in digital transformation, MCS offers a comprehensive range of innovative solutions tailored to diverse business needs. Our offerings include custom software development, e-Commerce development, mobile and web applications, cloud integration, and enterprise resource planning (ERP) systems that enhance efficiency and streamline operations.

Job Overview

We are seeking a skilled and motivated Business Analyst to join our dynamic team. The Business Analyst will be responsible for gathering, analyzing, and documenting business requirements, and working closely with cross-functional teams to ensure that business needs are met. This role will play a key part in improving business processes, optimizing systems, and ensuring the successful delivery of projects.

What You Will Be Doing:

• Requirement Gathering & Documentation: Work with stakeholders to gather and document business requirements through interviews, workshops, and research. Develop detailed specifications and use cases.
• Process Analysis & Optimization: Analyze current business processes and workflows to identify areas for improvement. Propose solutions and strategies to enhance business performance.
• Data Analysis & Reporting: Conduct data analysis to support decision-making and provide insights into business performance. Create dashboards and reports for business stakeholders.
• Collaboration with Teams: Work closely with product managers, developers, and other business units to ensure seamless implementation of business requirements.
• Project Management Support: Assist in project management activities, including tracking progress, managing timelines, and ensuring project goals are met.
• Stakeholder Management: Communicate effectively with stakeholders at all levels to ensure expectations are aligned, and business needs are understood and delivered.

Benefits of Working with MCS:

• Work From Home: Enjoy the flexibility of working entirely from the comfort of your home, achieving a better work-life balance while contributing to impactful research initiatives.
• Direct Collaboration with Founders: Collaborate directly with MCS's founding team, gaining valuable insights and mentorship while contributing to the company's growth.
• Access to Premium Tools: Utilize the latest research tools and software to enhance your work efficiency and effectiveness.
• Recognition and Growth Opportunities: Potential for career advancement based on performance, with opportunities to take on more responsibilities and grow within the company.
• Comprehensive Benefits: Enjoy insurance coverage, paid leaves, and additional perks that support your well-being and work-life balance.

Ready to start your journey as a Business Analyst? Apply Now!

Apply : Please apply using the URL below Once you complete the application form, we will review your profile and get back to you.

Website:

https://www.mayuraconsultancy.com/careers/mcs-business-systems-analyst-opening?r=jlp

Strong Data Analyst Profile with advanced Excel and SQL expertise

2

Mandatory (Experience 1): Must have 4+ years of overall experience as a hands-on Data Analyst

3

Mandatory (Tech skill 1): Must be highly proficient in advanced Excel — complex functions, macros, calculations, and pivots

4

Mandatory (Tech skill 2): Must have strong hands-on SQL and a good understanding of relational database concepts

5

Mandatory (Tech skill 3): Must be able to automate routine tasks using Python (for automation purposes)

6

Mandatory (Skill 1): Must have exceptional analytical, problem-solving, and logical skills, with strong attention to detail and accuracy

7

Mandatory (Skill 2): Must be able to understand complex data and business logic and convert it into a model (the role models complex utility tariffs, rates, and programs)

8

Mandatory (Communication): Must have strong verbal and written communication, able to work independently with India- and US-based team members and articulate problems and solutions over calls and email.

9

Mandatory (Location): Must be based locally in Pune (or the nearby Maharashtra belt — Mumbai, Nagpur), as the final round is in person

10

Preferred (Domain): Experience in the Energy/Utility industry and familiarity with basic utility (electrical/gas) tariff concepts

Key Responsibilities:

• Manage FP&A, budgeting, forecasting and financial planning.
• Prepare and analyze P&L, MIS, Budget vs Actuals and variance reports.
• Drive monthly/quarterly financial reporting and business reviews.
• Perform revenue, cost and expense analysis and identify improvement opportunities.
• Support business teams and management with financial insights and decision-making.
• Manage rolling forecasts, financial models and KPI reporting.
• Analyze working capital, profitability and business performance.
• Drive process automation and standardization using advanced Excel/ERP tools.
• Work closely with cross-functional teams such as Sales, Operations, Supply Chain and Business teams.
• Support management presentations, strategic planning and ad-hoc financial analysis.

Preferred Profile

• Qualified Chartered Accountant (CA).
• 6.5–10 years of relevant experience in finance/accounting.
• Strong hands-on experience in MIS, AP/P2P, controllership, audit and compliance.
• Experience with India and US finance operations / US GAAP.
• Exposure to startup/product/SaaS environments preferred.
• Experience with fundraising, due diligence or investor reporting is a strong advantage.
• Prior experience working with Founders/CXOs/Leadership preferred.

RCM Analytics Specialist – US Healthcare

Job Title: RCM Analytics Specialist

Department: Revenue Cycle Management (RCM)

Industry: US Healthcare / Medical Billing

Experience: 2–5 Years

Employment Type: Full-Time

Location: Mohali

Shift: US Shift / Night Shift

Work Mode: Work from Office

Job Summary

We are looking for an experienced RCM Analytics Specialist to analyze US Healthcare RCM data, prepare performance reports, identify trends and revenue gaps, and provide actionable insights to improve collections, reduce denials, and enhance operational performance.

Key Responsibilities

• Analyze US Healthcare RCM data to identify trends, gaps, operational issues, and areas for improvement.
• Prepare and maintain daily, weekly, and monthly RCM performance reports and dashboards.
• Analyze denial trends and identify root causes, including eligibility, authorization, coding, documentation, and payer-related issues.
• Track payer-wise and client-wise performance and identify potential revenue leakage.
• Analyze AR aging buckets and identify high-value or aging accounts requiring immediate attention.
• Develop reports to help management monitor team productivity, collections, quality, and financial performance.
• Prepare MIS reports, dashboards, ad-hoc analysis, and business insights for management.
• Present analytical findings and recommendations to management and operational stakeholders.

Required Skills & Qualifications

• 3–5 years of experience in US Healthcare RCM, Medical Billing Analytics, MIS, Business Analytics, or Healthcare Operations.
• Strong analytical and problem-solving skills.
• Good understanding of RCM metrics, reports, and operational KPIs.
• Ability to analyze large datasets and identify trends, discrepancies, and opportunities for improvement.

Preferred Skills

• Experience with Power BI or other BI/dashboarding tools.
• Knowledge of SQL and database querying.
• Advanced Excel skills, including Pivot Tables, XLOOKUP/VLOOKUP, SUMIFS/COUNTIFS, charts, and dashboards.
• Experience in developing automated MIS/RCM dashboards.

What We Offer

• Competitive Salary: ₹40,000 – ₹70,000 per month
• Attractive Incentives for experienced candidates
• Growth and career development opportunities
• Professional and collaborative work environment

We're hiring a Data Analyst to turn raw data into clear, actionable insight. You'll partner with product, sales, marketing, and operations teams to answer their most important questions with data — building dashboards, running deep-dive analyses, and defining the metrics the business runs on. The ideal candidate is fluent in SQL, comfortable wrangling messy datasets, and just as strong at telling the story behind the numbers as they are at producing them. You'll own the accuracy and trustworthiness of the reporting stakeholders rely on to make decisions.

Key Responsibilities

• Design, build, and maintain dashboards and recurring reports across business functions
• Write and optimize SQL queries to extract, join, and transform data from multiple sources
• Run ad-hoc and deep-dive analyses to answer specific business questions
• Define, document, and standardize metrics and KPIs alongside stakeholders
• Investigate data-quality issues and ensure the numbers people see are accurate
• Translate analysis into clear recommendations and present them to non-technical audiences
• Support experimentation and A/B test analysis where relevant
• Automate repetitive reporting to free up time for higher-value analysis

Requirements

• 3+ years in a data analyst or business-intelligence role
• Strong SQL and hands-on experience with Power BI and/or Tableau
• Working knowledge of Python (pandas/numpy) for analysis
• Solid grounding in statistics and analytical methods
• Advanced Excel and strong data-visualization / storytelling skills
• Ability to work independently with stakeholders across functions

Nice to have

• Experience with cloud data warehouses (BigQuery, Snowflake, Redshift)
• Exposure to dbt or other ETL/transformation tooling

·      Process and verify invoices, payments, and expense reports.

·      Manage Accounts Payable (AP) and Accounts Receivable (AR) activities.

·      Perform bank, vendor, and customer account reconciliations.

·      Prepare daily, weekly, and monthly financial reports.

·      Monitor cash flow and assist in forecasting activities.

·      Support month-end and year-end closing processes.

·      Ensure compliance with company policies and accounting standards.

·      Coordinate with international teams and stakeholders during shift hours.

·      Maintain accurate financial records and documentation.

·      Assist in audit preparations and respond to audit queries.

·      Identify process improvement opportunities and support automation initiatives.

·      Taken care of additional responsibilities as assigned.

Required Qualifications

·      Bachelor's degree in Commerce, Finance, Accounting, or related field.

·      2 years of experience in Finance & Accounts.

·      Strong knowledge of AP, AR, General Ledger, and reconciliations.

·      Proficiency in MS Excel (Pivot Tables, VLOOKUP, formulas).

·      Good analytical and problem-solving skills.

·      Strong communication skills for interacting with global teams.

·      Willingness to work in permanent night shifts.

Key Skills

·      Financial Analysis

·      Accounts Payable & Receivable

·      Reconciliation

·      Reporting & MIS

·      Advanced Excel

·      Attention to Detail

This role will be permanent with NAM info and deploy to client location Hyderabad & Pune.

Work Mode: WORK FROM OFFICE

Role Descriptions:

• Perform detailed data analysis and support business decision-making
• Gather and document business requirements and translate them into technical specifications
• Work closely with stakeholders to define data needs and reporting requirements
• Create user stories, functional specifications, and support UAT activities
• Ensure alignment between business objectives and data solutions

Required Skills:

• Strong expertise in SQL and data querying
• Proven experience in data analysis, requirement gathering, and stakeholder management
• Ability to translate business requirements into technical solutions and user stories
• Good understanding of data models, reporting, and analytics concepts

Skills: Business Analysis~ORACLE SQL

Locations: ~HYDERABAD~PUNE~

Desire candidate

• Candidate should have valid PF.