**What We're Looking For** At HNTB, you can create a career that is meaningful to you while building communities that matter to all of us. For more than a century, we have been delivering solutions for some of the largest, most complex infrastructure projects across the country. With our historic growth, it is an exciting time to join our team of employee-owners. This opportunity entails being responsible for building and maintaining data pipelines and systems that support our data analysis and machine learning projects. You will be responsible for extracting, transforming, and loading data from various sources using SQL and AWS technologies, as well as creating and testing data models and schemas. You will also work closely with data scientists and analysts to provide them with the data they need to perform their tasks. **What You'll Do:** + Designs, develops, and deploys data pipelines and systems using SQL, AWS, Python, and other technologies + Implements best practices for data engineering, such as data modeling, data quality, data governance, data security, etc. + Performs data analysis, validation, and troubleshooting to ensure data accuracy and integrity + Monitors, optimizes, and maintains existing data pipelines and systems for performance and scalability + Researches and evaluates new data technologies and tools to improve data engineering processes and capabilities + Collaborates with cross-functional teams to understand business requirements and deliver data solutions that meet or exceed expectations. + Performs other duties as assigned. **What You'll Need:** + Bachelor’s degree in Computer Science, Engineering, or related field, or + In lieu of education, 4 years of relevant experience. **What You'll Bring:** + Proficiency in SQL queries and database management + Experience with Dashboarding tools such as PowerBI or Tableau + Experience with Data Gathering and Data Mapping exercises + Experience with AWS services such as S3, EC2, EMR, Lambda, etc. + Experience with ETL tools and frameworks such as Airflow, Spark, Kafka, etc. + Basic knowledge of Python or other programming languages for data manipulation and automation + Ability to work in a team and communicate effectively + Experience with a Public Sector Agency **What We Prefer:** + Master’s degree in Computer Science or Engineering **Additional Information** Click here for benefits information: HNTB Total Rewards Click here to learn more about EOE including disability and vet Visa sponsorship is not available for this position. \#RN . Locations: Atlanta, GA, Boston, MA . . . . . . . . . . . . . . . . The approximate pay range for Illinois is $71,265.82 - $106,898.74. Please note that the pay range provided is a good faith estimate for the position at the time of posting. Actual compensation will be dependent on factors, including but not limited to, the individual’s qualifications, experience, knowledge, skills, and abilities as well as physical work location within the state. . _NOTICE TO THIRD-PARTY AGENCIES:_ _HNTB does not accept unsolicited resumes from recruiters or agencies. Any staffing/employment agency, person or entity that submits an unsolicited resume to this site does so with the understanding that the applicant's resume will become the property of HNTB. HNTB will have the right to hire that applicant at its discretion and without any fee owed to the submitting staffing/employment agency, person or entity. Staffing/employment agencies who have fee agreements with HNTB must submit applicants to the designated HNTB recruiter to be eligible for placement fees._ **Job Type:** Regular **Full/Part Time:** Full time **Job Category:** Technical Group **ReqID:** R-24814