Data Systems Analyst 1-5 TX

Job Summary

Responsible for planning, designing, developing, and managing data systems infrastructure to ensure data integrity, security and accessibility. Includes maintaining and optimizing information systems, migrating data and systems as needed, managing or developing data practices, databases and related guidelines, dictionaries, registries and services. May include interpreting scientific research data artifacts, mediating across science and technology domains, and supporting long-term data stewardship. As an information architect and data steward: involves designing systems, data products and production processes with a focus on data curation, exchange, security, integrity and the overall information environment. This role also involves re-evaluating frameworks, strategies, and standards and may involve work with a project-level data repository, data center or archives.

Job Title	Data Systems Analyst 1 TX	Data Systems Analyst 2 TX	Data Systems Analyst 3 TX	Data Systems Analyst 4 TX	Data Systems Analyst 5 TX
Job Code	5449	5453	5469	6432	6433
Bargaining Unit	TX	TX	TX	TX	TX
FLSA	Non-Exempt	Non-Exempt	Exempt	Exempt	Exempt
Generic Scope	Entry-level professional with limited prior experience; learns to use professional concepts to resolve problems of limited scope and complexity; works on assignments that are initially routine in nature, requiring limited judgment and decision making. Employees at this level are expected to acquire the skills and knowledge to perform more advanced work following an agreed upon time in position, through defined training and development planning.	Professional who applies acquired job skills, policies, and procedures to complete substantive assignments / projects / tasks of moderate scope and complexity; exercises judgment within defined guidelines and practices to determine appropriate action.	Experienced professional who knows how to apply theory and put it into practice with in-depth understanding of the professional field; independently performs the full range of responsibilities within the function; possesses broad job knowledge; analyzes problems / issues of diverse scope and determines solutions.	Technical leader with a high degree of knowledge in the overall field and recognized expertise in specific areas; problem-solving frequently requires analysis of unique issues / problems without precedent and / or structure. May manage programs that include formulating strategies and administering policies, processes, and resources; functions with a high degree of autonomy.	Recognized organization-wide expert. Has significant impact and influence on organizational policy and program development. Regularly leads projects of critical importance to the organization; these projects carry substantial consequences of success or failure. Directs programs with organization-wide impact (or may have impact beyond the University) that include formulating strategies and administering policies, processes, and resources. Significant barriers to entry exist at this level.
Custom Scope	Under supervision applies professional concepts, methodologies and procedures to resolve routine data  information management problems. Works on problems of limited scope to provide data information management support. Follows standard practices and procedures in analyzing situations or data information from which answers can be readily obtained. This title is bargaining unit only. There should never be an uncovered position.	Applies data information management concepts, methodologies, policies and procedures to resolve a variety of data  information management issues. Works on data information management problems of moderate scope and complexity where analyses of situations or data require a review of a variety of factors. Typically, the bargaining unit job code should be used for work covered by this title. However, if the position is not covered by the Higher Education Employer-Employee Relations Act (HEERA) due to one of the following reasons—(1) Confidential status, where duties normally require access to confidential information that significantly influences the development of management’s bargaining or grievance positions; (2) employed outside of California at a location with 100 or fewer employees; or (3) Supervisory status, where duties include supervising employees as a regular part of the job—then the position should be listed under the generic title without the “TX” ending.	Applies skills as a seasoned, experienced data information management professional with full understanding of industry practices, data methodologies, policies and procedures to resolve complex and wide-ranging issues where analyses of situations or data requires a review of a variety of factors. Demonstrates competency in selecting methods and techniques to obtain solutions. Typically, the bargaining unit job code should be used for work covered by this title. However, if the position is not covered by the Higher Education Employer-Employee Relations Act (HEERA) due to one of the following reasons—(1) Confidential status, where duties normally require access to confidential information that significantly influences the development of management’s bargaining or grievance positions; (2) employed outside of California at a location with 100 or fewer employees; or (3) Supervisory status, where duties include supervising employees as a regular part of the job—then the position should be listed under the generic title without the “TX” ending.	Having significant experience, applies advanced data information management concepts and business objectives to resolve highly complex issues where analyses of situations, information or data require an in-depth evaluation of variable factors. Selects methods and techniques to obtain desired results. Typically, the bargaining unit job code should be used for work covered by this title. However, if the position is not covered by the Higher Education Employer-Employee Relations Act (HEERA) due to one of the following reasons—(1) Confidential status, where duties normally require access to confidential information that significantly influences the development of management’s bargaining or grievance positions; (2) employed outside of California at a location with 100 or fewer employees; or (3) Supervisory status, where duties include supervising employees as a regular part of the job—then the position should be listed under the generic title without the “TX” ending.	Having wide-ranging experience, applies data information management concepts and business objectives to resolve issues, up to and including the most complex, with institution-wide or multi-institutional impact. Formulates strategies and works on issues, including the most complex, with little or no precedent where analyses of situations, information or data requires an in-depth evaluation of variable factors. Selects methods, techniques and evaluation criteria to obtain results. Is considered a subject matter expert and often recognized as a field or industry expert. Develops conceptual and logical data models with institution-wide and/or discipline-wide scope. Typically, the bargaining unit job code should be used for work covered by this title. However, if the position is not covered by the Higher Education Employer-Employee Relations Act (HEERA) due to one of the following reasons—(1) Confidential status, where duties normally require access to confidential information that significantly influences the development of management’s bargaining or grievance positions; (2) employed outside of California at a location with 100 or fewer employees; or (3) Supervisory status, where duties include supervising employees as a regular part of the job—then the position should be listed under the generic title without the “TX” ending.
Key Resp 01	Performs basic data management duties.	Applies professional data management concepts and defined data information management policies and procedures in completing assignments.	Applies professional and broadly defined business analysis and data information administration and data use concepts to manage and perform complex assignments.	Develops full data information documentation for highly complex small and medium-sized projects.	Directs, initiates and designs data information management studies. Prepares recommendations for data management and resource plans having critical, organization-wide or institution-wide impact.
Key Resp 02	Researches information requirements and standards.	Researches, gathers and analyzes information requirements from data providers and users and documents them using formal data definition techniques and naming standards.	Independently analyzes complex information requirements and documents using formal data definition techniques and naming standards. Gathers, analyzes, prepares and summarizes information from subject matter experts and technical personnel. Researches relevant problem-domain literature and information standards and develops recommendations for data management resource plans including approaches, trends, sources and uses.	Plans and conducts data analysis efforts for highly complex small and medium-sized projects that may include managing partnerships between multiple institutions. Establishes and maintains information documentation standards such as data naming standards and value domain descriptions. Schedules and conducts analysis sessions. Documents ownership, custody and access requirements for data subject areas.	Regularly leads, directs, analyzes and prepares recommendations for data management information needs across process domains and academic disciplines. Performs analysis, up to and including the most complex and advanced.
Key Resp 03	Prepares simple data models and schemas. Researches basic data alignment and conversion requirements and, with assistance, develops data mappings to convert data from one schema to another.	Contributes to the development of logical data models, dimensional data models, and schemas for specific project components.	Implements related business processes, develops logical data models, dimensional data models and schemas for the scope of a project or specific project components. Develops data mapping specifications and extract-transform-load (ETL) designs.	Coordinates reviews of data models and data definitions. Develops both conceptual and detailed data models for projects. Develops dimensional models for data subject areas. Creates and manages workflows (including ETL, data curation and others).	Develops enterprise data models at several levels of detail. Develops and maintains enterprise dimensional data structures. Specifies processes for maintenance of dimensions and sets of dimensions.
Key Resp 04		Designs and implements capture of metadata from technical processes such as software design and database management. Assists with implementation of business processes.	Independently designs information transformation processes. Designs and implements capture of metadata from technical processes such as software design and database management. Performs complex data management or resource research and plans metadata acquisition for sets of unstructured data objects such as collections of images, documents or recordings.	Initiates and designs for diverse date and data systems. Initiates, designs and implements detailed interfaces between computer systems. Initiates, designs, executes and sustains metadata for collections of digital objects.	Designs overall sourcing strategies. Designs and maintains communication across functional areas or disciplinary domains.
Education	Bachelor’s degree in related area and / or equivalent experience / training	Bachelor’s degree in related area and / or equivalent experience / training	Bachelor’s degree in related area and / or equivalent experience / training	Bachelor’s degree in related area and / or equivalent experience / training	Bachelor’s degree in related area and / or equivalent experience / training
Special Condition	Exercise the utmost discretion in managing sensitive information learned in the course of performing their duties. Sensitive information includes but is not limited to employee and student records, health and patient records, financial data, strategic plans, proprietary information, and any other sensitive or non-public information learned during the course and scope of employment. Understands that sensitive information should be shared on a limited basis and actively takes steps to limit access to sensitive information to individuals who have legitimate business need to know. Ensure that sensitive information is properly safeguarded. Follow all organizational policies and laws on data protection and privacy. This includes secure handling of physical and digital records and proper usage of IT systems to prevent data leaks. The unauthorized or improper disclosure of confidential work-related information obtained from any source on any work-related matter is a violation of these expectations.	Exercise the utmost discretion in managing sensitive information learned in the course of performing their duties. Sensitive information includes but is not limited to employee and student records, health and patient records, financial data, strategic plans, proprietary information, and any other sensitive or non-public information learned during the course and scope of employment. Understands that sensitive information should be shared on a limited basis and actively takes steps to limit access to sensitive information to individuals who have legitimate business need to know. Ensure that sensitive information is properly safeguarded. Follow all organizational policies and laws on data protection and privacy. This includes secure handling of physical and digital records and proper usage of IT systems to prevent data leaks. The unauthorized or improper disclosure of confidential work-related information obtained from any source on any work-related matter is a violation of these expectations.	Exercise the utmost discretion in managing sensitive information learned in the course of performing their duties. Sensitive information includes but is not limited to employee and student records, health and patient records, financial data, strategic plans, proprietary information, and any other sensitive or non-public information learned during the course and scope of employment. Understands that sensitive information should be shared on a limited basis and actively takes steps to limit access to sensitive information to individuals who have legitimate business need to know. Ensure that sensitive information is properly safeguarded. Follow all organizational policies and laws on data protection and privacy. This includes secure handling of physical and digital records and proper usage of IT systems to prevent data leaks. The unauthorized or improper disclosure of confidential work-related information obtained from any source on any work-related matter is a violation of these expectations.	Exercise the utmost discretion in managing sensitive information learned in the course of performing their duties. Sensitive information includes but is not limited to employee and student records, health and patient records, financial data, strategic plans, proprietary information, and any other sensitive or non-public information learned during the course and scope of employment. Understands that sensitive information should be shared on a limited basis and actively takes steps to limit access to sensitive information to individuals who have legitimate business need to know. Ensure that sensitive information is properly safeguarded. Follow all organizational policies and laws on data protection and privacy. This includes secure handling of physical and digital records and proper usage of IT systems to prevent data leaks. The unauthorized or improper disclosure of confidential work-related information obtained from any source on any work-related matter is a violation of these expectations.	Exercise the utmost discretion in managing sensitive information learned in the course of performing their duties. Sensitive information includes but is not limited to employee and student records, health and patient records, financial data, strategic plans, proprietary information, and any other sensitive or non-public information learned during the course and scope of employment. Understands that sensitive information should be shared on a limited basis and actively takes steps to limit access to sensitive information to individuals who have legitimate business need to know. Ensure that sensitive information is properly safeguarded. Follow all organizational policies and laws on data protection and privacy. This includes secure handling of physical and digital records and proper usage of IT systems to prevent data leaks. The unauthorized or improper disclosure of confidential work-related information obtained from any source on any work-related matter is a violation of these expectations.
Special Condition	Must pass a background check.	Must pass a background check.	Must pass a background check.	Must pass a background check.	Must pass a background check.
KSA 01	Understanding of data management and database administration, including data modeling, data definition, data conversion and content management.	Knowledge of data management systems, practices and standards.	Ability to prepare data models unassisted.	Ability to prepare complex data models unassisted.	Ability to prepare models at varying levels of detail, from broad conceptual and planning models to detailed logical designs or dimensional models.
KSA 02	Knowledge of relevant rules and regulations.	Knowledge relating to logical data design, data warehouse design, data integration and web content management.	Familiarity with data model patterns in one or more common business or academic domains.	Ability to understand and model complex knowledge-intensive processes such as scholarly and research processes.	Expert skill in logical data design, data integration and the specification of data services.
KSA 03	Ability to represent relevant information in abstract models. Critical thinking skills and attention to detail.	Ability to prepare simple data models under guidance of more senior professionals.	Familiarity with complex logical data design and data mapping or data conversion.	Proven modeling and information design skills. Familiarity with complex logical data design and data mapping or data conversion.	Advanced modeling and information design skills. Familiarity with highly complex logical data design and data mapping or data conversion.
KSA 04	Demonstrated ability to communicate technical information to technical and non-technical personnel across the organization.	Familiarity with important types of data models such as logical and relational models, dimensional models and document models.	Familiarity with data quality and governance issues and requirements.	Familiarity with complex data quality and governance issues and requirements.	Familiarity with highly complex data quality and governance issues and requirements.
KSA 05	Analytical and design skills, including the ability to abstract information requirements from real-world processes to understand information flows in computer systems.	Analytical and design skills, including the ability to abstract information requirements from real-world processes to understand information flows in computer systems.	Strong analytical and design skills, including the ability to abstract information requirements from real-world processes to understand information flows in computer systems.	Advanced analytical and design skills, including the ability to abstract information requirements from real-world processes to understand information flows in computer systems.	Expert analytical and design skills, including the ability to abstract information requirements from real-world processes to understand information flows in computer systems.
KSA 06	Self-motivated and works independently and as part of a team.	Intermediate knowledge of relevant rules and regulations.	Thorough knowledge of data management systems, practices and standards and relevant rules and regulations.	Advanced knowledge of data management systems, practices, standards, and relevant rules and regulations. Skilled in data integration and the specification of data services.	Expert knowledge of data management systems, practices and standards and relevant rules and regulations. Highly skilled in data integration and the specification of data services.
KSA 07	Demonstrated problem-solving and organizational skills and the ability to learn effectively and meet deadlines.	Proven problem-solving and organizational skills with the ability to manage time and meet deadlines.	Demonstrated strong problem-solving and organizational skills with the ability to manage projects and meet deadlines.	Demonstrated advanced problem-solving and organizational skills with the ability to manage projects and meet deadlines.	Highly advanced problem-solving and organizational skills with the ability to manage projects, teams and meet deadlines.
KSA 08	Demonstrated ability to work effectively with individuals from diverse backgrounds, effective communication and interpersonal skills, and a strong service orientation.	Demonstrated ability to collaborate effectively with individuals from diverse backgrounds, good communication skills and a strong service orientation.	Proven ability to collaborate effectively with individuals from diverse backgrounds, demonstrating excellent communication, interpersonal skills, and a strong service orientation.	Advanced interpersonal skills, including exceptional communication, negotiation, and influencing abilities, to effectively work with individuals from diverse backgrounds.	Highly advanced interpersonal skills, including exceptional communication, negotiation, and influencing abilities, to effectively work with individuals from diverse backgrounds.
KSA 09		Self-motivated and works independently and as part of a team.	Self-motivated and works independently and as part of a team.	Self-motivated and works independently and as part of a team.	Self-motivated and works independently and as part of a team.
KSA 10		Demonstrated ability to communicate technical information to technical and non-technical personnel at various levels in the organization.	Demonstrated ability to communicate technical information to technical and non-technical personnel at various levels in the organization.	Demonstrated ability to communicate technical information to technical and non-technical personnel at various levels in the organization.	Demonstrated ability to communicate technical information to technical and non-technical personnel at various levels in the organization.
KSA 11		Ability to represent relevant information in abstract models. Critical thinking skills and attention to detail.	Ability to represent relevant information in abstract models. Critical thinking skills and attention to detail.	Ability to represent relevant information in abstract models. Critical thinking skills and attention to detail.	Ability to represent relevant information in abstract models. Critical thinking skills and attention to detail.
KSA 12					Demonstrated ability to effectively communicate with executive-level management on a regular basis.
Environment	Campus, medical center or other university setting and various external venues.	Campus, medical center or other university setting and various external venues.	Campus, medical center or other university setting and various external venues.	Campus, medical center or other university setting and various external venues.	Campus, medical center or other university setting and various external venues.