EXL—Data & Analytics Engineer

Job description

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 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 Requirements: 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 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.