Data Engineer

Job Title: Data Engineer Location: Hanover, MD (but travel to other offices may be required as needed. 2 days of telework is permitted with 3 days in office required, at the discretion of the client) Duration: 6+ months Interview Mode: In-person at client location Description: Client is seeking a Data Engineer who will serve as the primary technical resource responsible for the successful execution of all data integration, migration, implementation, and post-deployment support activities throughout the eight-month project lifecycle. The Data Engineer will provide end-to-end technical services, including designing and configuring the Azure Synapse environment, implementing private endpoint connectivity, developing and updating linked services, migrating existing pipelines, converting Talend ETL jobs, validating source-to-target data accuracy, troubleshooting technical issues, and supporting system integration testing, user acceptance testing, production deployment, and operational stabilization. The role will also provide technical guidance, documentation, knowledge transfer, and ongoing collaboration with cloud infrastructure, cybersecurity, database administrators, application owners, and business stakeholders to ensure successful implementation while maintaining the stability, security, and integrity of enterprise data operations. By providing specialized expertise in Azure Synapse, Azure Data Factory, ETL/ELT processes, Azure networking, private endpoints, data integration, cloud data architecture, performance optimization, and operational support, the Data Engineer will reduce project risk, accelerate issue resolution, ensure adherence to enterprise security and governance standards, maintain implementation continuity, facilitate a smooth transition to production, and ensure all project milestones are completed on schedule while delivering a secure, resilient, high-performing, and production-ready analytics platform. Responsibilities Build data analytics solutions using Azure Synapse serverless SQL pools. Perform data engineering with Azure Synapse Apache Spark Pools. Monitor and troubleshoot data systems and pipelines to ensure high availability and performance. Work with Data Warehouses, Data Lakes, and Data Marts using Azure Synapse Analytics. Transfer and transform data with Azure Synapse Analytics pipelines. Monitor and optimize data storage and processing solutions for performance and efficiency. Design and implement data storage solutions using Azure services such as Azure Data Lake Storage, Azure Synapse Analytics, and Azure SQL Database Apply structured system development methodologies. Organize, prioritize, and follow complex or detailed technical procedures. Develop and maintain Data Lake and Data Warehouse schematics, layouts, architectures, and relational/non-relational databases for data access and advance analytics. Minimum Qualifications 8 years of software development experience Experience with Maryland Department of Transportation (MDOT). Bachelor's degree from an accredited college or university with a major in computer science, statistics, mathematics, economics, or related field. Three (3) years of equivalent experience in a related field may be substituted for the bachelor's degree. Experience with Agile Development Possess Data Warehouse Experience Knowledgeable in DevOps Practices Utilize Azure Data Factory, Synapse Analytics to perform data conversions, imports, and exports of data within and between internal and external software systems. Experience automating tasks with scripting tools and languages such as PowerShell. Familiarity with Azure Cloud Technologies such as Power Apps and Dataverse. Integrate data from multiple sources, ensuring data quality and integrity. Experience keeping data pipelines secure. Experience with Azure Synapse, Azure Data Factory, Azure Databricks, and Azure Stream Analytics. Expert hands-on software development experience using C#, ASP.NET, Web Services/APIs. Experience with Microsoft DevOps, or GitHub code management environment. Experience or certification in Azure Cloud Services. Prior experience with Java/.NET and JavaScript Familiarity with Oracle and SQL databases Strong functional and technical background Excellent communications, collaboration, and customer focus skills. #J-18808-Ljbffr