Data Engineer

　　Job Number Full/Part Time Schedule Salary

　　31628571 Full Time 8AM - 5PM $78,700 - $145,100

　　Position Information

　　The Data Engineer will be responsible for creating and maintaining data pipelines between Google BigQuery and vended or UCR-hosted sources in support of a campus-wide data warehouse initiative. The successful candidate will utilize various GCP components and tools (BigQuery, Cloud Functions, Cloud Storage, Pub/Sub, etc.) combined with Python and GitLab to facilitate the population and ongoing maintenance of the data warehouse. Additionally, the Data Engineer would be responsible for assisting in the investigation and planning of data source ingestion along with assisting analysts and business intelligence team members in facilitating the utilization of the data warehouse by interested campus partners and other data consumers.

　　This position is classified as predominantly remote with occasional visits to campus as needed. Working hours will be based on Pacific Standard Time (PST).

　　The full salary range for the Data Engineer is $78,700 - $145,100 annually. However, the expected pay scale for this position is UP TO $126,000 annually. UCR bases salary offers on a variety of considerations, such as education, licensure and certifications, experience, and other business and organizational needs

　　Applicants must have current work authorization when accepting a UCR staff position. Currently, UCR is unable to sponsor or take over sponsorship of an employment Visa for staff.

　　As a university employee, you will be required to comply with all applicable University policies and/or collective bargaining agreements, as may be amended from time to time. Federal, state, or local government directives may impose additional requirements.

　　Education

　　Education Requirements

　　Degree Requirement

　　Bachelor's degree in related area and/or equivalent experience/training. Required

　　Certifications

　　Certification Requirement

　　Google Cloud Platform (GCP): Professional Data Engineer Preferred

　　Experience

　　Experience Requirement

　　4 - 7 years of related experience. Required

　　Experience with Google Cloud Platform tools (BigQuery, Cloud Functions, Logging, Cloud IAM, Pub/Sub, Cloud Scheduler, Cloud Storage). Required

　　Minimum of 4 years of working experience with GCP data centric tools. Preferred

　　Experience with data translation tools (DBT/Google Cloud Dataform) data visualization tools Looker/Looker Studio/Tableau. Preferred

　　Experience using source control to maintain and deploy changes in Cloud Function and ELT Code. Experience in REST API usage and Python code. Required

　　Special Conditions

　　Special Condition Requirement

　　Must pass a background check. Required

　　Occasional travel for university related business meetings, conferences and/or professional development. Required

　　Travel Outside of Normal Business Hours Required

　　Minimum Requirements

　　Strong organizational skills.

　　Ability to prepare data models unassisted.

　　Ability to represent relevant information in abstract models. Critical thinking skills and attention to detail.

　　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.

　　Thorough knowledge of data management systems, practices and standards.

　　Familiarity with logical data design and data mapping or data conversion.

　　Familiarity with data model patterns in one or more common business or academic domains.

　　Self-motivated and works independently and as part of a team.

　　Demonstrated ability to work with others from diverse backgrounds. Demonstrated effective communication and interpersonal skills. Demonstrated service orientation skills.

　　Demonstrated strong problem-solving skills. Able to learn effectively and meet deadlines.

　　Familiarity with data quality and governance issues and requirements.

　　Demonstrated ability to communicate technical information to technical and non-technical personnel at various levels in the organization.

　　Thorough knowledge of relevant rules and regulations.

　　Excellent planning and problem-solving skills.

　　Proficiency in SQL query language. Expertise in data structures, manipulation, and data design. Ability to investigate datasets that may not be well documented. Proficiency in Python or similar language.

　　Ability to manage multiple projects/tasks with competing priorities and keep leadership informed of changes.

　　Preferred Qualifications

　　Ability to think outside the documentation and apply techniques that are not explicitly referenced.

　　Knowledge of OAuth process and flow.

　　Additional Information

　　In the Heart of Inland Southern California, UC Riverside is located on nearly 1,200 acres near Box Springs Mountain in Southern California; the park-like campus provides convenient access to the vibrant and growing Inland region. The campus is a living laboratory for the exploration of issues critical to growing communities' air, water, energy, transportation, politics, the arts, history, and culture. UCR gives every student, faculty and staff member the resources to explore, engage, imagine and excel.

　　UC Riverside is recognized as one of the most ethnically diverse research universities in the country boasting several key rankings of which we are extremely proud.

　　UC Riverside is proud to be ranked No. 12 among all U.S. universities, according to Money Magazine's 2020 rankings, and among the top 1 percent of universities worldwide, according to the 2019-20 Center for World University rankings.

　　UC Riverside is the top university in the United States for social mobility. - U.S. News 2020

　　UCR is a member of the University Innovation Alliance, the leading national coalition of public research universities committed to improving student success for low-income, first-generation, and students of color.

　　Among top-tier universities, UC Riverside ranks No. 2 in financial aid. - Business Insider 2019

　　Ranked No. 2 in the world for research, UCR's Department of Entomology maintains one of the largest collections of insect specimens the nation. - Center for World University Rankings

　　UCR's distinguished faculty boasts 2 Nobel Laureates, and 13 members of the National Academies of Science and Medicine.

　　The University of California is an Equal Opportunity/Affirmative Action Employer with a strong institutional commitment to the achievement of excellence and diversity among its faculty and staff. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, disability, protected veteran status, or any other characteristic protected by law.

　　For information about our generous employee benefits package, visit: Employee Benefits Overview (https://ucnet.universityofcalifornia.edu/compensation-and-benefits/index.html)