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.

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.

Essential Duties and Functions: include the following. 

• 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.
• Other duties may be assigned.

Competencies:

• Self-Driven – the individual has a high level of motivation and can work in both a team and independent capacity, making the most of the time available within a workday, and completes items with limited oversight from leadership.
• Planning/organizing—the individual prioritizes and plans work activities and uses time efficiently.  Makes good and timely decisions that propels our company forward.
• Analytical – the individual is motivated as well as skilled to learn, discover, identify exceptions or outliers, make associations and come to conclusions by utilizing advanced data analysis and profiling skills.
• Collaborative – the individual is open to other’s ideas and has mutual respect for team members and other contributing roles strengths and skills that contribute to total team success and best results.
• Written and Oral communication—Communicate a concise message that resonates every time.  The individual speaks clearly and persuasively in positive or negative situations and demonstrates group presentation skills. 

• Problem solving—Create innovative ways for our customers and our company to be successful.  The individual identifies and resolves problems in a timely manner, gathers and analyzes information skillfully and maintains confidentiality.
• Quality control— Is relentless in the pursuit of the Data Lakehouse presenting accurate and quality data prepared from a diverse range of data sources.

• Adaptability—the individual adapts to changes in the work environment, manages competing demands, and can deal with frequent change, delays or unexpected events.  

Qualifications:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform the essential functions.

Required

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

Preferred

• Previous experience working in the pharmacy industry.
• Experience with Azure Data Factory
• Experience with SSIS
• Worked in a Scrum and or Kanban based team
• Comfortable using MS Teams, chat, channels, and integration with SharePoint for communications and collaboration
• Prior experience working as a member of a remote team

Pay Range

90000 - 100000 Annual

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