* 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 robust 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 visuali
📌 Data & Analytics Engineer (Gurugram)
🏢 EXL
📍 Gurugram