• 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, effective 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,
📌 Lead Assistant Manager (Gurugram)
🏢 EXL
📍 Gurugram