Data Lakehouse Architect

Built on meritocracy, our unique company culture rewards self-starters and those who are committed to doing what is best for our customers.

The Data Lakehouse Architect ensures the creation, expansion and sustaining of the Data Lakehouse, effectively supporting the storage, processing and integration of data for Brown & Brown’s National Pharmacy Team. As a subject matter expert on Data Lakehouse architecture this role provides technical leadership and guidance to the data development teams. The role will also ensure technical implementations align with standards and business goals, driving both innovation and operational excellence in data management.

Essential Duties and Functions: include the following.

• Collaborate with IT teammates of other disciplines to create optimized data architecture solutions for cross functional development teams that meet the business requirements for data storage, processing, and analysis. Lead group-based efforts and decisions that involve significant complexity and scope spanning organizational functions and data use.
• Be a liaison and partner to business stakeholders, explaining data concepts and applications that allow the business to understand and engage with the data teams and the architecture that provides business solutions.
• Create architecture strategies and frameworks while defining and maintaining detailed standards.
• Support the curation of and provide accessibility to external sourced master data within the Data Lakehouse.
• Identify and provide resolutions to architecture issues including, but not limited to, compatibility, fit, and integration.
• Create artifacts and objects used in the SDLC of the Data Lakehouse.
• Be a key contributor to emerging data governance capabilities within the Data Delivery teams.
• 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.

Competencies:

• Technical leadership – the individual is skilled at leading others to a point of understanding complex data, architecture structures or other technical content resulting in group understanding, decisions and agreements.
• 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.
• Conceptual and Detail Orientation - Ability to envision, inspire and lead a team-based execution of the Data Lakehouse while also being engaged at detailed levels of data instances and use cases managed by the Data Lakehouse.
• 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.
• Attentive listening and engagement – intakes, retains and responds to information presented through conversations or presentations, leading to follow up questions for confirmation and application of the knowledge received.
• Written and Oral communication—Communicates a concise message that resonates every time.  The individual speaks clearly and persuasively in positive or negative situations and demonstrates group presentation skills.
• Planning/organizing—the individual prioritizes and plans work activities and uses time efficiently.  Makes good and timely decisions that drives the Data Lakehouse forward to further provide data solutions and value to National Pharmacy Teams.
• 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 is flexible, skilled and willing to completing a range of tasks or duties either assigned or situationally self-identified as beneficial or needed for the success of the Data Lakehouse team.

Qualifications:

To perform this job successfully, an individual must be able to perform each essential duty satisfactorily. Reasonable accommodations may be made to enable qualified individuals with disabilities to perform the essential functions.

Required

• Detailed comprehension of Pharmacy claims data gained from 5+ years’ experience in an IT data team role with an applicable Pharmacy industry organization.
• 8+ years in data architecture, designing and building data assets and products.
• Expert knowledge of Data Lakehouse technical architecture concepts, infrastructure components and ELT process.
• Extensive experience with known data modeling and ETL tools.
• Proficient in the visual creation of complex data flow and process diagrams.
• Advanced working SQL knowledge and experience working with relational databases, query authoring (SQL) as well as working familiarity with a variety of databases, technologies.
• Associates or Bachelor’s degree in Information Systems, Computer Sciences related fields or equivalent experience in an enterprise organization.

Preferred

• Experience with Microsoft Azure technologies
• Experience with Idera ER/Studio
• Proficient with Azure DevOps for backlog management, source control as well as deployment builds and execution.
• Worked in a Scrum and or Kanban based team
• Comfortable using MS Teams, chat, channels, and integration with SharePoint for communications and collaboration
• Prior experience working as a member of a remote team

Pay Range

100000 - 125000 Annual

The 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”.