Data Engineer

Stellent IT LLC; Hanover (MD); Hybrid; USD 110,000 - 160,000; Full time

Job summary

Stellent IT LLC seeks a seasoned Data Engineer to lead data integration, migration, and post-deployment support across an eight-month project lifecycle.

You will design and configure Azure Synapse environments, implement private connectivity, migrate pipelines, and ensure data quality while coordinating with cloud infrastructure, DBAs, application owners, and stakeholders to deliver a secure, production-ready analytics platform.

Qualifications

• 8+ years of software development experience.
• Experience with MDOT or related transportation data projects.
• Bachelor's degree in CS, statistics, math, econ or related field; 3 years substitute allowed.
• Experience with Agile development.
• Data warehouse experience.
• Knowledge of DevOps practices.
• Use Azure Data Factory and Synapse Analytics for data migrations.
• PowerShell scripting skills.
• Azure cloud technologies (Power Apps, Dataverse).
• Data integration from multiple sources with quality focus.
• Keep data pipelines secure.
• Experience with Azure Synapse, Data Factory, Databricks, and Stream Analytics.
• Hands-on development with C#, ASP.NET, Web APIs.
• Microsoft DevOps or GitHub.
• Azure Cloud Services certification.
• Experience in Java/.NET and JavaScript.
• Familiarity with Oracle and SQL databases.
• Strong functional and technical background.
• Excellent communication, collaboration, and customer focus.

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.

Skills

Azure Synapse

Azure Data Factory

ETL/ELT

PowerShell

Azure Databricks

Data Warehousing

SQL

C#

ASP.NET

GitHub

Education

Bachelor's degree in Computer Science or related field

Tools

Azure Synapse Analytics

Azure Data Factory

Azure Databricks

SQL Server

Oracle

Job description

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.