Senior Systems Applications Programmer - Data Analytics Developer

<p data-pasted="true">The City of San José innovates to provide exceptional civic services using advanced technologies to help our community thrive.<br> <br>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.<br> <br>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.</p><p>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. </p><p>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. </p><p>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 <a href="" target="_blank" data-uw-rm-brl="PR" data-uw-original-href="" data-uw-rm-ext-link="">Information Technology Department’s website</a> to learn about our culture, vision, leadership, and innovative initiatives. </p><p>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. </p><p>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. </p><p>Key job responsibilities include, but are not limited to, the following:</p><ul style="margin-bottom: 3pt;"><li>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.</li><li>Develop and maintain data models, including star/snowflake schemas, for efficient reporting and analytics and ensuring data consistency and data integrity across multiple systems.</li><li>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.</li><li>Automate recurring reports and analytics workflows to support City departments.</li><li>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.</li><li>Design and implement data engineering prototypes or pilot projects leveraging hybrid-cloud platforms, including AWS and GCP. </li><li>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.</li><li>Document data lineage, pipelines, and processes to support compliance and auditing.</li><li>Implement access control for data stored across Azure resources and services to maintain strong governance and establish monitoring mechanisms to safeguard sensitive data.</li></ul><p>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.</p><p>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.</p><p data-uw-rm-sr="">Salary Range (including the 5% NPWI): $129,70.96 minimum-$157,182.48 annually</p><p>The SSAP classification is represented by the <a href="" data-uw-rm-brl="PR" data-uw-original-href="">Municipal Employees’ Federation (MEF)</a> bargaining unit.</p>This position will be posted until filled.<p data-pasted="true"><strong>Education: </strong>A Baccalaureate Degree from an accredited college or university in Business Administration, Public Administration, Computer Technology, or a closely related field.</p><p><strong>Experience: </strong>Three years of increasingly progressive experience in computer systems applications programming.</p><p><strong>Acceptable Substitutions: </strong>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.</p><p data-pasted="true">The ideal candidate will possess the following competencies, as demonstrated in past and current employment history.</p><p>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.</p><p>The ideal candidate will possess a combination of the following knowledge and experience:</p><ul style="margin-bottom: 3pt;"><li>Demonstrates strong technical experience in ETL, data engineering, and reporting.</li><li>Demonstrates the ability to translate end-user requirements into technical specifications for data integrations and reporting workflows.</li><li>Demonstrates proficiency in creating and maintaining dashboards and reports using Power BI, Tableau, or other visualization tools to deliver actionable insights.</li><li>Demonstrates ability to apply behavioral and operational analytics to support usability testing, reporting effectiveness, and continuous improvement of data products.</li><li>Familiarity with GitHub, Visual Studio, and Copilot to support version control, collaborative development, and efficient coding in data engineering and reporting projects.</li></ul><p>Analytical Thinking – Approaching a problem or situation by using a logical, systematic, sequential approach. </p><p>Collaboration – Develops networks and builds alliances; engages in cross-functional activities.</p><p>Teamwork & Interpersonal Skills – Develops effective relationships with co-workers and supervisors by helping others accomplish tasks and using collaboration and conflict resolution skills.</p><p>Multi-Tasking – Can handle multiple projects and responsibilities simultaneously; has handled a wide variety of assignments in past and/or current position(s).</p><p>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.</p><p>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.</p><p><strong>Selection Process: </strong></p><p>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.</p><p>If you have questions about the duties of these positions, the selection or hiring processes, please contact Felipa Perez at felipa.perez@sanjoseca.gov.</p>

Back to blog

Common Interview Questions And Answers

1. HOW DO YOU PLAN YOUR DAY?

This is what this question poses: When do you focus and start working seriously? What are the hours you work optimally? Are you a night owl? A morning bird? Remote teams can be made up of people working on different shifts and around the world, so you won't necessarily be stuck in the 9-5 schedule if it's not for you...

2. HOW DO YOU USE THE DIFFERENT COMMUNICATION TOOLS IN DIFFERENT SITUATIONS?

When you're working on a remote team, there's no way to chat in the hallway between meetings or catch up on the latest project during an office carpool. Therefore, virtual communication will be absolutely essential to get your work done...

3. WHAT IS "WORKING REMOTE" REALLY FOR YOU?

Many people want to work remotely because of the flexibility it allows. You can work anywhere and at any time of the day...

4. WHAT DO YOU NEED IN YOUR PHYSICAL WORKSPACE TO SUCCEED IN YOUR WORK?

