Database Warehouse Analyst designs and supports data warehouse systems, maintenance processes, and projects. Designs and writes code for ETL data solutions. Being a Database Warehouse Analyst plans and executes data warehouse implementations following system requirements and anticipated usage. Performs data extraction, ensures data accuracy, troubleshoots, and resolves bugs during data warehouse operations. Additionally, Database Warehouse Analyst analyzes business intelligence data and designs and generates reports. Understands and utilizes ETL tools like Informatica and programming languages like Python. Acts as liaison between information technology and business units. Requires a bachelor's degree. Typically reports to a manager. The Database Warehouse Analyst work is closely managed. Works on projects/matters of limited complexity in a support role. To be a Database Warehouse Analyst typically requires 0-2 years of related experience. (Copyright 2024 Salary.com)
The Crohn’s & Colitis Foundation is a non-profit, volunteer-fueled organization whose mission is to cure Crohn’s disease and ulcerative colitis and improve the quality of life for the children and adults affected by these diseases. Our work is dramatically accelerating the research process through our varied research initiatives; we also provide extensive educational and support resources for patients and their families, medical professionals, and the public. In addition, we lead federal and state-based advocacy campaigns to support medical research funding and improve patient access to care. The Foundation’s core values of compassion, integrity, leadership, collaboration, and inclusion inspire and drive every member of our highly performing team.
Position Summary:
The Database Analyst will perform key data management activities to ensure smooth business operation of Foundation’s Constituent Data management platforms which include Salesforce CRM (NPSP), Salesforce Marketing Cloud, DonorDrive and other platforms.
Essential Functions & Responsibilities: