Data Manager

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 dynamic Data Engineer to join our team of technology enthusiasts. You will leverage data to drive strategic decision-making and pioneering solutions, working with complex datasets, collaborating closely with stakeholders, and transforming data into actionable insights to drive innovation.

Qualifications and Skills:

• Minimum 5 years of experience as a Data Engineer
• Hands-on experience with Azure cloud-based data solutions
• Expertise in database design and management, including SQL databases such as SQL Server
• Proficient in ETL (Extract, Transform, Load) design for data integration and processing
• Strong knowledge of data modeling principles and techniques
• Ability to analyze and translate data into actionable insights, reports, and visualizations
• Proficiency in Power BI for reporting and data visualization

Desirable Skills:

• Experience with Power BI Report Builder / Reporting Services
• Knowledge of statistical analysis or Data Science
• Experience within the UK Insurance industry is a plus
• Python or R coding skills

Responsibilities:

• Implement efficient data exchange between internal and external systems to increase efficiency and reduce re-keying and translation errors
• Support the Broking business by developing high-quality information resources, ensuring data availability and accessibility for decision-making
• Engineer data inputs and outputs from core applications and semi-structured remote service data through data syncs between data lake, ODS (SQL database), and leveraging Fabric and ADF
• Perform data engineering tasks including ingestion, cleansing, and collation from a wide range of internal and external sources
• Implement different methods of streaming data and create reconciliations for datasets
• Build analytical models to support reporting and analytics
• Collaborate with an agile delivery team to work on the backlog of specified work

Role Overview

We are seeking a skilled Senior Data Analyst with substantial hands-on experience in Source System Analysis, data mapping, data modeling, SQL analysis, and integration testing. The ideal candidate will support seamless data flow across business applications, ensure data accuracy, and contribute to system improvements.

Key Responsibilities

• Conduct detailed data mapping between source and target systems, ensuring consistency and accuracy.
• Build and maintain data models to support business processes, reporting needs, and integration workflows.
• Write and optimize SQL queries for data validation, analysis, migration, and troubleshooting.
• Work closely with cross-functional teams to gather data requirements and understand business logic.
• Develop and execute integration test plans, including functional, data validation, and regression testing.
• Support data migration activities, including extraction, transformation, and loading (ETL).
• Monitor and troubleshoot integration issues, ensuring timely resolution.
• Document integration flows, data dictionaries, mapping catalogs, and knowledge artifacts.
• Ensure integration security, data integrity, and compliance with organizational standards.

Required Skills & Qualifications

• 5+ years of experience insource system integrations, data mapping, and system-to-system data workflows.
• Bachelor’s degree in Computer Science, Information Systems, Engineering, or related field.
• Hands-on experience with data mapping, data modelling, and database schema design.
• Proficiency in SQL (complex joins, stored procedures, performance tuning).
• Experience with ETL tools or integration platforms (Informatica, Boomi, MuleSoft, Talend, Pentaho).
• Strong analytical and problem-solving skills.
• Experience with API-based integrations (REST/SOAP) is a plus.
• Familiarity with testing methodologies for integrations and data validation.
• Ability to work with business users, understand workflows, and translate requirements into technical solutions.

Preferred Qualifications

• Experience with cloud ERP or cloud integration (AWS/Azure/GCP).
• Knowledge of JSON, XML, CSV transformation.
• Exposure to scripting languages (Python, Shell).
• Experience in Agile/Scrum environments.
• Prior involvement in ERP implementation or upgrade projects.

Competencies

• Tech Savvy - Anticipating and adopting innovations in business-building digital and technology applications.
• Self-Development - Actively seeking new ways to grow and be challenged using both formal and informal development channels.
• Action Oriented - Taking on new opportunities and tough challenges with a sense of urgency, high energy, and enthusiasm.
• Customer Focus - Building strong customer relationships and delivering customer-centric solutions.
• Optimize Work Processes - Knowing the most effective and efficient processes to get things done, with a focus on continuous improvement.

Why Join Us?

• Be part of a collaborative and agile team driving cutting-edge AI and data engineering solutions.
• Work on impactful projects that make a difference across industries.
• Opportunities for professional growth and continuous learning.
• Competitive salary and benefits package.

Application Details

Ready to make an impact? Apply today and become part of the QX Impact team!

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.

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)