Senior Business Intelligence Developer ( DATA SYS ANL 4 )
DEPARTMENT DESCRIPTION Risk and Safety Solutions founded to support the University of California, one of the world's leading research institutions. Meeting the challenges presented by the institution's vast breadth of EH&S and Risk Management activities required a creative spirit and new ways of thinking. Today that spirit continues as we expand our expertise to new activities and a wider range of business needs in the public and private sector. THIS POSITION IS NOT A VISA OPPORTUNITY JOB SUMMARY Risk and Safety Solutions supports the technology efforts of UC-wide Enterprise Risk Management. Under general supervision of the Risk and Safety Solutions Associate Director for DevOps, this position serves as a Senior Business Intelligence Developer working on University of California, Office of the President Risk Services initiatives. Responsible for working with stakeholders throughout the UC system as well as providing technical and project leadership to internal development teams to provide reporting, dashboards and analytics using data from the Risk and Safety Solutions platform as well as UC System wide data for Risk Services. Develop Business Intelligence (BI) and Analytics solutions, including requirements gathering, data analysis and modeling, design and building of ETL processes, reports, and dashboards, operational maintenance and support of existing solutions. For Full Consideration Apply By 1/27/2023 POSITION INFORMATION Salary Range $87,600/yr. - $183,000/yr. No. of Positions 1 Appointment Type Career Percentage of Time 100% Shift Hours M-F, hours TBD Location Davis/Hybrid Union Representation No Benefits Eligible Yes Apply by Date 2/12/2023 For full consideration apply by 1/27/2023 PHYSICAL DEMANDS Analytical and Problem Solving, Confidentiality, Customer Contact, Detailed Work, Language, Math, Multiple Concurrent Tasks, Reading (documents or instruments), Reasoning, Training, Verbal Communication, Written Communication Sitting, Talk or Hear Up to 50 Pounds (Medium) Close Visual Acuity (e.g., viewing a computer screen; using measurement devices) - Frequently Quiet Noise Conditions Computer and Peripheral Equipment - Frequently, Telephone WORK ENVIRONMENT Valid driver's license for occasional travel/training activities to various locations. Work flexible schedule evenings, weekends and holidays to work with clients, and meet operational and project priorities. Employee is personally responsible for following health and safety guidelines/instructions. The Smoke and Tobacco Free Environment policy is intended to provide a healthier, safer, and more productive work and learning environment for the entire UC community. The University of California prohibits smoking and tobacco use at all University owned or leased properties, or facilities operated by UC staff or faculty. Smoking and tobacco use are strictly prohibited in indoor and outdoor spaces, parking lots, residential space, and University vehicles. QUALIFICATIONS Required: Bachelor's Degree in Computer Science, Mathematics or equivalent combination of education and experience. Experience with the Microsoft Business Intelligence tool, with a focus on, but not limited to, Power BI (including DAX, data modeling and visualization), SQL Server, T-SQL, and SQL Server Integration Services (SSIS). Experience leading and mentoring a cross functional team Experience working with Data warehousing technology including but not limited to development of Cubes and writing T-SQL queries. Interpersonal and communication skills to communicate effectively with all levels of faculty and staff on a system wide level to both technical and non-technical audiences. Preferred: 4 years of experience in Business Intelligence development. Experience with Document Databases, such as MongoDB, and the migration of NoSQL to SQL databases. Experience working effectively in a service-oriented team environment. Experience applying iterative software development methodologies, working with a team for software development, and scheduled, process controls. Experience working in a collaborative Agile Software Development environment Decision-making and problem-solving skills. Knowledge of Azure SQL Database, Synapse Analytics and Pipelines SPECIAL REQUIREMENTS Background Check This position is a critical position and subject to a background check. Employment is contingent upon successful completion of background investigation including criminal history and identity checks. The University of California has implemented a SARS-CoV-2 (COVID-19) Vaccination Program SARS-CoV-2 Vaccination Policy (ucop.edu) covering all employees. To be compliant with the policy, employees must submit proof of vaccination or a University-approved exception or deferral. Diversity, Equity, Inclusion and Belonging At UC Davis, we're solving life's most urgent challenges to bring a fuller, healthier, and more resilient world within reach. We grow from every challenge we take on and we don't just maintain - we improve. We recognize that creating an inclusive and intellectually vibrant organization means understanding and valuing both our individual differences and our common ground. The most comprehensive solutions come from the most diverse minds and you belong here. As you consider joining UC Davis, please explore our Principles of Community, our Clinical Strategic Plan and strategic vision for research and education, and our latest efforts to outgrow the expected. The University of California is an Equal Opportunity/Affirmative Action Employer advancing inclusive excellence. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, age, protected veteran status, or other protected categories covered by the UC nondiscrimination policy.