Business Analyst; Group Policy, Windows Server, PowerShell scripting, Microsoft SQL Server, SSRS

LCSO-7640

• Provide first and second tier technical support for applications, systems, and servers.
• Work with vendors and stakeholders on the selection, implementation, and integration of new applications and infrastructure.
• Participate in testing and user acceptance of applications and upgrades.
• Assist with software updates, upgrades, patching, license inventory, and monitoring of various applications and databases.
• Develop workflow and processes for querying, editing, reporting, and mapping of application data.
• Design and implement processes, or process improvements, to aid in development and support of applications.
• Design, develop, and implement internal data feeds, data reporting extracts, and ETL processes between disparate systems.
• Create and maintain custom views and stored procedures as needed to support automation and data integrations.
• Leverage API and author interfaces to facilitate and enhance business processes.
• Document data flows and application specifications from a database perspective
• Configure and monitor relational databases to optimize performance and resource use, safeguard backup and recovery, and ensure health and availability.
• Design, create, and implement analytical reports and provide general support using SQL Server Reporting Services (SSRS) and Power
  
  BI.
• Write and maintain clear and accurate technical documentation to describe procedures and processes.
• Provide training documentation and/or training as needed to transition to support to areas within and beyond the IT section.
• Support activities and initiatives concerning the Sheriff's Office Strategic goals and objectives.
• Perform other duties of similar nature and level.
• Ability to work closely with others as a team.
• Ability to effectively communicate both orally and in writing.
• Ability to provide professional customer service skills to both the public and agency members.
• Ability to prepare and present clear, accurate, concise, and objective written and oral reports.
• Ability to meet requirements and maintain required licensures and certifications as well as agency required in-service training.
• Ability to adhere to the standards and principles of the agency's core values and professionally represent the agency.
• Ability to report to work timely, consistently, and as scheduled.

• Minimum two years of experience in business analysis, project management, or other technical role designing, testing, deploying and supporting applications and their related databases in current technologies OR
• Possession of any equivalent combination of education, training, certification, and experience which provides the requisite knowledge, skills, and abilities for this position.
• The ideal resource will have (and preference will be given to those with experience with):
  Active Directory, Group Policy, Windows Server, Power Shell scripting, Microsoft SQL Server, SQL Server
• Reporting Services (SSRS), Microsoft Power
  
  BI, Smart Sheet, Excel, ASP.NET, Visual Studio, HTML5, Internet Information Server, DNN Content Management System (CMS), Laserfiche Document Imaging, and Neo Gov HRM.
• Exposure to common Project Management (PM) practices also preferred.