Data Engineer II

at Alight Solutions LLC in Lincolnshire, Illinois, United States

Job Description

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."

It's why we're so driven to connect passion with purpose. Our team's expertise in human insights and cloud technology, gives companies and employees around the world the ability to power confident decisions, for life.

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

Position responsible for delivery of data solutions supporting analytic and reporting efforts. Specifically, the position will focus on the creation of data pipelines to optimize the architecture, design, governance, and movement to support self-service BI as well as performing statistical analysis, correlations, etc.

Responsibilities include leading, defining, designing, building, testing and maintenance of the AWS data architecture, including ingestion of data from S3 across various source types - Parquet, csv, text, etc. Responsible for the architecture of the transformation and integration layers utilizing various ETL tools and Redshift to create optimal structures to support centralized usage across BU and analytics. Responsible for helping propagate knowledge across this space to other team members and help to promote standards and best practice definition.

What You'll Do:

Focuses on data architecture, design, and delivery of data solutions across the AWS environment.
Designs, implements, and ensures data solutions are built, maintained, and updated based on established business requirements.
Collaborates with leadership to provide meaningful and credible feedback on data architecture, design, and delivery.
Works autonomously, in team settings and in partnership with management to review data design and solutions.
Identifies information needed, sources, and uses tools to deliver optimal solutions per the use case.
Partners with IT, Database Administrators, and business owners to ensure all data/data sources needed for reporting and analytics are defined and incorporated into the appropriate data solution.
Develops, implements, communicates, and maintains automated processes adhering to the deployment and support standards.
Develops data quality metrics that identify gaps and ensures compliance with standards across the enterprise.
Leads analysis, estimation, planning and implementation of data solutions.
Serves as a liaison with functional groups around data and BI. Leads planning and execution of multiple, simultaneous initiatives.
Conducts business data analysis and design to support effective report development and business decisions.
Leverages external best in class reporting solutions to support data needs.
Understand the data ecosystem to support placing data in the correct infrastructure.
Create the processes to show where and how data should be moved/ aggregated once it is landed from source systems into the data lake environment (S3)
Create the design and models for combing data across sources for efficient query patterns from BI and analytics.
Ensure governance standards are followed.
Review ongoing performance of existing assets and modify if needed.
Fast-track the use of Redshift and other AWS tools & services across the data lake environment.

What You'll Need:

bachelor's degree in Business, Technology or equivalent
Demonstrated successful business analysis, design and development of data solutions, or equivalent combination of education and experience in data solution architecture, design, and solution delivery.
Multiple years of interaction with business and technology partners to collect and translate business needs into service deliverables.
Experience with Data Visualization and Business Intelligence tools
Extensive development of data solutions across disparate sources - Hadoop, Hive, Microsoft SQL, Redshift, Spark, NoSQL, etc.
Deep understanding of AWS data architecture, design, data modeling, and optimization of data solutions to support analytics and BI solutions requiring very fast query... For full info follow application link.

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

Copy Link

Job Posting: 11306849

Posted On: Sep 22, 2023

Updated On: Oct 22, 2023

Please Wait ...