Business Analyst

Job Title: Senior Data Analyst

Location: Sharnam Metrolinks, Amraiwadi, Ahmedabad

Working Days: 6 Days a Week

Department: MDO

Reporting To: COO

Employment Type: Full-Time

Job Summary

We are seeking a highly analytical and detail-oriented Senior Data Analyst to lead data management, reporting, automation, and system development initiatives across the organization.

The role focuses on transforming raw data into meaningful insights, designing and implementing automated systems, strengthening data structures, and supporting cross-functional teams with accurate, actionable intelligence to drive strategic and operational business decisions.

Key Responsibilities

1. Data Management & Reporting

● Collect, clean, validate, and consolidate data from multiple internal and external sources.

● Prepare and deliver daily, weekly, and monthly MIS reports for management and departments.

● Design, develop, and maintain dashboards to track KPIs, performance metrics, and operational trends.

2. Database & Data Accuracy Management

● Manage and regularly update internal databases, spreadsheets, and reporting systems.

● Ensure data accuracy, consistency, integrity, and confidentiality across all platforms.

● Implement best practices for data validation, version control, and audit checks.

3. Data Analysis & Business Insights

● Analyze large and complex datasets to identify trends, patterns, gaps, and anomalies.

● Translate data findings into clear, actionable insights and recommendations to support

strategic and operational decision-making.

4. Reporting Automation, System Recommendation & Implementation

● Identify opportunities to replace manual or semi-manual processes with automated, data-driven systems.

● Design and implement automated reporting frameworks, dashboards, and data pipelines using Excel (Power Query, VBA, Macros), SQL, BI tools, and Python.

● Proactively suggest new automation tools, system enhancements, or integrations to

improve efficiency, accuracy, and scalability.

● Lead the end-to-end implementation of approved automation initiatives, including requirement gathering, system design, testing, deployment, and stabilization.

● Continuously monitor and optimize automated systems in line with business growth and evolving data needs.

5. Cross-Functional Coordination & Support

● Collaborate with Sales, HR, Finance, Operations, and other departments to understand

reporting and data requirements.

● Provide support for ad-hoc analysis, custom reports, and special data requests.

● Act as a data partner to department heads for decision support and performance tracking.

6. Documentation & Compliance

● Maintain complete and updated documentation for MIS processes, reports, data models,

automation logic, and system changes.

● Ensure compliance with company data governance policies and applicable data protection standards.

System Development & Data Structuring Responsibilities

● Study and understand departmental workflows to evaluate how data is generated, processed, and utilized.

● Review existing manual and digital data systems to identify operational gaps, risks, and

mprovement opportunities.

● Recommend structured data models, reporting formats, and storage solutions aligned with

business requirements.

● Coordinate with department heads to define data structures, access levels, and reporting

standards.

● Implement new or upgraded data systems (Excel-based models, cloud platforms, ERP

integrations) with minimal operational disruption.

● Design structured data formats and role-based access controls to ensure secure and

organized data management.

● Train employees on newly implemented systems and provide post-implementation

support.

● Monitor system performance, resolve issues, and continuously improve systems based on

user feedback and organizational growth.

Qualifications & Experience

● Bachelor’s degree in Commerce, Statistics, Computer Applications, or a related field.

● 3–5 years of experience in data analytics, reporting, or system automation roles.

● Strong analytical thinking, logical reasoning, and problem-solving abilities.

● High attention to detail with excellent organizational and documentation skills.

Technical Skills (Must Have)

● Advanced Excel: Power Query, Power Pivot, VBA basics, Macros, Charts

● BI Tools: Power BI or Tableau (DAX, data modeling, dashboard optimization)

● Google Apps Script: Automation in Google Sheets, custom functions, triggers, API integrations, workflow optimization

● Vlook

Preferred Skills

● Strong verbal and written communication skills

● Ability to handle sensitive and confidential information responsibly

● Quick learner with a tech-savvy, improvement-driven, and solution-oriented mindset

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.

