Data Systems Analyst (7198U), Berkeley Law - 53075 Job at University of California Berkeley
University of California Berkeley Berkeley, CA 94720
$97,000 - $113,500 a year
Data Systems Analyst (7198U), Berkeley Law - 53075 About Berkeley
At the University of California, Berkeley, we are committed to creating a community that fosters equity of experience and opportunity, and ensures that students, faculty, and staff of all backgrounds feel safe, welcome and included. Our culture of openness, freedom and belonging make it a special place for students, faculty and staff.
The University of California, Berkeley, is one of the world's leading institutions of higher education, distinguished by its combination of internationally recognized academic and research excellence; the transformative opportunity it provides to a large and diverse student body; its public mission and commitment to equity and social justice; and its roots in the California experience, animated by such values as innovation, questioning the status quo, and respect for the environment and nature. Since its founding in 1868, Berkeley has fueled a perpetual renaissance, generating unparalleled intellectual, economic and social value in California, the United States and the world.
We are looking for equity-minded applicants who represent the full diversity of California and who demonstrate a sensitivity to and understanding of the diverse academic, socioeconomic, cultural, disability, gender identity, sexual orientation, and ethnic backgrounds present in our community. When you join the team at Berkeley, you can expect to be part of an inclusive, innovative and equity-focused community that approaches higher education as a matter of social justice that requires broad collaboration among faculty, staff, students and community partners. In deciding whether to apply for a position at Berkeley, you are strongly encouraged to consider whether your values align with our Guiding Values and Principles , our Principles of Community , and our Strategic Plan .
At UC Berkeley, we believe that learning is a fundamental part of working, and our goal is for everyone on the Berkeley campus to feel supported and equipped to realize their full potential. We actively support this by providing all of our staff employees with at least 80 hours (10 days) of paid time per year to engage in professional development activities. To find out more about how you can grow your career at UC Berkeley, visit grow.berkeley.edu .
Departmental Overview
Berkeley Law is one of the nation's great centers for legal education, ever exploring and pushing new intellectual boundaries while tackling urgent, real-world issues. The law school is also known for its vibrant and engaged community of students and scholars who are committed to providing leadership and making a difference on problems of local, national and global import. Currently ranked among the top law schools in the country, the School of Law has ambitious development goals as it looks to continue producing leaders in law, government, and society.
The Data Systems Analyst provides critical data analysis, reporting, visualization, and stewardship of sensitive student and departmental data. This position will work closely with IT operations, web development, database, and helpdesk staff within IST, as well as with the Financial Aid and Admissions teams within the Law School. This position reports to the Information Systems Architect and has a dotted reporting line to the Dean of Admissions.
Application Review Date
The First Review Date for this job is: May 24, 2023
Responsibilities
Applies professional and broadly defined business analysis and data/information administration and data use concepts to manage and perform complex assignments. Supports a suite of Tableau dashboards for both admissions and financial aid departments. Consults with the Dean of Admissions and Financial Aid to conceptualize, design, and build new data visualizations for a variety of audiences (internal and external). Develops and maintains task-oriented Google Sheets which rely on an integration between Google Sheets, Qualtrics, and DocuSign. Responsible for all facets of financial aid data management, including internal and external reporting. Manages transfers between databases, bulk data uploads, and related troubleshooting. Works with the Dean of Admissions and Financial Aid to ensure these processes adhere to campus and law school requirements for data security and compliance, and to consider PRA-related implications for creating new reports. Supports data management and communication plans to financial aid recipients and Loan Repayment Assistance Program (LRAP) participants. Manages multiple Access databases including LRAP and American Bar Association (ABA) reporting; maintains and ensures secure data storage and integrity of data relationships. Independently analyzes complex information requirements and documents them 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. Serves as a key departmental resource in identifying technical solutions for business needs. Implements related business processes and develops logical data models, dimensional data models, and schemas for the scope of a project or a component of a project. Develops data mapping specifications and extract-transform-load (ETL) designs. Facilitates data transfers between departments. Develops and maintains documentation both for technical specifications and also for general departmental use. 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 studies for a variety of constituents and plans metadata acquisition for sets of unstructured data objects such as collections of images, documents, or recordings. Develops queries and data sources from within the Law school and externally in support of ad-hoc analysis, forecasts, and other as-needed reporting. Engages in professional development and training opportunities as needed. Performs additional duties within the scope of this classification as assigned.
Required Qualifications
Familiarity with data model patterns in one or more common business or academic domains. Familiarity with logical data design and data mapping or data conversion. Familiarity with data quality and governance issues and requirements. Ability to represent relevant information in abstract models. Thorough knowledge of data management systems, practices, and standards. Thorough knowledge of relevant rules and regulations. Demonstrated ability to work with others from diverse backgrounds. Demonstrated effective communication (both written and verbal) and interpersonal skills. Demonstrated service orientation skills. Demonstrated ability to communicate technical information to technical and non-technical personnel at various levels in the organization. Self-motivated and works independently and as part of a team. Demonstrated strong problem-solving skills. Able to learn effectively and meet deadlines. Strong organizational skills. Strong analytical and design skills, including the ability to abstract information requirements from real-world processes to understand information flows in computer systems. Ability to represent relevant information in abstract models. Critical thinking skills and attention to detail. Demonstrated ability to develop, create, and maintain data visualizations. Demonstrated commitment to and understanding of diversity, equity, inclusion, and belonging (DEIB), and ability to apply and integrate core concepts of DEIB into everyday practice. Must be committed to creating a community that fosters equity of experience and opportunity, and ensures that students, faculty, and staff of all backgrounds feel safe, welcome, and included. Must demonstrate a sensitivity to and understanding of the diverse academic, socioeconomic, cultural, disability, gender identity, sexual orientation, and ethnic backgrounds present in our community.
Education/Training:
Bachelor's degree in related area and/or equivalent experience/training.
Preferred Qualifications
Advanced SQL and Tableau skills. Familiarity with and/or ability to learn UC Berkeley campus data systems. Working knowledge of at least one programming/scripting language (e.g. Python, R, shell scripting (sed, awk), etc.).
Salary & Benefits
For information on the comprehensive benefits package offered by the University, please visit the University of California's Compensation & Benefits website.
Under California law, the University of California, Berkeley is required to provide a reasonable estimate of the compensation range for this role and should not offer a salary outside of the range posted in this job announcement. This range takes into account the wide range of factors that are considered in making compensation decisions including but not limited to experience, skills, knowledge, abilities, education, licensure and certifications, analysis of internal equity, and other business and organizational needs. It is not typical for an individual to be offered a salary at or near the top of the range for a position. Salary offers are determined based on final candidate qualifications and experience.
The budgeted salary that the University reasonably expects to pay for this position is $97,000.00 - $113,500.00.
This is a 100% full-time (40 hours per week), career position that is eligible for full UC benefits. This position is exempt and paid monthly. This is a hybrid position, eligible for 20% remote capability.
Please Note :
blog.nvalabs.org is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, blog.nvalabs.org provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.
At the University of California, Berkeley, we are committed to creating a community that fosters equity of experience and opportunity, and ensures that students, faculty, and staff of all backgrounds feel safe, welcome and included. Our culture of openness, freedom and belonging make it a special place for students, faculty and staff.
The University of California, Berkeley, is one of the world's leading institutions of higher education, distinguished by its combination of internationally recognized academic and research excellence; the transformative opportunity it provides to a large and diverse student body; its public mission and commitment to equity and social justice; and its roots in the California experience, animated by such values as innovation, questioning the status quo, and respect for the environment and nature. Since its founding in 1868, Berkeley has fueled a perpetual renaissance, generating unparalleled intellectual, economic and social value in California, the United States and the world.
We are looking for equity-minded applicants who represent the full diversity of California and who demonstrate a sensitivity to and understanding of the diverse academic, socioeconomic, cultural, disability, gender identity, sexual orientation, and ethnic backgrounds present in our community. When you join the team at Berkeley, you can expect to be part of an inclusive, innovative and equity-focused community that approaches higher education as a matter of social justice that requires broad collaboration among faculty, staff, students and community partners. In deciding whether to apply for a position at Berkeley, you are strongly encouraged to consider whether your values align with our Guiding Values and Principles , our Principles of Community , and our Strategic Plan .
At UC Berkeley, we believe that learning is a fundamental part of working, and our goal is for everyone on the Berkeley campus to feel supported and equipped to realize their full potential. We actively support this by providing all of our staff employees with at least 80 hours (10 days) of paid time per year to engage in professional development activities. To find out more about how you can grow your career at UC Berkeley, visit grow.berkeley.edu .
Departmental Overview
Berkeley Law is one of the nation's great centers for legal education, ever exploring and pushing new intellectual boundaries while tackling urgent, real-world issues. The law school is also known for its vibrant and engaged community of students and scholars who are committed to providing leadership and making a difference on problems of local, national and global import. Currently ranked among the top law schools in the country, the School of Law has ambitious development goals as it looks to continue producing leaders in law, government, and society.
The Data Systems Analyst provides critical data analysis, reporting, visualization, and stewardship of sensitive student and departmental data. This position will work closely with IT operations, web development, database, and helpdesk staff within IST, as well as with the Financial Aid and Admissions teams within the Law School. This position reports to the Information Systems Architect and has a dotted reporting line to the Dean of Admissions.
Application Review Date
The First Review Date for this job is: May 24, 2023
Responsibilities
Applies professional and broadly defined business analysis and data/information administration and data use concepts to manage and perform complex assignments. Supports a suite of Tableau dashboards for both admissions and financial aid departments. Consults with the Dean of Admissions and Financial Aid to conceptualize, design, and build new data visualizations for a variety of audiences (internal and external). Develops and maintains task-oriented Google Sheets which rely on an integration between Google Sheets, Qualtrics, and DocuSign. Responsible for all facets of financial aid data management, including internal and external reporting. Manages transfers between databases, bulk data uploads, and related troubleshooting. Works with the Dean of Admissions and Financial Aid to ensure these processes adhere to campus and law school requirements for data security and compliance, and to consider PRA-related implications for creating new reports. Supports data management and communication plans to financial aid recipients and Loan Repayment Assistance Program (LRAP) participants. Manages multiple Access databases including LRAP and American Bar Association (ABA) reporting; maintains and ensures secure data storage and integrity of data relationships. Independently analyzes complex information requirements and documents them 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. Serves as a key departmental resource in identifying technical solutions for business needs. Implements related business processes and develops logical data models, dimensional data models, and schemas for the scope of a project or a component of a project. Develops data mapping specifications and extract-transform-load (ETL) designs. Facilitates data transfers between departments. Develops and maintains documentation both for technical specifications and also for general departmental use. 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 studies for a variety of constituents and plans metadata acquisition for sets of unstructured data objects such as collections of images, documents, or recordings. Develops queries and data sources from within the Law school and externally in support of ad-hoc analysis, forecasts, and other as-needed reporting. Engages in professional development and training opportunities as needed. Performs additional duties within the scope of this classification as assigned.
Required Qualifications
Familiarity with data model patterns in one or more common business or academic domains. Familiarity with logical data design and data mapping or data conversion. Familiarity with data quality and governance issues and requirements. Ability to represent relevant information in abstract models. Thorough knowledge of data management systems, practices, and standards. Thorough knowledge of relevant rules and regulations. Demonstrated ability to work with others from diverse backgrounds. Demonstrated effective communication (both written and verbal) and interpersonal skills. Demonstrated service orientation skills. Demonstrated ability to communicate technical information to technical and non-technical personnel at various levels in the organization. Self-motivated and works independently and as part of a team. Demonstrated strong problem-solving skills. Able to learn effectively and meet deadlines. Strong organizational skills. Strong analytical and design skills, including the ability to abstract information requirements from real-world processes to understand information flows in computer systems. Ability to represent relevant information in abstract models. Critical thinking skills and attention to detail. Demonstrated ability to develop, create, and maintain data visualizations. Demonstrated commitment to and understanding of diversity, equity, inclusion, and belonging (DEIB), and ability to apply and integrate core concepts of DEIB into everyday practice. Must be committed to creating a community that fosters equity of experience and opportunity, and ensures that students, faculty, and staff of all backgrounds feel safe, welcome, and included. Must demonstrate a sensitivity to and understanding of the diverse academic, socioeconomic, cultural, disability, gender identity, sexual orientation, and ethnic backgrounds present in our community.
Education/Training:
Bachelor's degree in related area and/or equivalent experience/training.
Preferred Qualifications
Advanced SQL and Tableau skills. Familiarity with and/or ability to learn UC Berkeley campus data systems. Working knowledge of at least one programming/scripting language (e.g. Python, R, shell scripting (sed, awk), etc.).
Salary & Benefits
For information on the comprehensive benefits package offered by the University, please visit the University of California's Compensation & Benefits website.
Under California law, the University of California, Berkeley is required to provide a reasonable estimate of the compensation range for this role and should not offer a salary outside of the range posted in this job announcement. This range takes into account the wide range of factors that are considered in making compensation decisions including but not limited to experience, skills, knowledge, abilities, education, licensure and certifications, analysis of internal equity, and other business and organizational needs. It is not typical for an individual to be offered a salary at or near the top of the range for a position. Salary offers are determined based on final candidate qualifications and experience.
The budgeted salary that the University reasonably expects to pay for this position is $97,000.00 - $113,500.00.
This is a 100% full-time (40 hours per week), career position that is eligible for full UC benefits. This position is exempt and paid monthly. This is a hybrid position, eligible for 20% remote capability.
Please Note :
blog.nvalabs.org is the go-to platform for job seekers looking for the best job postings from around the web. With a focus on quality, the platform guarantees that all job postings are from reliable sources and are up-to-date. It also offers a variety of tools to help users find the perfect job for them, such as searching by location and filtering by industry. Furthermore, blog.nvalabs.org provides helpful resources like resume tips and career advice to give job seekers an edge in their search. With its commitment to quality and user-friendliness, Site.com is the ideal place to find your next job.