Volunter SQL Server Reporting Services (SSRS) ProgrammerBookmark This
Clinton Health Access Initiative
Since 2008, CHAI’s Southern Africa Malaria Elimination Support Team (SAMEST) has provided day-to-day management and technical support to southern African countries (South Africa, Swaziland, and Namibia) as they began reorientation of their malaria programs from control to elimination. CHAI has contributed significantly to elimination progress in the region by working closely with the programs to mobilize resources, develop sound comprehensive strategic plans and guide the translation of strategies into high impact results.
Swaziland is near to achieving malaria elimination with less than 500 reported malaria cases in 2011. To achieve elimination, Swaziland’s National Malaria Control Program (NMCP) requires robust data systems to ensure rapid capture of information on all interventions and all malaria cases. Information collected on malaria cases and the environment can be used to dispatch targeted interventions to halt malaria transmission leading to a more efficient use of limited resources. To this end, Swaziland’s NMCP developed a centralized Malaria Surveillance Database System (MSDS) for the storage, management, and strategic manipulation of malaria data and introduced Geographic Information Systems (GIS) to support the monitoring and evaluation of the malaria elimination campaign and to inform operational strategies related to vector control and surveillance.
The MSDS was developed on Microsoft SQL Server and consists of 12 modules, which are the operational functions of the database that specific information on different NMCP operation areas including vector control interventions and surveillance activities. To improve analytics and utilization of the MSDS to halt transmission, CHAI seeks to support the NMCP in the development of a web-based, analytics system that will provide succinct reports on recent epidemiological indicators and recommended interventions for response. The analytics system will be built on SQL Server Reporting Services (SSRS) and will be based on reports designed by CHAI in partnership with the NMCP.
ResponsibilitiesCHAI seeks a volunteer SQL Servers Reporting Services (SRRS) Programmer to develop and assist in the launch of a comprehensive analytics system based on data collected and stored on Swaziland’s Malaria Surveillance Database System. The volunteer will work closely with the NMCP’s Information Technology team and CHAI malaria team based in Swaziland on the development and refinement of the analytics reporting system. The volunteer must be highly motivated, entrepreneurial individual with outstanding problem-solving, analytical, and communication skills. The volunteer must be able to function independently and flexibly and have a strong commitment to excellence.
The location of this position is flexible and does not require travel to Swaziland. Communication with the Swaziland team will be through email and teleconference.
The anticipated timeframe for the engagement is 2 months for the development and testing of the malaria analytics reporting system.
•Develop SQL Server Reporting Services (SSRS) ad hoc reports according to specifications
•Create report models to be deployed on report server
•Create user defined functions in SSRS using VB script
•Build data charts in reports as required using SSRS
•Build reports that contain maps based on GIS data using SSRS
•Collaborate with end users on various systems to view/access reports
•Identifying application gaps and developing and executing gap closure plans
Deliverables from the SSRS Programmer will include the following:
•SQL Server Reporting Services (SSRS) ad hoc reports according to specifications with all code
•Report models as per specifications
•BSC in Information Systems/Computer Science or like discipline or experience to substitute for degree (5+ years’ experience or 3+ years’ experience with database query and reporting tools)
•Experience with SQL Server Reporting Services SSRS , SQL Server Integration Services SSIS and SQL Server Analysis Services SSAS
•Previous experience with server-client computing and relational database environments
•Experience with data management and data processing flowcharting techniques
•Understands Full Software Development Life Cycle
•Report Design experience using both RDBMS & OLAP Cubes
•Knowledge of reporting and query tools and practices
•SSRS programming experience and SQL knowledge and skills
•Data quality with the use of SSRS
•Ability to gather functional requirements and turn them into technical specs to produce the requested reports
•ETL/Data Quality with the use of SSIS and SSRS
•Ability to quickly and effectively respond to Ad hoc requests to better understand data