CDM Smith is seeking a Data Engineer to join our Digital Engineering Solutions team. This individual will be part of the Data Technology group within the Digital Engineering Solutions team, helping to drive strategic Architecture, Engineering and Construction (AEC) initiatives using cutting-edge data technologies and analytics to deliver actionable business insights and robust solutions for AEC professionals and client outcomes. The Data Technology group will lead the firm in AEC-focused Business Intelligence and data services by providing architectural guidance, technological vision, and solution development. The Data Technology group will specifically utilize advanced analytics, data science, and AI/ML to give our business and our products a competitive advantage. It includes understanding and managing the data, how it interconnects, and architecting & engineering data for self-serve BI and BA opportunities. This position is for a person who has demonstrated excellence in data engineering capabilities, experienced with data technology and processes, and enjoys framing a problem, shaping and creating solutions, and helping to lead and champion implementation. As a member of the Digital Engineering Solutions team, the Data Technology group will also engage in research and development and provide guidance and oversight to the AEC practices at CDM Smith, engaging in new product research, testing, and the incubation of data technology-related ideas that arise from around the company.

Key Responsibilities:
• Assists in the design, development, and maintenance of scalable data pipelines and workflows to extract, transform, and load (ETL/ELT) data from various sources into target systems.
• Contributes to automate workflows to ensure efficiency, scalability, and error reduction in data integration processes.
• Tests data quality and integrity by implementing processes to validate completeness, accuracy, and consistency of data.
• Monitor and troubleshoot data pipeline performance and reliability.
• Document data engineering processes and workflows.
• Collaborate with Data Scientists, Analytics Engineers, and stakeholders to understand business requirements and deliver high-quality data solutions.
• Stay abreast of the latest developments and advancements, including new and emerging technologies & best practices and new tools & software applications and how they could impact CDM Smith.
• Assist with the development of documentation, standards, best practices, and workflows for data technology hardware/software in use across the business.
• Perform other duties as required.

Skills and Abilities:
• Good foundation with the Software Development Life Cycle (SDLC) and Agile Development methodologies.
• Good foundation with Cloud ETL/ELT tools and deployment, including Azure Data Factory, Azure Databricks, and Azure Synapse Analytics.
• Good Knowledge in data modeling and designing scalable ETL/ELT processes.
• Familiarity with CI/CD pipelines and DevOps practices for data solutions.
• Knowledge of monitoring tools and techniques for ensuring pipeline observability and reliability.
• Excellent problem-solving and critical thinking skills to identify and address technical challenges effectively.
• Strong critical thinking skills to generate innovative solutions and improve business processes.
• Ability to effectively communicate complex technical concepts to both technical and non-technical audiences.
• Detail oriented with the ability to assist with executing highly complex or specialized projects.