Senior Applications Developer (Data Architect)

MUST APPLY ONLINE

Position Duties

• To see a full description please refer to the Senior Applications Developer job description 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.
• To see a full description please refer to the Senior Applications Developer job description
• 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.

Minimum Qualifications

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

EDUCATION AND EXPERIENCE

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

VACANCY INFORMATION

Other Qualifications

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