Senior Applications Developer; Data Architect

The City of Pasadena Department of Information Technology is seeking a 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.

• Become a core team member of the Department of Information Technology’s Applications Team.
• Lead the continued development of the City’s modern data platform, including Microsoft Fabric and enterprise analytics environments.
• Advance the City’s enterprise data strategy by enabling trusted, scalable, and self-service analytics across departments.
• Partner with business stakeholders, application developers, ERP team, and project teams to define data requirements.
• Partner with reporting teams to design data models that support enterprise analytics.
• Partner with departments to translate operational workflows into sustainable data models and reporting solutions.
• Ensure compliance with organizational data governance policies and regulatory requirements.
• Design and maintain enterprise data architecture, including data models, integration frameworks, and scalable data platforms.
• Lead end-to-end enterprise reporting, including architecting and governing the semantic data layer, standardizing metrics and visualization practices, and enabling scalable self‑service analytics.
• Design and maintain data pipelines to ingest, transform, and integrate data from multiple operational systems and external sources.
• Develop and maintain data warehouses, lake houses, 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.

• 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.

• 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 workloads.
• 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 collaboratively within cross-functional teams.
• Strong communication skills, capable of leading projects and influencing technical direction.

The City offers outstanding benefits, including 9/80 schedules with alternate Fridays off.