Business Intelligence Developer - Mercy Corps, Portland, OR

Closing date:  24 Dec 2011


Mercy Corps helps people turn the crises they confront into the opportunities they deserve. Driven by local needs, our programs provide communities in the world’s toughest places – places like Iraq, Afghanistan, Somalia and Haiti – with the tools and support they need to transform their own lives.

Resource Development (RD) staff work in three main areas: 1) raising private funds and cultivating and maintaining relationships with private donors; 2) defining the agency’s brand, raising our public profile and sharing stories about our work by engaging with the media, the public, and our supporters and producing a wide range of online and offline communications; and 3) teaching visitors to our Portland Action Center about issues of global poverty and engaging them in efforts to end it.

The RD team includes several dozen dynamic professionals who possess a wide range of skills. We are database managers, web developers, internet marketers and public relations experts. We are writers, designers, photographers and teachers. We are fundraisers with expertise in direct response, online, community, major gift and corporate giving. We are specialists in fundraising analysis, stewardship, prospecting and customer service. Most of all, we are passionate about Mercy Corps’ mission and dedicated to supporting our worldwide team that’s improving the lives of 19 million people in 40 countries.


The BI Developer provides ongoing support for the RD team’s business intelligence solution(s), primarily a custom data warehouse built in SQL Server, and a suite of reports in Microsoft’s SQL Server Reporting Services and Crystal Reports. S/he will play a critical role in all phases of the solution’s life cycle. This includes participating in or leading requirements definition, data analysis, data modeling, data warehouse development, ETL design and development, data integration from disparate data sources, reports creation and deployment, and database cleansing efforts. The BI Developer will focus on building reports that enable analysis of fundraising performance, constituent and gift analysis, and data mining/predictive modeling results. This position interviews key stakeholders on report requirements and verifies the results before final publication. Ultimately, it’s the goal of the BI Developer to help ensure the reporting and analysis of critical marketing and fundraising data to help guide and support the RD team’s strategic decisions.

  • SQL development in a production environment: Develop, test and document stored procedures, views, tables, indexes, constraints, functions and/or T-SQL scripts. Prepare detailed and comprehensive documentation for all programs.
  • Interview stakeholders about reporting needs: work regularly with the Director of Development Operations, Database Manager and other RD team members to identify existing and new reports; communicate with team members about report requirements; design, test and vet the final report results with relevant team members.
  • Develop and maintain standardized reports using Microsoft’s SQL Server Reporting Services: Create a suite of reports that are scheduled and delivered electronically or are available on-demand in a self-service environment for RD team members. Development of Cubes for OLAP purposes may be needed for specific end users.
  • Create custom Crystal Reports as needed depending on business requirements.
  • Maintain, expand and support the SQL Server-based data warehouse and associated ETL processes for reporting and analysis for the RD team. Provide ample documentation on the data warehouse and associated reports. Use Microsoft’s SQL Server Management Studio throughout all phases.
  • Work closely with the RD Database Manager to identify data anomalies and broken business rules within operational and transactional data systems. Assist in developing data integrity solutions and data cleanup processes.
  • Support the development of analytical report-writing skills within the RD team, cross-train in essential functions.
  • Advise RD and IT about the requirements (hardware, software, and skill sets) necessary to meet growing analytical demands.
  • Other duties as requested or required.
Organizational Learning:
As part of our commitment to organizational learning and in support of our understanding that learning organizations are more effective, efficient and relevant to the communities they serve - we expect all team members to commit 5% of their time to learning activities that benefit Mercy Corps as well as themselves.

Accountability to Beneficiaries
Mercy Corps team members are expected to support all efforts towards accountability, specifically to our beneficiaries and to international standards guiding international relief and development work, while actively engaging beneficiary communities as equal partners in the design, monitoring and evaluation of our field projects.



REPORTS DIRECTLY TO: Director of Development Operations

WORKS DIRECTLY WITH: RD Team Leaders, Development Operations, IT Staff, Finance Staff

  • College degree in information management or computer science, or comparable experience, required.
  • Solid knowledge and experience with data warehousing projects – 3+ years experience preferred.
  • At least 3 years experience in data modeling, database management, reporting development, data analysis, preferably in a non-profit fundraising environment, required.
  • At least 3 years professional experience using T-SQL or MySQL required.
  • 2+ years experience working with Microsoft SQL Server Reporting Services to create customized reports, including multi-dimension reports with drill-down capabilities preferred.
  • 2+ years demonstrated technical competency with Microsoft SQL Server 2008, including Analysis Services, Integration Services and Reporting Services (SSAS, SSIS, SSRS) required.
  • 1+ year(s) experience with Crystal Reports required.
  • Knowledge of The Raiser’s Edge strongly preferred.
  • Strong written and spoken communication skills; demonstrated ability to communicate effectively with team members of varied work styles.
  • Discretion with confidential materials required.
A successful candidate will be interested in fundraising and the questions that fundraisers ask and also have a curiosity and an investigative and analytical approach to data and fundraising strategies. S/he will have an ability to work independently in a deadline-oriented team environment and have a strong commitment to teamwork and cross-training.

Being engaged, interested and communicative; willing to ask questions; able to understand the bigger picture while staying focused on the details is critical as is being capable of organizing and prioritizing multiple, competing tasks. An even temperament and good sense of humor are appreciated and an awareness of and sensitivity to multi-cultural international development work is essential.

COVER LETTER REQUIRED for consideration as a candidate!!!

Position is based in Portland, Oregon at Mercy Corps Headquarters. Must be able to work at the computer for long periods of time.

Mercy Corps Team members represent the agency both during and outside of work hours when deployed in a field posting or on a visit/TDY to a field posting. Team members 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.