Experience: 7–10+ years | Industry Preference: Financial Services / BFSI

Role Overview

We are seeking a Senior Reporting Analyst / Business Intelligence Lead to own and drive

enterprise reporting, analytics, and data insights across the organization. This is a senior,

hands-on role requiring deep technical expertise across the Microsoft data and BI stack,

strong business acumen, and the ability to operate with minimal hand-holding. The ideal

candidate will act as a bridge between business leadership and technical teams, translating

complex business questions into scalable, reliable data models and executive-ready insights.

Key Responsibilities

 Serve as the primary owner of enterprise reporting and BI solutions, from data

ingestion through executive dashboards.

 Design, build, and maintain scalable Power BI / Microsoft Fabric semantic models using

STAR schema best practices.

 Partner closely with business stakeholders and C-level executives to define KPIs,

metrics, and reporting requirements.

 Lead and present weekly reporting and insights sessions with senior and executive

leadership.

 Ensure data accuracy, consistency, and trust across all reports and analytics outputs.

 Proactively identify data quality issues, root causes, and remediation strategies.

 Drive automation of reporting, alerts, and data refresh processes to reduce manual

effort.

 Collaborate with engineering, data, and application teams to align business logic with

source system data structures.

 Mentor junior analysts and establish BI standards, best practices, and documentation.

Technical Skills – Data & Backend

 Advanced SQL: complex queries, views, stored procedures, and validation against

source systems (RDN, Recovery Connect).

 Azure Data Factory: build and manage copy pipelines from SQL sources to data

warehouses / dedicated pools.

 Incremental refresh, parameterized pipelines, and schema replication.

 Data warehouse design: STAR schema, fact vs dimension tables, handling deleted

records and SCDs.

Technical Skills – Reporting & Frontend

 Power BI / Microsoft Fabric: Power Query, DAX, and M language expertise.

 Semantic model design (1-to-many, 1-to-1, many-to-1 relationships).

 Query folding and performance optimization best practices.

 Paginated Report Builder (SSRS-style) for automated Excel and PDF reporting.

 Power Automate integration for alerts and workflow-driven notifications.

Data Quality & Analytics

 Ability to clean, normalize, and reconcile data across multiple systems.

 Strong troubleshooting skills when business definitions and data do not align.

 Translate business terminology into accurate technical mappings and calculations.

Communication & Leadership

 Serve as a key liaison between business stakeholders and technical teams.

 Comfortable working directly with C-level executives and senior leadership.

 Ability to lead executive-level meetings and clearly communicate insights.

 Self-starter mindset with minimal hand-holding.

Qualifications

 7–10+ years of experience in BI, analytics, or enterprise reporting roles.

 Preferred experience in financial services or regulated environments.

 Strong experience across the Microsoft BI ecosystem.

Preferred Certifications

 Microsoft PL-300 (Power BI Data Analyst)

 Microsoft DP-600 (Fabric Analytics Engineer)

 Microsoft DP-700 (Fabric Data Engineer)

What Success Looks Like

 Executive leadership trusts and relies on BI dashboards for decisions.

 Reporting is automated, accurate, and scalable.

 BI functions as a strategic partner to the business.

We are looking for a Lead – Information Systems who can combine strong Salesforce/CRM expertise, advanced Excel skills, MIS reporting and business analytics to support data-driven decision-making.

🔹 What We’re Looking For

• Minimum 4 years of hands-on experience with CRM systems, preferably Salesforce

• Minimum 3 years of practical Salesforce experience preferred

• Advanced proficiency in Microsoft Excel, including:

Advanced formulas, Pivot Tables, Power Query, Data analysis, Automation

• Strong experience in MIS reporting, data validation, analysis and presentation of insights

• Proven experience creating and maintaining dashboards, KPI reports and management reports

• Good technical aptitude with the ability to understand business processes and convert them into effective reporting solutions

• Basic to intermediate understanding of finance and business metrics, including revenue, costs, budgeting and financial reporting concepts

• Strong analytical and problem-solving skills

