Data Engineer

Data Engineer City Chicago State IL Country United States Area of Interest Information Technology Type Full Time - Regular Job ID 2024-13381 Business Group CEO Group Department Information Management 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. 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. The responsibilites for a Data Engineer include but are not limited to: 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. Analytics & Experimentation Develop and optimize data models for reporting and analytics, ensuring data is structured efficiently for business use, supporting evolving business needs, and driving efficiency and scalability in data workflows. Support experimentation efforts, working closely with product teams to design, track, and analyze A/B tests that impact user experience. Lead initiatives in predictive analytics or machine learning projects that bring new value to the business, identifying and prototyping innovative approaches to solve complex challenges. Identify opportunities for data-driven process improvements, collaborating with teams to redesign workflows that enhance productivity and effectiveness. Drive the adoption of self-service analytics, empowering other departments to explore and leverage data autonomously by creating user-friendly dashboards and resources. 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 This position requires: 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 such as Alteryx, Talend, Informatica, Microsoft SSIS, or AWS Glue. 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 alongside a talented team that values learning, growth, and innovation in the data and energy sector. Gain hands-on experience with modern data tools and technologies, and contribute to impactful projects in the power and energy domain. Benefit from mentorship opportunities from experienced data analysts and engineers to accelerate your professional development. Join a company committed to sustainability and making a positive impact in the energy industry. We do not sponsor employees for work authorization in the U.S. for this position. Sargent & Lundy is an Equal Opportunity/Affirmative Action employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability status, protected veteran status, or any protected status as defined by law. Award Winning Compensation & 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. Health & Wellness Financial Benefits Work-Life Balance Health Plans: Medical, Dental, Vision Life & Accident Insurance Disability Coverage Employee Assistance Program (EAP) Back-Up Daycare FSA & HSA 401(k) Pre-Tax Commuter Account Merit Scholarship Program Employee Discount Program Corporate Charitable Giving Program Tuition Assistance First Professional Licensure Bonus Employee Referral Bonus Paid Annual Personal/Sick Time (PST) Paid Vacation Paid Holidays Paid Parental Leave Paid Bereavement Leave Flexible Work Arrangements