Lead Assistant Manager

Earnmodes; Gurugram District; On-site; INR 1,200,000 - 1,800,000; Full time

Job summary

Earnmodes is seeking an Analytics Engineer with 6–9 years of experience to design scalable analytics solutions and enterprise data products in Gurgaon. You will work across data modeling, SQL, and Power BI to deliver actionable business insights.

You will engage with cross-functional teams, implement robust ETL pipelines, and optimize data quality, governance, and reporting. Prior experience in insurance/financial analytics is a plus.

Qualifications

• 5-9 years of experience in Azure/AWS, Power BI, SQL, data modeling and analytics engineering.
• Experience building end-to-end modern data warehouses for analytical data preparation and data products.
• Strong SQL scripting including complex queries, views, and transformation logic.
• Solid understanding of analytical data models and enterprise analytics architecture.
• Experience in Agile delivery environments is preferred.

Responsibilities

• Design and implement scalable analytical solutions using AWS Redshift and S3.
• Build and optimize transformation workflows, ingestion pipelines, and enterprise reporting structures.
• Develop and maintain advanced SQL scripts, views, stored procedures, and reusable analytical components.
• Lead enterprise analytics initiatives with robust modeling and warehouse best practices.
• Develop, design, and enhance dashboards and reports using Power BI.
• Collaborate with clients and teams to gather analytics requirements and deliver insights.
• Ensure data governance, data organization, and reporting standards across projects.

Skills

Azure/AWS

Power BI

SQL

Data modeling

Data visualization

Analytics engineering

Agile

Data governance

Stakeholder management

Cloud analytics

Tools

Power BI

SQL scripting

ETL

Job description

Job Description

Job Identification20006
Posting Date18/10/2026, 01:26 pm
Job RoleProduct Development-Technology/Digital Product Owner
Experience (In Years)6-9
Job LocationGurgaon
Job Description
Design and implement scalable analytical solutions using the AWS redshift , S3 bucket
Build and optimize transformation workflows, ingestion pipelines, and enterprise reporting structures
Develop and maintain advanced SQL scripts, views, stored procedures, and reusable analytical components
Drive enterprise-wide analytics initiatives through robust modeling and warehouse best practices along with data preparation, analytics data organization, data schema testing, and enterprise data product management.
Build and support scalable ETL workflows, ingestion pipelines, and transformation processes
Perform analytical data manipulation by writing complex SQL scripts, creating views, and optimizing queries to support reporting and business analytics needs.
Exposure with data products development, support with SCD (Slowly Changing Dimensions) ,CDC (Change Data Capture) ,Dimensional and relational modeling techniques , Enterprise warehouse frameworks
Perform detailed data quality checks, reconciliation, validation, and assessment activities
Deliver high-performing analytical solutions with strong focus on scalability, reliability, and optimization
Design and maintain analytical data models to enable scalable reporting, efficient data consumption, and business insight generation.
Develop, design, and enhance interactive dashboards and reports using Microsoft Power BI by translating client requirements into innovative BI solutions.
Participate in architecture discussions and recommend best practices for analytics modernization initiatives
Collaborate with clients, business users, and technical teams to gather analytics requirements and deliver strategic insights for decision-making.
Ensure adherence to best practices in data governance, analytical data organization, reporting standards, and cross-functional project delivery.

Candidate Profile

• 5-9 years of experience with Azure/ AWS, Microsoft Power BI, SQL, analytical data modeling, data visualization, enterprise data products, and analytics engineering frameworks.
• Proven experience as an Analytics Engineer with strong hands-on expertise in end-to-end modern data wareshouse build for analytical data preparation, data manipulation, schema validation/testing, and working with data products.
• Strong proficiency in SQL scripting including writing complex queries, creating views, data transformation logic, performance optimization andLarge-scale ingestion and transformation processes
• Solid understanding of analytical data models, data modeling concepts, data organization frameworks, and enterprise analytics architecture.
• Strong troubleshooting, tuning, and performance optimization capabilities
• Expertise in Microsoft Power BI including dashboard development, DAX, data modeling, and advanced visualization techniques.
• Good to have experience in Insurance Analytics, Financial Analytics, or strategic analytics and insights delivery for enterprise clients.
• Excellent communication and stakeholder management skills with the ability to work effectively across cross-functional business and technical teams.
• Exposure to modern cloud analytics ecosystems and enterprise transformation initiatives
• Experience working in Agile delivery environments
• Domain Expertise : Good to have

Prior experience in the Insurance domain

• Good understanding of Finance processes within Insurance
• Familiarity with insurance reporting, premium, claims, policy, and financial data structures is an added advantage

Responsibilities

• Design and implement scalable analytical solutions using the AWS redshift , S3 bucket
• Build and optimize transformation workflows, ingestion pipelines, and enterprise reporting structures
• Develop and maintain advanced SQL scripts, views, stored procedures, and reusable analytical components
• Drive enterprise-wide analytics initiatives through robust modeling and warehouse best practices along with data preparation, analytics data organization, data schema testing, and enterprise data product management.
• Build and support scalable ETL workflows, ingestion pipelines, and transformation processes
• Perform analytical data manipulation by writing complex SQL scripts, creating views, and optimizing queries to support reporting and business analytics needs.
• Exposure with data products development, support with SCD (Slowly Changing Dimensions) ,CDC (Change Data Capture) ,Dimensional and relational modeling techniques , Enterprise warehouse frameworks
• Perform detailed data quality checks, reconciliation, validation, and assessment activities
• Deliver high-performing analytical solutions with strong focus on scalability, reliability, and optimization
• Design and maintain analytical data models to enable scalable reporting, efficient data consumption, and business insight generation.
• Develop, design, and enhance interactive dashboards and reports using Microsoft Power BI by translating client requirements into innovative BI solutions.
• Participate in architecture discussions and recommend best practices for analytics modernization initiatives
• Collaborate with clients, business users, and technical teams to gather analytics requirements and deliver strategic insights for decision-making.
• Ensure adherence to best practices in data governance, analytical data organization, reporting standards, and cross-functional project delivery.

Qualifications

• 5-9 years of experience with Azure/ AWS, Microsoft Power BI, SQL, analytical data modeling, data visualization, enterprise data products, and analytics engineering frameworks.
• Proven experience as an Analytics Engineer with strong hands-on expertise in end-to-end modern data wareshouse build for analytical data preparation, data manipulation, schema validation/testing, and working with data products.
• Strong proficiency in SQL scripting including writing complex queries, creating views, data transformation logic, performance optimization andLarge-scale ingestion and transformation processes
• Solid understanding of analytical data models, data modeling concepts, data organization frameworks, and enterprise analytics architecture.
• Strong troubleshooting, tuning, and performance optimization capabilities
• Expertise in Microsoft Power BI including dashboard development, DAX, data modeling, and advanced visualization techniques.
• Good to have experience in Insurance Analytics, Financial Analytics, or strategic analytics and insights delivery for enterprise clients.
• Excellent communication and stakeholder management skills with the ability to work effectively across cross-functional business and technical teams.
• Exposure to modern cloud analytics ecosystems and enterprise transformation initiatives
• Experience working in Agile delivery environments

Required Skills

• Attention To Consistency
• Data Management Tools
• Excel Applications
• Internal Communications
• Interpersonal Relationship Building
• Leadership Capabilities
• SQL Analysis
• Tableau
• Working under Pressure

Source: Company Career page