• Excellent stakeholder management and communication skills

• Ability to work independently and convert data into actionable business insights

🔹 Key Responsibilities

• Manage and analyze data from Salesforce/CRM and other business systems

• Develop and maintain MIS reports, dashboards and KPI trackers

• Ensure data accuracy, validation and consistency across reports

• Analyze business data and identify trends, gaps and opportunities

• Translate business requirements into meaningful reports and dashboards

• Work closely with business and functional stakeholders to understand reporting requirements

• Support management with timely and accurate business insights and performance reports

• Identify opportunities to improve reporting processes through Excel, Power Query and automation

• Support CRM-related reporting and process improvements

🎯 Ideal Candidate

Someone who is comfortable working at the intersection of CRM + MIS + Excel + Business Analytics, and can go beyond preparing reports to explain what the data means and what action the business should take.

Job Summary

We are looking for an experienced professional with strong expertise in Power BI, Power Apps, Power Automate, Excel, data analysis, and executive reporting. The candidate will be responsible for developing interactive dashboards, automating business processes, analyzing data, and preparing management reports to support business decision-making.

Key Responsibilities

• Develop, maintain, and enhance interactive dashboards and reports using Power BI.
• Build Power Apps solutions to improve business processes and user productivity.

Required Technical Skills

• Power BI: Dashboard development, report creation, data modeling, and visualization.
• Power Apps: Canvas apps, forms, and business application development.
• Power Automate: Workflow automation, approvals, notifications, and process automation.
• Microsoft Excel: Advanced formulas, PivotTables, lookups, data cleaning, and analysis.
• Data Analysis: Data interpretation, trend analysis, KPI tracking, and business insights.
• Executive Reporting: Management dashboards, performance reports, and KPI presentations.
• DAX & Power Query: Data transformation, calculations, and report optimization.

Preferred Skills

• Experience integrating multiple data sources.
• Knowledge of Microsoft 365 and SharePoint.
• Understanding of business intelligence and reporting best practices.
• Strong analytical, problem-solving, and communication skills.
• Ability to interact with business stakeholders and senior management.

Experience and Qualification

• Minimum 5+ years of relevant experience in BI, data analytics, reporting, or Microsoft Power Platform.
• Hands-on experience with Power BI, Power Apps, Power Automate, and Excel.

Business Intelligence Analyst - 2

Planview is the world leader in enterprise software planning for enterprise-wide deployment strategies, processes and resources. More than 4000 customers, among the world's largest and most respected companies, have successfully implemented Planview software to optimize their enterprise portfolio management, project, portfolio and resource management, business intelligence and expense tracking processes. We have had stable, organic growth for years and now need reinforcement.

Job Summary:

The Planview BI Team is seeking an experienced Business Intelligence Analyst – 2 to support, troubleshoot, optimize, and enhance business intelligence and reporting solutions built on Planview products.

This role focuses on advanced BI support across Power BI, Microsoft Fabric, SQL Server, SSAS, SSRS, OData, Dataflows, Data Pipelines, Data warehousing, and Data models. The BI Analyst – 2 will handle complex technical issues, perform advanced root-cause analysis and performance tuning, and work closely with customers and internal teams to deliver scalable BI solutions.

Key Responsibilities:

· Troubleshoot and resolve complex issues involving data accuracy, refresh failures, report behavior, connectivity, security, and performance across Power BI, SSRS, SSAS, SQL Server, OData, and Data warehousing layers.

· Perform advanced T-SQL development and performance tuning, including execution plans, indexing, query optimization, stored procedures, views, and complex queries.

· Support, develop, maintain, and optimize Power BI semantic models, DAX measures, Power Query, datasets, workspaces, gateways, refreshes, and Row-Level Security.

· Support and troubleshoot SSAS Tabular and Multidimensional models, including processing, calculations, relationships, security, and performance.

· Develop and troubleshoot advanced SSRS/paginated reports, including parameters, subreports, drill-through, expressions, pagination, subscriptions, and export formats.

