Mis Data Analyst

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 

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.

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 skilled Power BI / Power Platform Analyst with experience in data analysis, dashboard development, automation, and executive reporting. The ideal candidate should be proficient in Power BI, Power Apps, Power Automate, and advanced Excel to transform business data into actionable insights and improve operational efficiency.

Responsibilities

• Develop interactive dashboards and reports using Power BI to support business decision-making.
• Build and maintain applications using Microsoft Power Apps to streamline business processes.
• Design automated workflows using Power Automate to reduce manual tasks and improve efficiency.
• Perform data analysis, data validation, and data cleansing using Excel and other relevant tools.
• Prepare executive-level reports, KPI dashboards, and management presentations.
• Gather reporting requirements from stakeholders and translate business needs into analytical solutions.
• Integrate data from multiple sources and ensure data accuracy and consistency.
• Identify trends, performance gaps, and opportunities for process improvement.

Required Skills

• Strong experience in Power BI, Power Apps, and Power Automate.
• Advanced Excel skills, including PivotTables, lookup functions, and data analysis.
• Experience in dashboard development, KPI tracking, and executive reporting.
• Strong analytical, problem-solving, and data interpretation skills.
• Good communication and stakeholder management skills.
• Knowledge of SQL, DAX, Power Query, and data modelling is an added advantage.

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.

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.

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:

With over 10 years of experience serving 200+ clients across diverse geographies specific to real estate, we have launched a dedicated vertical for the real estate sector. Our comprehensive services are designed to support clients at every stage of their project lifecycle, from initial planning to closing sales.

Why Choose Us?

Proven Experience: Over 200 successful client engagements across diverse geographies in the real estate industry.

Holistic Service Offering: Covering every aspect of real estate marketing and sales.

Innovation & Creativity: Cutting-edge campaigns and creative assets that stand out.

Dedicated & Skilled Team: Experts passionate about driving results and fostering growth.

Role Overview:

We are looking for a proactive and detail-oriented Business Coordinator – Real Estate to manage operational coordination, business reporting, sales data management, and cash flow tracking for the real estate vertical. The ideal candidate should have strong coordination skills, excellent data management abilities, and experience in handling real estate operational processes. .

Key Responsibilities

1. Data Maintenance & Reporting

● Maintain and update all real estate business data with accuracy.

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

● Generate reports related to sales, collections, inventory, and team performance.

● Ensure proper documentation and data organization across departments.

2. Inventory Data Management

● Maintain project inventory records, including unit availability, pricing, and status updates.

● Coordinate with sales and management teams for real-time inventory updates.

● Ensure inventory data is accurately updated in internal systems/software.

3. Sales Data Management

● Track leads, site visits, bookings, closures, and sales performance data.

● Maintain sales pipeline reports and team target tracking.

● Coordinate with the sales team for accurate reporting and follow-ups.

4. Collection Data Management

● Maintain customer payment and collection records.

● Track pending payments, due amounts, and payment schedules.

● Coordinate with finance and sales teams for timely collection updates.

5. Individual & Departmental Performance Tracking

● Maintain individual sales performance and target achievement data.

● Prepare departmental performance reports and dashboards.

● Support management with operational and performance analysis.

6. Software & CRM Updates

● Ensure timely updates of data in CRM and internal software systems.

● Maintain the accuracy of customer, sales, inventory, and payment records.

● Coordinate with teams to resolve discrepancies in reports or software entries.

7. Cash Flow Coordination & Management

● Assist in tracking project-wise cash inflow and outflow.

● Coordinate with finance and operations teams for payment processing and reporting.

● Maintain records related to receivables, collections, and financial coordination.

Requirements

Bachelor’s degree in Business Administration, Commerce, Management, or related field.

1–3 years of experience in coordination, operations, or MIS roles, preferably in real estate.

Strong knowledge of MS Excel, Google Sheets, and reporting tools.

Good understanding of CRM/software management and reporting processes.

Strong communication, coordination, and follow-up skills.

Ability to manage multiple tasks in a fast-paced environment.

As a Founder's Office Intern, you will work directly with the founders and leadership team, gaining hands-on exposure to business strategy, operations, sales, marketing, and cross-functional projects.

Key Responsibilities

• Work closely with the Founder and leadership team on strategic business initiatives.
• Conduct market research, competitor analysis, and industry benchmarking.
• Assist in preparing business presentations, proposals, reports, and meeting materials.
• Coordinate with internal teams to track project progress and ensure timely execution.
• Support business development, partnerships, and client engagement activities.
• Analyze business data and prepare dashboards and actionable insights.
• Assist in operational planning and process improvement initiatives.
• Follow up on action items from leadership meetings and maintain project trackers.
• Support special projects assigned by the Founder from time to time.

