Senior It Professional

POSITION OVERVIEW

Applications accepted from: ALL PERSONS INTERESTED

Job Classification: SENIOR IT PROFESSIONAL – APPLICATIONS (Senior Data Warehouse Engineer)

Position Number: 38042

Department: HOUSTON INFORMATION TECHNOLOGY SERVICES (HITS)

Division: ENTERPRISE APPLICATIONS SERVICES

Reporting

Location:

611 WALKER

Workdays &

Hours:

MONDAY – FRIDAY 8AM-5PM
* Subject can Change*

Houston, TX, is the fourth largest city in the country, with a budget of over 6 billion dollars, a workforce strong of 20,000 employees, and 23 departments with fascinating data and a wide range of questions. Houston promotes healthy and resilient communities through smart civic investments, dynamic partnerships, education, and innovation. It is a place where anyone can prosper and feel at home.

The city offers its employees various , including healthcare, wellness, professional development, and an excellent . The Enterprise Data Office is part of the Houston IT Services department and provides city-wide services. Our four focus areas are Open Data, Data Community, Data Governance, and a Modern Data Stack.

The Senior Public Safety Data Warehouse Engineer is responsible for designing, building, and sustaining a secure, reliable, and high‑performing public safety data warehouse ecosystem. The initial focus is the ingestion and curation of HPD data (e.g., Record Management System (RMS) and other operational systems), followed by expansion to Houston Emergency Center (HEC) (e.g., CAD/9‑1‑1 and related systems). This role will create robust ETL/ELT pipelines, ensure data completeness and quality, optimize complex queries for business divisions, enable reporting and analytics, perform database administration, and support a 247 on‑call rotation for mission‑critical operations.

The engineer collaborates closely with public safety stakeholders, application teams, vendors, and regularly provides guidance and training to other team members.

• Participate in the full lifecycle of the public safety data warehouse: architecture, design, build, test, deploy, operate, and improve.
• Design and develop data pipelines and integrations (ETL/ELT) from HPD Record Management System (RMS) and other applications into the data warehouse; extend integrations to additional systems as the program evolves.
• Use cloud data services (e.g., Microsoft Azure ADL, ADF, AWS, Snowflake); implement metadata, lineage, and cataloging.
• Implement batch and near‑real‑time ingestion using tools such as ADF, SSIS, APIs/REST, streaming where appropriate, and scripting languages (e.g., Python, Power Shell).
• Gather, document, and translate business needs into solution architecture, data models, and technical requirements.

• Establish data quality rules, validation checks, reconciliation, and exception handling to ensure completeness, accuracy, and timeliness of public safety data.
• Implement robust observability (monitoring, alerting, logging), dashboards, and runbooks to ensure reliable operations and faster incident resolution.
• Enforce standards, role‑based access control, least‑privilege, encryption, auditing, and secure data sharing in compliance with CJIS and IT Security policies.
• Support data governance, retention, and legal/records compliance practices suitable for law‑enforcement and emergency communications data.

• Prepare and optimize complex SQL queries, views, and data structures for public safety divisions, analysts, and leadership; enable self‑service analytics and ad‑hoc reporting.
• Collaborate with reporting teams to deliver performant, curated datasets to be leveraged with Power BI, Excel, or SQL; tune semantic models and views when needed.
• Proactively manage performance (indexing, partitioning, caching, workload management).

• Perform database administration on SQL Server: monitoring, performance tuning, backup/restore, high availability, disaster recovery, and user access management.
• Automate common operational tasks (CI/CD, deployments, data…