· Support Microsoft Fabric solutions including Data Pipelines, Dataflows Gen2, Lakehouse/Warehouse, semantic models, and Power BI integration.

· Troubleshoot ETL/ELT processes, data pipelines, Dataflows, refresh failures, and data transformation issues across BI environments.

· Analyze and troubleshoot OData feeds, including filtering, pagination, refresh, connectivity, and large-volume data scenarios.

· Support Planview Automart, Datamart, and data warehouse implementations and ensure data consistency across source, warehouse, semantic, and reporting layers.

· Perform end-to-end root-cause analysis and performance optimization across the BI technology stack.

· Collaborate with customers, Product, Engineering, Hosting, and Support teams on complex technical issues and escalations.

· Provide technical guidance and mentoring to BI Analyst – 1 team members and contribute to BI best practices and documentation.

Required Skills & Qualifications:

·      5+ years of professional experience in Business Intelligence Development, BI Support, Data Analytics, or a related field.

·      Strong hands-on experience with Power BI, DAX, Power Query, and enterprise data modeling.

·      Advanced knowledge of SQL Server and T-SQL, including query optimization and performance tuning.

·      Strong experience with SSRS and enterprise reporting.

·      Experience with SSAS Tabular and/or Multidimensional models.

·      Experience with Microsoft Fabric, particularly Data Pipelines, Dataflows, Lakehouse/Warehouse, and Power BI.

·      Experience working with OData and enterprise data integration.

·      Strong understanding of Data Warehousing, Datamarts, Automart, ETL/ELT, and data modeling.

·      Experience troubleshooting Power BI Service, gateways, refreshes, security, and semantic models.

·      Strong analytical, troubleshooting, and root-cause analysis skills.

·      Proven ability to work directly with customers and communicate technical concepts to both technical and non-technical stakeholders.

·      Experience with tools such as DAX Studio, Tabular Editor, Performance Analyzer, Query Store, or SQL Profiler is an advantage.

• Relevant Microsoft certifications such as PL-300, DP-600, or DP-203 are an added advantage.

About Us

Corporate Web Solutions provides technology-driven solutions involving data analysis, automation, web development, and digital transformation.

Role Overview

As a Data Analyst Intern, you'll assist in analyzing datasets, preparing reports, identifying trends, and exploring AI-assisted analytics workflows.

Key Responsibilities

• Collect and organize data.
• Analyze datasets and identify trends.
• Prepare reports and visualizations.
• Work with Excel, spreadsheets, or analytical tools.
• Assist with dashboards and data-driven insights.
• Explore AI tools for data analysis.

Requirements

• Basic understanding of data analysis.
• Familiarity with Excel or Google Sheets.
• Basic knowledge of SQL or Python is a plus.
• Analytical mindset.
• Good attention to detail.

Perks

• Certificate of Internship
• Flexible work hours
• Mentorship and real project exposure
• Potential for PPO
• Letter of Recommendation
• Performance-Based Stipend available up to ₹18,000/month

Strong Data Analyst Profile with Python, SQL, and data-pipeline expertise, ideally with retail / e-commerce datasets

2

Mandatory (Experience 1): Must have 4+ years of hands-on data-analyst experience, working with large datasets across areas such as sales, inventory, pricing, promotions, and customer behaviour.

3

Mandatory (Tech skill 1): Must have strong hands-on Python for data processing, transformation, automation, and analysis

4

Mandatory (Tech skill 2): Must have strong SQL skills, including complex queries, joins, aggregations, and data validation.

5

Mandatory (Tech skill 3): Must have a solid understanding of Data Lake architecture, ingestion, storage, and processing workflows

6

Mandatory (Tech skill 4): Must have hands-on experience with ETL / ELT pipelines, data integration, and transformation

7

Mandatory (Tech skill 5): Must have experience with Azure or GCP data services.

8

Mandatory (Tech skill 6): Must have understanding of or experience with Databricks and distributed data processing.

9

