Senior Applications Developer (Data Architect)

Salary : $126,429.00 - $158,036.00 Annually
Location : Pasadena City Hall, CA
Job Type: Full -Time
Job Number: 26-142
Department: Information Technology
Division: IT Operations
Opening Date: 03/26/2026
Closing Date: Continuous

The City of Pasadena Department of Information Technology is seeking a skilled Senior Applications Developer serving as a Data Architect to lead the design and evolution of the City's enterprise data ecosystem. This role is responsible for designing and managing enterprise data architecture, developing data pipelines, and administering SQL database environments that support enterprise applications, reporting and analytics platforms. This position also supports analytics and reporting platforms such as Microsoft Power BI and modern data platforms including Microsoft Fabric.

This career opportunity includes:

• Becoming a core team member of the Department of Information Technology's Applications Team.
• Leading the continued development of the City's modern data platform, including Microsoft Fabric and enterprise analytics environments.
• Advancing the City's enterprise data strategy by enabling trusted, scalable, and self-service analytics across departments.
• Partnering with business stakeholders, application developers, ERP team, and project teams to define data requirements.
• Partnering with reporting teams to design data models that support enterprise analytics.
• Partnering with departments to translate operational workflows into sustainable data models and reporting solutions.
• Ensuring compliance with organizational data governance policies and regulatory requirements.

The City offers outstanding benefits, including 9/80 schedules with alternative Fridays off. Learn more about working for the Department of Information Technology


MUST APPLY ONLINE

This recruitment is open until filled, with a first review of applications scheduled for April 10th, 2026. Apply now! All applicants must submit resumes.

Please note: This examination is authorized as Promotional and Open Competitive, with the promotional eligibility list taking precedence.


To be considered for the next stage of the process, supplemental questions must be answered in full detailed responses . Applications and resumes will be evaluated based on these detailed supplemental responses.

Applicants that state "see resume" will not be considered further in the process.

Essential Functions
To see a full description please refer to the

• Design, develop, and maintain enterprise data architecture, including data models, integration frameworks, and scalable data platforms.
• Lead end-to-end enterprise reporting function, including architecting and governing the semantic data layer, standardizing metrics and visualization practices, enabling scalable self-service analytics, and ensuring reporting is accurate, trusted, and aligned with business needs.
• Design and maintain enterprise data pipelines to ingest, transform, and integrate data from multiple operational systems and external sources.
• Develop and maintain data warehouses, lakehouses, or modern analytics environments using platforms such as Microsoft Fabric.
• Oversee and guide enterprise database administration practices, including performance optimization, security, and resiliency for Microsoft SQL Server environments.
• Design and maintain curated datasets and semantic models to support dashboards and reports using Microsoft Power BI and other business intelligence tools.
• Serve as a strategic advisor to departments by translating business needs into scalable data architecture and reporting solutions.
• Document data architecture, data flows, database configurations, and reporting standards.
• Provide technical guidance and best practices related to database management, data engineering, analytics platforms, and reporting frameworks.
• Support implementation of enterprise data governance practices, including data quality, metadata management, and stewardship processes.
• Ensure data integrity and security.

Qualification Guidelines
EDUCATION AND EXPERIENCE

• Graduation from an accredited four-year college or university with a major in management information systems, computer science or a closely related field.
• At least six years of progressively responsible experience in application configuration, development and systems analysis.

Desirable Qualifications:

• Experience building enterprise data models and supporting business intelligence and reporting solutions using tools such as Microsoft Power BI.
• Experience designing dimensional or semantic data models to support enterprise reporting and analytics.
• Experience developing data pipelines, ETL/ELT processes, and data integration solutions supporting enterprise applications and analytics platforms.
• Experience working directly with business stakeholders to define data requirements and translate them into technical solutions.
• Experience with Microsoft Fabric including Lakehouse, Data Factory, or analytics workload.
• Experience with Azure Synapse Analytics or other cloud data platforms.
• Experience with Azure Data Factory or similar orchestration tools.
• Experience building dashboards and reports using Microsoft Power BI.
• Knowledge of data governance frameworks and data catalogs.
• Microsoft .NET Framework and ASP.NET web development using C# is highly desirable.
• Experience supporting self-service analytics models and governance frameworks in enterprise environments.
• Ability to work both independently and collaborative within cross-functional teams.
• Strong communicator, capable of leading projects and influencing technical direction.

SELECTION PROCESS:

The selection process may consist of a training and experience evaluation based on the application and supplemental question responses, written exam, interview panel, and/or department-level interviews. Candidates may be required to complete a brief soft-skills assessment during the selection process. The candidate assessment provides insight into core interpersonal skills, behavioral traits, and preferred work environment - helping us support your success in the role.


