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 a EDM Architect 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, blending strategic EDM architectural leadership with hands-on development responsibilities. The EDM Architect will actively contribute to the design and implementation of data solutions, perform peer code reviews, and mentor junior team members to foster technical excellence and team growth. Working closely with the Analytics, Operations, and Software Development teams, the architect will help deliver innovative data integration solutions and extracts that drive actionable customer insights.
How You Will Contribute:
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.
Skills and Experience to be Successful:
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. Preferred
Pay Range
$115,000 - $130,000 AnnualThe pay range provided above is made in good faith and based on our lowest and highest annual salary or hourly rate paid for the role and takes into account years of experience required, geography, and/or budget for the role.
Teammate Benefits & Total Well-Being
We go beyond standard benefits, focusing on the total well-being of our teammates, including:
- 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”.
Similar Jobs
What We Do
Brown & Brown Insurance provides risk management solutions to help protect what our customers value most. Our four business segments offer insurance products and services to businesses and individuals. Our culture is built on integrity, innovation, superior capabilities, and discipline. We view insurance differently and use our experience, carrier relationships, and principled customer focus to deliver first-class service and solutions. Becoming a Brown & Brown teammate introduces you to a career with virtually unlimited possibilities. We think of ourselves as a team, so we have teammates—not employees. We strive to attract people who are competitive, driven, and disciplined. Our unique company culture of meritocracy rewards self-starters and those committed to doing what is best for our customers. We are proud to be certified as a Great Place to Work ®. Brown & Brown has demonstrated a Culture of Caring through dedication to the people and communities we serve. With more than 11,000 teammates in over 300 locations across the US, Canada, Ireland, the UK, Bermuda, and the Cayman Islands, we actively support numerous organizations in the local communities in which we live, work, and play. With a long-standing history of proven success, Brown & Brown is one of the insurance industry’s most powerful and influential leaders, ranked as the fifth-largest brokerage in the US and sixth in the world. You can find us on the NYSE as BRO.