Mandatory (Tech skill 7): Must have knowledge of data modeling, data warehousing, and Lakehouse architecture

10

Mandatory (Tech skill 8): Must have experience with Power BI, Tableau, or Excel for reporting.

11

Mandatory (Communication): Must have strong analytical, documentation, and stakeholder-communication skills.

12

Mandatory (Education): Must hold a Bachelor’s degree in Computer Science, IT, Engineering, or a related field.

13

Mandatory (Note1): This is a 6-month contract role. Candidate must be comfortable with the contract engagement and able to join immediately (urgent — onboarding within ~a week)

About AbleCredit

Anyone can build an AI demo. Building AI systems that are reliable, observable, secure, and trusted by enterprise customers is an entirely different challenge.

At AbleCredit, we're building an execution platform that combines AI models, APIs, business rules, human decisions, and enterprise systems into production workflows. Every workflow needs to be fast, resilient, auditable, and easy to extend. We’re solving hard problems- come join us while we build this rocketship.

The company was founded in June 2023 by Utkarsh Apoorva (IIT Delhi, built Reshamandi, Guitarstreet, Edulabs); Harshad Saykhedkar (IITB, ex-AI Lead at Slack); and Ashwini Prabhu (IIML, co-founder of Mythiksha, ex-Product Head at Reshamandi, HandyTrain).

About the Role

AbleCredit is looking for a detail-oriented RevOps Analyst to help scale the systems, data, and processes that power our go-to-market engine. You will sit at the intersection of Sales, Customer Success, Marketing, and Product, ensuring that our CRM, pipeline data, and reporting infrastructure give leadership a single, reliable view of the revenue funnel — from first outreach to bank and NBFC clients, through to renewal and expansion.

This is a high-visibility role for someone who enjoys working with data, is comfortable navigating ambiguity in a fast-growing startup, and wants to build the operational backbone of a GenAI platform that serves India's lending ecosystem.

Key Responsibilities

• Own the day-to-day administration of HubSpot, including data hygiene, deduplication, field mapping, pipeline stage governance, and user access management.

• Consolidate, clean, and standardize data arriving as files from multiple sources (e.g., partner/lender exports, internal team trackers) and reconcile it with HubSpot to maintain a single source of truth.

• Build and maintain dashboards and reports that track pipeline health, conversion rates, sales cycle length, forecast accuracy, and revenue against targets for the leadership and GTM teams.

• Partner with Sales and Customer Success leaders to support territory planning, account segmentation, quota tracking, and pipeline reviews for AbleCredit's bank and NBFC customers.

• Document and continuously improve lead-to-cash processes — lead routing, lead scoring, deal desk approvals, contracting, and handoffs between Sales, Onboarding, and Customer Success.

• Analyze funnel performance and customer data to surface trends, bottlenecks, and opportunities, and translate findings into clear, actionable recommendations for stakeholders.

• Support monthly/quarterly revenue forecasting and business reviews by consolidating data from CRM, finance, and product usage sources.

• Evaluate, implement, and maintain the broader RevOps tool stack (CRM, sales engagement, BI/reporting, contract management) and manage integrations between these systems.

• Act as a cross-functional point of contact for data requests, ad hoc analyses, and process troubleshooting from Sales, Marketing, Customer Success, and Finance.

• Maintain data accuracy and compliance standards appropriate for a platform operating in the regulated BFSI (banking, financial services, and insurance) space.

What Are We Looking For?

• Bachelor's degree in Business, Economics, Engineering, Statistics, or a related field.

• 4+ years of experience in RevOps, Sales Operations, or a related function; prior experience at a B2B SaaS, fintech, or BFSI-facing company is a plus.

• Strong proficiency in Excel/ Google Sheets; working knowledge of SQL and comfort querying and interpreting large datasets.

• Hands-on experience with HubSpot and BI/ visualization tools (e.g., Looker, Power BI, Tableau, or Metabase).

• Sharp analytical and problem-solving skills, with the ability to translate raw data into clear business insights.

