Highlights
The role requires strong coordination between the external vendor, internal IT Bureau staff, and various Police Department bureaus that depend on accurate, timely data reporting. •Design, build, test, and deploy SSRS reports for multiple Police Department bureaus, ensuring accuracy, security, and performance.
Numbers & Facts
| Location | Phoenix, AZ |
| Industry | Staffing/Employment Agencies |
| Salary | $65 |
| Company Size | 2,000 to 2,499 employees |
| Year Founded | 2000 |
| Website | http://www.lancesoft.com/ |
Description
Duration: 08/31/2026 - 06/30/2028
Work Hours: 8hrs/Day or 40hrs/week/AZ time
Location: Arizona, Phoenix
Position: Hybrid( 100% Hybrid (75% on-site, 25% remote to be discussed after onboarding)
Job Description:
Provides advanced technical support, data management, and reporting services for the Police Department’s Premier One Records Management System (RMS). This position focuses on SQL Server permissions administration, query development and optimization, and the creation of SSRS reports. The role requires strong coordination between the external vendor, internal IT Bureau staff, and various Police Department bureaus that depend on accurate, timely data reporting.
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). Work Environment: This position supports a multi-bureau Police Department environment and requires interaction with technical and non-technical users. Work may involve sensitive or confidential data requiring strict adherence to security protocols.
Required Skills
Work Hours: 8hrs/Day or 40hrs/week/AZ time
Location: Arizona, Phoenix
Position: Hybrid( 100% Hybrid (75% on-site, 25% remote to be discussed after onboarding)
Job Description:
Provides advanced technical support, data management, and reporting services for the Police Department’s Premier One Records Management System (RMS). This position focuses on SQL Server permissions administration, query development and optimization, and the creation of SSRS reports. The role requires strong coordination between the external vendor, internal IT Bureau staff, and various Police Department bureaus that depend on accurate, timely data reporting.
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). Work Environment: This position supports a multi-bureau Police Department environment and requires interaction with technical and non-technical users. Work may involve sensitive or confidential data requiring strict adherence to security protocols.
Required Skills
- Advanced experience with Microsoft SQL Server, including T-SQL, permissions administration, and query optimization.
- Experience with Premier One RMS
About Company
We are a $125 Million, NMSDC-certified Minority & Woman owned Workforce Solutions Company headquartered in the DC metro area with presence across US with global presence - Canada, Mexico, India, UK, Malaysia, Indonasia, Hongkong, Singapore, UAE. We are specialized in providing Workforce Solutions, SOW project delivery, Engineering Solutions, Creative Services. We currently support 100+ Fortune companies globally and across multiple industry segments. We are currently supporting several massive programs across industry segment nationally/globally (Intel, Ally, AMD, QUALCOMM, Morgan Stanley, Kraft/ Mondelez, MNP, Amdocs, Dell, SanDisk, Medtronic, Becton Dickinson, GE, Lockheed Martin, UTC, L-3 Communications, Caterpillar, BMW, Mercedes Benz, National Grid, Dominion, Energy Future Holdings, PSEG, 3M, Fidelity, Aetna, Humana, Johnson & Johnson, Pfizer, Merck etc).
All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender, identity, national origin, disability, or protected veteran status.