EDM Architect – National Pharmacy Team
Posted 102ds ago
Employment Information
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.



















