Data Warehouse Analyst

If you have the appropriate skills and experience, you could be making more money as a consultant working with us serving Florida Government Agencies!

We have the following position available:

Job Title: Data Warehouse Analyst

Job Compensation: $100 per hour

Job Type: 1099

Job Location: Tallahassee, FL

Application Deadline: 02-25

___

Job Duties and Tasks

The assigned Data Warehouse Analyst will be responsible for the following tasks:

1. Maintenance, upkeep, and redevelopment of an existing MS-SQL-based Data Warehouse, associated infrastructure, and processes.

2. Document current infrastructure and processes.

3. Analysis and strategic planning for data infrastructure services.

4. Design the next iteration of data infrastructure.

5. Develop BI Capabilities:

a. Provide Dashboards, Scorecards, and Interactive Analytical reports.

b. Train staff on all pertinent BI data structures and BI production

6. Design and implement Data Warehouse Architecture and Data Flow:

a. Ingest Incremental Data into ODS from Source Systems.

b. Apply Data Quality Assurance and business rules to transform the data.

c. Store the transformed data in a Normalized Data Warehouse.

d. From the Normalized Data Warehouse, build a Data Warehouse for Analytics.

e. Build Data Marts per the business Analytics need.

7. BI and data delivery layers – present different tools and methods to serve Analytics and reporting needs.

8. Project Management

a. Set up DevOps for version control and Project Management.

b. Fully incorporate the enterprise data management strategy into the solution.

c. Thoroughly document Data Warehouse architecture to convey the objectives effectively.

9. Data discovery

a. Identify data sources from business and responsible subject matter experts (SMEs).

b. Analyze, develop, and document business process knowledge.

c. Identify data quality issues at the source and challenges to resolving these issues.

d. Identify and understand the relationship between different source systems.

e. Implement Dataedo software:

i. develop ERDs

ii. work with SMEs to implement the Dataedo Data Dictionary

10. Reporting

a. Critical reports and data required by the enterprise.

b. Order of priority to help set the priority of deliverables.

c. Current inventory of reports to identify what is currently in use.

11. Development

a. Build Enterprise Data Warehouse.

b. Data Warehouse Environment Build.

c. Identify the Subject Area and data sources to start developing processes to build the Data Warehouse

d. Revise applicable data processes per discovery

12. Other duties and responsibilities as assigned.

___

Department has a strong preference to procure an Analyst local to the Tallahassee, Florida area.

The assigned Data Warehouse Analyst may work remotely, but must be reasonably available for meetings, phone calls, answering e-mails, etc., during these business hours.

#RFQuote 2024-03

Job Types: Full-time, Contract

Pay: $100.00 per hour

Schedule:

• Monday to Friday

Ability to Commute:

• Tallahassee, FL 32399 (Preferred)

Work Location: In person