Sign up to access all features of our service.
  • Job search
  • Favorites
  • Create a CV
    New
  • Salaries
  • Subscriptions

Database Analyst

3B Staffing LLC

Database Analyst

Overview for Database Analyst
The Contractor Personnel will be responsible for implementing the Florida PALM statewide accounting system at the Department under the direction of the Office of Information Technology (OIT) and the Office of Strategic Planning.



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.



Preferred Qualifications and Experience
A bachelor's degree from an accredited college or university in
management information systems or in one of the computer sciences
and three (3) years of experience in Database Administration, DBMS
design and support or relevant computing environments.
- The Database Analyst must have knowledge and
experience in the following areas related to database
languages and integration:
a. Database Management Systems (DBMS): Familiarity with popular DBMS platforms such as Oracle, Microsoft SQL Server, MySQL, or PostgreSQL. Understanding the concepts of data modeling, table structures, and
query optimization.
b. Structured Query Language (SQL): Proficiency in SQL, including writing complex queries, optimizing database performance, and manipulating data using
SQL statements. Understanding of joins, subqueries, and indexing.
c. Data Integration Tools and Techniques: Knowledge of data integration methods and tools, such as ETL (Extract, Transform, Load) processes, data migration
strategies, and data synchronization techniques. Familiarity with tools like Informatica, Talend, or SSIS (SQL Server Integration Services).
d. API Integration: Understanding of API (Application Programming Interface) concepts and experience with integrating systems using APIs. Knowledge of RESTful APIs, SOAP, or other web service protocols. Ability to work with API documentation and make API calls for data retrieval or data synchronization purposes.
e. Data Mapping and Transformation: Proficiency in data mapping techniques to align data structures and fields between different systems. Experience in data
transformation processes to convert data formats, standardize data, or cleanse data during integration.
f. Data Warehousing Concepts: Understanding of data warehousing principles and practices. Knowledge of dimensional modeling, ETL processes for data
warehouse loading, and data mart design. Familiarity with tools like Snowflake, Amazon Redshift, or Microsoft Azure Synapse Analytics.
g. Data Governance and Data Quality: Awareness of data governance principles, including data standards, data quality rules, and data lineage. Understanding the
importance of data integrity, data validation, and data cleansing techniques during integration.
h. Database Performance Optimization: Knowledge of techniques for optimizing database performance, including query optimization, indexing strategies, and
database tuning. Ability to identify and resolve performance bottlenecks in integrated systems.
i. Data Security and Privacy: Understanding of data security principles and best practices, including data encryption, access controls, and data privacy
regulations (e.g., GDPR, HIPAA). Knowledge of secure data handling during integration processes.
j. Data Analysis and Reporting: Proficiency in data analysis tools and techniques to extract insights from integrated datasets. Experience in creating reports,
dashboards, or visualizations to present integrated data to stakeholders.
Vacancy posted 4 days ago
Similar jobs that could be interesting for youBased on the Database Analyst in Tallahassee, FL vacancy
  •  ...Database Analyst Job Location: Tallahassee, FL (Hybrid Role) Job Duration: Long Term Contract Position Job Description: Two-plus years of progressive cloud database experience Proven experience with Microsoft SQL and Oracle databases Experience with... 
    Database
    Long term contract

    Samprasoft

    Tallahassee, FL
    2 days ago
  •  ...client, I will appreciate if you can have an eye on the below requirement and send me your consultant updated profile ASAP. Title: Database Analyst Location: Tallahassee FL Duration: Long Term Maintains the implemented Informatica Data Quality and Data Cleansing software... 
    Database
    Immediate start
    Worldwide

    USM

    Tallahassee, FL
    5 days ago
  •  ...supervision of the staff director and committee members, the legislative analyst applies this expertise when researching and preparing staff...  .... May operate a computer to perform word processing, database management, and/or spreadsheet applications. Performs other... 
    Database
    Interim role
    Internship

    Florida Legislature

    Tallahassee, FL
    3 days ago
  • Bachelor's degree in Computer Science, Information Systems, or a related field OR Four (4) years of equivalent work experience (education substitution allowed on a year-for-year basis) Strong experience in analyzing and documenting technical and business processes...
    Database
    Work experience placement

    Saxon Global

    Tallahassee, FL
    5 days ago
  •  ...visualization and reporting including ArcGIS Online, Tableau, or similar tools. Experience designing, modeling, developing and supporting Database Management Systems (DBMS). Experience writing SQL queries and writing data patches. Experience analyzing data requirements,... 
    Database
    Work experience placement
    Work at office

    Software Technology Inc

    Tallahassee, FL
    4 days ago
  •  ...not available for this position. Lyric is seeking a Clinical Analyst to support the development of clinical policies and payment...  ...inwritten policies· Enter clinical content into internal tooling and databases Provide clinical content support to customers in... 
    Database
    Full time
    Remote work
    Visa sponsorship

    Lyric

    Tallahassee, FL
    1 day ago
  •  ...migration requirements. Refactoring and/or migrating existing databases, as needed, to integrate seamlessly with the new financial system...  ...team, including developers, project managers, and business analysts, to define integration strategies and technical solutions. Develop... 
    Database
    Contract work
    Flexible hours

    Vista Application Solutions Group

    Tallahassee, FL
    3 days ago
  •  ...Excellent benefits package available. Job Description The ERP Analyst will assist with the development and maintenance of the Enterprise...  ...Resource Planning system(s). He/she will be responsible for database administration, data consolidation, data analysis, and management... 
    Database
    Immediate start

    Lilly & Associates International

    Tallahassee, FL
    5 days ago
  •  ...Business and Professional Regulation Working Title: GOVERNMENT ANALYST I - 79001149 Pay Plan: Career Service Position Number: 79001149...  ...in the E-Verify System which is a federal government electronic database available for employers to use to verify the identity and... 
    Database
    For contractors
    Work at office
    Local area

    State of Florida

    Tallahassee, FL
    2 days ago
  • $1,500 per month

     ...Legislative Analyst This is work functioning as a technical expert to the Office of the Minority Leader, legislators, and the public...  .... May operate a computer to perform word processing, database management, and/or spreadsheet applications. Performs other... 
    Database
    Full time
    Contract work
    Part time
    Interim role
    Internship
    Work at office
    Flexible hours

    Florida House of Representatives

    Tallahassee, FL
    1 day ago
  •  ...Business Analyst Location: Tallahassee Florida Responsibilities The Business Analyst will be responsible for the following:...  ...and general debugging. # Liaise with network administrators, database administrators, systems analysts, and business owners to assist... 
    Database

    Software Technology Inc

    Tallahassee, FL
    3 days ago
  •  ...Familiarity with the full Microsoft Office Suite, including Word, Outlook and Access Experience with data analysis, including maintaining databases, collecting data, filtering and cleaning data, identifying patterns, interpreting data and presenting findings Experience in the... 
    Database
    Work at office
    Flexible hours

    Bank of America Corporation

    Tallahassee, FL
    5 days ago
  •  ...operationalize governance tools and processes Mentor junior analysts and contribute to best practices within the data governance...  ...manufacturing ~ Advanced understanding of data structures, relational databases, data modeling, and analytical techniques ~ Proficiency in... 
    Database
    Remote work
    Flexible hours

    AFL

    Tallahassee, FL
    9 hours ago
  • HEICO is seeking a HRIS Analyst for a full -time direct hire position in Hollywood, FL. For more than 65 years, HEICO Corporation has...  ...and payroll processes. Exposure to reporting, data analysis, or database management. Experience with ticketing systems, application... 
    Database
    Full time
    Internship
    Work at office

    HEICO

    Tallahassee, FL
    4 days ago
  •  ...Government Analyst I This position handles invoice processing for the agency which includes but is not limited to office supplies,...  ...Management System (STMS), Bank of America PCard WORKS, Purchasing database, CTRS and FLAIR. Qualifications: Six (6) years of... 
    Database
    Work at office

    FDOT Northeast Florida

    Tallahassee, FL
    17 hours ago
  •  ...Global Marketing Data Analyst - Investment firm Turn data into decisions. Drive growth on a global scale.Global Marketing sits at the...  ...with Python or R is beneficial Experience working with relational databases and large datasets Proven ability to manage complexity and... 
    Database

    H Squared LLC

    Tallahassee, FL
    5 days ago
  •  ...Software Development, Software Consultancy and Information Technology Enabled Services. Job Description Good Understanding on No SQL Database Minimum 2 years of experience in Cassandra Data Modelling Minimum 2 years of Experience CQL (Cassandra Query Language) Experience... 
    Database

    Sonsoft Inc

    Tallahassee, FL
    3 days ago
  • $80k - $100k

     ...change in healthcare. Role Summary: The Customer Insights Analyst will transform customer and operational data into clear, actionable...  ...Sigma Computing. ~ Strong proficiency in SQL and relational database concepts; familiarity with cloud data warehouses, such as... 
    Database

    Datavant

    Tallahassee, FL
    4 days ago
  • $30 per hour

     ...industries. We remain the gold standard as the world’s first autonomous database and industry’s broadest and deepest suite of AI-powered cloud...  ...internal distribution of Employee Laptops. Customer Service analysts deliver service and support that represents the highest level... 
    Database
    Hourly pay
    Temporary work
    Work experience placement
    Internship
    Worldwide
    Flexible hours

    Oracle

    Tallahassee, FL
    3 days ago
  • Job Title Business Analyst Requirements Business analyst experience (5+ years); Salesforce experience (3+ years); Experience in Microsoft...  ...with state government projects; Experience working with databases and analyzing data to help formulate system or reporting requirements... 
    Database

    Rootshell Inc

    Tallahassee, FL
    3 days ago
  • Business Analyst Arete Technologies, Inc. offers set of innovative Consulting and Outsourcing services, bridging the gap between requirements...  ...with the Department's standards Knowledge of relational database theories and concepts Skill in testing complex applications and... 
    Database
    Local area
    Worldwide

    Arete Technologies Inc

    Tallahassee, FL
    3 days ago
  •  ...programs, claims activities, and risk mitigation strategies. You will review policies, advise on coverage, maintain insured-item databases, and support contract risk language to protect university interests. Responsibilities include providing training across the university... 
    Database
    Contract work

    Florida State University

    Tallahassee, FL
    5 days ago
  • Title: Enterprise Data Warehouse Analyst Location: Tallahassee, FL Job Description: Key Responsibilities Support cloud-based data integration...  ...of accurate, consistent, and governed data across relational databases and mainframe flat files. Collaborate with business... 
    Database
    Work experience placement
    Casual work
    Remote work
    Monday to Friday

    Apex Informatics

    Tallahassee, FL
    3 days ago
  •  ...and governed data across diverse platforms such as relational databases and mainframe flat files. They will collaborate with business...  ...integration workflows. This includes working closely with business analysts and stakeholders in analyzing existing logic, reports, and... 
    Database
    Work experience placement

    Apex Informatics

    Tallahassee, FL
    3 days ago
  • Data Administration Analyst DEP's Office of Technology and Information Services (OTIS) is currently recruiting for a Data Administration...  ...techniques and best practices. Knowledge of relational database design and data modeling. Comfortable with speaking/presenting... 
    Database
    Work experience placement
    Work at office

    Environmental Protection Services

    Tallahassee, FL
    3 days ago
  • Business Analyst Job Location: Tallahassee, FL Job Duration: Contract through June + annual extension Job Overview: The Business Analysts...  ...project management software (e.g., JIRA Software, Trello), and databases and Enterprise Resource Planning (ERP) systems. Familiarity... 
    Database
    Contract work
    Work at office

    Software Technology Inc

    Tallahassee, FL
    3 days ago
  • Brown & Brown is seeking a Senior Marketing Analyst to join our growing team in Maitland, FL! The Senior Marketing Analyst role isresponsible...  ...proposals for discussion and presentation. Maintain internal database information, prepare related reports as requested, and maintain... 
    Database
    Work at office

    Brown & Brown

    Tallahassee, FL
    2 days ago
  • Senior Data Base Analyst This is an exciting opportunity to help shape the quality of health care in Florida. We are seeking to hire Senior...  ...with Excel. Experience with Access, SQL, SAS, or other Database programs. Experience working with large data sets. Preferably,... 
    Database
    Work at office
    Flexible hours

    Agency for Health Care Administration

    Tallahassee, FL
    3 days ago
  • $50k

     ...maintaining financial aid reporting and analysis. Serves as data management analyst and leverages financial aid data with other key institutional data. Designs, develops, and maintains financial aid databases and reports for state, federal, and institutional reports such as... 
    Database
    Work at office

    Florida State University

    Tallahassee, FL
    2 days ago
  •  ..., Microsoft Visio, SharePoint, the Microsoft 365 Office Suite, and familiar with business analyst software tools. Skilled with writing queries for a Microsoft SQL Server database. Proven communication skills, both orally and in writing, with technical and non-technical... 
    Database
    Work experience placement
    Work at office
    Local area

    Software Technology Inc

    Tallahassee, FL
    3 days ago

Do you want to receive more vacancies?

Subscribe and receive similar vacancies to Database Analyst. Be the first to apply!