UC Merced
Left Button
BottomBottom Right
Center Image

Data Warehouse Reporting Programmer
Job Category:   Computing/Information Technology
Unit:   Information Technology
Position Code:   SIT8252A
Status:   Closed
Closing Date:   08/12/2018
Salary:   $85,000 - $95,000
Location:   DCC - Downtown Campus Center
Background check:   Background check and fingerprinting may be required

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 nearly 8,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 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.

In Fall 2016, UC Merced broke ground on a $1.3 billion public-private partnership that is unprecedented in higher education. The Merced 2020 Project will nearly double the physical capacity of the campus by 2020, enhancing academic distinction, student success and research excellence. In 2018, UC Merced opened the Downtown Campus Center, a $33 million, three-story administrative building located in the heart of Merced.


• Cutting-edge sustainability and clean energy focus.
• Outstanding benefits with significant paid time off.
• A culture of collaboration that is mission-driven.
• Radically fast, high-performance super computing capabilities.
• An affordable and welcoming community.
• Once-in-a-lifetime opportunity to put your mark on a growing Research University.


The Data Warehouse Reporting Programmer applies skills as a seasoned, experienced data / information management professional with full understanding of data warehouse methodologies, and provision data in ways that enable modern end user practices such as visualization, advanced analytics, data prep, and self-service data access. Will resolve complex and wide ranging issues where analyses of situations or data requires a review of a variety of factors. Demonstrates competency in selecting methods and techniques to obtain solutions. Evaluate and improve existing BI systems. Experience with in-database analytics system consisting of an enterprise data warehouse (EDW) built on an analytic database platform providing parallel processing, partitioning, scalability and optimization features geared toward analytic functionality.


1) Applies professional and broadly defined business analysis and data / information administration and data use concepts to manage and perform complex assignments. Optimization of data models, queries, views to support data processing and reporting requirements. Designing and writing PL/SQL for Oracle databases and hands-on experience in database and SQL performance tuning.

2) Designs data models with data modeling techniques, including 3rd normal form, dimensional data models, facts, star/snowflake schema, etc. Develop OLAP cubes for data store. Performs independent audits and reviews and validates databases to ensure data integrity. Facilitates the discovery of entities, attributes, relationships, and business rules from the functional experts and the user community.

3) Implements related business processes, develops logical data models, dimensional data models and schema for the scope of a project or a component of a project. Develops data mapping specifications and extract-transform-load (ETL) designs. Independently designs information transformation processes. Designs and implements capture of metadata from technical processes such as software design and database management. Use Oracle Data Integrator 12c for data migration (cloud to cloud or cloud to local platforms).

4) Develops models using Cognos Frame Work Manager and reports with Cognos Report Studio and Tableau. Independently designs information transformation processes. Design and implement capture of metadata from technical processes such as software design and database management.


Qualifications:   EDUCATION

- Bachelor's degree in Computer Science, Computer Engineering, Information Technology, Information Systems or a related field and at least four (4) years of progressively responsible related experience /or equivalent experience/training.


- Ability to prepare data models unassisted. At least 4 years experience in data warehouse using in-database analytics, real-time functions, and data federation.

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

- Ability to develop ETL specifications, source to target mappings and other documentation required for ETL development.

- Thorough knowledge of data management systems, practices and standards and Designing data warehouses.

- Experience managing schema objects, such as tables, indexes, and materialized views.

- Adept at creating reports based on the data in the data warehouse (Cognos).

- Experience monitoring the data warehouse's performance and taking preventive or corrective action as required.

- Familiarity with Cognos Frame Work Manager & Tableau.

- Demonstrated ability to work with others from diverse backgrounds.

- Demonstrated effective communication 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.


- Familiarity with data quality and governance issues and requirements.

- Ability to represent relevant information in abstract models.

To Apply:   Click on the link below to use our new on-line application system.

If you do not have internet access you may mail your application, resume, and cover letter to: University of California, Merced, 5200 North Lake Rd., Merced CA 95343. Please list the job number on the subject line.

NOTICE: This position is not open. We are not accepting applications at this time.

    The University of California is an Equal Opportunity/Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability, age or protected veteran status.

For the complete University of California nondiscrimination and affirmative action policy see: http://policy.ucop.edu/doc/4000376/NondiscrimAffirmAct.

As of January 1, 2014 the University of California, Merced will be a smoke and tobacco free workplace. Information and the Smoke and Tobacco Free policy is available at

E-Verify: Effective September 8, 2009, 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.
More Information

For information on the comprehensive benefits package offered by the University of California visit:

Working at UC Merced
UC Systemwide Jobs
Log in to My Jobs
Hiring Manager

People Finder
Our Values
Contact Us