Data Analyst Python Sql Jobs in Madison, WI (NOW HIRING)

The Wisconsin Foundation and Alumni Association (WFAA)*, the private fundraising and alumni relations organization for UW-Madison, is recruiting for a Data Analyst to join our Data Analytics Team. The Data Analyst position provides complex and high-quality data analysis in support of WFAA fundraising, marketing and engagement goals, translates business objectives into analytics solutions, deploys complex data mining, modeling and statistical techniques and summarizes key findings and insights to stakeholders to inform business strategy and optimize results.

• Analyze and segment suspect pools for development, as well as target audiences for engagement and marketing, to maximize business results. Leverage statistical tools and techniques including data mining, predictive modeling, geospatial analysis and multivariate regression analysis.
• Develop quantitative analyses on the dynamics of donor behavior, using behavioral models and other statistical techniques.
• Design complex data analyses of WFAA initiatives including responses to marketing efforts, cultivation, solicitation and stewardship activities.
• Analyze prospect universe and movement of prospects through the pipeline, in order to inform development team assessment and strategy.
• Deliver statistical trend analysis, including performance, forecasting and projection reports.
• Provide campaign design support for marketing efforts.

Internal Consulting

• Collaborate with Research & Prospect Management and Development staff to understand and inform unit prospecting priorities and constituencies.
• Collaborate with Annual Giving, Alumni Relations and Engagement staff to understand and inform marketing and audience segmentation priorities and strategies.
• Present analytical findings to various stakeholders, advising on how to use results to inform business strategy.
• Collaborate with Data Warehouse and Business Intelligence teams to understand data needs and priorities, identify opportunities for analytics services, and operationalize analytics tools into reports.

Data Management Duties

• Identify and manage data acquisition projects in support of analytics, including wealth screening, demographic and behavioral profiles, discretionary spending, etc.
• Advise on data processing and quality assurance activities. Make recommendations for opportunities for improvement through audit reporting, business process and training.
• Manage the capacity, readiness and other modeling or rating scores. Support dynamic scoring and advise on solutions for delivering scores to stakeholders.

• Bachelor’s degree (or higher) in applied quantitative discipline (e.g. statistics, mathematics, economics, or other quantitative sciences) is preferred.
• 2 + years of demonstrated analytical experience preferred, along with experience supporting internal or external clients.
• Solid understanding of relational database concepts. Intermediate SQL (preferably T-SQL) skills including but not limited to complex SQL statements, stored procedures, user defined functions, etc.
• Experience with a data science programing language such as R or Python. Proficiency with at least one of these tools is preferred.

WFAA is committed to provide our employees with an environment that is inspiring, creative and respectful. The Data Analyst is a full time exempt position and reports to the Data Warehouse and Business Intelligence Technical Manager. We offer a competitive salary and an excellent benefits program, which includes a 10% 401k contribution after 1 year of service

Just as the university community benefits from differing viewpoints, perspectives, and experiences, inclusion and diversity are imperative for the success of our mission. WFAA values people and the differences that they bring to the organization, and creates an environment in which all staff members and constituents feel respected and have opportunities to thrive.  

The Wisconsin Foundation and Alumni Association is an Equal Opportunity Employer *The Wisconsin Foundation and Alumni Association is the “doing business as” name of the merged organization comprising the University of Wisconsin Foundation (supportuw.org) and the Wisconsin Alumni Association (uwalumni.com). Its legal corporate name is registered as the University of Wisconsin Foundation.

• Bachelor’s degree (or higher) in applied quantitative discipline (e.g. statistics, mathematics, economics, or other quantitative sciences) is preferred.
• 2 + years of demonstrated analytical experience preferred, along with experience supporting internal or external clients.
• Solid understanding of relational database concepts. Intermediate SQL (preferably T-SQL) skills including but not limited to complex SQL statements, stored procedures, user defined functions, etc.
• Experience with a data science programing language such as R or Python. Proficiency with at least one of these tools is preferred.

WFAA is committed to provide our employees with an environment that is inspiring, creative and respectful. The Data Analyst is a full time exempt position and reports to the Data Warehouse and Business Intelligence Technical Manager. We offer a competitive salary and an excellent benefits program, which includes a 10% 401k contribution after 1 year of service

Just as the university community benefits from differing viewpoints, perspectives, and experiences, inclusion and diversity are imperative for the success of our mission. WFAA values people and the differences that they bring to the organization, and creates an environment in which all staff members and constituents feel respected and have opportunities to thrive.  

The Wisconsin Foundation and Alumni Association is an Equal Opportunity Employer *The Wisconsin Foundation and Alumni Association is the “doing business as” name of the merged organization comprising the University of Wisconsin Foundation (supportuw.org) and the Wisconsin Alumni Association (uwalumni.com). Its legal corporate name is registered as the University of Wisconsin Foundation.