Portland, OR - Program Operations Analysis Intern
INTERN WORKSITE LOCATION: Portland, OR
LENGTH OF INTERNSHIP: May - October 2019 (Flexible as long as 3 months minimum) at 20 hours/week
Availability: M-F 9am-5pm (flexible)
FUNDING AVAILABLE FOR THE INTERNSHIP: $1500/month stipend
Mercy Corps Responsibilities
For the duration of this internship assignment the intern will receive:
- Workspace within the MC HQ in Portland
- Access to Mercy Corps online tools
- All other tools, materials and communication requirements for this project to be undertaken.
Intern will remain responsible for all costs associated with:
- Travel to and from Mercy Corps HQ
- Maintaining their personal computer which will be used for the internship
- Accommodation, travel, and living expenses
- All other costs associated with this internship
Mercy Corps is a leading global organization powered by the belief that a better world is possible. In disaster, in hardship, in more than 40 countries around the world, we partner to put bold solutions into action — helping people triumph over adversity and build stronger communities from within.
The Program Operations unit supports and enables quality program implementation by establishing and managing standards for quality, championing an evidence-based practice to improve program performance, and supporting strategic organizational pivots. The Program Operations unit oversees multiple functions including monitoring, evaluation and learning (MEL); program management standards; program data management (TolaData); infrastructure quality assurance; cash transfer program (CTP) quality assurance; strategic change management; and managing the complex program process.
The Program Ops Intern will spearhead research & data analytics requests that cover multiple program areas and combine data sources. The internship will involve conducting thoughtful analysis and creating clear communications of results to the broader agency. They will work closely with the Program Operations team, finance, and other relevant stakeholders.
The intern will have the opportunity to create meaningful data pathways by curating from disparate sets of data; analyzing based on various business and program criteria; and communicating through various written and visual channels. This includes the ability to find relevant data sources, combine them in a meaningful and accurate way, and then create clear visualizations to identify trends and results. The intern will also gain understanding of software for data visualization in one or more of the following applications: Power BI, Tableau, or Google Data Studio. The intern will also need to be able to effectively interview and summarize Mercy Corps stakeholder analytical interests and needs resulting in a product design and output that addresses the hypothesis and increases their knowledge of the subject area.
- Quick Sheet for Program Operations standard use of Power BI & Tableau (and any other platforms applicable)
- Completed analysis on the following questions:
- What is our average rate of spend on complex programs organized by duration of grant?
- What is our average budget v. actual per general ledger code?
- Research and analyze expenditure on infrastructure projects over the last three years and create a tool by which infrastructure project expenditures can be tracked looking forward
- Completed analysis will include an internal presentation on findings, and a 1-2 page synopsis of the methodology and results with a finalized dashboard or visual representation of the work.
- Template for connecting multiple internal data sources in a replicable way.
THE IDEAL CANDIDATE:
- Bachelor’s degree is required
- Excellent writing skills in English
- Demonstrated attention to detail, ability to follow procedures, meet deadlines and work independently and cooperatively with team members is required
- Strong multi-tasking, organizational and prioritization skills are necessary.
- Commitment to working with vulnerable groups in need regardless of race, religion or gender
- Excellent communication skills are required
- Highly developed computer skills and strong familiarity with Microsoft Office are mandatory
- Experience with Power BI or other data visualization software a plus
- Experience managing and developing online content a plus
- Multi-tasker with the proven ability to organize and prioritize competing priorities
- Demonstrated ability to communicate effectively with team members of varied work styles, follow procedures, and meet deadlines
- Flexibility and creativity in planning and problem solving
- Ability to learn quickly, take initiative, and be accountable for results
- Understanding for diverse cultural, political and religious environments and be able to work successfully in those environments.
Mercy Corps interns and team members represent the agency both during and outside of work hours and are expected to conduct themselves in a professional manner and respect local laws, customs and MC's policies, procedures, and values at all times and in all in-country venues.
Diversity is powerful. To achieve transformational change, we seek out team members with different origins, beliefs, backgrounds and ways of thinking. Diversity helps us unlock complexity.