ETL Developer

Built on meritocracy, our unique company culture rewards self-starters and those who are committed to doing what is best for our customers.

Brown & Brown is seeking an ETL Developer to join our growing team!

This role will act as a technical expert for the creation, management, and extraction of data for Brown & Brown’s National Pharmacy Team. Primary duties include participating in requirements gathering meetings, establishing a design, and developing new solutions based off the requirements, extract/transform/load raw data files into the Data Lakehouse for both standard and customized file layouts, and work directly with the Analytics team, Operations team, and Software Development team to build innovative data delivery solutions and extracts that provide customer insight.

How You Will Contribute:

• Develop ETL pipelines in Azure Data Factory to support various types of data loads and business needs.

• Work with the Enterprise Data Management team to create, expand and sustain data procedures with the Data Lakehouse.

• Use Sql to support National Pharmacy Team business/users, create new data deliverables, and enhance current scripts.

• Map data from source to target by applying standardization techniques to ensure accuracy.

• Migrate legacy SSIS packages into Azure Data Factory

• Apply quality assurance practices that minimize errors and/or data discrepancies.

• Perform data resolution efforts if an issue arises.

• Apply database schema concepts that ensure optimally running applications / routines.

• Collaborate directly with internal teammates to take business ideas and develop technical requirements that meet the business request.

• Follow all department procedures, including source control, release, and change management procedures.

• This position will include job duties that require risk designations for access to Electronic Protected Health Information (PHI) in the course of their job responsibilities.

Skills and Experience to be Successful:

• Computer Science Degree of related fields OR direct applicable experience in an enterprise environment

• 2+ years of working with ETL tools in an enterprise environment.

• 2+ years of direct experience using SQL Server with advanced knowledge in relational database querying.

• Previous experience working in the pharmacy industry. Preferred

• Experience with Azure Data Factory. Preferred

Pay Range

The pay range provided above is made in good faith and based on our lowest and highest annual salary or hourly rate paid for the role and takes into account years of experience required, geography, and/or budget for the role.

Teammate Benefits & Total Well-Being

We go beyond standard benefits, focusing on the total well-being of our teammates, including:

• 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. 

Not reflective of all benefits. Enrollment waiting periods or eligibility criteria may apply to certain benefits. Benefit details and offerings may vary for subsidiary entities or in specific geographic locations. 

The Power To Be Yourself  

As an Equal Opportunity Employer, we are committed to fostering an inclusive environment comprised of people from all backgrounds, with a variety of experiences and perspectives, guided by our Diversity, Inclusion & Belonging (DIB) motto, “The Power to Be Yourself”.