MercedRecruiter Since 2001
the smart solution for Merced jobs

Data Warehouse Reporting Programmer - 11975

Company: University of California - Merced
Location: Merced
Posted on: November 21, 2020

Job Description:

Hiring Range

$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 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.



KEY RESPONSIBILITIES

* 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 community.

* 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).



*LI-RM1

Qualifications

* 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 equivalent experience/training.

* At least 4 yrs experience in data warehouse using in-database analytics, real-time functions, and data federation. (Preferred)



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 requirements.

* Familiarity with Cognos Framework Manager and Tableau.

* Ability to represent relevant information in abstract models.

* Thorough knowledge of data management systems, practices and standards.

* 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.

* Demonstrated ability to create concise documentation of technical modifications and/or additions

* Experience with Amazon Web Services (AWS) and/or other cloud-based environments

* 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

Background check and fingerprinting may be required.

Policy Statement

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 veteran status.
For the complete University of California nondiscrimination and affirmative action policy see: http://policy.ucop.edu/doc/4000376/NondiscrimAffirmAct.

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.

E-Verify:
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.

Pay, Benefits & Work Schedule:
For information on the comprehensive benefits package offered by the University of California visit: http://ucnet.universityofcalifornia.edu/compensation-and-benefits/

Keywords: University of California - Merced, Merced , Data Warehouse Reporting Programmer - 11975, IT / Software / Systems , Merced, California

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category
within


Other IT / Software / Systems Jobs


Senior Android Developer
Description: eBay is where the world goes to shop, sell, and give.Whether you are buying new or used, plain or luxurious, commonplace or rare, trendy or one-of-a-kind if it exists in the world, it probably is for (more...)
Company: eBay Inc.
Location: San Jose
Posted on: 11/25/2020

MTS 1, Software Engineer(Front End)
Description: Looking for a company that inspires passion, courage and imagination, where you can be part of the team shaping the future of global commerce Want to shape how millions of people buy, sell, connect, (more...)
Company: eBay
Location: San Jose
Posted on: 11/25/2020

Software Quality Engineer
Description: We are seeking a highly motivated Software Engineer, who can contribute in the role of Quality Engineering. You will be working on the Onsite Traffic and Monetization Team in delivering best in class (more...)
Company: eBay
Location: San Jose
Posted on: 11/25/2020


Linux Kernel Developer
Description: Opportunity br br We are on a mission to build a software defined infrastructure that builds, manages, scales and heals with our business growth. There are many challenges that engage us on a daily (more...)
Company: eBay
Location: San Jose
Posted on: 11/25/2020

Software Engineer I
Description: Power the Possibilities br The CDK Global technology team is looking for collaborative innovators who are passionate about making their mark on emerging enterprise software products. We're building (more...)
Company: CDK Global
Location: San Jose
Posted on: 11/25/2020

SE-III, Software Engineer, Quality
Description: eBay is a global commerce leader that allows our employees to help change how the world buys, sells, and gives. Come be a part of the work culture thats genuinely committed to diversity and inclusion (more...)
Company: eBay
Location: San Jose
Posted on: 11/25/2020

POWER BI DEVELOPER
Description: 10 years in an Advanced analytics and SQL 3 years of experience building Power
Company: E Solutions, Inc.
Location: San Jose
Posted on: 11/25/2020

SW Eng 3 (Sr Software Eng-JAVA Back End)
Description: This opportunity is to work for the Payments Group in eBay. We support all activities on eBay that require money movement and beyond. We build critical software that has immediate impact on millions of (more...)
Company: eBay
Location: San Jose
Posted on: 11/25/2020

Certified Mobile Notary Service (certifiedmobilenotaryservice.com) is now seeking Mobile Notaries na
Description: Be your own boss and work from home There simply is no better choice for a loan signing company Our clients include title and escrow companies, financial institutions, mortgage brokers, real estate
Company: Certified Mobile Notary Service
Location: San Jose
Posted on: 11/25/2020

MTS2, Software Engineer
Description: Do you want to make an impact on the worlds largest e-commerce website Are you interested in building performance efficient, high-volume and highly scalable distributed systems We have a place for you (more...)
Company: eBay
Location: San Jose
Posted on: 11/25/2020

Log In or Create An Account

Get the latest California jobs by following @recnetCA on Twitter!

Merced RSS job feeds