Primary Purpose
This position is primarily responsible for ensuring the timely and accurate preparation of standard and ad hoc statistical and operations reports.
Key Relationships
Internal to CWS
- Other Data Analysts
- Data Integrity Supervisor-USRAP
- Data Integrity Supervisor-Administration
- Data Integrity Manager
- Senior Manager, Data Analytics & Visualization
- Associate Director, Strategic Planning
- Deputy Director Program Implementation & Quality
- RSC Director
- Other team members in administration & program units
External
- BPRM Program Officer
- UNHCR
- IOM
- RPC
- Other NGOs
- Resettlement Agencies
Working Environment
- Office environment, Periodic travel to the field as may be required.
Responsibilities
Core Job Responsibilities:
Data Management and Program Administration (45%)
- Prepares routine and ad hoc CWS RSC Africa statistical reports as needed for various CWS RSC Africa staff and implementing partners e.g. US Embassy Refugee Coordinator, UNHCR, IOM and the Resettlement Agencies.
- Prepares and automates regular sectional quality control reports to ensure data accuracy and identify training needs.
- Prepare reports designed to track CWS RSC Africa operations’ productivity for an overall improvement in efficiency.
- Works closely with IT to ensure that reports run in the most current software environment and in publishing QC reports in a user-friendly interface.
- Continually works on converting as much of the DI reporting portfolio into an automated format on Tableau.
Compliance (30%)
- Carries out annual inter-departmental process reviews and recommends improvements in quality control.
- Updates automated and ad hoc reports in line with START database schema changes and/or Policy and Program changes.
- Maintains a current understanding and keeps abreast of any updates of START or RSC Africa Standard Operating Procedures.
- Works closely with Programs staff to ensure that they have adequate reporting tools available to them to enable their departments meet RSC quality standards and adhere to USRAP processing guidelines.
Representation/Engagement (20%)
- Works closely with RPC staff on issues related to START data fixes and deployed new releases.
- Works with other programs teams when to assist with their reporting needs, as needed.
- Serves as the contact person for all inquiries directed to the Data Integrity Unit while the Data Integrity Supervisor is on leave.
- Actively works on and resolves all work order tickets raised by Programs staff.
Additional Responsibilities (5%)
- Performs any other duties assigned to improve the operations of CWS Africa.
Qualifications
Experience:
- A minimum of 5 years paid work experience required
- Good understanding (2+ years required) of databases and Tableau (or other business intelligence tools like Power BI)
- Previous experience working within the U.S. Refugee Admissions Program (USRAP) is required
- Experience using Microsoft Visual Studio 2016 in the context of SQL Server Reporting Services required.
- Previous experience working within the U.S. Refugee Admissions Program (USRAP) is required.
Skills:
- Advanced knowledge in TRANSACT SQL and Microsoft SQL Server database design, stored procedures, views and functions.
- Advanced computer knowledge, specifically with MS Office (Access, Outlook, Word, PowerPoint). Advanced knowledge in using Tableau Business Analytics software.
- Knowledge of US refugee resettlement and working experience with the START database preferred.
Education & Certifications:
- Bachelor’s degree or four (4) years of directly related experience in lieu of a Bachelor’s Degree is required.