Data Analyst

Qualification and Experience

• Five years of experience in data modelling, data mining, database standardization, deduplication and performance tuning.
• Five years of experience developing Online Analytical Processing (OLAP) cubes using SQL Server Analysis Services.
• Five years of experience developing SQL Server Integration Services packages performing Extraction, Transformation and Loading activities.
• Five years of experience with dashboard and scorecard development.
• Five years of experience with the development of reports using MS SQL Server Reporting Services (MS SSRS) and maintenance of enterprise reports using MS SSRS.
• Five years of experience with business intelligence tools and systems, such as SSRS.
• Five years of experience with MS SQL product inclusive of MS SQL 2016,2019, 2022.
• Five years of experience with SQL programming inclusive of stored procedures, functions, triggers, scheduled jobs, and linked servers
• Five 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.
• Three years of experience with software build and release management methodologies.
• Two years of experience in a healthcare IT domain.
• One year of experience with Prenatal Risk Screening datasets

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.
• Work with Division resources to standardize collection and storage of CHP shared data daily as requested by the Department.