JD Analytics Engineer

Experience & Expectations :
- Leverage extensive experience (2 to 4 years overall Analytics experience).
- We are seeking a hands-on Analytics Engineer to bridge the gap between Data Engineering and Business Analytics within the Alight ecosystem. The role focuses on transforming raw data into analytics-ready datasets, enabling scalable reporting, and driving data-driven insights across different Analytics domains.
- The ideal candidate will work closely with Data Engineers / BI teams, and Product stakeholders to build robust semantic models, and support enterprise analytics platforms.

1. Data Modeling & Transformation
- Develop and maintain analytics-ready data models (dimensional/star schema) for reporting and dashboards
- Ensure consistency, reusability, and scalability of data models

2. Analytics Engineering & Pipeline Support
- Work alongside Data Engineers to understand the ETL/ELT pipelines

3. BI & Reporting Enablement
- Design and optimize datasets for BI tools (AWS QuickSight, Tableau, Power BI)
- Partner with BI developers to build dashboards, KPIs,



and analytical reports
- Support ad-hoc analytics and business use cases

4. Data Quality, Governance & Security
- Ensure adherence to data governance, security, and understanding of RLS / CLS concepts.
- Maintain documentation

5. Performance Optimization
- Optimize SQL queries, and reporting performance
- Ensure efficient handling of large datasets across distributed systems

6. Cross-functional Collaboration
- Work with Product Owners, Data Engineers, and Analysts to translate business requirements into technical solutions
- Support stakeholder teams across different Alight domains
- Contribute to Agile delivery

Critical Technical Skills (Alight Ecosystem Focus)
Core Data & Analytics
- Robust Advanced SQL skills (Preferably Redshift DB)
- Data modeling: Dimensional modeling, star schema, normalization concepts

Cloud & Data Platform (AWS-heavy)
- Working knowledge of:
- DynamoDB
- A

📌 Analytical EngineerF Interview) (Gurugram)
🏢 Sourceease Hr Services
📍 Gurugram