ETL Developer

Brown & Brown; United States; On-site; USD 95,000 - 115,000; Full time

Benefits offered by this job

Health Benefits: Medical/Rx, Dental, Vision, Life Insurance

401k and Tuition Reimbursement

Paid Time Off and Holidays

Mental Health & Wellness Services

Job summary

A growing technology firm in the United States is looking for an ETL Developer to join their team. This role involves developing ETL pipelines in Azure Data Factory, collaborating with the Analytics and Operations teams, and ensuring data quality and accuracy. Candidates should have a Computer Science degree or relevant experience, along with at least two years of working with ETL tools and SQL Server. The compensation range is between $95,000 and $115,000 annually, along with comprehensive health and financial benefits.

Qualifications

• 2+ years of working with ETL tools in an enterprise environment.
• 2+ years of direct experience using SQL Server with advanced database querying knowledge.
• Previous experience working in the pharmacy industry preferred.

Responsibilities

• Develop ETL pipelines in Azure Data Factory to support various data loads.
• Use SQL to create new data deliverables and enhance current scripts.
• Collaborate with teams to develop technical requirements.

Skills

ETL tools

SQL Server

Azure Data Factory

Data Management

Standardization techniques

Education

Computer Science Degree or related field

Tools

SQL

Azure Data Factory

Job description

Overview

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 or related field 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

$95,000 - $115,000 Annual

Teammate Benefits & Total Well-Being

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