City of Houston · 8 hours ago
SENIOR IT PROFESSIONAL-APPLICATIONS
Walker, MI
Full-time
Onsite
Senior Level
5+ years expThe City of Houston is the fourth largest city in the country, promoting healthy and resilient communities through smart civic investments and innovation. They are seeking a Senior Public Safety Data Warehouse Engineer responsible for designing, building, and sustaining a secure, reliable, and high-performing public safety data warehouse ecosystem.
HospitalityNon Profit
No H1B
U.S. Citizen Only
Responsibilities
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, PowerShell)
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 leverage 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 refreshes, environment configuration) to improve reliability and speed
Troubleshoot incidents, assist with complex change requests and participate in a rotation on-call duty supporting 24x7 public safety operations
Maintain technical documentation, SOPs/runbooks, and contribute to knowledge sharing across teams
Perform other duties as assigned
Qualification
Required
5+ years of hands-on experience in data engineering, data warehousing, or database administration, including production support for mission-critical systems
Proficiency in SQL and performance tuning; experience with ETL tools (Azure Data Factory, SSIS) and data orchestration
Experience administering SQL Server
Working knowledge of SDLC, ITIL processes, and Agile/DevOps practices
Strong analytical, documentation, and communication skills; ability to translate business requirements into scalable technical solutions
CJIS Certification (or ability to obtain within 90 days of hire) is mandatory
Must successfully pass a comprehensive background check, including criminal history, and fingerprinting per Houston Police Department and CJIS standards
Candidate must maintain eligibility for access to sensitive law enforcement systems and data
Requires a Bachelor's degree in Computer Science, Management and Information Systems (MIS) or a closely related field
At least six (6) years of technology experience developing, administering, and supporting applications and databases
Preferred
Preference shall be given to eligible veteran applicants provided such persons possess the qualifications necessary for competent discharge of the duties involved in the position applied for
Prior experience with public safety data such as Police RMS, CAD/9-1-1, NIBRS/UCR reporting structures, evidence/chain-of-custody, case management, or similar sensitive domains
Experience building or maintaining a data warehouse
Hands-on experience with metadata and data lineage; familiarity with data governance and retention practices for law enforcement
Experience with Power BI or SSRS for report-enablement and optimization
Programming/scripting in Python and/or PowerShell for data processing, automation, and DevOps tasks
Experience with CI/CD pipelines (GitHub, Azure DevOps)
Relevant certifications (e.g., Azure Data Engineer (DP-203), Azure Administrator (AZ-104), Snowflake certifications, ITIL Foundation, etc.)
Demonstrated success supporting a mission-critical technology environment with strict SLAs
Benefits
Healthcare
Wellness
Professional development
Excellent pension plan
Company
City of Houston
The city also employs over 22,000 full-time staff to keep the city running.
10001+ employees
Funding
Current Stage
Late StageTotal Funding
unknownKey Investors
U.S. Department of Housing and Urban Development
2024-07-29Grant
Leadership Team
Todd DeGidio
Founder & CEO
Mark Seale
Chief Technology Officer
Recent News
bloomberglaw.com
2026-01-03
2025-11-12
Company data provided by crunchbase