City of San Jose
About the City
The City of San José innovates to provide exceptional civic services using advanced technologies to help our community thrive.
As one of the largest cities in the nation, the City manages a large set of services and assets. The City operates on a budget of $5 billion, with approximately 7,000 employees serving about 1 million residents and 80,000 businesses in the heart of Silicon Valley.
The Information Technology Department’s (ITD) mission is to enrich the quality of life in San José through innovation, collaboration, and engagement. ITD enables that mission through business and infrastructure systems, cybersecurity, data management and analysis, responsible use of Artificial Intelligence (AI), productivity and collaboration tools, the San José 311 resident experience platform, data equity and privacy programs, and strategic planning. San José is powered by truly great people, a robust technology environment, and a strong sense of purpose.
The IT department is a leader in innovation, embracing cutting‑edge technologies and pioneering solutions to enhance efficiency and quality of life in San José. As part of this effort, the City leads a national initiative for AI through the GovAI Coalition, which was established to give local governments a voice in shaping the future of AI, ensuring it is developed responsibly for the public good.
Promoting the City’s commitment to equity and inclusion, we believe that all members of the community, regardless of background, have access to the tools and resources needed to thrive in the digital age. San José is located in the heart of Silicon Valley, which boasts a rich history in technology, education, and agriculture. Over half of San José residents speak a language other than English at home, highlighting the importance of language accessibility in all City services. By fostering inclusivity, promoting digital literacy, and building accessible platforms, we are advancing technology while creating a more equitable future for everyone.
At the City of San José, we promote work‑life integration and a focus on growth to bring out the best in our people. Come join us in making San José the most vibrant, equitable, sustainable, and innovative city in the nation! Visit the Information Technology Department’s website to learn about our culture, vision, leadership, and innovative initiatives.
Application Schedule NOTE – The first review of applications will be on Tuesday, January 6, 2026. Please submit your application by 11:59 p.m. (PST) on Monday, January 5, 2026, if you would like your application to be included in the first review. Candidates who pass the first application review round will be invited to interviews on the week of January 19, 2026.
Job Summary The Information Technology Department is seeking a Data Analytics Developer to be part of the City’s Data Governance Team to build data pipelines and dashboards for the San José 311 application and other citywide applications. The team partners with departments to establish data standards, strengthen data quality, and support effective data sharing and collaboration, which creates a strong and equitable data foundation that enables informed decision‑making and prepares the City for emerging technologies such as AI. The team fosters a collaborative, mission‑driven environment that welcomes individuals who are eager to advance how data supports government services and community outcomes.
This position offers an exciting opportunity to create automated reporting tools that will transform how the City collects, manages, and visualizes data. The Data Analytics Developer will take ownership of data workflows, develop clear, impactful visualizations across departments, and shape how the City uses data to improve services, strengthen transparency, and guide decision‑making.
Key Responsibilities
Design, develop, and maintain end‑to‑end ETL pipelines using tools such as Python and SQL to integrate data from diverse data sources, including internal databases, APIs, and SaaS platforms such as Zoom, Salesforce, and Oracle Service Cloud, into a centralized data warehouse to enable efficient reporting and analysis.
Develop and maintain data models, including star/snowflake schemas, for efficient reporting and analytics and ensuring data consistency and data integrity across multiple systems.
Design and implement interactive dashboards and reports in Power BI and Tableau to assist City departments in monitoring and analyzing key metrics, transforming complex data into clear visual insights across multiple initiatives.
Automate recurring reports and analytics workflows to support City departments.
Build Azure Synapse Analytics pipelines to ingest data from various formats into Azure Data Lake, enabling centralized storage and seamless access for analytics and reporting.
Design and implement data engineering prototypes or pilot projects leveraging hybrid‑cloud platforms, including AWS and GCP.
Communicate complex technical concepts to non‑technical stakeholders and collaborate with key stakeholders, cross‑functional teams, third‑party vendors, and the San José 311 Customer Contact Center team to prioritize and develop high‑quality datasets that support data‑driven decision‑making.
Document data lineage, pipelines, and processes to support compliance and auditing.
Implement access control for data stored across Azure resources and services to maintain strong governance and establish monitoring mechanisms to safeguard sensitive data.
Education and Experience Education:
A Baccalaureate Degree from an accredited college or university in Business Administration, Public Administration, Computer Technology, or a closely related field.
Experience:
Three years of increasingly progressive experience in computer systems applications programming.
Acceptable Substitutions:
Additional years of directly related work experience may be substituted for up to a maximum of two years of the educational requirement on a year‑for‑year basis.
Qualifications The ideal candidate will possess the following competencies, as demonstrated in past and current employment history.
Demonstrates strong technical experience in ETL, data engineering, and reporting.
Demonstrates the ability to translate end‑user requirements into technical specifications for data integrations and reporting workflows.
Demonstrates proficiency in creating and maintaining dashboards and reports using Power BI, Tableau, or other visualization tools to deliver actionable insights.
Demonstrates ability to apply behavioral and operational analytics to support usability testing, reporting effectiveness, and continuous improvement of data products.
Familiarity with GitHub, Visual Studio, and Copilot to support version control, collaborative development, and efficient coding in data engineering and reporting projects.
Analytical Thinking:
Approaching a problem or situation by using a logical, systematic, sequential approach.
Collaboration:
Develops networks and builds alliances; engages in cross‑functional activities.
Teamwork & Interpersonal Skills:
Develops effective relationships with co‑workers and supervisors by helping others accomplish tasks and using collaboration and conflict resolution skills.
Multi‑Tasking:
Can handle multiple projects and responsibilities simultaneously; has handled a wide variety of assignments in past and/or current position(s).
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.
Communication Skills:
Effectively conveys information and expresses thoughts and facts clearly, orally and in writing; demonstrates effective use of listening skills and 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 all the job‑specific questions. You must answer all questions to be considered, or your application may be deemed incomplete and withheld from further consideration. Only those 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.
Contact If you have questions about the duties of this position, the selection or hiring processes, please contact Felipa Perez at felipa.perez@sanjoseca.gov.
#J-18808-Ljbffr
As one of the largest cities in the nation, the City manages a large set of services and assets. The City operates on a budget of $5 billion, with approximately 7,000 employees serving about 1 million residents and 80,000 businesses in the heart of Silicon Valley.
The Information Technology Department’s (ITD) mission is to enrich the quality of life in San José through innovation, collaboration, and engagement. ITD enables that mission through business and infrastructure systems, cybersecurity, data management and analysis, responsible use of Artificial Intelligence (AI), productivity and collaboration tools, the San José 311 resident experience platform, data equity and privacy programs, and strategic planning. San José is powered by truly great people, a robust technology environment, and a strong sense of purpose.
The IT department is a leader in innovation, embracing cutting‑edge technologies and pioneering solutions to enhance efficiency and quality of life in San José. As part of this effort, the City leads a national initiative for AI through the GovAI Coalition, which was established to give local governments a voice in shaping the future of AI, ensuring it is developed responsibly for the public good.
Promoting the City’s commitment to equity and inclusion, we believe that all members of the community, regardless of background, have access to the tools and resources needed to thrive in the digital age. San José is located in the heart of Silicon Valley, which boasts a rich history in technology, education, and agriculture. Over half of San José residents speak a language other than English at home, highlighting the importance of language accessibility in all City services. By fostering inclusivity, promoting digital literacy, and building accessible platforms, we are advancing technology while creating a more equitable future for everyone.
At the City of San José, we promote work‑life integration and a focus on growth to bring out the best in our people. Come join us in making San José the most vibrant, equitable, sustainable, and innovative city in the nation! Visit the Information Technology Department’s website to learn about our culture, vision, leadership, and innovative initiatives.
Application Schedule NOTE – The first review of applications will be on Tuesday, January 6, 2026. Please submit your application by 11:59 p.m. (PST) on Monday, January 5, 2026, if you would like your application to be included in the first review. Candidates who pass the first application review round will be invited to interviews on the week of January 19, 2026.
Job Summary The Information Technology Department is seeking a Data Analytics Developer to be part of the City’s Data Governance Team to build data pipelines and dashboards for the San José 311 application and other citywide applications. The team partners with departments to establish data standards, strengthen data quality, and support effective data sharing and collaboration, which creates a strong and equitable data foundation that enables informed decision‑making and prepares the City for emerging technologies such as AI. The team fosters a collaborative, mission‑driven environment that welcomes individuals who are eager to advance how data supports government services and community outcomes.
This position offers an exciting opportunity to create automated reporting tools that will transform how the City collects, manages, and visualizes data. The Data Analytics Developer will take ownership of data workflows, develop clear, impactful visualizations across departments, and shape how the City uses data to improve services, strengthen transparency, and guide decision‑making.
Key Responsibilities
Design, develop, and maintain end‑to‑end ETL pipelines using tools such as Python and SQL to integrate data from diverse data sources, including internal databases, APIs, and SaaS platforms such as Zoom, Salesforce, and Oracle Service Cloud, into a centralized data warehouse to enable efficient reporting and analysis.
Develop and maintain data models, including star/snowflake schemas, for efficient reporting and analytics and ensuring data consistency and data integrity across multiple systems.
Design and implement interactive dashboards and reports in Power BI and Tableau to assist City departments in monitoring and analyzing key metrics, transforming complex data into clear visual insights across multiple initiatives.
Automate recurring reports and analytics workflows to support City departments.
Build Azure Synapse Analytics pipelines to ingest data from various formats into Azure Data Lake, enabling centralized storage and seamless access for analytics and reporting.
Design and implement data engineering prototypes or pilot projects leveraging hybrid‑cloud platforms, including AWS and GCP.
Communicate complex technical concepts to non‑technical stakeholders and collaborate with key stakeholders, cross‑functional teams, third‑party vendors, and the San José 311 Customer Contact Center team to prioritize and develop high‑quality datasets that support data‑driven decision‑making.
Document data lineage, pipelines, and processes to support compliance and auditing.
Implement access control for data stored across Azure resources and services to maintain strong governance and establish monitoring mechanisms to safeguard sensitive data.
Education and Experience Education:
A Baccalaureate Degree from an accredited college or university in Business Administration, Public Administration, Computer Technology, or a closely related field.
Experience:
Three years of increasingly progressive experience in computer systems applications programming.
Acceptable Substitutions:
Additional years of directly related work experience may be substituted for up to a maximum of two years of the educational requirement on a year‑for‑year basis.
Qualifications The ideal candidate will possess the following competencies, as demonstrated in past and current employment history.
Demonstrates strong technical experience in ETL, data engineering, and reporting.
Demonstrates the ability to translate end‑user requirements into technical specifications for data integrations and reporting workflows.
Demonstrates proficiency in creating and maintaining dashboards and reports using Power BI, Tableau, or other visualization tools to deliver actionable insights.
Demonstrates ability to apply behavioral and operational analytics to support usability testing, reporting effectiveness, and continuous improvement of data products.
Familiarity with GitHub, Visual Studio, and Copilot to support version control, collaborative development, and efficient coding in data engineering and reporting projects.
Analytical Thinking:
Approaching a problem or situation by using a logical, systematic, sequential approach.
Collaboration:
Develops networks and builds alliances; engages in cross‑functional activities.
Teamwork & Interpersonal Skills:
Develops effective relationships with co‑workers and supervisors by helping others accomplish tasks and using collaboration and conflict resolution skills.
Multi‑Tasking:
Can handle multiple projects and responsibilities simultaneously; has handled a wide variety of assignments in past and/or current position(s).
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.
Communication Skills:
Effectively conveys information and expresses thoughts and facts clearly, orally and in writing; demonstrates effective use of listening skills and 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 all the job‑specific questions. You must answer all questions to be considered, or your application may be deemed incomplete and withheld from further consideration. Only those 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.
Contact If you have questions about the duties of this position, the selection or hiring processes, please contact Felipa Perez at felipa.perez@sanjoseca.gov.
#J-18808-Ljbffr