Analytical Engineer(F2F Interview)

Sourceease Hr Services; Dadri, Gurugram District; On-site; INR 1,200,000 - 2,200,000; Full time

Job summary

Sourceease Hr Services seeks an Analytics Engineer to bridge data engineering and business analytics within the Alight ecosystem. Transform raw data into analytics-ready datasets to enable scalable reporting and drive data-driven insights across analytics domains.

The role collaborates with Data Engineers, BI teams, and product stakeholders to build semantic models, optimize SQL queries, and support enterprise analytics platforms using AWS-based tools such as Redshift, S3, DynamoDB and BI

Qualifications

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

Responsibilities

• Develop analytics-ready data models (dimensional/star schema) for reporting and dashboards.
• Collaborate with Data Engineers to understand ETL/ELT pipelines.
• Design and optimize datasets for BI tools (QuickSight, Tableau, Power BI).
• Partner with BI developers to build dashboards, KPIs, and analytical reports.
• Ensure data governance, security, and understanding of RLS/CLS concepts.

Skills

Advanced SQL

Data modeling

Analytics mindset

Education

Bachelor's degree in CS/Engineering or related field

Tools

DynamoDB

Amazon S3

Redshift

QuickSight

Tableau

Power BI

Job description

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