Data Engineer (hybrid)
- Discuss this with your agent
- Open in Claude
- Open in ChatGPT
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Role details
Tech stack
+37 more
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.
- 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.
- 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.
- 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.
- 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.
- 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.
Prepare application
- Draft this with your agent
- Open in Claude
- Open in ChatGPT
Good distractions
Loading talks and stories from around this roleβ¦