Information Technology Specialist - Database Analyst

REQUIREMENTS AND PREFERENCES

The Broward County Board of County Commissioners is seeking qualified candidates for Information Technology Specialist (Database Analyst).

The Office of Regional Communications and Technology (ORCAT) is responsible for the County's 911 program and all technology infrastructure that supports public safety communications in Broward County.

The E911 Section of the Office of Regional Communications and Technology is responsible for the implementation of lifecycle, strategic, and operational projects to enhance the overall call-handling process for over one million 911 and over eight hundred thousand non-emergency calls annually by all Public Safety Answering Points (PSAP) in Broward County. E911 supports and maintains a mission-critical environment which includes the voice network (i.e., wireless, and non-wireless), voice recording, MIS reporting and analytics, language translation services, Text to 911 / call handling and processing equipment, address updates and maintenance for call routing, and support continuity of services. The E911 section is committed to providing technology solutions to enhance the call processing environment and ongoing support for high availability associated with mission-critical systems at the PSAPs. E911 has established several key projects as top priority to transition from the existing 911 call delivery and call processing infrastructure to Next Generation 911 (NG911). We are excited about our direction and transition to NG911 and would like you to join our team.

General Description

The Communications and Technology Division is seeking candidates for an Information Technology Specialist (ITS) to fulfill the role of Database Analyst. The Database Analyst will be responsible for SQL Database support, Data Analysis, Data Mining, Business Intelligence Integration and support, database design and data replication, report development and report scheduling, automatic report generation and distribution, and serve as the subject matter expert for all reporting requirements associated with the NG911 implementation. This role will lead in the design, development, testing, and implementation of databases, database interfaces, and end user reports for the Office of Regional Communications and Technology. The ITS will be required to provide database and systems support 24 X 7 as needed. Travel between the Public Safety Answering Points (PSAP) within Broward County is required.The ITS manages large scale information technology projects, works under administrative supervision, developing and implementing programs within organizational policies and reports major activities to executive level administrators through conferences and reports.

Minimum Education and Experience Requirements

Requires a Bachelor's degree from an accredited college or university with major coursework in computer science or closely related field. (One year of relevant experience may be substituted for each year of required education.)

Requires four (4) years of experience in systems analysis, systems design and / or applications programming relevant to area of assignment including related project management or closely related experience.

Special Certifications and Licenses Requires the possession and maintenance of a valid Florida E Class Driver's License

Requires the possession of or eligibility to obtain basic CJIS Security Awareness Level 4 certification.

Preferences Six Sigma Certifications (Green Belt, Black Belt, or Master Black Belt) Experience with performing research, data analysis, and feasibility studies

Experience designing, developing, implementing and integrating business intelligence tools and performance dashboards

Experience with Crystal Reports, MiniTab, or Monarch Datawatch tools

Proficient in Microsoft SQL development

High level proficiency with Microsoft Excel

Experience with SharePoint administration

Experience with SQL Server Report Services (SSRS)

Strong communications, critical thinking, interpersonal, and presentation communication skills

Masters Degree or Higher in Computer Science, MIS, CIS, Business, or closely related field

Experience with ETL

SCOPE OF WORK

The functions listed below are those that represent the majority of the time spent working in this class. Management may assign additional functions related to the type of work of the job as necessary.

• Assist as the liaison between the Regional Communications Operations Team, Operator, and consultants for data analytics.
• Work with management team to create a prioritized list of ORCAT reporting needs
• May supervise professional and technical personnel on assigned work teams
• Maintain backups and backup schedules across all E911 systems and databases.
• Serve as a Data Analyst for data mining, analysis, and reporting on the call processing environment
• Assist in planning, design, setup, testing and implementation of databases required for the Next Generation 911 environment
• Assist with updating all SOP documents associated with E911 databases
• Design and develop scheduled reports for exception call processing.
• Design, develop, and implement business intelligence tools and performance dashboards
• Design, develop, test, and implement interfaces to obtain data from disparate and legacy systems
• Support the existing Replicated Databases and all interfaces
• Assist with database upgrades on key application databases utilized internally
• Development of reports in SQL Server Reporting Services (SSRS)
• Assist in developing reports of Key Performance Indicators
• Write SQL queries when needed
• Become proficient and support Power BI tools and Voice Recording System (VRS) search tools.
• Serve as backup for all project activities associated with the GIS Assessment and Remediation initiatives.
• Serve as the backup liaison to agencies, carriers, customer premise equipment vendor(s), and internal County staff for the County Geospatial Routing database that will be used for Next Generation 911.
• Assist in establishing and maintaining the Geospatial Database for Broward County to ensure and maintain 98+% accuracy across the Automatic Location Information Database, MSAG Database, and the County equivalent GIS Databases
• Serve as backup for exception reporting and coordinating all remediation activities associated with the GIS Central Repository data by working with the individual agencies for timely reporting and updates.
• Responsible for designing, modeling, developing, and supporting SQL Relational Database Management Systems (RDBMS).
• Write SQL queries when needed for troubleshooting, data analysis, and interfaces

