Data Warehouse Analyst (Business Data Analyst)

About

Client: Florida Department of Corrections

Note: Only candidates already in Florida (preferably within 1 hour of Tallahassee). No relocation, Profiles of non-local candidates will not be accepted.

Job Details

• Openings: 2
• Duration: 12+ months (possible extension).

Why Join?

• Work on large-scale data warehouse projects
• Contribute to critical government systems
• Long-term, stable public sector opportunity
• Collaborate with business and technical teams

Required Experience

• 5+ years in IT
• 3+ years in:
  • Data Warehouse / Business Intelligence
  • Data Modeling, Mapping, Integration (ETL/RDBMS)
  • Requirements Gathering & Business Analysis

Key Responsibilities

1. Requirements & Business Analysis

   • Gather business requirements from stakeholders
   • Convert requirements into technical specifications

2. Data Warehouse Development

   • Design and develop data warehouse solutions
   • Perform data mining and analysis
   • Support database architecture and metadata

3. Data Quality & Validation

   • Validate and clean data
   • Ensure accuracy, consistency, and completeness

4. Reporting & User Support

   • Work with users on reporting needs
   • Provide guidance on data usage and best practices

5. Testing & Prototyping

   • Build prototypes
   • Create test cases and perform testing
   • Evaluate solutions and fix gaps

6. ETL & Data Integration

   • Manage ETL processes (Extract, Transform, Load)
   • Maintain data models and data flows

7. Technical Support

   • Work with data tools, scripts, and systems
   • Support multiple platforms and environments

8. Process Improvement

   • Improve data warehouse processes
   • Follow best practices in data modeling and documentation

Qualifications

• Bachelor’s degree in Computer Science / IT (or equivalent experience)
• 3+ years of relevant experience
• Strong skills in:
  • Data modeling & data mapping
  • Business process analysis
  • Identifying inefficiencies
• Experience with Microsoft Visio