Reporting and Database Developer

Contributor Development Partnership - Boston, MA

Full-time
Save
Under the supervision of the Associate Director of Business Data & Analytics, the Senior Reporting and Database Developer will collaborate closely with functional business units to leverage CDP data assets and all ancillary applications to deliver best-in-breed reporting and analytics services. The ideal candidate is one who lives and breathes data, with an acute curiosity about the business of fundraising. This individual will continuously seek to sharpen key skills aimed at writing proficient queries, surfacing meaningful insights, and developing intuitive visualizations all targeted towards guiding the success of our membership service bureau and associated fundraising services .

Priorities

  • Report development leveraging our Tableau and Salesforce (NGOC) reporting platforms
  • Communicate with various stakeholders to identify and develop operational and strategic dashboard and reporting
  • Support existing analytics initiatives and services while identifying opportunities to continually improve upon current design and technology platforms.
  • Maintain documentation related to development initiatives and communicate functionality to internal staff and station partners
  • Assist with case management, support and maintenance of our reporting and analytics platform
Essential Functions

  • 20% Development/coding of ETL scripts in support of enterprise data warehouse and functional data marts
  • 25% Report development in Tableau and Salesforce (NGOC)
  • 15% Case management, troubleshooting and support of existing reports and analytics products
  • 30% Support, maintenance and execution existing ETL code in support of database conversion activities
  • 10% Process documentation and improvement aimed at helping the team find ways to work smarter, not harder
Experience/Skills

  • 1 – 3 years of experience with SQL Server or another enterprise database technology
  • 1 - 3 years of experience with SQL and ETL programming (e.g. SSIS, Informatica, RedPoint Data Management)
  • Solid understanding of statistical analysis and concepts • 1 year of experience with statistical analysis tool (R, Python, SPSS) • 1 – 3 years of experience with at least one business intelligence/reporting tool (Tableau, SSRS, Salesforce Reporting)
  • experience with Data Warehouse design and implementation a plus
  • experience with object-oriented database technology (Postgres) a plus
  • Experience with non-profit fundraising a plus • ability to manage multiple tasks simultaneously and work with cross-functional teams in a dynamic, fast-paced environment • ability to work under pressure and to prioritize tasks • exposure to cloud services platforms and technologies (AWS, Azure) a plus • Exposure to Agile project management a plus
Educational Requirements

Bachelor’s Degree is required