With this question, companies are looking to see what equipment they may need to provide you with and to verify how aware you are of what remote working could mean for you physically and logistically...

5. HOW DO YOU PROCESS INFORMATION?

Several years ago, I was working in a team to plan a big event. My supervisor made us all work as a team before the big day. One of our activities has been to find out how each of us processes information...

6. HOW DO YOU MANAGE THE CALENDAR AND THE PROGRAM? WHICH APPLICATIONS / SYSTEM DO YOU USE?

Or you may receive even more specific questions, such as: What's on your calendar? Do you plan blocks of time to do certain types of work? Do you have an open calendar that everyone can see?...

7. HOW DO YOU ORGANIZE FILES, LINKS, AND TABS ON YOUR COMPUTER?

Just like your schedule, how you track files and other information is very important. After all, everything is digital!...

8. HOW TO PRIORITIZE WORK?

The day I watched Marie Forleo's film separating the important from the urgent, my life changed. Not all remote jobs start fast, but most of them are...

9. HOW DO YOU PREPARE FOR A MEETING AND PREPARE A MEETING? WHAT DO YOU SEE HAPPENING DURING THE MEETING?

Just as communication is essential when working remotely, so is organization. Because you won't have those opportunities in the elevator or a casual conversation in the lunchroom, you should take advantage of the little time you have in a video or phone conference...

10. HOW DO YOU USE TECHNOLOGY ON A DAILY BASIS, IN YOUR WORK AND FOR YOUR PLEASURE?

This is a great question because it shows your comfort level with technology, which is very important for a remote worker because you will be working with technology over time...

Other Jobs To Apply

Manufacturing CEO

reputed company: Mail Inventory Specialist

Remote | Public Health Communications Specialist — $70–$110/hour

Hiring Now: Part-Time Live Chat Representative

[Remote] Content Developer (Biology)

Geographic Information System (GIS) Analyst

Customer Service - Temporary Mon-Fri

Join Today: Online Jobs for Teens: Content Creator & Virtual

Creative Project Coordinator

Construct-X, Workface Planner (WFP)

Remote Payroll Specialist Position at XYZ Company

Remote Per Diem Registered Dietitian — Virtual Trials

Call Center Service Advocate I - Remote

Key Account Manager (Sephora)

Remote Inside Account Executive (Hunter AE) - Bay Area

Teach Physical Science Online

CONSULTANT (Junior Enterprise Consultant)

Freelance Graphic Designer

Luxury Travel Consultant – Customer Experience (Remote)

Tele-Critical Care Clinical Coord FT

10 Side Hustles That Work Even with a reputed company Job -- Work From Home Gigs

B2B Customer Service Representative – Sales Appointments - Outbound - Remote USA

Remote Customer Service Specialist

Part-Time Bookkeeper (Remote) -- Immediate Opening

Amazon Work-From-Home Jobs - Part-Time Positions Available

twitter admin

Customer Service Representative Agent Work From Home - Part Time Focus Group Panelists

Remote Prior Authorization Pharmacist

Software Engineer II (.NET & React) (Remote)

Central Selling Specialist – Millwork

[Remote] Government Account Executive

Freelance reputed company (m/f/d) International Research Projects - remote

Remote Insurance Field Sales Agent - Now Hiring

**Remote Customer Experience Representative – High-Paying $19+/hr – No Degree Required – Join reputed company’s Dynamic Remote Team**

Remote Biology Research Scientist (BA, MS, PhD's) - reputed company Trainer ($60-$100 per hour)

Agency Lead

Graphic Designer / Illustrator – 100% Remote

Help Desk Agent ( Remote)

Remote CSR/Dispatcher

**Experienced Evening Customer Support Specialist – Part Time – Work from Home**

Specialist, Strategic Communications Remote / reputed company Jobs

Remote Data Entry Operator Full & Part Time

call center/customer care representative (REMOTE) $15/hr FOR…

Chat Support Agent (Remote) - 15 - 18/hr

Senior Inpatient DRG Medical | Prairie, |

**Remote Data Entry Specialist – Entry Level – No Experience Required – Work From Home – Chula Vista, CA – Join reputed company’s Growing Team**

Second Shift Remote Customer Care Representative – Texas (WFH) – 2nd Shift Inbound Call Center Specialist

Remote BCBA (2 days per month in clinic)

Senior Federal Customer Success Manager - Remote

Remote Lead SAS Developer: SAS-to-Python Migration