(Senior) Data Architect

Rockville, MD
Jun 19, 2022
Required Education
Bachelors Degree
Position Type
Full time

Summary of the Position

This is a hands-on non-supervisory strategic position is responsible for defining and delivering data architectures and solutions as well as contribute to the development, alignment, and implementation of IT plans in line with the overall strategy of IT and the business; to act as the Lead Architect on major data initiatives and programs.

Roles and Responsibilities

• Lead the data design of solutions for large projects and programs; through expert knowledge translate high-level business requirements into data models and appropriate metadata, test data, and data quality standards

• Direct and control large specialist teams to undertake the delivery of a comprehensive data-centric project

• Lead and support IT initiatives in developing and management of USP Data Lake

• Lead and support USP analytics team in designing and curating data from Data Lake for business intelligence dashboards

• Lead and support in architecting USP’s cloud-enabled data platforms and services including data warehouse, systems of record and operational databases

• Direct and manage USP’s enterprise data landscaping efforts

• Manage senior business stakeholders to secure strong engagement for the solution and ensure that the delivery of the project aligns to longer-term strategic roadmaps

• Work as part of the program management team on large program, governing and shaping the delivery of projects. Work closely with external suppliers to ensure solution makes best use of technology and meets requirements

• Simplify the existing data architecture, delivering reusable services and cost saving opportunities in line with the policies and standards of the group

• Lead collaborative team working with other areas within Global Information Services to ensure that all solutions are complete, operable, conform to business processes, and meet the business needs with the agreed quality of service

• Responsible throughout the entire project lifecycle for the end-to-end solution of the project and compliance with enterprise data model

• Provide clear, continuous, and consistent data architecture leadership at a detailed level within projects

• Ensure the end-to-end solution is fit for purpose, meet the needs of business, the agreed requirements, and are both pragmatic and supportive of the strategic architecture direction

• Lead and participate in the peer review and quality assurance of project architectural artifacts across Enterprise Architecture group through governance forums (such as ARB). Report key architecture decisions and implications to the architectural governance forums

• Identify and communicate appropriate resource requirements and work breakdown structure based on skills profile and best fit to complete the end-to-end solution design, and work with the project manager to ensure that project plans and finances align with the design

• Participate from time to time in the supplier selection process, evaluating usefulness and cost of products and making appropriate recommendations

• Expected to carry out core accountabilities with minimal level of supervision for complex tasks and no supervision for more routine matters

• Drive project knowledge back to the enterprise data model and ensure that it evolves correctly

• Lead the design, development, implementation and maintenance of complex data systems and solutions

• Develop conceptual, logical, and physical data models to support data analysis and business intelligence

• Create and maintain current- and target-state data architectures

• Define and manage standards, guidelines, and processes to ensure data quality

• Ensure technology solutions are in alignment with data architecture principles and target state

• Work with IT teams, business analysts and data analytics teams to understand data consumers’ needs and develop solutions

• Evaluate and recommend emerging technologies for data management, storage and analytic

Basic Qualifications

Data Architect:

• Bachelor’s degree in Computer Science, Information Systems, or related field, or equivalent combination of education and experience  

• Eight (8) years of experience working in Information Technology 

• Four (4) years of experience with database technologies (e.g., RDBMS, GraphDB, PostgreSQL, NoSQL, Oracle, Hadoop, Teradata)

• Demonstrated experience with NoSQL or GraphDB technologies

Senior Data Architect:

• Bachelor’s degree in Computer Science, Information Systems, or related field, or equivalent combination of education and experience  

• Ten (10) years of experience working in Information Technology 

• Six (6) years of experience with database technologies (e.g., RDBMS, GraphDB, PostgreSQL, NoSQL, Oracle, Hadoop, Teradata)

• Two (2) years of experience with NoSQL or GraphDB technologies

Skills Sought

• Ability to relate architectural decisions and recommendations to business needs

• Experience in Entity Relationship modeling, metadata systems, data quality tools and techniques

• Experience in data warehousing, data modeling and/or data analysis

• Excellent knowledge of data management, data integration and database development techniques

• Ability to regularly learn and adopt new technology

• Strong analytical and problem-solving skills

• Ability to communicate across all levels of the organization and work with diverse project teams

• Manages the investigation of corporate data requirements, and co-ordinates the application of data analysis, design, and modelling techniques, based upon a detailed understanding of the corporate information requirements, to establish, modify or maintain data structures and their associated components (entity descriptions, relationship descriptions, attribute definitions). 

Preferred Qualifications

• Four (4) years of experience with ETL and other business intelligence tools

• Experience managing the iteration, review and maintenance of data requirements and data models.

• Experience developing reference architecture, principles, and standards

• Derives an overall strategy of master data management, within an established information architecture, that supports the development and secure operation of information and digital services

• Sets standards for data modelling and design tools and techniques, advises on their application, and ensures compliance. 

• .Develops organizational policies, standards, and guidelines for data management, aligned with ethical principles. 

• Takes overall responsibility for planning effective data storage, security, quality, sharing, availability, retention, and publishing within the organization. Plans, establishes, and manages processes for regular and consistent access to, and independent validation of external information from multiple sources.

Supervisory Responsibilities



USP provides you with the benefits you need to protect yourself and your family today and tomorrow. From company-paid time off, comprehensive healthcare options to retirement savings, you can have peace of mind that your personal and financial wellbeing are protected.

About USP

The U.S. Pharmacopeial Convention (USP) USP is an independent scientific organization that collaborates with the world's top experts in health and science to develop quality standards for medicines, dietary supplements, and food ingredients. USP brings together more than 1,100 talented professionals across five global locations to deliver its mission to strengthen the supply of safe quality medicines and supplements worldwide. USP is proud to be an equal employment opportunity employer (EEOE) and affirmative action employer. Employment selection and related decisions are made without regard to sex, race, age, disability, religion, national origin, color, veteran status, sexual orientation, gender identity or any other protected class. We are committed to working with and providing reasonable accommodation to individuals with disabilities. USP does not accept unsolicited resumes from 3rd party recruitment agencies and is not responsible for fees from recruiters or other agencies except under specific written agreement with USP.