Senior Business Intelligence Developer – US or UK
SKILLS
FULL DESCRIPTION
Senior Business Intelligence Developer – US or UK
Organization: [Employer hidden — sign up to reveal]
Type: Full-Time
Salary: $90,000 to $110,000 / Yearly
Location: US or UK – flexible home base (Remote)
About [Employer hidden — sign up to reveal]
[Employer hidden — sign up to reveal] 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. Now, and for the future.
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 Microsoft Power BI. They play a critical role in all 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 evolve, we anticipate opportunities to streamline and modernize our environment. The Senior BI Developer will help assess improvement areas within our current architecture, optimize performance, and strengthen documentation to support future scalability and long-term data strategy.
Essential Responsibilities
- SQL development in a production environment: Develop, test and document stored procedures, views, tables, indexes, constraints, functions and T-SQL scripts.
- Interview stakeholders about reporting needs: Work regularly with the Director of Fundraising Data & Analytics and team members to identify new reports and updates.
- Develop and maintain standardized reports using Microsoft’s SQL Server Reporting Services and Microsoft Power BI: Create scheduled and on-demand reports, support legacy MDX while focusing on Power BI tabular models and DAX.
- Expand, assess, and maintain the SQL Server data warehouse and SSIS-based ETL processes.
- Data quality and integrity: Work closely with the Donor Database Manager, Online Database Developer and Manager, and Development Operations Manager to identify data anomalies and support data integrity.
- Other duties as requested or required.
Minimum Qualification & Transferable Skills
- Bachelor’s degree or equivalent professional 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 (ideally 5+ years).
- Demonstrated technical competency (ideally 3+ years) with Microsoft SQL Server 2016, including SSAS, SSIS, SSRS, and Power BI.
- Demonstrated success (ideally 2+ years) developing customized reports in SSRS and Power BI.
- Knowledge of The Raiser’s Edge ideal; non-profit experience preferred.
- 3+ years of experience with fundraising data or other comparably complex data.
- Strong written and verbal communication skills.
- Python experience is a plus.
How to Apply
Please submit application including CV and cover letter by April 27th. Apply via: [Employer hidden] application page.