oracle
Data & Analytics Engineer
EXL Service
Gurugram, IND
Full-time
Senior · 5+ years experience
Hybrid
Discovered 3 days ago
AWSMicrosoft Power BISQLDAXETLSCD (Slowly Changing Dimensions)
Free
Job Fit Check
Base Career helps you apply smarter for this job.
?%
Ready to ScanKey skills for this role
AWSMicrosoft Power BISQL
Key Skills for This Role
AWSMicrosoft Power BISQLDAXETLSCD (Slowly Changing Dimensions)
Full Job Posting
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
- Candidate Profile:
Apply for this job in 1 click
Skip the repetitive application forms
Install the Base Career Chrome Extension and autofill job applications across major job boards with your profile.
Trusted by over 500,000 job seekers on Base Career
More from this employer
More jobs at EXL Service
Senior Manager
Pune, IND
Discovered TodayFull-time
Senior Associate
Noida, IND
Discovered TodayFull-time
Lead Assistant Manager
Noida, IND
Discovered TodayFull-time
Senior Executive
Bengaluru, IND
Discovered TodayFull-time
Senior Executive
, IND
Discovered TodayFull-time
Full Stack Engineer
Noida, IND
Discovered TodayFull-time
AWS Data Engineer
Gurugram, IND
Discovered TodayFull-time
CRM Manager (Planning), 1:1 Fan Engagement Marketing
, CAN
Discovered TodayFull-time