Database Analyst

$83,200 - $104,000/Yr

DP Professionals - Tallahassee, FL

Full-time - Mid Level

Tallahassee, FL

Administrative and Support Services

About the position

Seeking a Database Analyst for an opportunity in Tallahassee, FL. This position involves data processing technical work, including planning, designing, and enhancing a statewide, wide area, or comparable distributed computer systems network for use by end-users. This encompasses the hardware, software, and communications components of distributed systems. The role requires designing, coding, testing, and documenting applications software to ensure effective data management and integration across various platforms. The Database Analyst will be responsible for designing, modeling, developing, and supporting database management systems. This includes analyzing data requirements, application and processing architectures, data dictionaries, and database schemas. The analyst will gather, analyze, and normalize relevant information related to business processes to evaluate data credibility and determine relevance and meaning. Additionally, the role involves developing database and warehousing designs across multiple platforms and computing environments, ensuring that the overall data architecture supports the information needs of the business in a flexible yet secure environment. The analyst will conduct comprehensive data analysis to understand the structure, content, and relationships of the existing FLAIR system and the various departmental systems that interact with it. They will gather requirements from stakeholders to identify specific integration needs and desired functionality for the PALM system, collaborating with project teams to define integration strategies and technical solutions. The role also includes developing data migration plans to ensure a seamless transition from FLAIR to Florida PALM, integrating departmental systems with the Florida PALM system and other relevant systems and data warehouses. The Database Analyst will write data reports and create documentation to capture system configurations, integration processes, and data mapping. They will conduct thorough testing to ensure the accuracy, reliability, and performance of the integrated system, providing technical support and troubleshooting during the onboarding and integration process. The analyst will also assess future information requirements to develop long-range comprehensive database plans and establish database policies and procedures, ensuring data integrity and control redundancy.

Responsibilities

• Designs, models, develops, and supports database management systems.
• Analyzes data requirements, application and processing architectures, data dictionaries, and database schema(s).
• Gathers, analyzes, and normalizes relevant information related to business processes to evaluate data credibility.
• Develops database and warehousing designs across multiple platforms and computing environments.
• Conducts comprehensive data analysis to understand the structure, content, and relationships of the existing FLAIR system.
• Gathers requirements from stakeholders to identify integration needs for the PALM system.
• Collaborates with project teams to define integration strategies and technical solutions.
• Develops data migration plans to ensure a seamless transition from FLAIR to Florida PALM.
• Integrates departmental systems with the Florida PALM system and other relevant systems.
• Writes data reports and creates documentation for system configurations and integration processes.
• Conducts thorough testing to ensure accuracy, reliability, and performance of the integrated system.
• Provides technical support and troubleshooting during the onboarding and integration process.
• Assesses future information requirements to develop long-range comprehensive database plans.
• Establishes database policies and procedures and evaluates user requests for new data elements.
• Coordinates the use of the organization's data to ensure data integrity and control redundancy.

Requirements

• A Bachelor's degree from an accredited college or university in management information systems or in one of the computer sciences.
• Three (3) years of experience in Database Administration, DBMS design and support, or relevant computing environments.
• Advanced understanding of SQL for data analysis and manipulation.
• Advanced knowledge of API integration and data warehouse concepts.
• Experience with application refactoring and modernization projects.
• Strong problem-solving skills and attention to detail.

Nice-to-haves

• Familiarity with popular DBMS platforms such as Oracle, Microsoft SQL Server, MySQL, or PostgreSQL.
• Proficiency in SQL, including writing complex queries and optimizing database performance.
• Knowledge of data integration methods and tools, such as ETL processes and data synchronization techniques.
• Understanding of API concepts and experience with integrating systems using APIs.
• Knowledge of data warehousing principles and practices.

Benefits

• Contract position with a pay range of $40.00 - $50.00 per hour.
• Expected hours: 40 per week.
• In-person work location.