Brown & BrownRemote
Data Engineer
United States of America
Full Time
2 hours ago
$175,000 - $200,000 USD
Visa Sponsor
Key skills
Azure Synapse AnalyticsAzure Data Lake StorageSQLPythonPySparkELT pipeline developmentDimensional data modelingHealthcare data claimsHealthcare data eligibilityHealthcare data providerMicrosoft Certified Azure Data Engineer Associate (DP-203)Microsoft Certified Azure Fundamentals (AZ-900)ELTData EngineeringData LakeAnalyticsSparkAzureGitHub ActionsServerlessAzure DevOpsGitHubPerformance OptimizationCI/CD
About this role
Brown & Brown is seeking a Data Engineer to join their growing team. This role involves designing, building, and optimizing scalable healthcare data solutions using the Microsoft Azure ecosystem, with a focus on Azure Synapse Analytics.
Responsibilities:
- Design and implement end-to-end data pipelines within Azure Synapse Analytics, including:
- Synapse Pipelines
- Dedicated and serverless SQL pools
- Synapse Spark for distributed processing
- Build scalable ELT workflows transforming raw healthcare data into analytics-ready structures
- Optimize distributed workloads for performance and cost efficiency
- Design layered architecture using Azure Data Lake Storage and Synapse
- Develop healthcare data models across claims, eligibility, provider, and service dimensions
- Build aggregated datasets (PMPM, utilization, risk scoring, provider performance)
- Performance optimization/troubleshooting of existing data and pipelines
- Clear/concise documentation of data transformations and key data details
- Ensure compliance with HIPAA
- Implement validation, reconciliation, and anomaly detection frameworks
Requirements:
- Bachelor's degree in computer science, Data Engineering, or related field
- 3–7+ years of data engineering experience (healthcare strongly preferred)
- Strong SQL expertise and proficiency in Python or PySpark
- Hands-on experience with: Azure Synapse Analytics (SQL pools, Spark, pipelines), Azure Data Lake Storage
- Experience building scalable ELT pipelines and dimensional data models
- Familiarity with healthcare datasets (claims, eligibility, provider data)
- Azure Certification Requirement (one or more of the following): Microsoft Certified: Azure Data Engineer Associate (DP-203) or equivalent, Microsoft Certified: Azure Fundamentals (AZ-900) (minimum baseline expected)
- Experience designing enterprise data warehouses within Synapse
- Familiarity with lakehouse architectures (Delta Lake, Spark)
- Experience with CI/CD (Azure DevOps, GitHub Actions)
- Exposure to value-based care or population health analytics