Data Warehouse Analyst (OnSite)

QUALIFICATIONS AND EXPERIENCE:Twelve years of experience in data modelling, data mining, database standardization, deduplication and performance tuning.Twelve years of experience developing Online Analytical Processing (OLAP) cubes using SQL Server Analysis Services.Twelve years of experience developing SQL Server Integration Services packages performing Extraction, Transformation and Loading activities.Twelve years of experience with dashboard and scorecard development.Twelve years of experience with the development of reports using MS SQL Server Reporting Services (MS SSRS) and maintenance of enterprise reports using MS SSRS.Twelve years of experience with business intelligence tools and systems, such as SSRS.Twelve years of experience with MS SQL product inclusive of MS SQL 2016.Twelve years of experience with SQL programming inclusive of stored procedures, functions, triggers, scheduled jobs, and linked servers.Fifteen years of experience with SQL relational databases, Online Transaction Processing (OLTP) and Decision Support System (DSS) serving in high performance, service-oriented, multi-tiered environments.Twelve years of experience with Source Control systems such as Visual Studio Team Services or Team Foundation Server.Fifteen years of experience with software build and release management methodologies.Five years of experience with Project Management with a Project Management Certification (PMP).Four years of experience in a healthcare IT domain.Three years of experience with HIV/AIDS Patient Care Applications such as AIDS Information Management System (AIMS), AIDS Drug Assistant Program (ADAP) and Department Health Management System (HMS).RESPONSIBILITIES:Monitor and optimize the performance of existing Data Exchange Interfaces, including SQL Server Integration Services (SSIS) or any other HIV/AIDS data systems daily as directed by the Department.Develop and submit new Data Exchange Interfaces utilizing SSIS, File Mover, or other available tools daily as directed by the Department.Document and submit modifications and additions to integration processes, system technical objects and system processes and store in a documentation repository daily as directed by the Department.Develop and submit database objects in Transact-SQL (T-SQL) in support of programming changes daily as directed by the Department.Develop and submit Ad-hoc reports and queries on MSSQL databases daily as directed by the Department.Process release tickets to manage user requirements and defect tickets to correct system errors within the timeframe directed by the specific ticket request.Facilitate collecting system requirements with the Department’s Division of Disease Control and Health Protection (DCHP) staff daily as directed by the Department.Deliver code to perform system functions as defined in use requirements daily as assigned by the Department.Perform testing on system changes to meet user-defined requirements daily as assigned by the Department.Facilitate user acceptance testing (UAT) with the DCHP staff daily as assigned by the Department.Produce and submit work estimates to implement user-defined requirements and system changes daily as directed by the Department.Produce and submit status reports on the implementation of user-defined requirements daily as directed by the Department.Coordinate with the Department’s Information Technology staff to ensure processes are followed and in compliance with Department standards daily as directed by the Department.Correspond (verbally and in written formats) with project teams, internal stakeholders regarding project activities deliverables, and status daily as directed by the Department.Collaborate with the DCHP information technology teams; design, develop, and code based on business requirements for the DCHP Master Person Index project as part of the overall strategic effort for integration and interoperability of its systems and software daily as directed by the Department.Work with DCHP resources to standardize collection and storage of DCHP shared data daily as directed by the Department.Assist with COVID-19 related activities. Contractor will be available to provide support off hours, holidays, and weekends as needed by the Department.Must comply at all times with all Department data security procedures and policies.Job Types:

Full-time, ContractPay:

$120,000.00 - $160,000.00 per yearSchedule:8 hour shiftAbility to Relocate:Tallahassee, FL 32311: Relocate before starting work (Required)Work Location:

In person

#J-18808-Ljbffr