Data Systems Analyst 3 (Hybrid)

The University of California, Merced is required to provide a reasonable estimate of the compensation range for this role. 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, 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 full salary range for this position is $77,900 - $143,300. The budgeted salary range that the University reasonably expects to pay for this position is $87,000 - $105,000.

This position is approved for a "hybrid" work modality. We will consider a "remote" arrangement provided we find an exceptionally well-qualified candidate who lives within a 150 mile radius of campus.

Initial applicant review will take place on or around October 28, 2024. Posting may close any time after that without notice.

UC Merced will not sponsor H-1-B or J-1 Visas for this position.

There are no relocation funds approved for this position.

The University of California, Merced, is the newest of the University of California system's 10 campuses and the first American research university built in the 21st century. With more than 9,000 undergraduate and graduate students, UC Merced offers an environment that combines a commitment to diversity, inclusion, collaboration and professional development. With bachelor's, master's and doctoral degree programs, strong research and academic partnerships, and community involvement, the UC Merced campus is continually evolving and requires talented, knowledgeable and dynamic educators, researchers, management and staff.

Ranked among the best public universities in the nation by U.S. News and World Report, UC Merced is uniquely equipped to provide educational opportunities for highly qualified students from the San Joaquin Valley and throughout California. The campus enjoys a special connection with nearby Yosemite National Park, is on the cutting edge of sustainability in construction and design and supports the economic development of Merced and the region.

The Merced 2020 Project, a $1.3 billion public-private partnership unprecedented in higher education and completed in 2020, nearly doubled the physical capacity of the campus, enhancing academic distinction, student success and research excellence. UC Merced also operates the Downtown Campus Center, a $33 million, three-story administrative building located in the heart of Merced.

The university's mission of educational excellence and rigorous inquiry is powered by three schools and numerous research institutes and centers that seek scientific and social solutions for the Valley, California and the world. In partnership with UC San Francisco, UC Merced is preparing the way for a rigorous medical education program.

The course of UC Merced's evolution is piloted by a long-range strategic plan. Enacted in 2021, the 10-year blueprint is guiding how the values of equity and justice influence our pathway to earning Carnegie R1 research status, growing enrollment, upholding our identity as a minority-serving institution, and operationalizing how commitments to equity, diversity and inclusion are enacted in each campus unit.

We are looking for a highly skilled and experienced ETL (Extract, Transform, Load) Developer and Database Architect to join our dynamic team. This role combines two critical functions within our organization, focusing on the seamless management of data extraction, transformation, and loading processes as well as the architectural design and optimization of our operational data store and enterprise data warehouse. The successful candidate will play a pivotal role in ensuring our data infrastructure's availability, reliability, and performance, contributing to the success of UC Merced's data-driven initiatives

Key Responsibilities:

1. ETL Development: Design, develop, and maintain ETL processes to efficiently extract data from various sources, transform it to meet business requirements, and load it into data warehouses or data stores. Collaborate with data analysts, business users, and other stakeholders to understand data integration needs and requirements. Optimize ETL workflows to improve data quality, accuracy, and efficiency. Monitor and troubleshoot ETL jobs to ensure data integrity and consistency. Act as a subject matter expert in ETL and database architecture, offering guidance and mentorship to junior team members.
2. Database Architecture: Design, implement, and maintain database architectures that align with the organization's data strategy and business goals. Perform capacity planning, scalability assessments, and database performance tuning to ensure optimal database operations. Evaluate and recommend database technologies, tools, and platforms to support evolving data needs. Ensure data security, compliance, and disaster recovery strategies are effectively implemented in database systems. Collaborate with development teams to integrate.
3. Data Modeling and Documentation, Communication and Collaboration: Develop and maintain data models, schema designs, and data dictionaries for various databases. Document database architecture, ETL processes, and data flow diagrams for knowledge sharing and compliance purposes. Provide guidance and support to data modeling efforts across the organization. Work closely with cross-functional teams, including data engineers, data scientists, business analysts, and OIT team members. Communicate technical concepts and solutions effectively to non-technical stakeholders. Data Privacy,
4. Security, and Governance: Ensure compliance with data privacy regulations (e.g., FERPA, IS3) by developing and enforcing data protection policies. Collaborate with legal and compliance teams to manage data access permissions, masking, and encryption. Administer on-premises and cloud-based databases security, role-based access control (RBAC), managing load operation, performance, computing and storage management, data replication and data sharing. Evaluate and implement data governance tools and platforms to support data management and compliance efforts. Maintain a comprehensive data catalog that documents data assets, lineage, and metadata; define metadata standards and ensure consistent metadata tagging across the organization. Stay current with industry trends and best practices in data governance technology.

