176 applicants
City and County of San Francisco · 1 week ago
Oracle Business Intelligence Reporting Analyst
San Francisco, CA
Full-time
Hybrid
Mid Level
$123K/yr - $155K/yr
3+ years exp
Wonder how qualified you are to the job?
GovernmentSmall and Medium Businesses
Insider Connection @City and County of San Francisco
Responsibilities
Analyze the interrelationships of business processes, complex financial data, and systems to develop reporting requirements and data structures.
Perform fit/gap analysis, define and implement application configuration settings, and work on transition plans for re-engineered business processes.
Design and build solutions to specifications, develop and execute system and user acceptance test plans, and provide support and training for users.
Write technical specifications, business and system process documentation, and identify, manage, and escalate issues and risks throughout the software development life cycle.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
An associate degree in business administration, public administration, information systems, economics, finance, computer science or a closely related field from an accredited college or university OR its equivalent in terms of total course credits/units [i.e., at least sixty (60) semester or ninety (90) quarter credits/units with a minimum of twenty (20) semester or thirty (30) quarter credits/units in one of the fields above or a closely-related field]
Three (3) years in the information systems field, including system analysis, business process design, development and implementation of business application solutions or IT project management
Preferred
Hands on working experience with OBIA 11g (with ODI 12C), including the following: Oracle ODI Load Plans from PeopleSoft 9.2 FSCM (GL, AP, AR, BI, Contracts, PO, Project Costing) and HCM (Time and Labor, Payroll); OBIEE 12.2.1.1 and above (RPD and Dashboard Development); Extending out-of-the-box OBIA RPD with custom fact tables and metrics
Strong hands on experience with SQL Scripting and PL/SQL experience
Setup and integration of OBIEE/OBIA/ODI with various systems such as PeopleSoft and / or EBS
Working with DBAs, BI Dev, PeopleSoft and / or EBS Functional Teams, and Security teams to improve performance and data quality using Agile sessions
Deep understanding of Data Warehouse concepts and working knowledge of data modeling in large data warehouses
Working knowledge with Business Intelligence tool sets like Oracle OBIEE/ SAP Business Objects / IBM Cognos / MS Power BI
Experience analyzing, creating, documenting functional business/application solutions with clients and/or end users for large complex BI systems. This experience must include: Experience with formal software development life cycle methodologies i.e. SDLC
Working knowledge of business process flows used to support a complex Data warehouse, and experience in developing and executing Data Extraction and Dashboards
Expertise in utilizing appropriate tools for analyzing data, documenting processes, developing and testing prototype solutions, including Oracle SQL Query, Visio, MS Access, FTP
Senior level experience in enterprise relational database and/or On-line Analytical Processing (OLAP) modeling and design
Substitution: Additional experience as described above may be substituted for the required degree on a year-for-year basis (up to a maximum of two (2) years). One (1) year is equivalent to thirty (30) semester units / forty-five (45) quarter units with a minimum of 10 semester / 15 quarter units in one of the fields above or a closely related field
Completion of the 1010 Information Systems Trainee Program may be substituted for the required degree
Company
City and County of San Francisco
City and County of San Francisco is the only consolidated city-county in California.
10,001+ employees
H1B Sponsorship
City and County of San Francisco has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Trends of Total Sponsorships
2023 (5)
2022 (2)
2021 (4)
2020 (6)
Funding
Current Stage
Late StageLeadership Team
Carrie Bishop
Chief Digital Services Officer
Dennis Herrera
City Attorney
Company data provided by crunchbase
