The Senior Manager, Data Ingest Validation and Architecture will lead our data warehousing team guiding them to build scalable, high-performance data solutions. In this critical role, the Senior Manager will be responsible for the overall architecture, automation, development and maintenance of the company’s data warehouse. This includes overseeing the ingestion of large, diverse datasets, ensuring data quality and integrity, and providing reliable data for analytics, reporting, and our product verticals and other offerings. This includes developing and implementing data models, schemas, and processes to ensure the accuracy, consistency, and security of the data.

DUTIES AND RESPONSIBILITIES:

· Lead, mentor, and manage a team of data warehouse data engineers and analysts while fostering a culture of collaboration, technical excellence, and continuous quality improvement.

· Conduct performance reviews and support career development for members of the team.

· Oversee the development and maintenance of the processes for ingesting data from a wide variety of external sources. Ensure with the vendors that the data meets expectations and work with the team to ensure it is aggregated, cleaned, and loaded efficiently and reliably.

· Establish and enforce best practices for data quality, integrity, and governance.

· Ensure the team implements monitoring tools and processes to proactively identify and resolve data or processing issues.

· Collaborate with stakeholders to understand use cases, client data needs to deliver solutions that meet the business needs.

· Evaluate and recommend new technologies, tools, and platforms to improve data warehousing capabilities or efficiencies.

· Define and implement Key Performance indicators that will ensure that stakeholders can assess any risks with the data received from each source.

· Develop and maintain documentation including data dictionaries, transformations, and data flow diagrams and other requirements for consumers of the data.

· Stay up to date on the latest data technologies and trends and evaluate potential technologies, tools and frameworks as needed.

· Represent the company with external vendors, clients, industry events and conferences.

· Work on projects as required from senior leadership.

· This role includes people management responsibilities, including coaching, supporting, and developing direct reports to achieve individual, team and company goals. 

· Perform other duties as assigned to support business needs and company objectives.

· Bachelors Degree or 10 years of related healthcare data experience or equivalent combination of education and experience is required.

· 5+ years of experience in data warehousing, with a minimum of 3+ years in a leadership or management role.

· Extensive experience with modern data warehouse technologies (e.g., Snowflake, Google BigQuery).

· Proficiency in SQL and experience with a scripting language (e.g., Python).

· Proven experience with ETL/ELT tools and data pipeline orchestration (e.g., Airflow).

· Extensive knowledge of medical and pharmacy claims data, provider data, and supporting structures.

· Strong understanding of data governance, data quality management, and data security best practices.

· Excellent communication, leadership, and problem-solving skills.

· Ability to design and implement efficient processes.