About this role
• 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 and Large-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
• 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 and Large-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