CRM Data Warehouse Manager, BI & Analytics

New York University; New York (NY); Hybrid; USD 125,000 - 145,000; Full time

Job summary

New York University is seeking a Data Warehouse Manager to join the Advancement Services and Analytics team. This role involves maintaining BI data flows, ensuring data quality for reporting, and continuous improvement of user-driven reporting with tools like Tableau and Microsoft BI Stack. The position supports a hybrid work arrangement and includes an annual salary range of $125,000 to $145,000 based on the candidate's experience and qualifications. NYU is committed to equal opportunity and diversity in the hiring process.

Qualifications

• 5+ years of database and applications programming experience.
• Experience with database administration and data warehouse design.
• Ability to write and understand MDX or DAX queries.

Responsibilities

• Lead maintenance of Business Intelligence data flows and Data Warehouse.
• Ensure quality data availability for reporting throughout the organization.
• Engage in continuous improvement of user-driven reporting functionality.

Skills

Business Intelligence experience using Microsoft BI Stack – SSIS, SSAS, SSRS

Microsoft SQL Server administration and development

Extract-Transform-Load (ETL) development

Advanced Structured Query Language (T-SQL)

Reporting using SQL and Tableau

Education

Bachelor's Degree

Master's Degree in relevant field

Tools

Microsoft SQL Server

Tableau

Microsoft Azure

Job description

Position Summary

University Development and Alumni Relations (UDAR) is dedicated to soliciting the private funding necessary to support the strategic goals of the University in teaching, learning, and research. The personnel of UDAR work university-wide as well as within individual schools and colleges of the University to discover, motivate, cultivate, solicit, and steward alumni, parents, faculty, and friends for immediate, long-range, and future financial support, through gifts and pledges to the University, for critical operations such as student aid, faculty support, academic and research program development, and facilities and infrastructure. UDAR's endeavors raise funds for immediate University use and also for the University's endowment.

The Blackbaud Data Warehouse Manager role is under the Advancement Services and Analytics team. Facilitates business intelligence data requirements and information delivery. Lead the maintenance of Business Intelligence data flows and the Data Warehouse. The Manager will combine technical aspects with business needs to ensure quality data, so that information is available for reporting throughout the organization. Engage in continuous improvement of our user-driven reporting functionality through Tableau and other Microsoft products.

UDAR encourages work-life integration for our employees, therefore this position is eligible for a hybrid work arrangement.

Qualifications

• Required Education: Bachelor's Degree
• Preferred Education: Master's Degree in any of these majors: MIS, IT, Business, Computer Sciences, Statistics, Math, Economics, Operational Research or equivalent combination of education and experience.
• Required Experience: 5+ years of database and significant applications programming experience or equivalent combination of education and experience
• Preferred Experience: 7+ years experience with database administration, data warehouse design, and data modeling or a combination of education and experience
• Required Skills, Knowledge and Abilities: Business Intelligence experience using Microsoft BI Stack – SSIS, SSAS, SSRS
• Hands-on experience with Microsoft SQL Server administration and development
• Experience developing reports using SQL
• Experience working with different source data such as SQL Server, Excel, Access, Flat Files, On-Prem, Cloud, APIs
• Hands-on experience with Donor/Alumni Databases such as Blackbaud CRM, Raiser’s Edge, or Advance
• Deep knowledge and understanding of Microsoft .NET programming stack aka C# and VB.NET
• Experience writing REST API calls within SSIS
• Experience working with scripting languages
• Experience developing complex reports and deliveries using SSRS and Tableau
• Experience developing reports using Excel Pivot tables or Tableau with SSAS
• Experience working with various source control solutions
• Ability to write and understand MDX or DAX queries
• Knowledge and understanding of Microsoft BI stack Services
• Knowledge on Microsoft Azure technology
• Preferred Skills, Knowledge and Abilities: Extract-Transform-Load (ETL) development experience using Microsoft SQL Server Integration Services (SSIS) or similar data integration tools
• Advanced Structured Query Language (T-SQL) programming experience, including working knowledge of stored procedures and views
• Advanced Structured Query Language (SQL) programming experience including SSIS and ETL is preferred
• Knowledge of data warehouse methodologies
• Exceptional business analyst skills; ability to complete complex analysis, design, and programming projects
• Ability to multi-task and set task prioritizations
• A minimum of two years of experience with Tableau is preferred
• Experience working at an academic institution and/or advancement context is preferred
• Proven data warehouse implementation and maintenance skills and methods
• Ability to work effectively in a multi-function environment across organizations with and without direct supervision
• Ability and willingness to learn new technologies

Additional Information

In compliance with NYC's Pay Transparency Act, the annual base salary range for this position is USD $125,000.00 to USD $145,000.00. New York University considers factors such as (but not limited to) scope and responsibilities of the position, candidate's work experience, education/training, key skills, internal peer equity, as well as, market and organizational considerations when extending an offer. This pay range represents base pay only and excludes any additional items such as incentives, bonuses, clinical compensation, or other items. NYU aims to be among the greenest urban campuses in the country and carbon neutral by 2040. Learn more at nyu.edu/nyugreen.

NYU is an Equal Opportunity Employer and is committed to a policy of equal treatment and opportunity in every aspect of its recruitment and hiring process without regard to age, alienage, caregiver status, childbirth, citizenship status, color, creed, disability, domestic violence victim status, ethnicity, familial status, gender and/or gender identity or expression, marital status, military status, national origin, parental status, partnership status, predisposing genetic characteristics, pregnancy, race, religion, reproductive health decision making, sex, sexual orientation, unemployment status, veteran status, or any other legally protected basis. All interested persons are encouraged to apply at all levels.