Data Warehouse Reporting Programmer - 11975
Company: University of California - Merced
Posted on: November 21, 2020
$80,000 - $100,000
Job Closing Date
Applicant review will begin on or around November 2, 2020 and
posting may close any time after that date without notice.
About UC Merced
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
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 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.
About the Job
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. Resolves 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. Evaluates and improves existing BI
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.
* 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.
* Designs data models with data modeling techniques, including 3rd
normal form, dimensional data models, facts, star/snowflake schema,
etc. Develops OLAP cubes for data store. Performs independent
audits and reviews and validate databases to ensure data integrity.
Facilitates the discovery of entities, attributes, relationships,
and business rules from the functional experts and the user
* 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
* Bachelor's degree in Computer Science, Computer Engineering,
Information Technology, Information Systems or a related field and
three years of progressively responsible related experience /or
* At least 4 yrs experience in data warehouse using in-database
analytics, real-time functions, and data federation.
CRITICAL KNOWLEDGE AND COMPETENCIES
* Ability to prepare data models unassisted.
* Experience with data model patterns in one or more common
business or academic domains.
* Expertise developing ETL specifications, source to target
mappings and other documentation required for ETL development.
* Familiarity with data quality and governance issues and
* Familiarity with Cognos Framework Manager and Tableau.
* Ability to represent relevant information in abstract models.
* Thorough knowledge of data management systems, practices and
* Demonstrated ability to work with others from diverse
* 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
* 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.
* Demonstrated ability to create concise documentation of technical
modifications and/or additions
* Experience with Amazon Web Services (AWS) and/or other
* Experience with cloud data warehousing solutions such as
Snowflake, Cloudera, Redshift, or similar.
* Thorough knowledge of and Designing data warehouses, managing
schema objects, such as tables, indexes, and materialized views,
creating reports based on the data in the data warehouse (Cognos),
monitoring the data warehouse's performance and taking preventive
or corrective action as required.
Background check and fingerprinting may be required.
How to Apply:
An online application is required for each position to apply.
Equal Employment Opportunity:
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
For the complete University of California nondiscrimination and
affirmative action policy see:
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.
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
Pay, Benefits & Work Schedule:
For information on the comprehensive benefits package offered by
the University of California visit:
Keywords: University of California - Merced, Merced , Data Warehouse Reporting Programmer - 11975, IT / Software / Systems , Merced, California
Didn't find what you're looking for? Search again!