Additional Responsibilities :

WORK ENVIRONMENT

Physical Demands

Physical demands refer to the requirements for physical exertion and coordination of limb and body movement.

Performs sedentary work that involves walking or standing some of the time and involves exerting up to 10 pounds of force on a regular and recurring basis or sustained keyboard operations.

Unavoidable Hazards (Work Environment)

Unavoidable hazards refer to the job conditions that may lead to injury or health hazards even though precautions have been taken

SPECIAL INFORMATION

Competencies

Anticipates and adopts innovations in business-building digital and technology applications. Is an early adopter of new technologies, technical skills, and capabilities that improve performance. Regularly experiments with and leverages technologies and tools to substantially improve performance.

Makes sense of complex, high quantity, and sometimes contradictory information to effectively solve problems. Consistently looks at complex issues from many angles; obtains a rich and deep understanding; swiftly cuts to the core issue; skillfully separates root causes from symptoms.

Takes on new opportunities and tough challenges with a sense of urgency, high energy, and enthusiasm. Takes immediate, decisive, independent action to resolve issues or problems. Persists as needed. Quickly and consistently identifies and pursues beneficial new opportunities.

Plans and prioritizes work to meet commitments aligned with organizational goals. Outlines clear plans that put actions in a logical sequence; conveys some time frames. Aligns own work with relevant workgroups. Takes some steps to reduce bottlenecks and speed up the work.

Knows the most effective and efficient processes to get things done, with a focus on continuous improvement. Pays close attention to a variety of metrics and benchmarks; determines both major and subtle ways to optimize processes. Swiftly resolves process breakdowns; takes steps to ensure that problems do not recur.

Steps up to address difficult issues, saying what needs to be said. Shares own ideas and points of view openly, regardless of potential criticism or risk; shows conviction when faced with adversity and challenges; raises difficult topics to be sure they are addressed.

Actively seeks new ways to grow and be challenged using both formal and informal development channels. Demonstrates a strong commitment to development by regularly practicing and applying new knowledge and skills; is quick to share new learning with others. Creates a thorough, detailed development plan.

County Core Values All Broward County employees strive to demonstrate the County's four core behavioral competencies.

Americans with Disabilities Act (ADA) Compliance Broward County is an Equal Opportunity Employer committed to inclusion. Broward County is committed to providing equal opportunity and reasonable accommodations to qualified persons with disabilities. We support the hiring of people with disabilities; therefore, if you require assistance due to a disability, please contact the Professional Standards Section in advance at 954-357-6500 or email Profstandards@broward.org to make an accommodation request.

Emergency Management Responsibilities Note : During emergency conditions, all County employees are automatically considered emergency service workers. County employees are subject to being called to work in the event of a disaster, such as a hurricane, or other emergency situation and are expected to perform emergency service duties, as assigned.

County-wide Employee Responsibilities All Broward County employees must serve the public and fellow employees with honesty and integrity in full accord with the letter and spirit of Broward County's Employee Code of Ethics, gift, and conflict of interest policies.

All Broward County employees must establish and maintain effective working relationships with the general public, co-workers, elected and appointed officials and members of diverse cultural and linguistic backgrounds, regardless of race, color, religion, sex, national origin, age, disability, marital status, political affiliation, familial status, sexual orientation, pregnancy, or gender identity and expression.