Brown & Brown Insurance · 2 days ago

ETL Developer

Michigan, United States

Full-time

Remote

Entry, Mid Level

2+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

Financial ServicesInsurance

Actively Hiring

Insider Connection @Brown & Brown Insurance

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

Responsibilities

Develop solutions for optimal extraction, transformation, and loading of data from a wide variety of data sources into targeted databases.

Support ETL operations and the administration of data and systems securely and in accordance with enterprise data governance standards.

Follow all department procedures, including source control, release/deployment, and change management procedures.

Collaborate directly with internal teammates to take business ideas and develop technical requirements that meet the business request.

Perform quality assurance testing and troubleshooting to ensure all pipeline jobs and technical activities are completed accurately and timely.

Identify, design, and implement internal process improvements such as automation of manual processes and the optimization of data delivery for greater scalability.

Support internal IT teammates by helping to implement tools for tracking of data, users & performance of sql queries that enable strategic planning of product enhancements & process improvements.

Perform root cause analysis on internal and external data and processes to answer specific business questions and identify opportunities for improvement.

Create and maintain data-related documentation (e.g. data dictionaries, ERD’s, data maps, etc.)

Comply with and adhere to all regulatory compliance areas, policies and procedures, including HIPAA requirements.

Work with stakeholders including the Executive, Clinical, and Product teams to assist with data-related technical issues and support their data needs.

Work with data analytics experts to strive for greater functionality in our data systems and incorporation of governance practices.

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 as assigned.

Qualification

Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.

SQLPythonData Integration ToolsAzure Data FactoryInformaticaData Warehouse ConceptsCloud-based InfrastructureOracle PL/SQLPharmacy/Medical Claims DataHIPAA Concepts

Required

Computer Science Degree of related fields OR direct applicable experience in an enterprise environment

2+ years of enterprise experience working directly in relational databases, query authoring (SQL) as well as working familiarity with a variety of databases, technologies, data structures and algorithms

2+ years of enterprise experience using Python

Proficient experience using Enterprise Data Integration Tools, preferably Azure Data Factory and/or Informatica

Detailed knowledge of data warehouse concepts and cloud-based infrastructure components