Data Warehouse Developer

This job is no longer available

Search for More Jobs
Alzheimer's Association
Chicago, IL, USA
Full-time

The Data Warehouse 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. 

Areas of Responsibility: 
  • 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    
Educational Background: 
Bachelor's degree in Information Systems, Information Technology or Computer Sciences or equivalent work experience.  
Skills/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.    
How to Apply: 

https://jobs.alz.org/data-warehouse-developer-remote-based/job/11404541

Job Function: 
Technology / Data Management

Organization Info

Alzheimer's Association

Overview
Headquarters: 
Chicago, IL, United States
Website: 
alz.org
Founded: 
1980
About Us
Areas of Focus: 
Medical Research
Diseases / Disorders
Association / Union
Mission: 

The Alzheimer’s Association is the leading voluntary health organization in Alzheimer's care, support and research. Our mission is to eliminate Alzheimer’s disease through the advancement of research, to provide and enhance care and support for all affected, and to reduce the risk of dementia through the promotion of brain health. Our vision is a world without Alzheimer’s®.

Listing Stats

Post Date: 
Nov 20 2019
Active Until: 
Dec 20 2019
Hiring Organization: 
Alzheimer's Association
industry: 
Nonprofit