Data Engineer

Stellent IT LLC (Hanover MD, USA) Follow 9 days ago

Full-time

Apply Now

Hi,

Hope you are doing well. This is Dheeraj from Stellent IT.

We are hiring for the given job requirement. If you are interested in this role then please share below details:

Updated Resume
Current Location
Work Authorization
LinkedIn Id

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.