The New York City Criminal Justice Agency (CJA) needs to support its Azure SQL Server environment and a real-time data processing system to provide live KPIs and measures to dashboards, applications, and external partners. They are expanding their data platform to support modern analytics use cases and require a Senior Data Engineer to build reliable streaming and batch pipelines, implement dimensional models, and support reporting and BI tools.
Requirements
- 4+ years building and operating data solutions in SQL Server and Azure or equivalent cloud environments.
- 2+ years of experience with event streaming technologies such as Kafka or Azure Event Hubs.
- 2+ Big data Cloud Data Platform experience is required
- Expert T-SQL performance-tuning skills and advanced scripting or data engineering experience (e.g., Python).
- Hands-on experience with complex data integration, orchestration, monitoring, and reporting tools.
- Embed CI/CD as a cornerstone of sustainable delivery using Azure DevOps or equivalent pipelines.
- Automate data quality checks, enforce RBAC, encryption, and auditing across SQL Server and Azure.
Responsibilities
- Support the Azure SQL Server environment powering operational applications and analytics.
- Support NYCJA’s event-driven, real-time data processing system that computes and delivers live KPIs and measures to dashboards, applications, and external partners.
- Partner with Product, Analytics, and DevOps teams as NYCJA expands its data platform to support modern analytics use cases.
- Collaborate cross-functionally with Product, Analytics, DevOps, and Data teams to build reliable streaming and batch pipelines
- Document, version, and test all pipelines to support current and future business requirements.
- Implement dimensional models and data structures to enable unified reporting and analytics across systems.
- Support and optimize existing SSRS and Power BI reports sourced from SQL Server.
Other
- Bachelor’s degree in data science, Computer Science, Information Technology or equivalent experience.
- 2+ years of technical leadership (sprint planning, code review, mentoring) in an agile environment.
- Excellent written and verbal communication skills; able to translate justice-domain needs into scalable hybrid-cloud solutions.
- Able to work independently with minimal guidance.
- Participate in a rotating 24×7 on-call schedule to support SQL Server and Azure data operations
