SQL Server Business Intelligence Developer

WHYY

This position will work to develop and provide new business intelligence solutions to the organization by developing SSRS reports using SQL Server, stored procedures, and queries.

This positions primary responsibilities include:

Creating distributable SSRS reporting, ad-hoc queries, and data extractions to help support overall management, planning and vendor data requirements.

Experience with relational databases, data extraction, query writing, SQL logic, stored procedures, SSRS report development, SSIS and SSMS experience as well as Microsoft Word and Excel skills are required. Knowledge and/or understanding of hosted environments like Amazon Web Services a plus.

Excellent organizational and administrative skills are required. Must be able to communicate effectively in order to train and cross-train staff. Must have the ability to monitor TA performance and error reports. Must be able to work well with others, outside of own department, in order to achieve a common goal. Must be able to initiate and lead stakeholder meetings to gather requirements and schedules for deliverables.

A successful candidate will be expected to gather and evaluate report and data extraction requirements, develop queries and reports to support the request, test and validate results and distribute to necessary stakeholders.

Qualifications

The ideal candidate will possess:

  • Bachelor's degree in computer science or equivalent knowledge
  • 3-4 years' experience with database management, creating queries and analyzing results
  • Knowledge of non-profit fundraising operations a plus
  • Responsible for the administration, configuration, development, and ongoing support of reporting and analytical solutions.
  • Intermediate working knowledge of SQL and a solid history of project management.
  • The desire to be a self-starter by taking the initiative to get stuff done.
  • Strong analytical and quantitative skills.
  • Experienced with Microsoft Excel and a deep understanding of database design.
  • Data Warehouse, business intelligence experience
  • Experience designing dashboards with reporting tools such as Power BI, SSRS or other reporting tools.
  • Two plus years of SSRS, SSIS and SSMS experience critical to the role.
  • Working experience troubleshooting and writing complex SQL queries and stored procedures essential.

Interested applicants should submit a resume and a cover letter when applying for this position.

Education Level: 
Bachelors Degree