Senior Business Intelligence Developer - US

Description

Location: Portland, Oregon; or a location within the United States (Remote)

Valid unrestricted work authorization in the country in which you will be based (United States) is required at the time of application for this position.

Position Status: Full-time, Exempt, Regular

Salary Level: US: Starting salary for this role will be USD $84,000 to $99,750 commensurate on experience.

About Mercy Corps

Mercy Corps is powered by the belief that a better world is possible. To do this, we know our teams do their best work when they are diverse, and every team member feels that they belong. We welcome diverse backgrounds, perspectives, and skills so that we can be stronger and have long term impact.

The Program / Department / Team

The Fundraising team raises private funds, cultivating and maintaining relationships with private donors; 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 by producing a wide range of online and offline communications. Our marketing team includes several dozen dynamic professionals who possess a wide range of skills. We are passionate about Mercy Corps’ mission and dedicated to supporting our worldwide team that is improving the lives of 19 million people in 40+ countries.

The Position

The Senior Business Intelligence Developer supports and expands the fundraising 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 Microsoft Power BI. They 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, modeling and piloting emerging technologies and toolsets, ETL design and development, data integration from disparate data sources, reports creation and deployment, and database cleansing efforts. The Senior Business Intelligence Developer supports will focus on building reports that enable analysis of fundraising performance, constituent and gift analysis, and occasional data mining/predictive modeling results. This position interviews key stakeholders on report requirements and verifies the results before final publication. Ultimately, it is the goal of the Senior Business Intelligence Developer to help ensure the reporting and analysis of critical marketing and fundraising data to guide and support the teams’ strategic decisions.

Essential Responsibilities

• 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 Data Reporting and Analytics and other team members to identify new reports and changes to existing 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 and Microsoft Power BI:

• Create a suite of reports that are scheduled and delivered electronically or are available on-demand in a self-service environment for team members. Some basic MDX is required to support legacy services while new report development is focusing on Power BI tabular models and DAX scripting.

• Using Microsoft’s Integration Services (SSIS), expand and support the SQL Server-based data warehouse and associated ETL processes for reporting and analysis for fundraisers. Provide ample documentation on the data warehouse and associated reports.

• Work closely with the Donor Database Manager, Online Database Manager and Development Operations 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.

• Ensure that personally identifiable data and data analytics practices are in alignment with Mercy Corp’s Responsible Data Policy.

• Cross-train in essential functions to ensure business continuity.

• Collaborate with the IT Department; ensure that marketing technical strategy and direction is in alignment with the larger enterprise roadmap.

• Development and maintenance of Cubes for OLAP purposes as needed.

• Other duties as requested or required.

Supervisory Responsibility

The Senior Business Intelligence Developer has no supervisory responsibilities.

Accountability

Reports Directly To: Director, Development Reporting & Analytics.

Works Directly With: Online Database Manager, IT Team, Marketing Team, Database Manager, Development Operations Manager, Corporate & Foundations Team, Major Gifts Team.

Accountability to Participants and Stakeholders

Mercy Corps team members are expected to support all efforts toward accountability, specifically to our program participants, community partners, other stakeholders, and to international standards guiding international relief and development work. We are committed to actively engaging communities as equal partners in the design, monitoring, and evaluation of our field projects.

Minimum Qualification & Transferable Skills

• College degree in information management or computer science, or comparable experience.

• Demonstrated knowledge of data warehousing, database management, reporting development, data cleansing, ETL and data analysis, preferably in a non-profit fundraising environment.

• Demonstrated success using T-SQL or MySQL to support data warehousing and reporting projects, 5+ years of professional experience preferred.

• Demonstrated technical competency (ideally 3+ years of experience) with Microsoft SQL Server 2016, including Analysis Services, Integration Services, and Reporting Services (SSAS, SSIS, SSRS) and Power BI.

• Demonstrated success (ideally 2+ years of experience) working with Microsoft SQL Server Reporting Services and Microsoft Power BI to create customized reports, including multi-dimensional reports with drill-down capability.

