Apply on Employer Site

City of San José · 4 hours ago

Senior Systems Applications Programmer - Data Analytics Developer

San Jose, CA

Full-time

Hybrid

Mid, Senior Level

$13K/yr - $157K/yr

3+ years exp

The City of San José is committed to providing exceptional civic services through advanced technologies. They are seeking a Data Analytics Developer to build data pipelines and dashboards for the San José 311 application, enhancing data quality and supporting informed decision-making across city departments.

Environmental ConsultingInnovation ManagementOffice AdministrationRecycling

No H1B

U.S. Citizen Only

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

Qualification

ETLData EngineeringData VisualizationPythonSQLPower BITableauAzure Synapse AnalyticsAWSGCPCollaborationTeamworkProblem SolvingCommunication Skills

Required

A Baccalaureate Degree from an accredited college or university in Business Administration, Public Administration, Computer Technology, or a closely related field

Three years of increasingly progressive experience in computer systems applications programming

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