Job Description
This resource will support a Police Records Management System (RMS) migration effort by designing, recreating, modifying, and delivering SSRS reports, forms, and reporting outputs within a new reporting environment. Responsibilities include developing complex SQL queries, validating report accuracy, replicating legacy reporting functionality from existing examples and business requirements, and ensuring reports meet operational and formatting standards. The consultant will work closely with City IT staff, Police Department users, and subject matter experts to gather requirements, troubleshoot issues, and deliver production-ready reporting solutions along with supporting documentation and knowledge transfer materials. The role will require onsite and hybrid collaboration while adhering to CJIS and City security requirements.
We are a company committed to creating diverse and inclusive environments where people can bring their full, authentic selves to work every day. We are an equal opportunity/affirmative action employer that believes everyone matters. Qualified candidates will receive consideration for employment regardless of their race, color, ethnicity, religion, sex (including pregnancy), sexual orientation, gender identity and expression, marital status, national origin, ancestry, genetic factors, age, disability, protected veteran status, military or uniformed service member status, or any other status or characteristic protected by applicable laws, regulations, and ordinances. If you need assistance and/or a reasonable accommodation due to a disability during the application or recruiting process, please send a request to HR@insightglobal.com.To learn more about how we collect, keep, and process your private information, please review Insight Global's Workforce Privacy Policy: https://insightglobal.com/workforce-privacy-policy/.
Required Skills & Experience
7+ years of hands-on experience with Microsoft SQL Server Reporting Services (SSRS)
Strong SQL development and query writing experience
Experience developing, modifying, and deploying SSRS reports, forms, and report outputs
Experience working with relational databases, reporting databases, and/or data warehouse structures
Ability to build reports using parameters, grouping, expressions, formatting, and export functionality
Experience recreating reports from screenshots, PDFs, legacy reports, standards documentation, or business requirements
Ability to troubleshoot report accuracy, formatting, and data integrity issues
Experience producing complete deliverables including supporting SQL, technical documentation, and handoff materials
Strong communication skills with both technical teams and business stakeholders
Ability to quickly understand new reporting environments and underlying data structures
Nice to Have Skills & Experience
Police Records Management System (RMS) experience
Public safety or municipal government experience
Experience supporting system migrations or reporting modernization initiatives
Experience handling sensitive or law enforcement-related data
Data warehouse/reporting architecture experience
Benefit packages for this role will start on the 1st day of employment and include medical, dental, and vision insurance, as well as HSA, FSA, and DCFSA account options, and 401k retirement account access with employer matching. Employees in this role are also entitled to paid sick leave and/or other paid time off as provided by applicable law.