Principal Data Architect

Principal Data Architect


Principal Data Architect

YSM ITS Software Solutions & Engineering


University Job Title

Senior Data Architect

Bargaining Unit

None - Not included in the union (Yale Union Group)

Time Type

Full time

Duration Type


Compensation Grade

Administration & Operations

Compensation Grade Profile

Senior Manager; Senior Program Leader (P6)

Wage Ranges

Click here to see our Wage Ranges

Searchable Job Family

Computing and Information Systems

Total # of hours to be worked:


Work Week

Standard (M-F equal number of hours per day)

Work Location

Central Campus

Worksite Address

150 Munson Street
New Haven, CT 06511

Work Model


Position Focus:

Yale is seeking a dynamic, seasoned Principal Data Architect to serve on the Health Sciences Information Services (HSIS) team. Reporting to the Director of Health Software and Analytics Solutions, and in partnership with Yale University data stewards and Yale ITS, the candidate will develop Enterprise Information Management and Data Integration Strategies for an analytics platform that will support the Yale Health Sciences.  This is a hands-on technical position which will require both breadth and depth in Data Architecture, Data Warehousing and Business Intelligence as well as delivering integrated data solutions that enable data driven decision making. May lead and direct the work of others.

Principal Responsibilities:
HSIS at Yale supports the School of Medicine, School of Public Health, School of Nursing, and Yale Health. This position will create a unified Data Architecture and Data Warehouse across Health Sciences to support those units with a focus on 5 key business dimensions: Finance and Administration, Education, Clinical, Research and Faculty Affairs.

As Principal Data Architect, the candidate will be responsible for the design, modeling, and implementation of this EDW and all associated data dictionaries, business rules and logic. This position will leverage and partner with developers, analysts, and departmental unit technology resources to create a holistic approach to Master Data Management. This includes developing and implementing plans to develop a trusted, authoritative data store from multiple sources (administrative, faculty, student, research administration) to better inform school-wide decision making, enabled by dashboards, analytics, and reporting solutions. Additionally, the position will work closely with data stewards across the business and technical team of stakeholders to identify data requirements, develop data integration strategies, and ensure the successful implementation of those strategies. The position will be expected to design effective role-based authorization standards and practices to ensure Yale’s data is secure and accessible to authorized parties throughout its lifecycle; interface with IT technologists to define, implement and support the Data Infrastructure and Analytics for Yale Health Sciences.

As Principal Data Architect, the candidate will provide end-to-end vision of data solutions and data models. Define and lead the data architecture including the development of a data roadmap and data strategy. Meet with key stakeholders and department leads to get a comprehensive understanding of their data needs. Design and implement data models, data warehouses, data lakes, and data integration processes to support the organization's data needs. Actively participate in / Lead data model design sessions and, where applicable, apply industry best practices. The candidate will help coordinate/design integrated data solutions across the Yale Health Sciences to support the tripartite mission of Education, Patient Care and Research. Produce data models and solution design documents including data dictionaries in alignment with business objectives. Evaluate the relative maturity of existing systems and identify areas where standards are immature or lacking in comprehension. Prioritize remediation of technical gaps across the enterprise Drive the technology components of long-range planning across the institution. Advise Senior Leadership on technical risks, debt, and gaps. Establishes and maintains the suite of technologies that are in current use as well as their relative maturity and degree of expected future investment. Identifies areas of technical debt and develops remediation plans. Responsible for broad technology and policy decisions as well as the ability to articulate the likely impact on the long-term overall effectiveness of ITS.

Essential Duties

1. Conducts research and evaluation of technology options for the development and deployment of applications by working closely with ITS staff to provide production support and enhancements for several applications. 2. Plans, designs, and implements strategic development initiatives so that data assets of the organization are supported by a data architecture in line with the organization strategic goals and initiatives. 3. Interfaces with other teams within ITS and with major users in order to ensure a high level of integration and effectiveness among all application software within the organization and to design systems that meet the stated objectives. Prioritizes and solves application software problems. 4. Ensures the preparation of formal system specification documents, including business process diagram, data flows, and technical documentation. 5. Works as part of ITS teams in the selection of application and infrastructure software. 6. Sets up a metadata registry and allows domain-specific stakeholders to maintain their own data elements as required. 7. May perform other duties as assigned.

Required Education and Experience

Bachelor's degree in a related field and six years of related work experience or an equivalent combination of education and experience.

Required Skill/Ability 1:

Demonstrated ability in developing unified data models for an enterprise data warehouse.

Required Skill/Ability 2:

Expertise in Master Data Management (MDM), Business Intelligence (BI) and analytics and modern data management including data warehousing and data lakes, data profiling and data quality.

Required Skill/Ability 3:

Highly proficient in IT system integration, data integration, and Extract, Transform, and Load (ETL) tools like Talend or SSIS

Required Skill/Ability 4:

Hands-on demonstrated ability with various data sources ranging from warehouses to structured and unstructured data.

Required Skill/Ability 5:

Highly proficient in SQL Server and T-SQL

Preferred Education, Experience and Skills:

Masters in computer science, Data Science or equivalent. Project management experience. Experience with Power BI preferred. Higher education experience preferred but not required.

Drug Screen


Health Screening


Background Check Requirements

All candidates for employment will be subject to pre-employment background screening for this position, which may include motor vehicle, DOT certification, drug testing and credit checks based on the position description and job requirements. All offers are contingent upon the successful completion of the background check. For additional information on the background check requirements and process visit "Learn about background checks" under the Applicant Support Resources section of Careers on the It's Your Yale website.

COVID-19 Vaccine Requirement

The University maintains policies pertaining to COVID-19. All faculty, staff, students, and trainees are required to comply with these policies, which may be found here:

Posting Disclaimer

The intent of this job description is to provide a representative summary of the essential functions that will be required of the position and should not be construed as a declaration of specific duties and responsibilities of the particular position. Employees will be assigned specific job-related duties through their hiring departments.

EEO Statement:

University policy is committed to affirmative action under law in employment of women, minority group members, individuals with disabilities, and protected veterans. Additionally, in accordance with Yale’s Policy Against Discrimination and Harassment, and as delineated by federal and Connecticut law, Yale does not discriminate in admissions, educational programs, or employment against any individual on account of that individual’s sex, sexual orientation, gender identity or expression, race, color, national or ethnic origin, religion, age, disability, status as a special disabled veteran, veteran of the Vietnam era or other covered veteran.

Inquiries concerning Yale’s Policy Against Discrimination and Harassment may be referred to the Office of Institutional Equity and Accessibility (OIEA).


Yale University is a tobacco-free campus

Logos/outerjoin logo full

Outer Join is the premier job board for remote jobs in data science, analytics, and engineering.