Data Analytics Developer

Our diverse and inclusive workforce of more than 7000 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.Visithere to learn more about our One Team Leadership Values and Expectations including quality and excellent customer service and hereto 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 statusor 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 711 (TTY) or via email at .

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 7000 employees serving about 1 million residents and 80000 businesses in the heart of Silicon Valley.

The Information Technology Departments (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 Citys 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 theInformation Technology Departments websiteto learn about our culture vision leadership and innovative initiatives.

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 Citys 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 candidates qualifications and experience shall determine the actual 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): $12970.96 minimum-$157182.48 annually

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

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.

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 peoples ideas and thoughts.

Selection Process:

The selection process will consist of an evaluation of the applicants 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

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 acceptedthrough 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 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 avaluable tool for learning research and professional growth. We encouragecandidates to use AI responsibly as a support in preparing application materials liveassessments and interviews. Howeverwe value authenticity accuracy and truthfulness.Application responses and interview answers must reflect your ownknowledge skills and experiences. While AI can supplement preparation it cannotreplace the originality and judgment we look for in our employees. This ensuresfairnesstransparency and equityfor all applicants in the hiring process.