Our client is seeking a mid–junior level Data Engineer to support a data warehouse modernization initiative centered on Azure Data Lake Storage (ADLS) and Azure Synapse Analytics. The objective of this effort is to consolidate and centralize enterprise data into a single, cloud-based source of truth.

While the role will involve working with existing SSIS and SSRS assets, it’s important to clarify that this position will not be responsible for the ongoing maintenance of SSIS/SSRS. Instead, the focus will be on supporting the migration and ingestion of those workloads into Synapse as part of a broader modernization strategy.

This is not a staff-augmentation or short-term contract opportunity. Our client is seeking a full-time hire who can grow with the team and make meaningful contributions as the data platform continues to evolve.

Role Summary
The Data Engineer will support development and business teams with data workflows, reporting processes, and incremental cloud adoption. This role is well-suited for a candidate with strong SQL Server and SSIS fundamentals who is motivated to grow deeper expertise in Azure-based data platforms under the guidance of senior engineers.

Key Responsibilities

Maintain and enhance SQL Server–based workflows, including stored procedures and existing SSIS/SSRS assets
Support senior engineers with data integration, data quality checks, and foundational modeling tasks
Assist with migrating SSIS and SSRS workloads into Azure (ADLS and Synapse)
Help automate recurring processes using UiPath or similar tools (training provided as needed)
Collaborate with backend developers on data integrations using C#, .NET, and ADO.NET
Partner with frontend developers and analysts to prepare datasets for dashboards and reporting
Contribute to documentation, quality checks, and continuous improvement of data pipelines

Required Experience

3–5 years of hands-on experience with Microsoft SQL Server (queries, stored procedures, performance basics)
Solid experience with SSIS and SSRS
Understanding of ETL concepts and production data workflows
Exposure to cloud platforms (Azure preferred; AWS or GCP acceptable)
Basic experience with C#, .NET, or ADO.NET in data-related contexts
Familiarity with HTML, CSS, and JavaScript for reporting or visualization support
Comfort using AI-assisted development tools (e.g., Copilot, ChatGPT)

Nice to Have

Experience with UiPath or similar automation tools
Exposure to Azure Data Factory, Databricks, or Power BI
Familiarity with data governance, metadata, or data quality concepts
Interest in growing into cloud-first data architecture and orchestration

Ideal Candidate Profile

Collaborative, detail-oriented, and eager to learn
Comfortable supporting others while building technical depth
Able to communicate clearly with both technical and non-technical stakeholders

Job Type: Full-time

Pay: $110,000.00 - $115,000.00 per year

Benefits:

Dental insurance
Health insurance
Paid time off
Vision insurance

Application Question(s):

Would you require visa sponsorship in the future?

Work Location: In person

Braden James Group

New Jobs

Data Engineer