US Citizen
Green Card
EAD (OPT/CPT/GC/H4)
H1B Work Permit
Corp-Corp
W2-Permanent
W2-Contract
Contract to Hire
Consulting/Contract
UG :- - Not Required
PG :- - Not Required
No of position :- ( 1 )
Post :- 19th Feb 2024
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 Florida Housing 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.