Position Title: Database Analyst
Location: Tallahassee FL-(Onsite)
Position Status: Contract
Position Description:
Description of services associated with this project include, but are not limited to, the following:
- Implementing the Florida PALM statewide accounting system for the
Department.
- Conducting a comprehensive assessment of the organization's existing
systems and how they interact with FLAIR.
- Collaborating with stakeholders to identify and document functional and
technical requirements for the new enterprise financial system.
- Performing data analysis to identify data migration requirements.
- Ensuring data integrity.
- Refactoring and/or migrating existing databases, as needed, to integrate
seamlessly with the new financial system.
- Designing and implementing API integrations to facilitate data exchange
between the new financial system and other systems, which may include the
development of data warehouses.
- Configuring and customizing existing systems to meet the organization's
specific needs and requirements.
- Developing data reports and analytical dashboards.
- Developing and delivering training programs for end-users to ensure a smooth transition to the new financial system.
- Conducting comprehensive testing and quality assurance activities to ensure system functionality and data accuracy.
- Providing post-implementation support and troubleshooting to address any issues or concerns that may arise.
- Performing other duties as required.
Database Analyst Job Description
This is data processing technical work: 1) planning, designing, and
enhancing a statewide, wide area, or comparable distributed computer
systems network for use by end-users including the hardware, software,
and communications components of distributed systems; and 2) designing,
coding, testing, and documenting applications software.
Key Areas of Responsibility
- Designs, models, develops, and supports database management systems.
- Analyzes data requirements, application and processing architectures, data dictionaries, and database schema(s), and then designs, develops, amends, optimizes, and certifies database schema design to meet system(s) requirements.
- Gathers, analyzes, and normalizes relevant information related to, and from business processes, functions, and operations to evaluate data credibility and determine relevance and meaning.
- Develops database and warehousing designs across multiple platforms and computing environments.
- Develops an overall data architecture that supports the information needs of the business in a flexible but secure environment.
- Conducts comprehensive data analysis to understand the structure, content, and relationships of the existing FLAIR system and the various departmental systems that interact with it.
- Gathers requirements from stakeholders to identify the specific integration needs and desired functionality for the PALM system.
- Collaborates with the project team, including developers, project managers, and business analysts, to define integration strategies and technical solutions.
- Develop data migration plans and strategies to ensure a seamless transition from FLAIR to Florida PALM.
- Integrates departmental systems with the Florida PALM system and other relevant systems and data warehouses.
- Writes data reports and creates documentation to capture system configurations, integration processes, and data mapping.
- Conducts thorough testing to ensure the accuracy, reliability, and performance of the integrated system.
- Provides technical support and troubleshooting during the onboarding and integration process.
- Collaborates with cross-functional teams to address any issues or challenges encountered during the integration process.
- Assesses future information requirements to develop long range comprehensive database plans.
- Establishes database policies and procedures.
- Evaluates user's request for new data elements and systems and incorporate into the existing shared data environment.
- Coordinates use of the organization's data to ensure data integrity and control redundancy.
- Develops database feasibility studies and cost/benefit analyses.
- Establishes database design techniques using data modeling and prototyping software.
- Analyzes and proposes changes to database structures.
- Maintains data dictionary ensuring uniformity of definitions and setting standards for use of data dictionary.
- Determines necessary database security.
- Assists in selection of database management software.
- Educates management in the need for long-range data planning and management of the data resource.
- Develops and controls the procedures necessary to save,
retrieve, and recover databases for hardware and/or software failure.
- Coordinates reorganizations with the applications and systems staff.
- Acts as consultant to both the applications and systems programming staff on all aspects of database and/or on-line management software standards.
- Performs related work as required.
About Seneca Resources:
Seneca Resources is a client driven provider of strategic Information Technology consulting services and Workforce Solutions to government and industry. Seneca Resources is a leading IT services provider with offices in Virginia, Alabama, Georgia, Florida and Texas that service clients throughout the United States.
We are an Equal Opportunity Employer and value the benefits of diversity in our workplace.