Solutions Engineer – Data Engineering

This is a fully remote position, open to applicants in Texas.

📋 Description

• Design, develop, and execute data ingestion, transformation, and integration pipelines utilizing Azure Data Factory, Azure Synapse Analytics, Microsoft Fabric, and associated Azure data services.

• Construct and enhance scalable, reliable, secure, and cost-efficient data lakehouse and warehouse solutions.

• Create and sustain data models, ETL/ELT processes, and historical data versioning mechanisms.

• Set up and oversee Azure Data Lake Storage Gen2 environments, focusing on organization, lifecycle management, and archival processes.

• Execute data validation, cleansing, reconciliation, and quality assurance measures.

• Collaborate with BI and analytics teams to prepare data for reporting, analytics, and AI applications.

• Implement security, encryption, identity-based access, and compliance best practices.

• Support data governance, lineage tracking, access patterns, and operational readiness.

• Establish monitoring and operational reporting for production data platforms.

• Work with structured, semi-structured, and unstructured data in both cloud and on-premises settings.

• Engage in technical workshops, discovery sessions, requirements gathering, code reviews, testing, and quality assurance activities.

• Convert business requirements into actionable technical solutions.

• Generate technical documentation, design artifacts, migration strategies, and operational runbooks.

• Contribute reusable frameworks, templates, and engineering best practices.

• Adhere to source control, CI/CD, and environment promotion protocols.

• Assist in post-implementation troubleshooting, optimization, and client enablement.

• Take ownership of assigned deliverables and proactively manage delivery risks.

⛳️ Requirements

• Demonstrated hands-on experience in delivering modern data engineering solutions on Microsoft Azure and/or Microsoft Fabric.

• Solid engineering background in data pipelines, lakehouse or warehouse architectures, and relational data platforms.

• Practical experience with Azure Data Factory, Azure Synapse, Databricks, SQL Server, Azure SQL, ADLS Gen2, and Microsoft Fabric.

• Experience in designing and managing production data platforms, including data modeling, incremental processing, historical retention, monitoring, and operational support.

• Understanding of data security, governance, and compliance, encompassing identity-based access, encryption, HIPAA, PII handling, and NIST 800-53.

• Experience in consulting or project-based delivery environments.

• Familiarity with source control, CI/CD, testing, and environment promotion practices.

• Strong analytical, problem-solving, and communication abilities.

• Microsoft Certified Azure Data Engineer Associate, required or expected within six to twelve months.

• Willingness to travel to SHI, partner, and customer events.

• Capability to work autonomously as well as part of a collaborative, cross-functional team.

• Dedication to continuous learning and professional development in Microsoft technologies and data visualization trends.

• Strong ethical standards and commitment to data privacy, governance, and security policies.

• Preferred: experience with dimensional and lakehouse data modeling, advanced proficiency in Azure and Microsoft Fabric, infrastructure as code, Power BI operational reporting, public sector or regulated industry experience, AI-ready workloads, reusable engineering frameworks, and Azure Databricks.

🏝️ Benefits

• Opportunities for continuous professional growth and leadership development.

• Comprehensive health, wellness, and financial benefits.

• Access to world-class facilities and the technology required to excel in both office and remote environments.

• Home office setup provided in line with company policy.

• Medical, vision, dental, 401K, and flexible spending benefits may be included.