ETL Developer

Brown & Brown Insurance

1d • $90,000 - $100,000

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

Requirements

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

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.

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.

What This Job Offers

• Job Type: Full-time
• Career Level: Mid Level