EDM Architect – National Pharmacy Team

Posted 102ds ago

Employment Information

Education
Salary
Experience
Job Type

Report this job

Job expired or something wrong with this job?

Job Description

EDM Architect designing and implementing data solutions for Brown & Brown’s Pharmacy Team. Blending strategic leadership with hands-on development to drive customer insights and data excellence.

Responsibilities:

  • Design and implement scalable, secure, and high-performance data ingestion, transformation, and orchestration solutions using Azure Data Factory and other Azure services, following established architectural patterns.
  • Develop and maintain ETL pipelines to support diverse business needs, including structured and unstructured data loads into the Data Lakehouse.
  • Write and optimize SQL scripts to support business users by creating and enhancing data deliverables.
  • Partner with EDM developers, analysts, and cross-functional teams (Analytics, Operations, Software Development) to translate business requirements into technical solutions.
  • Apply quality assurance practices to ensure data accuracy, consistency, and integrity across all deliverables.
  • Enforce adherence to departmental procedures, including source control, release management, and change management protocols.
  • Ensure compliance with data governance standards and security policies, including handling of Electronic Protected Health Information (PHI).
  • Conduct peer code reviews to uphold coding standards and architectural guidelines.
  • Mentor junior developers and data engineers, promoting a culture of continuous learning and technical excellence.
  • Lead knowledge-sharing initiatives and contribute to internal documentation and training resources.

Requirements:

  • Computer Science Degree of related fields OR direct applicable experience in an enterprise environment.
  • 4+ years of working with ETL tools in an enterprise environment.
  • 4+ years of direct experience using SQL Server with advanced knowledge in relational database querying.
  • Experience with Azure Data Factory including pipeline orchestration & data flows.
  • Strong understanding of data modeling, ETL/ELT processes, and data warehousing concepts.
  • Previous experience working in the pharmacy industry.
  • Preferred Worked in a Scrum and or Kanban based team.
  • Preferred Comfortable using MS Teams, chat, channels, and integration with SharePoint for communications and collaboration.

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.