Job Description

 

The Database Developer is responsible for partnering with multi-disciplined teams in implementing and supporting development of the Association Data Warehouse to support reports and analysis for all areas of the organization. This may be a US-based remote position.

 


 

Essential Job Functions:

 
     
  • Design, develop, and maintain Enterprise Data Warehouse (EDW) and related databases 
  •  
  • Build ETL Processes to load data from business systems/external sources into EDW, and generate external data feeds and extracts 
  •  
  • Collaborate with BI Reporting and Dashboard Visualization teams to ensure high quality/timely product delivery (Reports, Dashboards, Data Extracts, etc.) 
  •  
  • Create and maintain technical documentation 
  •  
  • Manage source code versioning and deployments 
  •  
  • Independently analyze and solve complex problems 
  •  
  • Evaluate large and complex data sets 
  •  
  • SQL Query performance tuning/optimization 
  •  
  • Participate in design and code reviews and ensure adherence to best practices 
  •  
  • Support on-going data quality and data integrity initiatives through creation/expansion of audit processes, exception reports, and alerts  
  •  
 

 

Minimum Requirements:

 
     
  • Bachelor's degree in Information Systems, Information Technology or Computer Sciences or equivalent work experience. 
  •  
  • Highly-motivated self-starter who is also comfortable working in a team-oriented and collaborative environment 
  •  
  • Excellent communication and problem-solving skills 
  •  
  • Experience working on agile project team(s) 
  •  
  • Passion for solving complex business problems by designing clean, high-quality solutions 
  •  
  • 5 years of hands-on experience with relational and dimensional data modeling 
  •  
  • 5 years working Microsoft SQL Server databases and SQL Service Integration Services (SSIS) 
  •  
  • Advanced-level SQL development skills, including query performance tuning/optimization  
  •  
 

 

Preferred Skills:

 
     
  • Oracle PL/SQL 
  •  
  • SQL Server Reporting Services (SSRS) 
  •  
  • SQL Server Analysis Services (SSAS) 
  •  
  • Power BI 
  •  
  • C#/VB .Net 
  •  
  • Experience with Team Approach, Personify or other fundraising applications and/or CRM systems.  
  •  
 

 


 

Application Instructions

Please click on the link below to apply for this position. A new window will open and direct you to apply at our corporate careers page. We look forward to hearing from you!

Apply Online