ETL Developer jobs in United States
cer-icon
Apply on Employer Site
company-logo

Brown & Brown · 14 hours ago

ETL Developer

Brown & Brown is seeking an ETL Developer to join their growing team. This role will act as a technical expert for the creation, management, and extraction of data for the National Pharmacy Team, focusing on developing ETL pipelines and collaborating with various teams to build innovative data delivery solutions.

Insurance

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

Qualification

Azure Data FactorySQL ServerETL toolsSSISPharmacy industry experienceScrum/Kanban experienceMS TeamsComputer Science DegreeAnalytical skillsQuality controlPlanning/organizingProblem solvingAdaptabilityWritten communicationOral communicationCollaboration

Required

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

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.

Company

Brown & Brown

company-logo
Brown & Brown delivers risk management solutions to help protect and preserve what our customers value most.

Funding

Current Stage
Late Stage

Leadership Team

leader-logo
Joel Eubank
COO/CFO Dealer Services
linkedin
leader-logo
Kadir Edghill , CPA, MBA
CFO - Arrowhead Programs Division
linkedin
Company data provided by crunchbase