<p>What We're Looking For</p> <p>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.</p> <p>This opportunity entails being responsible for designing, building and maintaining scalable and reliable data systems and pipelines. Will be responsible for creating and optimizing data architectures, developing and testing data processing software, and ensuring data quality and security across various data sources and platforms. Will also collaborate with data scientists, analysts, and other stakeholders to provide data-driven insights and solutions for our business needs.</p> <p>What You'll Do:</p> <ul> <li>Designs, develops, and deploys data pipelines and systems using SQL, AWS, Python, and other technologies </li><li>Implements best practices for data engineering, such as data modeling, data quality, data governance, data security, etc. </li><li>Performs data analysis, validation, and troubleshooting to ensure data accuracy and integrity </li><li>Monitors, optimizes, and maintains existing data pipelines and systems for performance and scalability </li><li>Researches and evaluates new data technologies and tools to improve data engineering processes and capabilities </li><li>Collaborates with cross-functional teams to understand business requirements and deliver data solutions that meet or exceed expectations </li><li>Mentors junior data engineers and provide technical guidance and support. </li><li>Performs other duties as assigned. </li></ul> <p>What You'll Need:</p> <ul> <li>Bachelor's degree in Computer Science, Engineering, or related field and 6 years of related experience, or, </li><li>Master's degree in Computer Science, Engineering, or related field and 5 years of related experience, or, </li><li>In lieu of education, 10 years of relevant experience. </li></ul> <p>What You'll Bring:</p> <ul> <li>Proficient in SQL and Python for data manipulation and analysis </li><li>Experience with AWS cloud services such as S3, EC2, EMR, Redshift, Glue, etc. </li><li>Experience with big data technologies such as Spark, Hadoop, Kafka, etc. </li><li>Experience with data pipeline orchestration tools such as Airflow, Luigi, etc. </li><li>Experience with data warehouse design and modeling techniques such as star schema, snowflake schema, etc. </li><li>Experience with data quality tools and frameworks such as Great Expectations, dbt, etc. </li><li>Experience with data visualization tools such as Tableau, Power BI, etc. </li><li>Strong knowledge of data engineering principles and best practices </li><li>Excellent communication, collaboration, and problem-solving skills </li></ul> <p>What We Prefer:</p> <ul> <li>Master's degree in Computer Science or Engineering </li></ul> <p>Additional Information</p> <p>Click here for benefits information: HNTB Total Rewards</p> <p>Click here to learn more about Equal Opportunity Employer/Disability/Veteran</p> <p>Visa sponsorship is not available for this position.</p> <p>#RN</p> <p>.</p> <p>Locations:</p> <p>Boston, MA, Chicago, IL</p> <p>.</p> <p>.</p> <p>.</p> <p>.</p> <p>.</p> <p>.</p> <p>.</p> <p>.</p> <p>.</p> <p>.</p> <p>.</p> <p>.</p> <p>.</p> <p>.</p> <p>.</p> <p>.</p> <p>The approximate pay range for Illinois is $103,015.28 - $161,126.45. 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.</p> <p>.</p> <p>NOTICE TO THIRD-PARTY AGENCIES:</p> <p>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.</p>