*LI-RM1

• Bachelor's degree in computer science, computer engineering, information technology, information systems or related field from an accredited institution (required); or
• Advanced master's degree in related field (preferred); and
• Two years of progressively responsible-related experience or equivalent experience/training (required).
• At least 2 years' experience in data warehouse using in database analytics and real-time functions.
• Familiarity with cloud-based data platforms (e.g., AWS, Azure, Google Cloud, Snowflake) is a plus.
• Relevant certifications (e.g., AWS Certified Data Analytics, Microsoft Certified: Azure Data Engineer, Snowflake: SnowPro Core Certification ) are advantageous.
• Previous experience with higher education and ERP software systems such as Banner, PeopleSoft, or similar ERP systems (preferred).
• Solid working knowledge of advanced analytics and business intelligence concepts such as data analysis, ETL, data warehousing, data lake, enterprise big data platforms, reporting, visualization and dashboards.
• Proven experience as an ETL Developer and Database Architect with a track record of successful project implementations.

Background check required.

How to Apply:
An online application is required for each position to apply.The University of California, Merced is aware that some web-based application processes may be cumbersome for differently abled applicants. Where appropriate, alternative accommodations will be provided. For applicants with disabilities who need additional assistance using TAM, or reasonable accommodations during the interview or search process, please contact ucmjobs@ucmerced.edu.

Equal Employment Opportunity:
The University of California, Merced is an Equal Opportunity/Affirmative Action employer advancing inclusive excellence. All qualified applicants will receive consideration for employment without regard to race, color, creed, religion, national origin, citizenship, sex, age, marital status, sexual orientation, gender identity or expression, disability, pregnancy, or status as a disabled veteran or Vietnam-era veteran, or other protected categories covered by the UC Nondiscrimination and Affirmative Action Policy. UC Merced intentionally promotes and maintains a discrimination- and harassment-free workplace by demonstrating it neither condones nor tolerates employment practices that discriminate against or harass any person or specific group of persons on the basis listed above. We seek candidates who will support our vision to cultivate a vibrant, equity-minded, inclusive excellence university community. When applying to UC Merced, we strongly encourage you to reflect on our Principles of Community and our 2021 strategic plan.

Vaccination Program Policy:

As a condition of employment, you will be required to comply with the University of California SARS-CoV-2 (COVID-19) Vaccination Program Policy. All Covered Individuals under the policy must provide proof of Full Vaccination or, if applicable, submit a request for Exception (based on Medical Exemption, Disability, and/or Religious Objection) or Deferral (based on pregnancy) no later than the applicable deadline. For new University of California employees, the applicable deadline is 14 days after their first date of employment.

Smoke and Tobacco Free Policy:
The University of California, Merced is a smoke and tobacco free workplace. Information and the Smoke and Tobacco Free policy is available at http://smokefree.ucmerced.edu.

E-Verify:
All employers who receive Federal contracts and grants are required to comply with E-Verify, an Internet-based system operated by the Department of Homeland Security (DHS) in partnership with the Social Security Administration (SSA). E-Verify electronically verifies employment eligibility by comparing information provided on the I-9 form to records in the DHS and SSA databases. Certain positions funded by federal contracts/subcontracts requires UC Merced to notify job applicants that an E-Verify check will be conducted and the successful candidate must pass the E-Verify check.

Pay, Benefits & Work Schedule:
For information on the comprehensive benefits package offered by the University of California visit: http://ucnet.universityofcalifornia.edu/compensation-and-benefits/

This position is eligible for the UC Merced Employee Referral Program (ERP). If you were referred by a UC Merced employee, please identify that employee by name in your application as follows:

Step 5 of 7 Referrals

How did you hear about the job? (select) "other"

Additional information? (select) "other"

Specific Referral Source? (write in) first and last name of referring employee

Referring employee MUST be named on application for eligibility.