Eligibility

• Final-year students or recent graduates in:
• MBA
• BBA/BMS
• Engineering
• Commerce
• Economics
• Any relevant discipline
• Strong interest in startups, entrepreneurship, and business strategy.

Required Skills

• Excellent verbal and written communication skills.
• Strong analytical and problem-solving abilities.
• Proficiency in Microsoft Excel or Google Sheets.
• Good knowledge of Microsoft PowerPoint or Google Slides.
• Strong organizational and time-management skills.
• Ability to work independently and manage multiple tasks.
• Positive attitude, willingness to learn, and ownership mindset.

Preferred Skills

• Experience with AI tools such as ChatGPT, Gemini, or Microsoft Copilot.
• Basic understanding of business operations, finance, or marketing.
• Familiarity with project management tools (Notion, Trello, ClickUp, Asana, etc.) is a plus.

What You'll Gain

• Direct mentorship from startup founders.
• Exposure to strategic decision-making and business operations.
• Opportunity to work across multiple business functions.
• Hands-on experience in an AI technology startup.
• Networking opportunities with clients, partners, and industry leaders.
• A certificate of completion and a Letter of Recommendation based on performance.
• Potential for a full-time opportunity after successful completion of the internship.

Why Join Daten & Wissen?

• Work on cutting-edge AI and Video Analytics solutions.
• Learn directly from experienced founders and industry professionals.
• Gain real startup experience with meaningful responsibilities.
• Fast learning environment with significant growth opportunities.
• Opportunity to contribute to products deployed across enterprise customers.

Location: Bhayandar West, Mumbai (On-site)

Internship Duration: 6 Months

Stipend: ₹5,000 – ₹10,000 per month (Based on skills and performance)

Employment Type: Internship (Full-time)

Laptop Compulsory

Joining: Immediate

Job role: FP&A Analyst

Location: Bangalore, India

Job Requirements: Drive end-to-end financial planning, budgeting, forecasting, and scenario analysis to support strategic decision-making across Balance Sheet, P&L, and cost structures.

Key responsibilities:

A. Planning & Budgeting

• Manage driver-based budgeting models

• Consolidate and validate P&L, Balance Sheet, and key ratios

• Support business units in preparing planning submissions and review packs

• Execute cost allocation models, Maintain allocation drivers,

B. Variance Analysis

• Actual vs Budget / Forecast analysis

• MoM and YoY movement analysis

• Cost center-level variance breakdowns

• Volume / rate / mix analysis

C. Forecasting

• Prepare monthly rolling forecasts

• Update outlook based on performance, macro factors, and business inputs

• Maintain driver-based and scenario-integrated forecasting models

D. Scenario Analysis & Stress Testing

• Perform sensitivity and what-if analysis (e.g., NIM, impairments, costs)

• Support regulatory exercises (ICAAP / ILAAP / stress scenarios)

• Quantify capital and liquidity impacts

• Prepare governance & committee packs

E. Governance & Reporting

• Produce segment/customer profitability reports

• Draft variance commentary (templated/automated)

• Highlight key drivers and anomalies

• Prepare Board / ExCo packs

• Identify risks and opportunities in financial plans

• Validate data integrity and consistency across models

Soft skills:

• Advanced FP&A expertise (Banking preferred)

• Strong understanding of Balance Sheet & Capital metrics

• Financial modelling (driver-based, scenario modelling)

• Knowledge of stress testing frameworks (BoE scenarios preferred)

• Advanced Excel + planning tools (Anaplan, SAP BPC, Hyperion)

Tools / Systems

• Planning tools: Anaplan / BPC / Hyperion/FCSS/ Oracle Fusion

• Excel (advanced modelling)

• BI tools: Power BI / Tableau

Risks & Controls

• Risk: Model inaccuracies → Control: Model validation & reconciliation

• Risk: Data inconsistency → Control: Cross-functional alignment checks

Risk: Regulatory non-compliance → Control: ICAAP/ILAAP validation reviews

Education requirements:

• Chartered Accountant

• Master’s degree in accounting, Finance, Economics, or related field

Certification:

• Anaplan / BPC / Hyperion/FCSS/ Oracle Fusion

• Excel (advanced modelling)

Keyword:

Skills: Data Concepts & Data Modelling~F&A - Financial Planning & Analysis

Experience Required: