Business Intelligence Engineer - Virtual

US-IL-Illinois-Virtual, United States

Alight Solutions

Alight works with the best-known brands to create a benefits advantage -- an opportunity to optimize costs while delivering a world-class benefits experience.

View all jobs at Alight Solutions

Apply now Apply later

Business Intelligence EngineerAre you a keen problem solver?Are you fascinated about data conversions?

Our Story

At Alight, we believe a company’s success starts with its people. At our core, we Champion People, help our colleagues Grow with Purpose and true to our name we encourage colleagues to “Be Alight.”

Our Values

Champion People – be empathetic and help create a place where everyone belongs.

Grow with purpose – be inspired by our higher calling of improving lives.

Be Alight – act with integrity, be real and empower others.


It’s why we’re so driven to connect passion with purpose. Alight helps clients gain a benefits advantage while building a healthy and financially secure workforce by unifying the benefits ecosystem across health, wealth, wellbeing, absence management and navigation.

With a comprehensive total rewards package, continuing education and training, and tremendous potential with a growing global organization, Alight is the perfect place to put your passion to work.

Join our team if you Champion People, want to Grow with Purpose through acting with integrity and if you embody the meaning of Be Alight.

Learn more at careers.alight.com.

About the Role

You will develop data models, construct visualizations, and conduct data analysis that can be used to communicate outcomes and identify opportunities.

Responsibilities

  • Writing high-quality SQL code to retrieve and analyze data from database tables, and design stored procedures.
  • Developing data models, dashboards, and reports to answer critical business questions.
  • Addressing ad-hoc requests swiftly by writing SQL queries or developing supporting visuals to answers critical questions.
  • Providing technical and design support for data analysts
  • Tracing data lineage across platforms to perform root cause analysis
  • Performing peer code reviews
  • Writing technical documentation to bridge communication between code scripts and business requirements
  • Designing, maintain and optimize ETL processes
  • Troubleshooting data issues, validate result sets, and perform effective testing on released content

Requirements

  • Have completed a program of study typically requiring four years of post-secondary education or higher educational attainment.
  • Demonstrate experience in SQL, ETL development, data modeling and data warehousing
  • 3+ years of relevant work experience performing quantitative analysis
  • Understand knowledge of data management and storage principles
  • Advance ability to distill complex problems into insights and opportunities
  • Enhanced track record of developing user-friendly reports and dashboards
  • Design with Tableau, PowerBI, QuickSight, SSRS or Tableau CRM/Einstein Analytics
  • Exhibit skills with MS-SQL or Redshift.
  • Experience with Dynamics CRM .
  • Demonstrate skills with Azure Data Factory, AWS Glue or SSIS.

Flexible Working

So that you can be your best at work and home, we consider flexible working arrangements wherever possible. Alight has been a leader in the flexible workspace and “Top 100 Company for Remote Jobs” 5 years in a row.

Benefits

We offer programs and plans for a healthy mind, body, wallet and life because it’s important our benefits care for the whole person. Options include a variety of health coverage options, wellbeing and support programs, retirement, vacation and sick leave, maternity, paternity & adoption leave, continuing education and training as well as a number of voluntary benefit options.

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: SSN/SIN 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.

Our commitment to Diversity and Inclusion

Alight is committed to diversity, equity, and 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 reasonable accommodations for the hiring process. If reasonable accommodation is needed, please contact alightcareers@alight.com.

Diversity 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 and advance in the employment of qualified minorities, women, disabled persons, disabled veterans and other covered veterans.

Alight provides reasonable accommodations 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 a reasonable accommodation/modification by contacting his/her 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.

Under Department of Labor Regulations (29 CFR Part 471) federal contractors and subcontractors are required to inform employees of their rights under the National Labor Relations Act: https://bit.ly/DOLgov

#LI-Remote

P&T2025

    We offer you a competitive total rewards package, continuing education & training, and tremendous potential with a growing worldwide organization.

    Salary Pay Range

    Minimum :

    65,600 USD

    Maximum :

    104,100 USD

    Pay Transparency Statement: Alight considers a variety of factors in determining whether to extend an offer of employment and in setting the appropriate compensation level, including, but not limited to, a candidate’s experience, education, certification/credentials, market data, internal equity, and geography. Alight makes these decisions on an individualized, non-discriminatory basis. Bonus and/or incentive eligibility are determined by role and level. Alight also offers a comprehensive benefits package; for specific details on our benefits package, please visit: https://bit.ly/Alight_Benefits


    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.

    Alight Solutions provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, religion, creed, sex, sexual orientation, gender identity, national origin, age, disability, genetic information, pregnancy, childbirth or related medical condition, veteran, marital, parental, citizenship, or domestic partner status, or any other status protected by applicable national, federal, state or local law. Alight Solutions is committed to a diverse workforce and is an affirmative action employer.
    Apply now Apply later
    Job stats:  0  0  0

    Tags: AWS AWS Glue Azure Business Intelligence Data analysis Data management Data Warehousing ETL MS SQL Power BI QuickSight Redshift SQL SSIS Tableau Testing

    Perks/benefits: Career development Competitive pay Equity / stock options Flex hours Flex vacation Health care Medical leave Parental leave Salary bonus

    Regions: Remote/Anywhere North America
    Country: United States

    More jobs like this