Data Engineer

Description

Sargent & Lundy is a leading consulting engineering firm specializing in the power and energy sectors. Since 1891, we have provided comprehensive engineering, design, and consulting services for both traditional and renewable power generation, grid modernization, nuclear power, and more. Our mission is to help clients achieve their energy goals effectively by adopting advanced technologies and sustainable practices. We are looking for a motivated Data Engineer to join our growing data-driven team to enhance our data infrastructure and support analytics initiatives.

Role Overview

As a Data Engineer at Sargent & Lundy, you will be involved collaborating with cross-functional teams, building and maintaining data pipelines, and ensuring data quality and governance. You'll contribute to analytics and experimentation efforts, while also driving process improvements and supporting strategic initiatives. This is a cross-functional and growth-oriented role, perfect for those eager to make a meaningful impact while fostering a culture of data literacy.

Key Responsibilities

Data Engineering & Infrastructure

• Assist in the design, development, and maintenance of scalable data pipelines and ETL processes to ensure data accuracy and reliability across various internal systems and support analytics initiatives.

• Help integrate and manage various data sources, including cloud-based data platforms (AWS, Azure, Google Cloud).

• Participate in data architecture discussions to improve data reliability and scalability, working with data engineers to enhance infrastructure.

• Maintain thorough documentation of data engineering processes and workflows to ensure consistency and ease of knowledge transfer within the team.

• Lead post-mortems on data-related incidents, helping the team learn from past challenges and refine processes to prevent future issues.

Collaboration & Cross-Functional Initiatives

• Collaborate with cross-functional teams to identify data needs and provide actionable insights.

• Partner with stakeholders to define and refine metrics that guide decision-making, helping teams across the organization make data-driven decisions.

• Work closely with data analysts, data scientists, and other stakeholders to provide reliable data access for analysis and ensure data availability and performance for different teams within the organization.

• Participate in cross-functional sprint planning to align data initiatives with broader company goals, ensuring that analytical work supports upcoming launches and projects.

• Facilitate regular data reviews with other teams, identifying gaps, inconsistencies, or emerging needs that could be addressed to improve business outcomes.

• Act as a liaison between business units and technical teams, translating business requirements into technical specifications that guide data-related projects.

• Contribute to company-wide data culture to increase awareness and understanding of data's impact.

Data Quality & Governance

• Monitor and ensure data quality by implementing validation checks, identifying data discrepancies, and advocating for data quality improvements across systems.

• Collaborate on data governance initiatives, working with security and compliance teams to ensure data privacy and adherence to regulatory requirements.

• Take ownership of data documentation, including definitions, data lineage, and best practices to promote data literacy across the organization.

Automation

• Leverage robotic process automation (RPA) and workflow automation tools (for example, Power Automate and Python scripts) to streamline repetitive operational tasks including reporting, data file transfers, compliance checks, and report generation

• Develop monitoring and automated alerting solutions for data pipeline failures, data drift, and data quality issues, enabling proactive resolution and maintaining high data reliability.

• Collaborate with cross-functional teams to identify, design, and implement process automation opportunities across engineering design, reporting, project management, and documentation workflows, boosting efficiency with macros, scripting, and industry-standard automation tools.

Strategic Support & Professional Growth

• Engage in the mentoring and training of other analysts or non-technical stakeholders, enhancing their data skills and helping them grow professionally.

• Stay up-to-date on industry trends and best practices, identifying opportunities to implement new tools or techniques that benefit the entire data team.

• Support leadership in strategic planning, providing data-backed insights that help shape the company's direction and key objectives.

This position offers the flexibility of a hybrid schedule with the expectation of 3 days per week in our downtown Chicago office, and 2 days remote from home.

Qualifications

Key Qualific ations

• Bachelor's degree in Computer Science, Information Systems, Data Engineering, or a related field.
• At least 2 years of experience in a data engineering or similar role, including internships or co-op programs.
• Basic proficiency in SQL for querying databases and manipulating data.
• Familiarity with ETL tools and processes
• Experience with cloud platforms, such as AWS, Azure, or Google Cloud, for data storage and processing.
• Familiarity with Python or another programming language used for data manipulation and scripting.
• Strong attention to detail with a proactive approach to problem-solving.
• Ability to work collaboratively with cross-functional teams and communicate effectively with both technical and non-technical stakeholders.
• A willingness to learn and adapt to new technologies and methodologies in data engineering.

Why Join Us?

• Work in an established company that values innovation and growth.
• Engage with a collaborative team that is dedicated to making a meaningful impact in the energy sector.
• Gain exposure to cutting-edge projects and contribute to data-driven decision-making processes.

We do not sponsor employees for work authorization in the U.S. for this position.

Award-Winning Benefits

At Sargent & Lundy, we care about the health and well-being of our employees. Our commitment extends beyond the workplace, offering comprehensive healthcare plans and generous paid time off to support our team members in every aspect of their lives. We understand the importance of work-life balance, which is why we are proud to provide competitive, award-winning benefits. Our dedication to employee satisfaction has earned us the prestigious Top Workplaces Culture Excellence Award for compensation and benefits in 2022, 2023, and 2024.

Compensation Range

$61,980.00 - $93,110.00

Transparency Statement

Sargent & Lundy discloses compensation ranges that comply with all local and state regulations. The total compensation package for eligible positions will include a base salary or an hourly rate and a comprehensive benefits package, reflecting our commitment to rewarding performance and supporting the overall well-being of our employees. Individuals may also be eligible to participate in our yearly discretionary bonus.

Awards & Recognition

Equal Opportunity

Sargent & Lundy is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, national origin, disability status, protected veteran status, or any protected status as defined by applicable law.