Remote Data Engineering Solutions Engineer - Azure Fabric

SHI

Boston (MA)

Remote

USD 156,000 - 181,000

Full time

14 days+

A complete application in a minute

Tailored resume and cover letter, ready to send.

Get past ATS filters

Benefits offered by this job

Health, wellness, and financial benef

Diversity and inclusion focus

Career growth opportunities

Remote work flexibility

Job summary

SHI is seeking a Services Solutions Engineer, Data Engineering to design and deliver enterprise-scale data pipelines on Azure/Synapse and Fabric. This hands-on, delivery-focused role collaborates with Solution Engineers, Project Managers, and client stakeholders to implement secure, scalable data platforms for analytics, reporting, and AI use cases.

Initial focus areas include state-level public sector and regulated industry projects.

Qualifications

Proven hands-on experience delivering modern data engineering solutions on Microsoft Azure and/or Microsoft Fabric.
Strong engineering foundation across data pipelines, lakehouse or warehouse architectures, with practical use of Azure Data Factory, Azure Synapse, Databricks, SQL Server, Azure SQL, ADLS Gen2, and Fabric.
Experience designing and operating production data platforms with data modeling, incremental processing, historical retention, monitoring, and operational support.
Solid understanding of data security, governance, and compliance concepts, including identity-based access, encryption, and handling sensitive or regulated data.
Experience working in consulting or project-based delivery environments, collaborating with engineers, project managers, and client stakeholders.
Familiarity with modern engineering practices such as source control, CI/CD, testing, and environment promotion.
Strong analytical, problem-solving, and communication skills, with the ability to translate business needs into practical technical solutions.

Responsibilities

Design, develop, and implement data ingestion, transformation, and integration pipelines using Azure Data Factory, Azure Synapse Analytics, Microsoft Fabric, and related Azure data services.
Build and optimize data lakehouse and warehouse solutions in Azure and Microsoft Fabric, ensuring scalability, reliability, security, and cost effectiveness.
Develop and maintain data models, ETL and ELT processes, and historical data versioning logic to support complex multi-source datasets.
Configure and manage Azure Data Lake Storage Gen2 environments, including data organization, lifecycle management, and archival strategies.
Implement data validation, cleansing, reconciliation, and quality controls to ensure trusted and auditable data platforms.
Collaborate with BI and analytics teams to prepare data for downstream reporting, analytics, and AI consumption.
Apply security best practices including encryption, identity-based access control, and compliance with HIPAA, PII handling, and NIST 800-53.
Support data governance practices including lineage, access patterns, and operational readiness.
Implement monitoring and operational reporting for pipelines and data platforms to support production support models.
Work with structured, semi-structured, and unstructured data sources across cloud and on-prem environments.
Participate in technical workshops, discovery sessions, and requirements gathering with clients and internal teams.
Translate business requirements into actionable technical solutions focused on client outcomes.
Produce high quality technical documentation including design artifacts, migration plans, and operational runbooks.
Contribute to reusable frameworks, templates, and engineering best practices within the Data and AI practice.
Participate in code reviews, testing, and quality assurance processes.
Follow modern engineering practices including source control, CI/CD, and environment promotion strategies.
Support post-implementation activities including troubleshooting, optimization, and client enablement.
Demonstrate ownership and accountability for deliverables and proactively address delivery risks.