• Knowledge of The Raiser’s Edge ideal; non-profit experience preferred.

• 3+ years of experience with fundraising analysis and data or comparably complex data.

• Strong written and spoken communication skills; demonstrated ability to communicate effectively with team members of varied work styles.

• Proven ability to handle confidential materials.

• Python experience is a plus.

Success Factors

The successful candidate will be a highly motivated self-starter who is deeply curious about fundraising and the questions fundraisers ask. She or he will be persistently curious, with an investigative and analytical approach to data and fundraising strategies. Above all, he or she will be comfortable in a flexible and highly informal development environment, low on protocol and high on relationship and give-and-take conversation. Being interested in the bigger questions that fundraisers are facing and engaging with colleagues about those questions will deepen understanding and success in the position. Even temperament and a good sense of humor are appreciated. Awareness of and sensitivity to multicultural international development work are valued.

Living Conditions / Environmental Conditions

The position is based in Portland, OR, or US remote work for the right candidate.

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

Equal Employment Opportunity

Mercy Corps is an equal opportunity employer that does not tolerate discrimination on any basis. We actively seek out diverse backgrounds, perspectives, and skills so that we can be collectively stronger and have sustained global impact.

We are committed to providing an environment of respect and psychological safety where equal employment opportunities are available to all. We do not engage in or tolerate discrimination on the basis of race, color, gender identity, gender expression, religion, age, sexual orientation, national or ethnic origin, disability (including HIV/AIDS status), marital status, military veteran status or any other protected group in the locations where we work.

Safeguarding & Ethics

Mercy Corps is committed to ensuring that all individuals we come into contact with through our work, whether team members, community members, program participants or others, are treated with respect and dignity. We are committed to the core principles regarding prevention of sexual exploitation and abuse laid out by the UN Secretary General and IASC and have signed on to the Interagency Misconduct Disclosure Scheme. We will not tolerate child abuse, sexual exploitation, abuse, or harassment by or of our team members. As part of our commitment to a safe and inclusive work environment, team members are expected to conduct themselves in a professional manner, respect local laws and customs, and to adhere to Mercy Corps Code of Conduct Policies and values at all times.

As a safeguarding measure, Mercy Corps screens all potential US-Based employees. Any offers of employment or continued employment are dependent on the successful completion of the screens which include, but are not limited to our Background Check and Interagency Misconduct Disclosure Scheme processes,

Diversity, Equity & Inclusion

Achieving our mission begins with how we build our team and work together. Through our commitment to enriching our organization with people of different origins, beliefs, backgrounds, and ways of thinking, we are better able to leverage the collective power of our teams and solve the world’s most complex challenges. We strive for a culture of trust and respect, where everyone contributes their perspectives and authentic selves, reaches their potential as individuals and teams, and collaborates to do the best work of their lives.

Ongoing Learning

In support of our belief that learning organizations are more effective, efficient and relevant to the communities we serve, we empower all team members to dedicate 5% of their time to learning activities that further their personal and/or professional growth and development.

Covid-19 Vaccine Policy for US-Based Employees

Mercy Corps has determined that, in an effort to protect the health, safety, and well-being of all Mercy Corps employees working in the United States, all U.S.-based employees must be fully vaccinated for COVID-19, regardless of prior COVID-19 infection status. This policy will be revised as needed to comply with federal, state, and local requirements, and to respond to changing guidance from public health authorities.

For new employees this requirement goes into effect within 10 business days of employment. Team members that travel are expected to comply with host-country requirements, including vaccinations. Failure to comply may impact your employment. Proof of vaccination or exemption must be provided.

Keywords

Business Intelligence DeveloperSQL ServerSQLMicrosoft Power BIdata analysisdata modelingdata warehouseETLreports creationdatabase cleansingfundraising performanceconstituent analysisgift analysisdata miningpredictive modeling