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

- Strong Advanced SQL skills (Preferably Redshift DB)
- Data modeling: Dimensional modeling, star schema, normalization concepts

Cloud & Data Platform (AWS-heavy)

- Working knowledge of:

- DynamoDB

- Amazon S3

- Redshift

BI & Visualization

- Hands-on experience with :

- QuickSight

- Tableau

- Power BI

Preferred / Good-to-Have Skills

- AWS Certification (Cloud Practitioner / Associate)

Experience & Qualifications

- Bachelors degree in Computer Science, Engineering, or related field
- Robust problem-solving and analytical mindset

Soft Skills

- Ability to translate business requirements into data solutions
- Strong collaboration across distributed teams (onshore/offshore)
- Ownership mindset with focus on delivery quality

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