Solutions Engineer - Data Engineering
SHI International Corp.3 months ago
Remote, United StatesMid Level
Responsibilities
- Design, develop, and implement data ingestion, transformation, and integration pipelines using Azure Data Factory, Azure Synapse Analytics, Microsoft Fabric, and related Azure services.
- Build and optimize Azure and Microsoft Fabric data lakehouse and warehouse solutions for scalability, reliability, security, and cost effectiveness.
- Develop data models, ETL and ELT processes, incremental processing, historical retention, and versioning logic for multi-source datasets.
- Configure and manage Azure Data Lake Storage Gen2 environments, including organization, lifecycle management, and archival strategies.
- Implement data validation, cleansing, reconciliation, quality controls, governance, lineage, and access patterns.
- Prepare trusted data for downstream reporting, analytics, and AI use cases in collaboration with BI and analytics teams.
- Implement monitoring, operational reporting, troubleshooting, optimization, and production support for data platforms and pipelines.
- Apply encryption, identity-based access control, privacy, and compliance practices for sensitive and regulated data.
- Participate in client workshops, discovery sessions, requirements gathering, technical design, documentation, code reviews, testing, and quality assurance.
- Translate business requirements into technical solutions and contribute reusable frameworks, templates, engineering practices, migration plans, and operational runbooks.
- Support post-implementation activities, client enablement, delivery risk management, and cross-functional collaboration.
Requirements
- Proven hands-on experience delivering modern data engineering solutions on Microsoft Azure and/or Microsoft Fabric.
- Strong engineering foundation in data pipelines, lakehouse or warehouse architectures, relational data platforms, data modeling, incremental processing, monitoring, and operational support.
- Practical experience with Azure Data Factory, Azure Synapse, Databricks, SQL Server, Azure SQL, Azure Data Lake Storage Gen2, and Microsoft Fabric.
- Experience designing and operating production data platforms.
- Understanding of data security, governance, identity-based access, encryption, compliance, and sensitive or regulated data.
- Experience in consulting or project-based delivery environments with engineers, project managers, and client stakeholders.
- Familiarity with source control, CI/CD, testing, environment promotion, and infrastructure-as-code concepts.
- Strong analytical, problem-solving, communication, facilitation, documentation, and client collaboration skills.
- Microsoft Certified Azure Data Engineer Associate certification is required or expected within six to twelve months.
- Preferred certifications include Microsoft Certified Fabric Analytics Engineer Associate and Azure Solutions Architect Expert.
- Preferred experience includes dimensional and lakehouse modeling, Power BI operational reporting, public-sector or regulated-industry data platforms, analytics and AI-ready workloads, reusable engineering frameworks, Azure Databricks, and Microsoft Fabric workflows.
Benefits
- Primarily remote position with a home office setup provided according to company policy.
- Benefits may include medical, vision, dental, 401K, and flexible spending accounts.
- Continuous professional growth, leadership opportunities, learning, and professional development in Microsoft technologies.
- Ability to travel to SHI, partner, and customer events.
- Access to world-class facilities and required technology in company offices or remotely.
Tech Stack
Categories
Solutions Engineering
About SHI International Corp.
SHI International is a privately held IT solutions provider and reseller that supplies software licensing, hardware, cloud, security, and managed services to enterprises, governments, and education customers. Founded in 1989 and headquartered in Somerset, New Jersey, SHI operates globally with in-house integration and device configuration centers plus procurement and asset management services. It is the largest minority- and woman-owned business enterprise in the United States.