Senior Data Engineer

Senior Data Engineer

Location : 1901 Chestnut Ave

Glenview, Illinois, 60025

United States

Category :

Information Technology

Date Needed by : 11 / 1 / 2025

Primary Duties and Responsibilities :

ou bring the motivation, teamwork, and integrity and we will provide the collaborative culture, professional development, and respect you deserve. And if you are good at what you do, you will have a career at Wespath Benefits and Investments. Join our team in Information Technology - and, if you like, teams such as our DEI Council or our Green Team on environmental sustainability - and make an impact through your work!

Wespath is an Equal Opportunity Employer that is committed to a diverse and inclusive company culture and does not discriminate against applicants and employees because of disability, sex, race, gender identity, sexual orientation, religion, national origin, age, veteran status, or any other protected status under the law.

Wespath, recognized as a 2017-2025 Chicago's Best and Brightest Companies to Work For and a 2018-2024 National Best and Brightest Companies to Work For, has an opportunity for a Senior Data Engineer that plays a crucial role in managing and optimizing data infrastructure at Wespath. The engineer is responsible for designing, building, deploying, and maintaining processes and solutions that will allow the business to make critical data-driven decisions. In coordination with project teams and IT management, the engineer will work with the business in defining project scope, requirements, and timeline for deliverables.

More specifically, as a Senior Data Engineer you will :

• Plan, design and implement the technical infrastructure for storing, processing, and analyzing data, including databases, data warehouses, data lakes, etc.
• Create and manage processes that take data from various sources, transform it into a usable format, and load it into a storage system.
• Utilize CI / CD pipelines to deploy solutions to target environments.
• Monitor data quality processes to ensure accuracy, consistency, and reliability.
• Perform data modelling and design for Wespath data and reporting applications.
• Collaborate with business users to create and support Business Intelligence reports.
• Conduct proof of concepts to guide technical implementation of modern data engineering tools and frameworks such as Azure Data Factory, Databricks, or MS Fabric.
• Document data and reporting application implementations, configurations, and support requirements as needed.
• Analyze and understand business user requirements to effectively develop solutions that meet business needs.
• Communicate regularly with stakeholders to provide updates on project progress and gather feedback.
• Implement data governance frameworks to ensure data quality, security, and compliance .

Senior Data Engineer Benefits and Compensation :

#LI-CW1

Minimum Requirements / Qualifications :

Bachelor's degree in computer science, Management Information

Systems, or a closely related field.

Seven years of experience in the solution development life cycle

for developing and maintaining data processing and reporting applications.

Extensive experience with :

Designing and implementing data, analytical and reporting ecosystems.

Data transformation development (ETL / ELT) tools (e.g., SSIS, Informatica, DataStage, etc.).

Reporting tools such as Power BI, Tableau, Domo, Infor Birst, or other similar tools.

Data modeling tools such as ER / Studio or Erwin.

Performance tuning and database design for SQL Server.

Building Operational Data Stores, Data Marts, Data Warehouses, Data Lakes, Lake Houses.

Working with non-relational data sources such as flat files, excel files, JSON files, and APIs.

Preferred Qualifications

Experience or familiarity with :

One or more Cloud Data platforms such as Microsoft Azure, AWS, or Google Cloud.

Emerging technologies such as machine learning and artificial intelligence.

Data quality

management and master data management, including tools such as Talend or

Informatica

Wespath Benefits and Investments is an Equal Opportunity Employer and does not discriminate in hiring.

PDN-9f1e51c1-9b27-4f62-8418-6f5b42c55077