What are the responsibilities and job description for the Data Analyst position at City of Tuscaloosa?
The purpose of this classification is to perform technical and analytical work functions associated with identifying, capturing, analyzing, and interpreting enterprise data across all city departments that contribute to better data-driven systems for decision-making, open government operations, cost reduction measures, quality of service improvements, and greater digitization, automation and planning. Employees in this classification serve as a resource to departments in the planning, development, and control of data systems, data analysis, and statistical and data reporting.The following duties are normal for this classification. The omission of specific duties does not exclude them from the classification if the work is similar, related, or a logical assignment for this classification. Other duties may be required and assigned. Specific duties listed may not be required for all positions within this classification, but are determined by the normal requirements for the particular position.
Develops and implements custom data capturing and analyzing programs; performs statistical analysis to include designing and producing numerical and descriptive information and reports for program reviews, departmental operations assessments, and activity efficiency and effectiveness.
Provides customer service and expert guidance to educate and advise city personnel on issues related but not limited to data creation, collection, and maintenance and formulation of data resources and systems.
Prepares analytical reports, summaries, and policy analyses as requested.
Independently creates, analyzes, modifies, and maintains data systems; monitors and assures quality of data; audits data systems and works with departments to correct errors and future problems.
Works closely with departments to gather requirements for key performance indicators and identify corresponding data sets and calculations needed.
Provides and fulfills requests for ad-hoc reports and analysis; performs data mining and analysis in order to extract and identify key trends and insights.
Reviews and validates data for accuracy; conducts research for data and reporting issues as required; performs cleansing of data to ensure sources are accurate for analysis and reporting.
Identifies opportunities to increase data quality to include automation and data entry procedural training.
Extracts and manages multiple sets of data from various databases and sources to bring together data from several areas for comparative analysis and reporting.
Designs reporting dashboards to translate data to an understandable illustrative format.
Documents all data management procedures and specifications; prepares and distributes correspondence, memoranda, and reports.
Trains as necessary on analytics platforms to enable self-service reporting by departments; serves as a subject matter expert and administrator for business intelligence tools.
Answers the telephone; provides information, guidance and assistance; takes and relays messages and/or directs calls to appropriate personnel; responds to questions, problems, and requests for information/assistance from employees, officials or other persons.
Communicates with supervisor, co-workers, users, departments, vendors, and outside agencies to discuss work in progress, exchange information, resolve problems, provide operational support, and project management.
Understands the functions, procedures, and workflow of city departments as they relate to the collection and analyzing of data.
Maintains knowledge of operating systems and platforms and software programs to operate a computer in an efficient and effective manner.
Maintains an awareness of new products, trends, and advances in the profession; reads professional literature; attends workshops, conferences, and training sessions.
Must possess and maintain strong analytical, mathematical, and critical thinking skills with attention to detail and organization.
Must possess and maintain a foundational understanding of statistical analysis and reporting.
Must possess and maintain working knowledge of Extraction, Translate & Load (ETL) Tools and experience using such tools to manipulate data sets.
Must have experience with relational databases and a working knowledge of Structured Query Language (SQL) to query and manipulate data.
Must have demonstrated abilities to understand and address client data requests and to use reporting tools to provide desired information.
Must have experience with scripting tools such as Visual Basic/VBScript, Python, JavaScript, Perl, PHP.
Must have experience with search and analysis tools such as ElasticSearch, Kibana, Logstash, ELK Stack, Google Analytics, etc.
Must have experience utilizing Application Programming Interfaces (API's).
Must have the ability to understand and utilize geospatial data.
Must possess and maintain knowledge of business intelligence and data visualization tools and quality control, analytic and reporting software systems.
Recommends policies and procedures that guide and support the provision of quality services by the department.
Incorporates continuous quality improvement principles in day to day activities.
Must accomplish the essential functions of the job, with or without reasonable accommodations, in a timely manner.
Must meet regular attendance requirements.
Must be able to maintain good interpersonal relationships with staff, co-workers, managers and citizens.
Performs other related duties as required.Bachelor's degree in Statistics, Mathematics, Computer Science, Management Information Systems, or related field required; two years of experience in business intelligence, statistical operations and analysis, database management, data analysis, data system design, or related field; or any equivalent combination of education, training, and experience which provides the requisite knowledge, skills, and abilities for this job. Must possess and maintain a valid driver's license.The following requirements are normal for this classification. Specific requirements may not apply to all positions within this classification, but are determined by the normal requirements for the particular position.
PHYSICAL REQUIREMENTS: Must be able to operate a variety of equipment, machinery and tools which may include a personal computer, terminal, terminal server, printer, tape/disk drives, uninterruptable power source, optical disk reader, scanner, modem, copy machine, facsimile machine, calculator, telephone, data scope, volt ohmmeter, crimper, wire cutter, etc. Physical demand requirements are at levels of those for light work.
DATA COMPREHENSION: Requires the ability to compare and/or judge the readily observable functional, structural, or compositional characteristics (whether similar to or divergent from obvious standards) of data, people, or things which may include forms, reports, logs, catalogs, flow charts, technical manuals, operational manuals, policy manuals, procedural manuals, and reference materials.
INTERPERSONAL COMMUNICATION: Requires the ability to speak with and/or signal people to convey or exchange technical information, including giving/receiving assignments and/or directions to/from co-workers, assistants, managers, or supervisors as well as communicating with elected officials and the general public.
LANGUAGE ABILITY: Requires ability to read a variety of technical documentation, directions, instructions, and methods and procedures. Requires the ability to write job related documentation and reports with proper format, punctuation, spelling and grammar, using all parts of speech. Requires the ability to speak with and before others with poise, voice control, and confidence using correct English and well-modulated voice such as in public speaking situations.
INTELLIGENCE: Requires the ability to learn and understand complex computer programming/operation principles and techniques, to understand departmental policies and procedures, to make independent judgments in absence of supervision, and to acquire and be able to expound on knowledge of topics related to primary occupation.
VERBAL APTITUDE: Requires the ability to record and deliver information, such as in a public speaking situation, to explain procedures, and to follow verbal and written instructions.
NUMERICAL APTITUDE: Requires the ability to add and subtract, multiply and divide, calculate decimals and percentages, determine time and weight, perform college level algebra, perform high school level trigonometry, perform statistical calculations, and perform Boolean algebra.
FORM/SPATIAL APTITUDE: Requires the ability to visually inspect items for proper length, width, and shape using job related equipment.
MOTOR COORDINATION: Requires the ability to coordinate hands and eyes in using job related equipment.
MANUAL DEXTERITY: Requires the ability to handle a variety of items, computer equipment, control knobs, switches, etc. Must have the ability to use one hand for twisting motion or turning motion while coordinating other hand with different activities. Must have minimal levels of eye/hand/foot coordination.
COLOR DIFFERENTIATION: May require the ability to discern color.
INTERPERSONAL TEMPERAMENT: Requires the ability to deal with and relate to people beyond giving and receiving instructions. Must be able to adapt to and perform under considerable stress when confronted with an emergency.
PHYSICAL COMMUNICATION: Requires the ability to talk, express, or exchange ideas by means of spoken words and/or hear and perceive nature of sounds by ear.
Develops and implements custom data capturing and analyzing programs; performs statistical analysis to include designing and producing numerical and descriptive information and reports for program reviews, departmental operations assessments, and activity efficiency and effectiveness.
Provides customer service and expert guidance to educate and advise city personnel on issues related but not limited to data creation, collection, and maintenance and formulation of data resources and systems.
Prepares analytical reports, summaries, and policy analyses as requested.
Independently creates, analyzes, modifies, and maintains data systems; monitors and assures quality of data; audits data systems and works with departments to correct errors and future problems.
Works closely with departments to gather requirements for key performance indicators and identify corresponding data sets and calculations needed.
Provides and fulfills requests for ad-hoc reports and analysis; performs data mining and analysis in order to extract and identify key trends and insights.
Reviews and validates data for accuracy; conducts research for data and reporting issues as required; performs cleansing of data to ensure sources are accurate for analysis and reporting.
Identifies opportunities to increase data quality to include automation and data entry procedural training.
Extracts and manages multiple sets of data from various databases and sources to bring together data from several areas for comparative analysis and reporting.
Designs reporting dashboards to translate data to an understandable illustrative format.
Documents all data management procedures and specifications; prepares and distributes correspondence, memoranda, and reports.
Trains as necessary on analytics platforms to enable self-service reporting by departments; serves as a subject matter expert and administrator for business intelligence tools.
Answers the telephone; provides information, guidance and assistance; takes and relays messages and/or directs calls to appropriate personnel; responds to questions, problems, and requests for information/assistance from employees, officials or other persons.
Communicates with supervisor, co-workers, users, departments, vendors, and outside agencies to discuss work in progress, exchange information, resolve problems, provide operational support, and project management.
Understands the functions, procedures, and workflow of city departments as they relate to the collection and analyzing of data.
Maintains knowledge of operating systems and platforms and software programs to operate a computer in an efficient and effective manner.
Maintains an awareness of new products, trends, and advances in the profession; reads professional literature; attends workshops, conferences, and training sessions.
Must possess and maintain strong analytical, mathematical, and critical thinking skills with attention to detail and organization.
Must possess and maintain a foundational understanding of statistical analysis and reporting.
Must possess and maintain working knowledge of Extraction, Translate & Load (ETL) Tools and experience using such tools to manipulate data sets.
Must have experience with relational databases and a working knowledge of Structured Query Language (SQL) to query and manipulate data.
Must have demonstrated abilities to understand and address client data requests and to use reporting tools to provide desired information.
Must have experience with scripting tools such as Visual Basic/VBScript, Python, JavaScript, Perl, PHP.
Must have experience with search and analysis tools such as ElasticSearch, Kibana, Logstash, ELK Stack, Google Analytics, etc.
Must have experience utilizing Application Programming Interfaces (API's).
Must have the ability to understand and utilize geospatial data.
Must possess and maintain knowledge of business intelligence and data visualization tools and quality control, analytic and reporting software systems.
Recommends policies and procedures that guide and support the provision of quality services by the department.
Incorporates continuous quality improvement principles in day to day activities.
Must accomplish the essential functions of the job, with or without reasonable accommodations, in a timely manner.
Must meet regular attendance requirements.
Must be able to maintain good interpersonal relationships with staff, co-workers, managers and citizens.
Performs other related duties as required.Bachelor's degree in Statistics, Mathematics, Computer Science, Management Information Systems, or related field required; two years of experience in business intelligence, statistical operations and analysis, database management, data analysis, data system design, or related field; or any equivalent combination of education, training, and experience which provides the requisite knowledge, skills, and abilities for this job. Must possess and maintain a valid driver's license.The following requirements are normal for this classification. Specific requirements may not apply to all positions within this classification, but are determined by the normal requirements for the particular position.
PHYSICAL REQUIREMENTS: Must be able to operate a variety of equipment, machinery and tools which may include a personal computer, terminal, terminal server, printer, tape/disk drives, uninterruptable power source, optical disk reader, scanner, modem, copy machine, facsimile machine, calculator, telephone, data scope, volt ohmmeter, crimper, wire cutter, etc. Physical demand requirements are at levels of those for light work.
DATA COMPREHENSION: Requires the ability to compare and/or judge the readily observable functional, structural, or compositional characteristics (whether similar to or divergent from obvious standards) of data, people, or things which may include forms, reports, logs, catalogs, flow charts, technical manuals, operational manuals, policy manuals, procedural manuals, and reference materials.
INTERPERSONAL COMMUNICATION: Requires the ability to speak with and/or signal people to convey or exchange technical information, including giving/receiving assignments and/or directions to/from co-workers, assistants, managers, or supervisors as well as communicating with elected officials and the general public.
LANGUAGE ABILITY: Requires ability to read a variety of technical documentation, directions, instructions, and methods and procedures. Requires the ability to write job related documentation and reports with proper format, punctuation, spelling and grammar, using all parts of speech. Requires the ability to speak with and before others with poise, voice control, and confidence using correct English and well-modulated voice such as in public speaking situations.
INTELLIGENCE: Requires the ability to learn and understand complex computer programming/operation principles and techniques, to understand departmental policies and procedures, to make independent judgments in absence of supervision, and to acquire and be able to expound on knowledge of topics related to primary occupation.
VERBAL APTITUDE: Requires the ability to record and deliver information, such as in a public speaking situation, to explain procedures, and to follow verbal and written instructions.
NUMERICAL APTITUDE: Requires the ability to add and subtract, multiply and divide, calculate decimals and percentages, determine time and weight, perform college level algebra, perform high school level trigonometry, perform statistical calculations, and perform Boolean algebra.
FORM/SPATIAL APTITUDE: Requires the ability to visually inspect items for proper length, width, and shape using job related equipment.
MOTOR COORDINATION: Requires the ability to coordinate hands and eyes in using job related equipment.
MANUAL DEXTERITY: Requires the ability to handle a variety of items, computer equipment, control knobs, switches, etc. Must have the ability to use one hand for twisting motion or turning motion while coordinating other hand with different activities. Must have minimal levels of eye/hand/foot coordination.
COLOR DIFFERENTIATION: May require the ability to discern color.
INTERPERSONAL TEMPERAMENT: Requires the ability to deal with and relate to people beyond giving and receiving instructions. Must be able to adapt to and perform under considerable stress when confronted with an emergency.
PHYSICAL COMMUNICATION: Requires the ability to talk, express, or exchange ideas by means of spoken words and/or hear and perceive nature of sounds by ear.
Salary : $74,305
Data Entry Work
Only Data Entry Clerk -
Tuscaloosa, AL
Data Clerks
Entegee -
Vance, AL
Data entry
EA Solutions -
Tuscaloosa, AL
