Database Analyst

Database Analyst Tech Army - 5.0 Tallahassee, FL Job Details Full-time | Contract 1 day ago Qualifications Data model design Data replication Data Integration (Data management) Operating systems Data mining Computer Science Requirements specification Data modeling projects Process optimization Process improvement Visio Information Systems Mid-level Quality assurance within IT Functional testing Database design Process mapping Data Architecture Design (Architecture design skills) Bachelor's degree Data quality monitoring Requirements analysis Prototype creation Scripting Data analytics Scalability Data validation Metadata Workshop facilitation 4 years Bachelor's degree in computer science Leadership Prototypes Communication skills Metadata management Business process modeling Full Job Description

INTERVIEW

= Onsite / Virtual

JOB TYPE

= Onsite Scope of Work/Job Characteristics The Database Analysts collect and translate business information needs into technical specifications and support the design, development, and optimization of data warehouse structures. The role ensures data accuracy through validation and quality checks, conducts data mining and analysis to support decision-making, and collaborates with users to clarify reporting requirements and proper data use. The analyst develops prototypes, performs testing, and evaluates proposed solutions to ensure alignment with business objectives. Additionally, the position manages Extract, Transform, Load (ETL) processes, maintains data models, supports technical tools and warehouse environments, and continually improves data-related processes by applying best practices in data modeling, metadata management, and documentation.

Business Information Analysis and Requirements Gathering:

" Engage with business stakeholders to identify, understand, and document information needs; and " Translate business requirements into clear, detailed technical specifications that align with data warehouse architecture and reporting objectives.

Data Warehouse Development and Data Mining:

" Design, develop, and enhance data warehouse structures, including data models, metadata, and repository frameworks; and " Perform data mining, analysis, and evaluation to support decision-making and optimize data utilization.

Data Validation and Quality Assurance:

" Review and validate data loaded into the warehouse to ensure accuracy, consistency, and completeness; and " Conduct routine data quality checks, identify discrepancies, and perform data cleansing and refinement activities.

User Interaction and Reporting Support:

" Partner with business users to understand reporting needs and deliver technical guidance; and " Provide consulting on proper data usage, highlight potential data conflicts, and promote best practices for accessing and interpreting warehouse data.

Prototyping, Testing, and Solution Evaluation:

" Develop prototypes to validate data design and reporting concepts; " Create and execute test scripts, conduct functional and system-level testing, and evaluate proposed solutions for alignment with business requirements; and " Identify solution gaps and coordinate remediation.

Data Integration and ETL Management:

" Support and maintain ETL workflows, including data extraction, transformation, loading, and replication; " Ensure data processes are efficient, scalable, and fully documented; and " Maintain enterprise data models supporting warehouse and data mart environments.

Technical Tooling and Environment Support:

" Apply strong working knowledge of relevant software tools, scripting languages, and system environments used within the warehouse ecosystem; and " Support data warehouse operations across multiple operating systems and platforms.

Process Improvement and Best Practices Implementation:

" Continuously evaluate and optimize data warehouse processes, recommending improvements where appropriate; and " Apply industry best practices in data modeling, metadata management, documentation, and data warehouse operations to strengthen organizational data capabilities. Requirements/Qualifications The Department is seeking two (2) full-time, on-site Database Analysts throughout the PO term of this RFQ. The positions required and preferred qualifications are described in Sections 4.1 and 4.2 and must be verifiable in the Candidates' resume.

NOTE:

Any successful Candidate with access to the Department's network is required to complete the Department's Security Awareness Training within 30 calendar days of hire. 4.1. Required Qualifications A bachelor's degree from an accredited college or university in Computer Science, Information Systems, or other related field, or four (4) years of equivalent work experience is required. Relevant experience may be substituted for education on a year-for-year basis when applicable. The Department requires the following experience, skills, and knowledge for this position: " Strong skills in analyzing and documenting technical processes, mapping out business processes, identifying bottlenecks, and analyzing inefficiencies; " Experience in Data Analysis and Management; " Experience in data mapping, modeling, and integration across systems; " Demonstrated experience and proficiency with Microsoft Visio; and " Excellent verbal and written communication abilities, along with strong interpersonal skills.

NOTE:

In addition to the above list, the selected Candidates must successfully complete a Level II Background Check. 4 RFQ-26-114 4.2. Preferred Qualifications The Department prefers the Candidates to have the following experience, skills, and/or knowledge for this position: " Familiarity with business process mapping and defining current state applications in requirements documentation; " Experience facilitating sessions with business leadership, Subject Matter Experts (SMEs), and users within a business function; and " Skilled in understanding web applications and common application approaches to support business capabilities.