• Excellent communication skills and the ability to work cross functionally with Sales, Marketing, Customer Success, Finance, and Product teams.

• High attention to detail, strong process orientation, and comfort operating with ambiguity in a fast-paced startup environment.

Good to Have

• Exposure to enterprise or B2B sales cycles involving banks, NBFCs, or other regulated financial institutions.

• Familiarity with sales engagement, contract/ CPQ, or customer success platforms.

• Basic scripting or automation skills (e.g., Python, Google Apps Script) for reporting workflows.

• Prior experience supporting forecasting, quota-setting, or compensation processes.

Why Join AbleCredit?

You'll join a fast-moving team building GenAI-powered infrastructure for one of India's most consequential industries — lending. You'll have direct visibility into how the business runs end-to-end, ownership over the systems and data that leadership relies on daily, and the opportunity to shape RevOps practices as the company scales.

Role Overview

We are seeking a Senior Reporting Analyst / Business Intelligence Lead to own and drive enterprise reporting, analytics, and data insights across the organization. This is a senior, hands-on role requiring deep technical expertise across the Microsoft data and BI stack, strong business acumen, and the ability to operate with minimal hand-holding. The ideal candidate will act as a bridge between business leadership and technical teams, translating complex business questions into scalable, reliable data models and executive-ready insights.

Key Responsibilities

·       Serve as the primary owner of enterprise reporting and BI solutions, from data ingestion through executive dashboards.

·       Design, build, and maintain scalable Power BI / Microsoft Fabric semantic models using STAR schema best practices.

·       Partner closely with business stakeholders and C-level executives to define KPIs, metrics, and reporting requirements.

·       Lead and present weekly reporting and insights sessions with senior and executive leadership.

·       Ensure data accuracy, consistency, and trust across all reports and analytics outputs.

·       Proactively identify data quality issues, root causes, and remediation strategies.

·       Drive automation of reporting, alerts, and data refresh processes to reduce manual effort.

·       Collaborate with engineering, data, and application teams to align business logic with source system data structures.

·       Mentor junior analysts and establish BI standards, best practices, and documentation.

Technical Skills – Data & Backend

·       Advanced SQL: complex queries, views, stored procedures, and validation against source systems (RDN, Recovery Connect).

·       Azure Data Factory: build and manage copy pipelines from SQL sources to data warehouses / dedicated pools.

·       Incremental refresh, parameterized pipelines, and schema replication.

·       Data warehouse design: STAR schema, fact vs dimension tables, handling deleted records and SCDs.

Technical Skills – Reporting & Frontend

·       Power BI / Microsoft Fabric: Power Query, DAX, and M language expertise.

·       Semantic model design (1-to-many, 1-to-1, many-to-1 relationships).

·       Query folding and performance optimization best practices.

·       Paginated Report Builder (SSRS-style) for automated Excel and PDF reporting.

·       Power Automate integration for alerts and workflow-driven notifications.

Data Quality & Analytics

·       Ability to clean, normalize, and reconcile data across multiple systems.

·       Strong troubleshooting skills when business definitions and data do not align.

·       Translate business terminology into accurate technical mappings and calculations.

Communication & Leadership

·       Serve as a key liaison between business stakeholders and technical teams.

·       Comfortable working directly with C-level executives and senior leadership.

·       Ability to lead executive-level meetings and clearly communicate insights.

·       Self-starter mindset with minimal hand-holding.

Qualifications

·       7–10+ years of experience in BI, analytics, or enterprise reporting roles.

·       Preferred experience in financial services or regulated environments.

·       Strong experience across the Microsoft BI ecosystem.

Preferred Certifications

·       Microsoft PL-300 (Power BI Data Analyst)

·       Microsoft DP-600 (Fabric Analytics Engineer)

·       Microsoft DP-700 (Fabric Data Engineer)

What Success Looks Like

·       Executive leadership trusts and relies on BI dashboards for decisions.

·       Reporting is automated, accurate, and scalable.

·       BI functions as a strategic partner to the business.