Job description

Our Story At Alight, we believe a company’s success starts with its people. Alight embraces values that come directly from our people – purposeful, human, united and growth-minded – reflecting our inclusive culture and promise that our clients expect. We are passionate about connecting purpose with impact. Alight empowers clients to build a healthier and more financially secure workforce by unifying the benefits ecosystem across health, wealth, wellbeing, navigation, and absence management. Our Benefits With a comprehensive total rewards package, Alight offers programs and plans that support your mind, body, wallet, and life. Benefits include health, starting Day One. Additionally, Alight colleagues enjoy wellbeing programs, retirement plans, and career growth opportunities – all within a thriving global organization. Great Place to Work Thanks to the work of every colleague, Alight has received multiple awards of recognition including “Great Place to Work” for the past 7 years and Fortune’s “Best Companies to Work For.” To learn more about our company culture and awards Click Here. We invite you to join our team! Learn more at careers.alight.com . JD – Analytics Senior Software Engineer Experience & Expectations : Leverage extensive experience (5 to 8 years overall Analytics experience). We are seeking a hands-on Analytics Senior Engineer to bridge the gap between Data Engineering and Business Analytics within the Alight ecosystem. The role focuses on designing robust analytics datasets, mentoring junior engineers, and driving BI solutions with a strong focus on performance, scalability, and governance 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 Modelling Design enterprise-grade data models Own semantic layer architecture Standardize KPIs and business metrics Ensure consistency, reusability, and scalability of data models 2. Analytics Engineering Work alongside Data Engineers to understand the ETL/ELT pipelines 3. BI & Reporting Enablement Build and optimize complex reports & dashboards Define data model strategies Handle large-scale analytical workloads 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 Implement advanced RLS/CLS models Define best practices for BI and data usage 5. Performance Optimization Tune complex SQL transformations Minimize dashboard latency and cost Ensure efficient handling of large datasets across distributed systems 6. Leadership & Mentorship Mentor junior engineers Review code, models, and dashboards Technical Skills (Alight Ecosystem Focus) Expert SQL (Redshift or similar MPP systems) Visualization Tools – QuickSight, Tableau, Power BI Database – Redshift, DynamoDB Strong AWS data ecosystem knowledge Data modelling expertise Preferred / Good-to-Have Skills AWS Certification (Cloud Practitioner / Associate) Qualifications Bachelor’s degree in Computer Science, Engineering, or related field Soft Skills Ability to translate business requirements into data solutions Strong collaboration across distributed teams (onshore/offshore) Ownership mindset with focus on delivery quality\ Application and Interview By applying for a position with Alight, you understand that, should you be made an offer, it will be contingent on your undergoing and successfully completing a background check consistent with Alight’s employment policies. Background checks may include some or all the following based on the nature of the position: Government ID validation , education verification, employment verification, and criminal check, search against global sanctions and government watch lists, credit check, and/or drug test. You will be notified during the hiring process which checks are required by the position. Alight requires all virtual interviews to be conducted on video. Please be aware that Alight is a camera-on culture and may require occasional travel to one of our physical office locations. Our commitment to Inclusion We celebrate differences and believe in fostering an environment where everyone feels valued, respected, and supported. We know that diverse teams are stronger, more innovative, and more successful. At Alight, we welcome and embrace all individuals, regardless of their background, and are dedicated to creating a culture that enables every employee to thrive. Join us in building a brighter, more inclusive future. As part of this commitment, Alight will ensure that persons with disabilities are provided with reasonable accommodation for the hiring process. If reasonable accommodation is needed, please contact alightcareers alight.com . Equal Opportunity Policy Statement Alight is an Equal Employment Opportunity employer and does not discriminate against anyone based on sex, race, color, religion, creed, national origin, ancestry, age, physical or mental disability, medical condition, pregnancy, marital or domestic partner status, citizenship, military or veteran status, sexual orientation, gender, gender identity or expression, genetic information, or any other legally protected characteristics or conduct covered by federal, state, or local law. In addition, we take affirmative action to employ disabled persons, disabled veterans, and other covered veterans. Alight provides reasonable accommodation to the known limitations of otherwise qualified employees and applicants for employment with disabilities and sincerely held religious beliefs, practices and observances, unless doing so would result in undue hardship. Applicants for employment may request reasonable accommodations/modifications by contacting their recruiter. Authorization to work in the Employing Country Applicants for employment in the country in which they are applying (Employing Country) must have work authorization that does not, now or in the future, require sponsorship of a visa for employment authorization in the Employing Country and with Alight. Note, this job description does not restrict management s right to assign or reassign duties and responsibilities of this job to other entities; including but not limited to subsidiaries, partners, or purchasers of Alight business units. We offer you a competitive total rewards package, continuing education & training, and tremendous potential with a growing worldwide organization. DISCLAIMER: Nothing in this job description restricts management s right to assign or reassign duties and responsibilities of this job to other entities; including but not limited to subsidiaries, partners, or purchasers of Alight business units. .

Requirements

Must-haves

Leverage extensive experience (5 to 8 years overall Analytics experience).
The ideal candidate will work closely with Data Engineers, BI teams, and Product stakeholders to build robust semantic models, and support enterprise analytics platforms.
Data Modelling
Design enterprise-grade data models
Own semantic layer architecture
Standardize KPIs and business metrics
Ensure consistency, reusability, and scalability of data models
Analytics Engineering
Work alongside Data Engineers to understand the ETL/ELT pipelines
BI & Reporting Enablement
Build and optimize complex reports & dashboards
Define data model strategies
Handle large-scale analytical workloads
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
Data Quality, Governance & Security
Implement advanced RLS/CLS models
Define best practices for BI and data usage
Performance Optimization
Tune complex SQL transformations
Minimize dashboard latency and cost
Ensure efficient handling of large datasets across distributed systems

Nice-to-haves

Preferred / Good-to-Have Skills

Application prep

Use the role’s language and application details while tailoring your materials.

Keywords to mirror

awssql

Platform: workday
Effort: long