ETL Developer

About the position

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.

Responsibilities

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

Requirements

• Computer Science Degree or 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.

Nice-to-haves

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

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.
• Paid Time Off, Holidays, Preferred Partner Discounts and more.