Opportunity in Washington, DC
The United States Agency for International Development (USAID) has contracted through ZemiTek partnered with CAMRIS International, to recruit and hire a qualified individual for the following position:
Title: Power Africa Senior Software Engineer
United States Agency for International Development/AFR/ Power Africa
With more than 30 years’ experience providing information technology (IT) and management consulting services worldwide, Rosa Caldas, formed ZemiTek in 2007. Based in the Washington, DC metro area, ZemiTek delivers solutions to the federal government by supporting agencies such as USAID, US Patent and Trademark Office, US Department of Justice, US Department of Agriculture, and Department of Homeland Security, among others; and internationally to their missions in Africa, Asia, Europe and Eurasia, Latin America, the Caribbean, and the Middle East.
CAMRIS International is among the top 20 USAID contractors for the third year in a row. CAMRIS realizes innovative solutions to health and development challenges through high-quality, cost-effective programs and research management services. With experience working in more than 80 countries, CAMRIS combines proven systems with today’s most effective, evidence-based best practices to improve the lives of people around the world.
More than 69 percent of the population of sub-Saharan Africa has no access to electricity – and that number rises to more than 85 percent in rural areas. And yet, the region has significant potential to develop clean, geothermal, hydro, wind, and solar energy.
Power Africa will bridge the gap between Africa’s power shortage and its economic potential by working with other U.S. Government Agencies, African Governments, NGOs, and Private Sector Partners to take the steps needed to building out power generation, transmission, and expanding the reach of mini-grid and off-grid solutions.
The Power Africa Information System (PAIS) is Power Africa’s primary information and document management system. The system is developed and managed by the USAID Office of Afghanistan and Pakistan (OAPA) within the USAID Info system. The USAID Info system is a dynamic, web-based information management application designed to organize, monitor, and store Office of Afghanistan and Pakistan Affairs (OAPA) Missions’ implementation- and performance-level information across their development portfolios. The system provides an easily accessible, central location to support accurate and consistent use of this information by stakeholders in USAID. Additionally, OAPA has also supported Power Africa to use the system for project, performance, and partnership management.
Power Africa requires customized functions within the USAID Info application and requires the Power Africa module in USAID Info System and related iOS/Android app development to increase its ability to collect, validate, report, and publish Power Africa’s activities and results. The information in the Power Africa Information System will be used for internal data analysis and decision making as well as reporting to external stakeholders, including Congress, the media, and Power Africa private sector and development partners.
The Power Africa additions to the USAID Info system and iOS/Android app services purchased through this solicitation will augment and coordinate closely with the OAPA-managed USAID Info development team.
The PAIS currently contains the following types of functions and types of information:
* Relationship Management Module (Private Sector Partners)
* Names, basic information, logo files and contact information of Power Africa’s private sector partners
* Partner commitments and progress towards meeting commitments
* Notes of meetings and phone calls that Relationship Managers and staff have with partners
* Media links and documents such as Letters of Commitment/Intent, Due Diligence Memos
* Development Partners Module
* Names and contact information of Power Africa’s multilateral and bilateral development partners
* Partner commitments and progress towards meeting commitments
* Notes of meetings and phone calls that Technical Relationship Managers and Coordinator’s Office staff have with partners
* Inclusion of Development Partner activities (upload options under review).
* Media records and files relevant to Development Partners
* Project and Performance Module
* Project and activity information, including names, implementing partners, start and end dates, total estimated cost, and type of agreement
* Indicators and targets
* Portfolio review sheets
* Fact sheets
* Document library
In the next phase of the PAIS development, the following modules and functions are needed to increase the effectiveness and usability of the Power Africa module of the USAID Info system.
DUTIES AND RESPONSIBILITIES:
Power Africa Information Systems Development
1 Transactions Tracking and Reporting
* Integration of all transaction information from multiple sections of the PAIS (Relationship, donor, and project information)
* Reconcile data across different project modules/PA Offices
* Develop tabular transaction reports
* Develop data visualizations and dashboards to facilitate program management. Linking existing and future PAIS modules (and other USAID/USG data) to show data visualisations including maps and dashboards that show the entire portfolio. Exact data visualizations and dashboards will be jointly developed between the contractor and USAID.
Possible examples include:
1 Geospatially map transactional data (examples for the work plan – i) on the continent, ii) US partners to the continent, iii) developer partners to the continent, iv) country perspective of IPs resources, partner investments, transactions,etc)
2 Dashboards, including transaction stages, MW and connections progress, user performance (MW & transaction count/connections/RM & interagency management, frequency of use, transaction/activity notifications).
1 Improved Document Management & Search
* Search engine that allows uploaded documents to be searched by text, and filtered by document type, partner/donor who uploaded it and when, and tags defined by Power Africa staff
* Improved document upload function, including editing of document titles and types within USAID Info
* Implement a notification system via email and notice list available in the Application.
* Enable search and develop reports by country (and Phase II - same by partner, e.g. implementing, interagency, development, and private sector)
1 Transaction information
2 Performance information
3 Partner updates
4 US-involved actor transactions & activities
5 Procurement opportunities
6 Pillar 3 Enabling Environment Scorecard
7 Pillar 3 Human and Institutional Capacity Assessment Tool
1 Front-End Maintenance and Development of USAID Info (Deliverables C.3-C.4 will be further defined after consultations with the various system users. The scoping and consultations will be lead by the OAPA USAID Info Project Manager.)
* Perform front-end maintenance to the USAID Info system as requested by the USAID Info Project Manager.
* Complete front-end backlog tasks per the direction of the USAID Info Project Manager.
* Develop data visualizations for:
- Performance metrics for example: compare quarterly performance to annual targets
- Develop award management tools including:
1 Develop an front-end interface that allows users to step-through data submission and approval process including developing tools to highlight missing or improperly inputed data from implementing partners.
2 Variable reporting frequency
Potential other tasks as assigned:
* Tender tracker - Linking project opportunities to developers and equipment suppliers
- Tender information, including:
- Ability to push out tender information to a public-facing website
- Ability to export information into an email-able format
- Ability to be accessed by interagency partners
* Power Africa Interagency Module
- Interagency commitments
- Contacts and notes
- Activities / transactions by country
* Improved Development Outreach and Communication Functions
- General contact & email database tracking (CRM functions)
- Press Tracking - capture media / press information
- Legislative Tracking - database of legislation, budget
- Regular automated updates to standard documents on the website
1 Fact Sheets
2 Country and regional profile sheets
1 Improved development of communication products based on the information already in the database, such as developing:
*Transaction fact sheets (including US involved information)
* Partnership fact sheets
* Country fact sheets
* Pillar 3 Scorecard & Assessment Tool fact sheets
* Procurement Opportunities fact sheets
1 Maps with layers/vectors with all PA-related activity encompassed in every country from transactions to Power Africa Working Group supporting teams and tools to US company involved actors/geography available with snapshots of each transaction that has reached financial close.
1 Improved Performance Module - Data entry process
* Build/arrange conditionality for incomplete data (zeros/blanks, no narrative, etc.) if a field is left blank, submission can’t be completed
1 Country level summaries / extracts (Microsoft Word)
2 Executive Summary Infographics - MW, connections
1 Budget Management
* Budget planning and tracking (across multiple operating units)
* Budget submissions by Missions and interagency
* Opportunity Fund intake / review
* Graphical budget reports that can be shared publicly
2 Front-End Maintenance and Development of USAID Info
* Perform front-end maintenance and develop new features to the USAID Info system as requested by the USAID Info Project Manager.
Development and Management of the Power Africa Transaction Apps
1 Maintain the current app to remain functional with iOS updates.
2 Update the app with new functions, as requested by the Coordinator’s Office.
3 Develop a new Android App similar to the current iPhone app and update it as needed.
Transaction Review Support
1 Research non-USG Power Africa transactions and complete the Power Africa Environmental and Social Review Methodology to confirm that the transaction meets U.S. Government environmental and social standards.
2 Complete the Qualified Transaction Assistance Tool on all transactions that may receive Power Africa support, including USAID, USG, and Private Sector Partners.
3 Facilitate transaction updates and quality checks with the program office.
QUALIFICATIONS, EDUCATION and/or EXPERIENCE:
* A Bachelor’s Degree in computer science, computer systems administration, web design, data visualization, data analysis, or a related field with a minimum of fifteen (15) years of experience in web application development or web based data visualization and mapping in an academic or professional setting. Or
* A Master’s Degree with significant study in or pertinent to a specialized field including, but not limited to computer science, computer systems administration, web design, data visualization, data analysis, or a related field and a minimum of twelve (12) years of experience in web application development or web based data visualization and mapping in an academic or professional setting.
* Expert, full stack web developer who can make significant contributions to a large codebase in these areas with minimal supervision and little ramp-up time:
* Development of json-based APIs in a dot net (c#) environment (2 years of experience)
* Microsoft SQL server database experience including ETL, OLAP and Object-relational mapping (10 years)
* Proven capability to design and implement usable and performance web-based user interfaces using modern design frameworks such as bootstrap (5 years)
* Certifications in relevant Microsoft technologies is preferred.
* Familiarity with USAID or foreign assistance budget and performance systems is preferred.
* US citizenship with the ability to obtain and maintain a Secret level clearance.
* Previous experience with USAID’s information systems (including the USAID Information System, Power Africa Transaction Tracker, AID Tracker, Phoenix, or other systems) is preferred.
Oral and written communications skills and the ability to read, analyze, and interpret general business periodicals. Ability to effectively present information and respond to questions from groups of managers, clients, customers, and the general public.
Ability to apply common sense understanding to carry out instructions furnished in written, oral, or diagram form.
CERTIFICATES, LICENSES, REGISTRATIONS
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of this job, the employee is frequently required to sit, stand and walk. The employee must occasionally lift and/or move up to 20 pounds. Specific vision abilities required by this job include close vision, color vision, and ability to adjust focus.
The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
This is an opportunity for employment or a contract, but we reserve the right to make no selection or award.
ZemiTek and CAMRIS International offer competitive salaries and comprehensive benefits.
ZemiTek and CAMRIS International are Equal Opportunity/Affirmative Action Employers. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, protected veteran status, disability status, or any other characteristic protected by law.