Data Analytics Developer

Our diverse and inclusive workforce of more than 7,000 employees play a key role in the success of San José, the heart of the Silicon Valley. All City of San José employees work together as one team to make San José a vibrant, innovative, and desirable place to live and work. Visit here to learn more about our One Team Leadership Values and Expectations, including quality and excellent customer service and here to learn more about San José.

The City of San José is an equal opportunity employer. Applicants for all job openings will be considered without regard to age, race, color, religion, sex, national origin, sexual orientation, disability, veteran status or any other consideration made unlawful under any federal, state or local laws. The City of San José is committed to offering reasonable accommodations to job applicants with disabilities. If you need assistance or an accommodation due to a disability, please contact us at 408-535-1285, 711 (TTY) , or via email at CityCareers@sanjoseca.gov .

About the Department

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.

Position Duties

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.

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 job responsibilities include, but are not limited to, the following:

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

Please note that the Senior Systems Applications Programmer position is currently eligible for a hybrid telework schedule (currently 32 hours onsite, 8 hours remote). Work schedules are subject to change.

Salary Information: The final candidate’s qualifications and experience shall determine the actual salary. In addition to the starting salary, employees in the Senior Systems Applications Programmer (SSAP) classification shall also receive an approximate five percent (5%) ongoing non-pensionable compensation pay.

Salary Range (including the 5% NPWI): $129,70.96 minimum-$157,182.48 annually

The SSAP classification is represented by the Municipal Employees’ Federation (MEF) bargaining unit.

Minimum Qualifications

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.

Other Qualifications

The ideal candidate will possess the following competencies, as demonstrated in past and current employment history.

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.

The ideal candidate will possess a combination of the following knowledge and experience:

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

If you have questions about the duties of these positions, the selection or hiring processes, please contact Felipa Perez at felipa.perez@sanjoseca.gov.

Additional Information:

Employment Eligibility: Federal law requires all employees to provide verification of their eligibility to work in this country. Please be informed that the City of San Jose will NOT sponsor, represent or sign any documents related to visa applications/transfers for H1-B or any other type of visa which requires an employer application.

You must answer all job-specific questions to be considered for this vacancy or your application will be deemed incomplete and withheld from further consideration. Applicants are expected to write their own essays/responses.

Please note that applications are currently not accepted through CalOpps or any other third party job board application system.

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.

Please allow adequate time to complete the application and submit before the deadline or the system may not save your application. If your online application was successfully submitted, you will receive an automatic confirmation email to the email address you provided. IF YOU DO NOT RECEIVE THE CONFIRMATION, please email CityCareers@sanjoseca.gov and we will research the status of your application.

AI and the Hiring Process

We recognize that Artificial Intelligence (AI) is becoming part of daily life and can be a valuable tool for learning, research, and professional growth. We encourage candidates to use AI responsibly as a support in preparing application materials, live assessments, and interviews. However, we value authenticity, accuracy and truthfulness. Application responses and interview answers must reflect your own knowledge, skills, and experiences. While AI can supplement preparation, it cannot replace the originality and judgment we look for in our employees. This ensures fairness, transparency, and equity for all applicants in the hiring process.

The City of San Jose offers a wide range of core health benefits including Medical, Dental, Vision, Employee Assistance Program, Life Insurance, Disability, and Savings Plans. Please visit the City's benefits pagefor detailed information on coverage, cost, and dependent coverage.

For information on the City’s Retirement Plan(pension for full-time employees), please visit the Office of Retirement Services website. You will be able to view information based on different Sworn/Federated job classification.

In additional to the benefits above, there is an additional perks siteto explore further benefits of working for the City of San Jose like paid leave, educational reimbursements, and holiday pay are specific to the job classification and union membership.

• 

• City of San Jose

• 408-535-1285

Show more