Data Engineer (hybrid)

University of California, Merced
Merced, CA, United States
3 days ago
Apply on diversityjobs.com
Prepare application

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Experience level
Expert
Experience required
3 years minimum
Compensation
$100,000 - $120,000
Working hours
Regular working hours

Tech stack

Artificial Intelligence Business Analytics Applications Data Analysis Confluence JIRA Cloud Database Computer Engineering Continuous Integration Data Architecture Data Validation Data Dictionary Information Engineering
+37 more
Data Governance Data Integration Data Integrity Extract Transform Load (ETL) Data Mining Data Security Data Sharing Data Warehousing Database Queries DevOps Dimensional Modeling Human Resources Information System (HRIS) Github JSON Jinja (Template Engine) Metadata Meta-Data Management Performance Tuning Systems Development Life Cycle Role-Based Access Control Student Information Systems SQL Databases Systems Integration Parquet Data Storage Management Enterprise Software Applications Cloud Platform System System Availability Snowflake Database Performance Indexer Semi-structured Data Templating Information Technology Data Management Database Replication Data Pipelines

Job description

Applies skills as a seasoned, experience data engineering professional with a full understanding of industry best practices and campus policies and procedures. Under general supervision, designs, builds, maintains, and optimizes data pipelines and integration workflows using Snowflake and dbt, serving both analytical platforms and destination applications. Performs a variety of tasks related to data extraction, transformation, and loading (ELT), data quality, and documentation.

Works collaboratively with Database Administrators, Analytics Engineers, other Data Engineers and BI/Reporting Analysts to ensure timely, accurate, and secure data delivery in support of enterprise reporting, research, and operational needs. Participates in technical design sessions and data governance activities to improve institutional data capabilities., 1. ELT Development and Snowflake Data Engineering: Develops and maintains scalable, reusable, and secure ELT pipelines using dbt and other tools. Performs data ingestions, transformation, and load operations in Snowflake. Monitors and troubleshoots data workflows to ensure performance, reliability, data integrity, and alignment with medallion architecture. Models data using dbt for transformation following SDLC best practices, exercising modularity and reusability principles in model code. Ensures data models are in alignment with medallion architecture and enterprise dimensional modeling concepts. Implements best practices and data governance standards in ELT processes.

  1. Data Integration and Reverse ETL: Develops and supports data activations between on-premises and cloud-based data platforms to destination applications. Ensures that data is delivered accurately and timely to downstream platforms supporting institutional operations. Develops and maintains data models, schema designs, and data dictionaries for shared data models and integrations. Documents design, mappings, and data flow diagrams for knowledge sharing and compliance purposes.
  2. Cross-functional Collaboration: Partners with DBAs for schema design, indexing, and database performance optimization. Collaborates with Analytics Engineers to prepare analysis-ready data models. Works with BI Analysts to ensure data availability for dashboards and operational reporting. Coordinates with external partners and functional units.
  3. Data Privacy and Security: 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 data security, role-based access control (RBAC), managing load operations, performance, computing and storage management, data replication and data sharing.
  4. Data Governance and Documentation: Supports data quality checks, metadata capture, and data catalog contributions. Develops and maintains dbt project yaml files that support semantic layer and semantic models. Documents data pipelines, mappings, and workflow logic using tools such as GitHub, JIRA, and Confluence. Participates in campuswide data governance and stewardship efforts.
  5. Platform Innovation and Continuous Improvement: Explores new technologies, proposes automation opportunities, AI-enabled development, and contributes to architectural decisions to modernize the university’s data ecosystems.

Requirements

  • Bachelor’s degree in computer science, computer science engineering, or other directly related area from an accredited institution; and
  • 3+ years progressively responsible, directly related experience in data engineering, data warehousing, and analytics modeling (required).
  • Demonstrated experience with Snowflake data warehousing including schema design, performance optimization, and use of modern cloud-based data architecture. Required
  • Strong SQL skills and experience working with structured and semi-structured data formats (e.g. JSON, Parquet, CSV). Required
  • Demonstrated ability to build and manage data pipelines across on-premises and cloud environments, integrating data from multiple source systems. Required
  • Ability to communicate technical information clearly to both technical and non-technical audiences. Required
  • Effective collaboration skills and experience working in cross-functional teams, especially with DBAs, data analysts, and business partners. Required
  • Experience with developing and managing dbt models using modular, reusable SQL and Jinja templating, designing layered architecture (STG, INT, MART), using dbt tests, document generation, lineage, and metadata management. Preferred
  • Experience supporting data activations such as integrations into enterprise applications (e.g. Student Information Systems, HRIS, Financial Systems). Preferred
  • Experience with DevOps or CI/CD tools for data pipeline development and deployment. Preferred
  • Exposure to higher education systems and reporting needs is a plus. Preferred
  • Snowflake SnowPro Certification, especially for data engineering role. Preferred
  • dbt Analytics Engineering Certification. Preferred

Background Check

Benefits & conditions

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 salary range the University reasonably expects to pay for this position is $100,000 - $120,000. Job Closing Date

This position is approved for a hybrid work modality. Currently, this Position requires 1 day per week in-office (Thursday).

This position is represented by University Professional and Technical Employees (UPTE-TX).

Initial applicant review will take place on or around December 14, 2026. Posting will close when position filled. About UC Merced

The University of California, Merced, is the newest of the University of California system’s 10 campuses and one of the youngest universities to be designated an R1 research university. With approximately 9,600 undergraduate and graduate students, UC Merced is a smaller, more intimate campus compared to its sister campuses, while equipped and staffed as a cutting edge, 21st century research institution. With bachelor’s, master’s and doctoral degree programs, strong research and academic partnerships and a growing community in the heart of the San Joaquin Valley, the UC Merced campus is continually evolving and requires talented, knowledgeable and dynamic educators, researchers, management and staff.

Ranked in the top 30 among the best public universities in the nation by U.S. News and World Report and #1 for social mobility by the Wall Street Journal, UC Merced is uniquely equipped to provide world class educational opportunities to dynamic and enterprising students in the Valley and throughout the state. In partnership with UC San Francisco, UC Merced has launched a rigorous medical education program that will supply the Valley with culturally competent providers dedicated to improving local access to quality care. The campus enjoys a special connection with nearby Yosemite National Park, is on the cutting edge of sustainability in construction and design and is accelerating the continued economic development of the region. About the Job

Apply for this position

This job is hosted externally. Click below to view the full posting and apply.

Apply on diversityjobs.com
Prepare application

Good distractions

Loading talks and stories from around this role…