Analytical Engineer(F2F Interview)

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
• Strong 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