Description

Key Responsibilities:
• Administer and manage SQL Server database permissions required for SSRS folder and report access. 
• Develop, optimize, and maintain SQL queries, stored procedures, and database objects to support operational and analytical reporting needs. 
• Design, build, test, and deploy SSRS reports for multiple Police Department bureaus, ensuring accuracy, security, and performance. 
• Collaborate with stakeholders to gather reporting requirements, validate data outputs, and refine deliverables based on operational needs. 
• Troubleshoot errors related to SQL queries, report execution, dataset performance, and data integrity. 
• Ensure all data handling aligns with departmental security standards, CJIS requirements, and established IT governance processes. 
• Document database changes, data workflows, permissions assignments, and report specifications. 
• Support ongoing improvements in data quality, reporting efficiency, and system integration. 

Required Skills & Qualifications: 
• Advanced experience with Microsoft SQL Server, including T-SQL, permissions administration, and query optimization. 
• Proficiency in SQL Server Reporting Services (SSRS) report design, deployment, and management. 
• Experience working with large, complex datasets in a public safety or enterprise environment (preferred but not required). 
• Strong analytical and problem-solving skills with attention to accuracy and performance. 
• Effective communication skills for interacting with vendors, technical staff, and operational personnel. 
• Ability to manage multiple reporting requests and project tasks with minimal supervision. 
• Understanding of data governance, security best practices, and role-based access control. 
• Experience with Premier One RMS (preferred but not required).

Key Skills

Education

Bachelor's degree