The City of San José is a place where we use civic technology to help our community thrive.
As the 10th largest city in the nation, the City manages a large set of services and assets. The City operates on a budget of $5 billion, with 7,000 employees serving 1 million residents and 80,000 businesses in the heart of Silicon Valley.
Information Technology’s (IT) mission: Put powerful tools and information in the hands of people to unleash their brilliance in service to our community. IT enables that mission through business and infrastructure systems, cybersecurity, data management and analysis, productivity and collaboration tools, the San Jose 311 resident experience platform, data equity and privacy programs, and strategic planning. San Jose is powered by truly great people, a robust technology environment, and a strong sense of purpose.
We promote work-life integration and a focus on growth to bring out the best in our people. Come join us in making San Jose the most vibrant, equitable, sustainable, and innovative city in America!
You can visit the Information Technology Department website to learn more about us.The City of San José is recruiting for Data Warehouse and Business Intelligence Manager (Enterprise Supervising Technology Analyst). This position will report directly to the Data Architect (Enterprise Principal Technology Analyst) in the Information Technology Department (ITD).
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 succeed in 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.
• Develop a combination of solve to complex SQL queries to fulfill cross departmental needs
• Creating reports, visualizations and custom extracts using BI Tools including but not limited to SQL Server Management Studio, Python, Excel, Power Query, Power BI Desktop/Service and Tableau Server
• Assists in the training of Power BI to different departments, if necessary.
• Provide support in ongoing development of technical best practices for data integration, data quality, data cleansing and other ETL related activities
• Ability to work collaboratively in a team environment on multiple Projects
• Managing employee work plans and performance appraisals.

Please note that the Data Warehouse and Business Intelligence Manager (Enterprise Supervising Technology Analyst) position is currently on a hybrid telework schedule – working remotely and onsite is subject to change.
Salary Information: 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.

• Salary Range (including the 5% NPWI): $136,237.92 (min) – $166,005.84 (max)

The ESTA classification is represented by the City Association of Management Personnel (CAMP).Education and Experience: A Bachelor’s Degree from an accredited college or university in a relevant field, AND four (4) years of progressively responsible professional/journey level experience, of which at least two (2) years of experience include lead technical work in development, implementation and maintenance of electronic business systems/solutions, or application development and/or support.
Acceptable Substitution:

• Additional years of increasingly responsible directly related work experience may be substituted for education on a year-for-year basis up to two (2) years.
• Completion of a Master's Degree in a relevant field from an accredited college or university may be substituted for one (1) year of the required two (2) years of experience which include lead technical work in development, implementation and maintenance of electronic business systems/solutions or application development and/or support.

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
• Demonstrates ability to generate reports to support meaningful insights and to support decision-making.
• Experience in SQL Server including ETL, data modeling, data warehousing, and reporting.

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 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.