Data Engineer

Company Description Halcyon Labs in North America is the top-ranked environmental company in the United States for three consecutive years, and the country’s largest private water operator and technology provider as well as hazardous waste and pollution treatment leader. It offers a full spectrum of water, waste, and energy management services, including water and wastewater treatment, commercial and hazardous waste collection and disposal, energy consulting and resource recovery. Halcyon Labs helps commercial, industrial, healthcare, higher education and municipality customers throughout North America. Headquartered in Boston, Halcyon Labs has more than 10,000 employees working at more than 350 locations across North America. Job Description Position Purpose: The Data Engineer is responsible for designing, building, and maintaining scalable data pipelines and infrastructure to support enterprise analytics, reporting, and AI initiatives. This role ensures the availability, quality, and reliability of data by integrating diverse sources into secure and optimized data platforms. Working closely with data scientists, analysts, and business stakeholders, the Data Engineer enables data-driven decision-making across the organization. #LI-DNI Primary Duties/Responsibilities: Develop and operate data management tools, monitoring data flows, data quality, data cleansing and data processing. Create and document logical data integration (ETL) strategies for data flows between disparate systems and the enterprise data warehouse/data lakes. Collaborate with different stakeholders (engineers, data owners) to collect required data from internal and external systems. Work in an Agile environment that focuses on collaboration and teamwork. Improve and extend existing data infrastructure services. Monitor production job schedule and correct job failures in a timely manner. Work Environment: Hybrid mode (2 days a week in the office). Qualifications Education/Experience/Background: MS degree in Computer Science or computer related field from an accredited institution. 3+ years hands proven experience as a Data Engineer or similar role. Knowledge/Skills/Abilities: Skills: More than 2 years of experience developing with Python. 1+ year performing with production environments in a DevOps culture managing code composed of multi-developer teams, following industry best practices. 2+ years SQL development experience. 1+ year experience with data modeling 1+ year bash scripting experience. 1+ year experience with Git, CI/CD (preferably GitLab) and Docker. 2+ years experience deploying and running services in Cloud Big Data platforms such as BigQuery and Snowflake. 1+ year experience with DAG workflows orchestration such as Apache Airflow, Prefect. Experience with designing and building data pipelines using tools like Apache Beam, CDAP (Data fusion). 1+ year experience with CDC design patterns and their challenges. Experience with NoSQL databases is a plus (i.e Firestore, MongoDB). Experience designing and developing APIs is a plus (i.e using FastAPI, Flask) Abilities: Embrace mentorship through design sessions, code reviews, and community building. Take ownership and support solutions you develop. Value collaboration with other members of the team. Have a product mindset. Good communication. Additional Information Pay Range: $169,541 to $175,000 Per Year. Benefits: Halcyon Labs’s comprehensive benefits package includes paid time off policies, as well as health, dental, vision, life insurance, savings accounts, tuition reimbursement, paid volunteering and more. In addition, employees are also entitled to participate in an employer sponsored 401(k) plan, to save for retirement. Sick leave – 56 hours; Observed Holidays – 11 days; Vacation – Flexible Time Off Eligible for up to 10% Annual Performance Bonus We are an Equal Opportunity Employer! All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability or protected veteran status. Disclaimer: The salary, other compensation, and benefits information is accurate as of the date of this posting. The Company reserves the right to modify this information at any time, subject to applicable law.