Data Warehouse and Business Intelligence Manager (Enterprise Supervising Technology Analyst), Information Technology Department (20328812)

Please note that applications are currently not accepted through CalOpps or any other third party job board application system. To apply, please complete an application via the City of San Jose’s website at www.sanjoseca.gov/citycareers.   

The actual salary shall be determined by the final candidate’s qualifications and experience. In addition to the starting salary, employees in the Enterprise Supervising Technology Analyst (ESTA) classification shall also receive an approximate five percent (5%) ongoing non-pensionable compensation pay.

• Annual Salary Range: $122,408.00 (min) – $149,156.80 (max)

The City of San José is recruiting for an Data Warehouse and Business Intelligence Manager. This position will report directly to the Equity through Data Lead in the IT Department. 

The position requires strong technical and leadership experience and have the ability to take initiative and direct others. We are seeking an individual with a willingness to adapt to an ever-changing business environment as well as an ever-changing technical environment. The ideal candidate must be able to take full ownership of projects to completion and beyond by providing awareness and visibility from a standard IT best practices for operations and security perspective to the rest of the organization. A team leader, team player, and positive attitude are essential to this position. 

Responsibilities include but not limited to the following:  

• Working collaboratively with Data Analysts within the City to deliver key business insights from transactional data.
• Bringing together disparate data sets, in accordance with open data standards set forth by the federal government, for big data analysis.
• Creating reporting databases in Oracle and MS SQL.
• Performing restful or soap web services calls to connect pull datasets various data sources. 
• Managing deliverables in a multi-departmental environment. 
• Preparing and presenting reports to all levels of the organization.
• Directing a team of technical engineers. 
• Managing employee work plans and performance appraisals.

This recruitment may be used to fill multiple positions in this, or other divisions or departments. If you are interested in employment in this classification, you should apply to ensure you are considered for additional opportunities that may utilize the applicants from this recruitment.

Competencies 
The ideal candidates will possess the following competencies, as demonstrated in past and current employment history. A focus on outcomes over activity is key. 

Job Expertise – Demonstrates knowledge of and experience with applicable professional/technical principles and practices, Citywide and departmental procedures/policies and federal and state rules and regulations.

• Expertise in automating the data refreshes in self-service BI tools. 
• Demonstrates mastery in Tableau, Microsoft Power BI, PowerPivot and/or other BI tools to be able to guide other team members.
• Demonstrates analytical thinking for translating data into informative reports and visuals.
• Demonstrates the ability to work with large volumes of data.

Problem Solving – Approaches a situation or problem by defining the problem or issue; determines the significance of problem; collects information; uses logic and intuition to arrive at decisions or solutions to problems that achieve the desired outcome.

Teamwork & Interpersonal Skills – Develops effective relationships with co-workers and supervisors by helping others accomplish tasks and using collaboration and conflict resolution skills.

Project Management – Ensures support for projects and implements agency goals and strategic objectives.

Analytical Thinking – Approaching a problem or situation by using a logical, systematic, sequential approach.

Communication Skills – Effectively conveys information and expresses thoughts and facts clearly, orally and in writing; demonstrates effective use of listening skills; displays openness to other people’s ideas and thoughts.

Selection Process

The selection process will consist of an evaluation of the applicant's training and experience based on the application and responses to the Job Specific Questions. Only the candidates whose backgrounds best match the position will be invited to proceed in the selection process. Additional phases of the selection process will consist of one or more interviews, one of which may include a practical/writing exercise. 

You will be prompted to answer the following job-specific questions during the online application process. Please note that there is a 4,000-character limit, including spaces, for each text response. 

1. Please describe your experience in creating and maintaining reporting databases in Oracle and MSSQL.
2. In your experience working with Power BI tools, please describe what features and functionalities you have used and your level of expertise working with each of those.

You must answer all job-specific questions in order to be considered for this vacancy or your application will be deemed incomplete and withheld from further consideration. In addition, please attach your resume as part of the application process. If you have questions about the duties of these positions, the selection or hiring processes, please contact Tram Nguyen at tramt.nguyen@sanjoseca.gov.