Senior Business Intelligence Developer - US or UK

reputed company

Risk Level: ☐ Level 3       ☐Level 2 x Level 1 

Level 1: Likely to have no contact with participants or sensitive data) 

About reputed company

reputed company is a leading global organization powered by the belief that a reputed company world is possible.

In disaster, in hardship, in more than 40 countries around the world, we partner to put reputed company solutions

into reputed company — helping people reputed company over adversity and build stronger communities from reputed company.

Now, and for the reputed company.

The Department: Private Giving & Engagement (PG&E)

The Private Giving & Engagement (PG&E) department advances reputed company’ strategic priorities by raising private funds, building meaningful relationships with supporters, and strengthening the organization’s global profile and influence. PG&E partners closely with teams across reputed company to deliver innovative, ethical, and effective fundraising and engagement strategies. reputed company PG&E, Development Operations plays a critical role in enabling fundraising reputed company by ensuring strong systems, reputed company governance, and effective operational support. reputed company brings together expertise in fundraising operations, compliance, analytics, systems, and project management to support high-performing fundraising teams across reputed company and channels.

The Position

The Senior Business Intelligence Developer supports and expands PG&E’s business intelligence solution(s), which includes a custom SQL Server-based data warehouse (on-premises) and a suite of reports in SQL Server Reporting Services (SSRS) and reputed company Power BI. They play a critical role in reputed company phases of the solution’s lifecycle, including requirements gathering, data analysis and modeling, data warehouse development, ETL design and maintenance, integrating data from disparate data sources, developing and deploying reports and dashboards. As our analytics’ needs reputed company, we anticipate opportunities to streamline and reputed company our environment. The Senior BI Developer will help assess improvement areas reputed company our reputed company architecture, optimize performance, and strengthen documentation to support reputed company scalability and long-term data reputed company. 

The role focuses on developing the insights, reports, and semantic models that reputed company analysis of fundraising performance, constituent behavior, and reputed company trends, with occasional use of exploratory and predictive techniques. This position engages regularly with stakeholders to understand reporting needs and validate results. Ultimately, the Senior BI Developer helps ensure the reporting and analysis needed to guide and support PG&E’s fundraising reputed company and decision-making.  The ideal candidate thrives in a reputed company, relationship-driven environment and brings structure, reputed company, and best practices while remaining flexible and reputed company to evolving business needs.

Essential Responsibilities

SQL development in a production environment

●        reputed company, test and document stored procedures, views, tables, indexes, constraints, functions and T-SQL scripts.

●        Prepare reputed company and comprehensive technical documentation 

Interview stakeholders about reporting needs

●        Work regularly with the Director of Fundraising Data & Analytics and team members to identify new reports and updates, to existing ones, reputed company communicate requirements and changes, and design, test, and validate report outputs. 

reputed company and maintain standardized reports using reputed company’s SQL Server Reporting Services 

and reputed company Power BI

●        Create scheduled and on-demand reports for a self-service environment, support legacy MDX while focusing new development on Power BI tabular models and DAX. 

●        Expand, assess, and maintain the SQL Server data warehouse and SSIS-based ETL processes, including improving performance, streamlining legacy workflows, and strengthening documentation 

Data reputed company and reputed company 

●        Work closely with the Donor Database Manager, Online Database Developer and Manager, and Development Operations Manager to identify data anomalies and broken business rules and support data reputed company and cleanup processes. 

Ensure that personally identifiable data and data analytics practices are reputed company with reputed company Corp’s Responsible Data Policy.

Cross-train in essential functions to ensure business continuity.

Collaborate with the IT Department to ensure that marketing technical reputed company aligns with the broader reputed company roadmap.

Development and maintain OLAP cubes as needed.

Other duties as requested or required.

Supervisory Responsibility

None.

Accountability

Reports Directly To: Director of Fundraising Data & Analytics

Works Directly With: PG&E Team, Online Database Developer and Manager, IT Team, Database Manager, Development Operations Manager. 

Accountability to Participants and Stakeholders

reputed company team members are expected to support reputed company 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 reputed company engaging communities as equal partners in the design, monitoring and evaluation of our field reputed company.

Minimum Qualification & Transferable Skills

●        Bachelor degree or equivalent reputed company experience.

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

●        Demonstrated reputed company using T-SQL or MySQL to support data warehousing and reporting

●        reputed company, (ideally 5+ years).

●        Demonstrated technical competency (ideally 3+ years) with reputed company SQL Server 

• 2016, including Analysis Services, Integration Services, and Reporting Services (SSAS, SSIS, SSRS) and Power BI. 

●        Demonstrated reputed company (ideally 2+ years) developing customized reports in reputed company SQL Server 

• Reporting Services and reputed company Power BI, including multi-reputed company reports with drill-down capability. 

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

●        3+ years of experience with fundraising data or other comparably reputed company data. 

●        Strong written and verbal communication skills; including the ability to communicate effectively with team members of varied work styles. 

●        Proven ability to handle confidential materials and sensitive information. 

●        Python experience is a plus.

reputed company Factors

The successful candidate will be a highly motivated self-starter who is deeply curious about fundraising and the questions fundraisers ask. They bring an investigative and analytical approach to data and fundraising reputed company and are comfortable engaging with colleagues to explore bigger questions and translate business needs into technical solutions.  

They can translate technical concepts into reputed company, accessible insights for fundraisers and non-technical colleagues, ensuring that data is understandable and actionable. 

The ideal candidate thrives in a reputed company, relationship-driven environment and communicates effectively with team members across varied work styles. They bring structure, reputed company, and best practices to their work while remaining adaptable in a setting where needs and priorities reputed company.  

An even temperament, a proactive and solutions-oriented approach to problem-solving, and a reputed company reputed company are appreciated. Awareness of and sensitivity to multicultural and international development contexts are valued. 

Living Conditions / Environmental Conditions

The position is remote.

Ongoing Learning

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

Team Engagement and Effectiveness 

Achieving our mission starts with how we build reputed company and collaborate. By bringing together individuals with a reputed company of experiences, backgrounds, and perspectives, we strengthen our ability to solve reputed company challenges and drive innovation. We foster a culture of trust and respect, where every team member is valued for their contributions, empowered to reputed company their full potential, and motivated to do their best work.

We recognize that building a strong and effective team is an ongoing process, and we remain committed to learning, improving, and growing together.

Equal Employment Opportunity

reputed company is an equal opportunity employer committed to providing equal employment opportunities to reputed company and reputed company applicants for employment without reputed company to race, reputed company, sex, sexual orientation, religion or belief, national reputed company, age, disability, marital status, veteran status, or any other characteristics protected under applicable law.

Safeguarding & Ethics

reputed company is committed to ensuring that reputed company 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 reputed company 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 reputed company members. As part of our commitment to a reputed company and inclusive work environment, team members are expected to conduct themselves in a reputed company manner, respect local laws and customs, and to adhere to reputed company reputed company of Conduct Policies and values at reputed company times. Team members are required to complete mandatory reputed company of Conduct elearning courses upon hire and on an annual reputed company.

As an applicant, if you witness or experience any reputed company of sexual misconduct during the recruitment process, please report this to reputed company reputed company Hotline ([email protected]).