Lakeshore Recycling Systems LLC

Data Engineer II

LocationRosemont, IL
Salary$93,000-$125,000

About This Job

As a Data Engineer II, you will be responsible for designing, developing, and maintaining robust data pipelines and warehouse solutions. You will work with modern data stack technologies to ensure efficient data integration, transformation, and delivery for analytics and reporting needs. This position requires hands-on development experience, mentorship of junior engineers, and close collaboration with analytics and business teams.


Design and implement scalable data pipelines using Azure Data Factory and other modern tools
Develop and optimize ETL/ELT processes for various data sources
Implement data quality frameworks and monitoring solutions
Build robust error handling and pipeline monitoring systems
Design and implement efficient data models for warehousing
Write complex SQL queries and stored procedures
Optimize database performance and query execution
Implement data governance and security measures
Develop solutions using Azure Fabric and other modern data platforms
Implement real-time data integration patterns when needed
Design and maintain data marts for specific business domains
Create and maintain data documentation and lineage
Develop automated testing frameworks for data pipelines
Implement data quality rules and monitoring systems
Perform code reviews and mentor junior engineers
Ensure compliance with data governance standards
Mentor Data Engineer I team members
Collaborate with business analysts and data scientists
Participate in architecture discussions and design reviews
Help define and implement best practices

Requirements: Bachelor's degree in Computer Science, Information Systems, or a related field * - or an equivalent combination of education, certifications, and proven hands-on experience.

2-5 years of hands-on data engineering experience
Strong experience with SQL and database optimization
Proficiency with Azure data services or similar cloud platforms
Experience with modern data warehouse architecture
Knowledge of data modeling and dimensional design
Understanding of data governance and security principles


Req Benefits: The Company LRS is the industry leader in providing innovative and environmentally responsibly waste and recycling solutions. Our team delivers exceptional service and value through relentless commitment to customer satisfaction and preservation of the en


Compensation: $93k to $125k

Additional Details : Physical Demands/Environmental Factors While performing the duties of this job, the employee is regularly required to sit; use hands to finger, handle, or feel; reach with hands and arms; and talk or hear Occasionally required to stand and walk

Lakeshore Recycling Systems is proud to be an equal opportunity workplace and is an affirmative action employer. We are committed to equal employment opportunity regardless of race, color, ancestry, religion, sex, national origin, sexual orientation, age,

Notice: The inclusion of job postings or company information on our platform does not imply endorsement, partnership, or affiliation. Listings may include publicly available roles from various sources, and companies shown may not have a direct relationship with Energy Hire.