Brown & Brown InsuranceRemote
Data Engineer
United States
Full Time
1 hour ago
$175,000 - $200,000 USD
No Visa Sponsorship
Key skills
AzurePySparkPythonSparkSQLELTData EngineeringData LakeAnalyticsServerlessPerformance Optimization
About this role
Role Overview
- 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)
Tech Stack
- Azure
- PySpark
- Python
- Spark
- SQL
Benefits
- Health Benefits : Medical/Rx, Dental, Vision, Life Insurance, Disability Insurance
- Financial Benefits : ESPP; 401k; Student Loan Assistance; Tuition Reimbursement
- Mental Health & Wellness : Free Mental Health & Enhanced Advocacy Services
- Beyond Benefits : Paid Time Off, Holidays, Preferred Partner Discounts and more.