Probationary work period is one year. FLSA = Exempt

UNIT = PMA

VACANCY INFORMATION:

There is currently one vacancy in the Operations division of our Department of Information and Technology.The resulting eligibility list from this recruitment may be used to fill this vacancy and similar vacancies in the future.

Candidates selected for this position are subject to a one-year probationary work period.

Special Requirements


For certain assignments, successful completion of a comprehensive background investigation is required, including a review of employment history, criminal conviction record, use of intoxicants and/or other controlled substances. In these cases, incumbents may be asked to work at secure locations and access highly confidential materials and information, in addition to working on systems that have city-wide impacts.
The City of Pasadena contracts with the California Public Employees' Retirement System (CalPERS) to manage our defined benefits program for eligible employees. CalPERS manages the pension and health benefits to more than 1.6 million public employees, retirees, and their families and more than 3,000 employers.
Effective January 1, 2013, new members to CalPERS will be subject to the provisions of the Public Employees' Pension Reform Act of 2013 (PEPRA) and will receive the 2% @ 62 benefit formula (if a miscellaneous employee) and 2.7% at 57 benefit formula (if a safety employee).
Employees who are deemed "Classic" members of CalPERS or a reciprocal system such as the Los Angeles County Employees' Retirement System (LACERA) or Los Angeles City Employees Retirement System (LACERS) will receive the 2.5% @ 55 benefit formula (if a miscellaneous employee) or 3% at 55 benefit formula (if a safety employee). A CalPERS "Classic" member is a member who previously worked for a California public agency and meets the following criteria:

1. First established CalPERS membership or membership in a CalPERS reciprocal agency prior to January 1, 2013,
2. And is hired by the City of Pasadena after a break in service of less than six months
3. And did not have concurrent (overlapping) service with the other agency.

01


A current resume must be attached to the application. Your application will not be accepted if a resume is not attached. Please select "Yes" to reflect you have read this statement and attached a resume.

• Yes
• No

02


Select an option that best describes your level of experience with designing and implementing enterprise data architecture.

• Expert
• Moderate
• Basic
• No experience

03


Based on your answer to question 2, include the types of data platforms, tools, and technologies you have used. (If you answer, "No Experience", enter "N/A")
04


Select an option that best describes your level of experience supporting enterprise reporting and analytics platforms.

• Expert
• Moderate
• Basic
• No experience

05


Based on your answer to question 4, include your experience developing semantic data models, curated datasets, or dashboards using tools such as Microsoft Power BI. Provide specific examples that justify your self-assessment. Your answer should describe specific work experience. (If you answered, "No Experience", enter "N/A")
06


Select an option that best describes your level of experience with implementing or supporting modern data platforms.

• Expert
• Moderate
• Basic
• No experience

07


Based on your answer to question 6, describe your experience implementing or supporting modern data platforms, including cloud-based solutions such as Microsoft Fabric or other data warehouse or lakehouse environments. Provide specific examples that justify your self-assessment. Your answer should describe specific work experience. (If you answered, "No Experience", enter "N/A")
08


Select an option that best describes your level of experience with integrating data from enterprise applications.

• Expert
• Moderate
• Basic
• No experience

09


Based on your answer to question 8, provide specific examples that justify your self-assessment. Your answer should describe specific work experience. (If you answered, "No Experience", enter "N/A")
10


Select an option that best describes your level of experience with complex reporting or analytical solutions you designed and implemented.

• Expert
• Moderate
• Basic
• No experience

11


Based on your answer to question 10, describe the business problem, your technical approach and outcomes. Your answer should describe specific work experience. (If you answered, "No Experience", enter "N/A")
12


Select an option that best describes your level of experience with administering relational databases.

• Expert
• Moderate
• Basic
• No experience

13


Based on your answer to question 12, Your answer should describe specific work experience administering Microsoft SQL Server databases. (If you answered, "No Experience", enter "N/A")
14


Select an option that best describes your programming experience with languages such as SQL, Python, or others you have used to build data pipelines, automate processes, or support analytics.

• Expert
• Moderate
• Basic
• No experience

15


Based on your answer to question 14, provide specific examples that justify your self-assessment. Your answer should describe specific work experience. (If you answered, "No Experience", enter "N/A")
16


Describe a time you partnered with a non-technical department to design a data or reporting solution. What was your approach and what was the outcome?
17


Please submit a resume for consideration and answer all supplemental questions in detail. Please initial that you understand this.
Required Question