Vacancy expired!
Business Intelligence Developer
University of California Merced
JOB ID: 26642
LOCATION: Merced
HIRING RANGE: $80,000 - $100,000
JOB CLOSING DATE
Initial applicant review will begin around November 30, 2021. Position will close when filled.
PLEASE NOTE:
• This position is not approved as a remote position (although UC Merced has a liberal telecommute policy)
• This position is not approved for VISA conversion/extension or relocation funding.
• Great benefits, affordable community, amazing career growth potential!
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 more than 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 for 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 nearly doubled the physical capacity of the campus, 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.
To set the course of UC Merced's evolution, in 2021 UC Merced will enact its first-ever 10-year strategic plan. This plan will guide how the values of equity and justice influence our pathway toward earning Carnegie R1 research status, growing enrollment, upholding our identity as a minority-serving institution, and operationalizing how commitments to equity, diversity and inclusion are enacted within each campus unit. UC Merced is expected to engage in sophisticated thinking, planning, and implementation of actions that effectively diversify the professoriate and staff, improve campus climate for all campus constituency groups, and strengthen our equity, diversity, and inclusion infrastructure and capacity.
ABOUT THE JOB
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. Ability to 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 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:
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. Design data models with data modeling techniques, including 3rd normal form, dimensional data models, facts, star/snowflake schema, etc. Develop OLAP cubes for data store. Perform independent audits and reviews and validate databases to ensure data integrity. Facilitate 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. Develop models using Cognos Framework Manager and reports with Cognos Report Studio. Independently design information transformation processes. Design and implement capture of metadata from technical processes such as software design and database management.
5. Develop dashboard using Tableau, Power BI, or other data visualization tools.
LI-RM1
QUALIFICATIONS
REQUIREMENTS:
• 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.
• Four years of progressively responsible related or equivalent experience/training. (Preferred)
CRITICAL COMPETENCIES:
• Ability to prepare data models unassisted.
• Experience with data model patterns in one or more common business or academic domains.
• Develop ETL specifications, source to target mappings and other documentation required for ETL development.
• Familiarity with data quality and governance issues and requirements.
• 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. (Preferred)
• Experience with Amazon Web Services (AWS) and/or other cloud-based environments. (Preferred)
• Experience with cloud data warehousing solutions such as Snowflake, Cloudera, Redshift, or similar. (Preferred)
• At least 4 yrs experience in data warehouse using indatabase analytics, real-time functions, and data federation. (Preferred)
• 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, monitoring the data warehouse's performance and taking preventive or corrective action as required. (Preferred)
• Previous experience with higher education and ERP software systems such as Banner or PeopleSoft. (Preferred)
• Experience SQL, Oracle PL/SQL, Tableau, Power BI, or other data visualization tools. (Preferred)
• Experience Cognos Framework manager and Cognos Report Studio. (Preferred)
• Experience SQL Server, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), and TSQL. (Preferred)
BACKGROUND CHECK
Background check and fingerprinting willbe required.
How to Apply:
An online application is required for each position to apply.The University of California, Merced is aware that some web-based application processes may be cumbersome for differently abled applicants. Where appropriate, alternative accommodations will be provided. For applicants with disabilities who need additional assistance using TAM, or reasonable accommodations during the interview or search process, please mailto:contactucmjobs@ucmerced.edu.
Equal Employment Opportunity:
The University of California, Merced is an Equal Opportunity/Affirmative Action employer advancing inclusive excellence. All qualified applicants will receive consideration for employment without regard to race, color, creed, religion, national origin, citizenship, sex, age, marital status, sexual orientation, gender identity or expression, disability, pregnancy, or status as a disabled veteran or Vietnam-era veteran, or other protected categories covered by the UC Nondiscrimination and Affirmative Action Policy. UC Merced intentionally promotes and maintains a discrimination- and harassment-free workplace by demonstrating it neither condones nor tolerates employment practices that discriminate against or harass any person or specific group of persons on the basis listed above. We seek candidates who will support our vision to cultivate a vibrant, equity-minded, inclusive excellence university community. When applying to UC Merced, we strongly encourage you to reflect on our Principles of Community and our 2021 strategic plan.
Vaccination Program Policy:
As a condition of employment,you will be required to comply with the University of CaliforniaSARS-CoV-2 (COVID-19)VaccinationProgram Policy. All Covered Individuals under the policy must provide proof of FullVaccinationor, if applicable, submit a request for Exception (based on Medical Exemption, Disability, and/or Religious Objection) or Deferral (based on pregnancy) no later than the applicable deadline.For new University of California employees, the applicable deadline is 14 DAYSafter their first date of employment.
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/
To apply, please visit: https://apptrkr.com/2655264
Copyright ©2021 Jobelephant.com Inc. All rights reserved.
Copyright ©2021 Jobelephant.com Inc. All rights reserved.
https://www.jobelephant.com/
jeid-741bd96ec5584858beed4b67c0027ce1
