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
