What are the responsibilities and job description for the Data Warehouse Analyst (Business Data Analyst) position at Adroit Innovative Solutions Inc?
Job Title: Data Warehouse Analyst (Business Data Analyst)
Client: Florida Department of Corrections
Location: Tallahassee, FL (Onsite – 5 days/week)
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).
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
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