Business Intelligence Developer

$85,400 - $156,800/Yr

University of California - Santa Barbara, CA

Full-time - Entry Level

Santa Barbara, CA

Educational Services

About the position

The Business Intelligence Developer at UC Santa Barbara is responsible for planning, coordinating, and managing data analytics and business intelligence solutions. This role involves working closely with business and technical staff to analyze data needs, develop reporting solutions, and provide training on business intelligence tools. The position requires a strong understanding of data management practices and the ability to resolve complex issues related to data analysis and reporting.

Responsibilities

• Works with business and technical staff to analyze and provide Business Intelligence solutions to meet operational and decision-making needs.
• Gathers, analyzes, prepares and summarizes information from subject matter experts and technical personnel.
• Uses established data platforms and business intelligence tools to develop reporting solutions.
• Coordinates with data engineers in the design and development of data models to support reporting implementations.
• Creates and maintains data definitions.
• Provides knowledge sharing and training of data concepts, business intelligence tools, processes, and standards.
• Provides oversight and support to BI developers across campus with development and deployment standards and security implementations.
• Independently analyzes complex information requirements and documents them using formal data definition techniques and naming standards.
• Implements related business processes, develops logical data models, dimensional data models and schemas for the scope of a project or a component of a project.
• Develops data mapping specifications and data transformation pipelines using continuous development and continuous integration best practices.
• Develops solutions to design and monitor customer security permissions, performs audits and monitors usage.
• Supports users in their effort to analyze data, trains developers and functional experts on UCSB data and implemented business intelligence technologies and best practices.
• Updates existing business intelligence solutions with required changes.
• Troubleshoots report and data analytics issues.
• Monitors reporting solutions and ensures data refresh consistency.
• Ensures integrity and completeness of data and workflows.

Requirements

• 1-3 years of experience developing data models, reports and dashboards with Oracle Fusion Analytics and the Fusion Autonomous Warehouse.
• 1-3 years of knowledge and experience implementing data warehousing principles and design concepts and developing dimensional data models.
• 1-3 years of experience analyzing business processes and information systems and creating specifications for business intelligence solutions.
• 1-3 years of experience with software development in SQL Server or Oracle database environments.
• Bachelor's Degree or equivalent work experience in programming and business analysis or equivalent experience and/or training.

Nice-to-haves

• 1-3 years of experience designing and developing data pipeline solutions using continuous development and continuous integration best practices.
• 1-3 years of experience designing and developing data warehouse solutions with Snowflake or comparable cloud data platforms.
• 1-3 years of knowledge of Oracle Financial Cloud data structures.

Benefits

• Excellent retirement and health benefits
• Flexible work arrangements
• Rich benefits package
• Full benefits eligibility