Data Analytics Developer

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 Google Cloud Platform.
• 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.