Data Management Specialist

  • CITY OF BIRMINGHAM, AL
  • Birmingham, Alabama
  • Jun 19, 2022
Full Time Information Technology and Communication Services

Job Description

ATTENTION Merit System Employees: Do not apply through this site.

If you are a current Merit System employee, please click HERE to log into

the internal career site.

Grade 25
Click HERE for Salary Ranges

CLOSE DATE
12/31/2022

SUMMARY

A Data Management Specialist assists in the documentation, reporting, and analysis of relevant data (e.g., disease control, overdose data, HR, etc.). The Data Management Specialist utilizes systems such as Crystal Reports, SQL, and Microsoft Report Builder to gather, transform, and analyze data requested by other departments. Analysis of data includes predictive analytics with possible machine learning and/or artificial intelligence applications and creating scripts and applications to automate information technology reporting processes. The Data Management Specialist performs under the general direction of more senior IT employees (e.g., Manager Systems Analysis) in accordance with policies and procedures with work being reviewed through meetings, reports, and performance appraisals for overall effectiveness.

TYPICAL JOB DUTIES:
Provides service to internal and/or external customers.
Creates, edits, and maintains official forms and documents for record-keeping and reporting.
Creates specialized reports using Crystal Reports, Query Wizard (SQL) by writing queries to gather requested data and organizing the information into an easily understandable format for review by others (e.g., HR, Disease Control, etc.).
Performs predictive analytics to provide analyses and results of pertinent data related to JCDH needs (e.g., disease control, overdose data, etc.).
Engages in activities designed to ensure professional development, awareness of developments in the field, and knowledge of relevant practices, rules, laws, policies, and/or guidelines.

MINIMUM QUALIFICATIONS:

The following Minimum Qualifications are required for this job. You must demonstrate possession of these qualifications by providing a detailed description of your related experience in the work history section of your application. Please note that replicating or restating these minimum qualifications or the information from the Personnel Board’s job description as your own work experience will result in your disqualification. Please describe your work experience in your own words to represent the work you have performed that is related to the minimum qualifications for this job.

  • Experience utilizing T-SQL and Crystal Reports or Microsoft Report Builder for data analytics and reporting.
  • Experience with Microsoft SQL server to extract, transform, and load data.


PREFERRED QUALIFICATIONS:
  • Microsoft Business Intelligence Certification.
  • Bachelors in Computer Science or Mathematics.
  • Experience with Microsoft Power BI.
  • Experience with Python.
  • Experience with R.
  • Experience with Machine Learning and/or Artificial Intelligence.


COMPETENCIES:
  • Adaptability & Flexibility.
  • Computer & Technology Operations.
  • Learning & Memory.
  • Mathematical & Statistical Skills.
  • Oral Communication & Comprehension.
  • Physical Abilities.
  • Planning & Organizing.
  • Problem Solving & Decision Making.
  • Professionalism & Integrity.
  • Researching & Referencing.
  • Reviewing, Inspecting & Auditing.
  • Self-Management & Initiative.
  • Teamwork & Interpersonal.
  • Technical & Job-Specific Knowledge.
  • Technical Skills.
  • Written Communication & Comprehension.


CRITICAL TECHNICAL KNOWLEDGE:
  • Knowledge of computer fundamentals and software, including database, spreadsheet, and word processing software.
  • Knowledge of computer operating systems such as UNIX and WINDOWS.
  • Knowledge of relational and/or hierarchical databases (e.g., MSSQL, Oracle, IMS, DMSII, etc.) and their operations.


WORK ENVIRONMENT:
Work is conducted almost exclusively indoors in an office setting. Work involves use of standard office equipment, such as computer, phone, copier, etc.

PHYSICAL DEMANDS:
Job is primarily sedentary involving sitting for long periods of time, but may involve occasional walking or standing for brief periods. May involve occasional light lifting of items or objects weighing up to 25 lbs.

DISCLAIMER: This job description is not meant to be an all-inclusive list of the job duties, responsibilities, or skills and abilities required to do the job and may be changed at the discretion of the Personnel Board at any time.

SPECIAL ACCOMMODATIONS

Persons requiring special conditions to accommodate a disability when completing the application should contact the Personnel Board at 205-279-3500 before the announcement closing date. Qualified applicants who believe they will need reasonable accommodation in the examination process should complete and submit an Accommodation Request Form. You may obtain an Accommodation Request Form by contacting our ADA Ombudsperson at ADAO@pbjcal.org, or by accessing the "Request for Accommodation" form through the following website: http://www.pbjcal.org/

AN EQUAL OPPORTUNITY EMPLOYER

The Personnel Board of Jefferson County (Personnel Board) provides a public personnel system based on merit principles. The Personnel Board strives for the constant improvement of the public service by employing and developing the best qualified persons available. The Personnel Board provides equal employment opportunities (EEO) to all employees and applicants for employment without regard to race, color, sex, creed, religion, political beliefs, national origin, age, disability, veteran status, sexual orientation, gender identity or expression, or genetics. This policy applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation and training. Employment decisions are made by the Merit System municipality or governmental agency in which the position exists. Each Merit System municipality, agency, or jurisdiction administers its own equal employment opportunity programs in compliance with applicable state and/or federal laws and regulations.

Remote-eligible (Remote work is a type of flexible working arrangement that allows an employee to work from remote location)

No

Job Address

Birmingham, Alabama United States View Map