Reporting to the Director, Reporting and Analytics, the Senior Data Analytics Consultant provides fundraising data analysis and reporting services for the executive leadership team of the Development arm of the Office of Advancement.
The Sr. Data Analytics Consultant will be primarily responsible for the development and implementation of measurement and analytics strategies designed to ensure appropriate operational models; to monitor and evaluate applicable metrics to compare and analyze data to support strategic fundraising decisions and process improvement; to ensure communication with senior leadership and synthesize data into useful and insightful information; and to write and automate tools and scripts to increase efficiency and reduce manual efforts.
The Sr. Data Analytics Consultant will design and build data visualizations using diverse data sets and will be instrumental in developing and translating analysis, data modeling and ad hoc decision support to fulfill the needs of the development organization. This includes data analysis and reporting to enhance operational efficiency, encouraging data driven decisions and promoting a higher level of data consumption as well as best practices to improve services and processes of strategic importance to the Development team.
Provides significant data analysis using both descriptive and predictive statistical analysis expertise for the Development leadership team. This work includes, but is not limited to, responsibility for the ongoing design and maintenance of monthly Development performance reports and the fundraising dashboard. It further includes conducting significant data analysis and data mining required to understand the results found and communication of insights to leadership.
This work is accomplished using visual query tools, custom built standard outputs, Microsoft SQL Reporting Services tools, data analysis tools like SPSS or Excel and Tableau.
Position highlights include opportunities to accomplish the following:
Responsibilities:
Data Analysis and Data Mining (40%)
Use statistical methods to analyze fundraising data to identify statistically significant patterns and trends that generate actionable insights
Provide high-confidence-level forecasts that allow the business to make informed decisions
Perform analysis and interpretation of data to demonstrate fundraising outcomes, within specified timeframes and frequencies
Report, Dashboard and Scorecard Creation (40%)
Gather requirements, create queries, build reports and dashboards that integrate multiple sources of data, identify actionable insights and conclusions, and translate complex results into simple visualizations that will empower department leaders to take decisive action
Develop trend analysis reports that monitor key performance indicators and compares them to internal and external benchmarks and uses this data to assist leadership in decision-making, planning and implementing performance improvement strategies Convene colleagues to share information and best practices.
Analyze report results with a focus on explaining changes, inconsistencies and any patters that are identified.
Become an established Subject Matter Expert within the Organization (20%)
Work collaboratively with Development leadership to understand and design analytical approaches to open-ended strategic business problems and communicates the findings to key stakeholders through reports, presentations, storytelling and thoughtful discussion;
Collaborate with the Development leadership team in order to identify trends and opportunities to improve and maximize fundraising revenue
Serve as a technical and educational resource to others on fundraising data and benchmarks, modeling, data acquisition and rapid analysis for insight generation
Performance Objectives
First 1-3 months
Demonstrate basic knowledge and understanding of the higher education advancement industry, with particular emphasis on the major gift fundraising component in particular.
Demonstrate intermediate level understanding of the t-SQL language, SQL Server Reporting Services and Tableau.
Demonstrate basic understanding of the advancement data warehouse.
First 3-6 months
Demonstrate intermediate knowledge and understanding of higher education major gift oriented fundraising.
Assume technical responsibility for the monthly fundraising suite of reports and being transition of existing t-SQL extract – Excel legacy reports to SSRS and / or Tableau.
Assume technical responsibility for the existing SSRS based Fundraising Dashboard and all linked reports.
First 12 months
Demonstrate intermediate knowledge and understanding of the higher education advancement industry.
Assume analysis responsibility for monthly fundraising performance analysis.
Assume business evolution responsibility for monthly reports and the fundraising dashboard.
Why Join Ohio State Advancement Now?
In 2016, The Ohio State University concluded the most successful fundraising effort in its history, with contributions from what is believed to be the most donors ever to a higher education campaign. The But for Ohio State Campaign raised over $3 billion from more than 750,000 donors, shattering the goal of $2.5 billion. Ohio State is now six months away from the public kickoff of the next campaign which coincides with the celebration of the university’s 150th birthday. All members of Advancement are part of creating an inclusive culture that inspires an exceptionally diverse and talented team and are measured on their adherence to the following core competencies: leadership, continuous improvement, teamwork and collaboration, and communication/interpersonal effectiveness.
More about Advancement Reporting and Analytics
Reporting and Analytics (R&A) is one part of the Business Intelligence and Data Science department totaling 15 full-time staff within Advancement. R&A is comprised of 10 staff members with nearly 100 years combined experience working in the Advancement and Enterprise Reporting professions. We are an extremely collaborative group possessing particular technical expertise in t-SQL, SSRS and Tableau. The larger BI team also then possesses extensive experience in Market Research and Data Sciences. Those groups are similarly collaborative in their approach and give the larger BI team experience in market research and advanced statistical techniques. Finally our in group project manager is guiding us in the implementation of the Agile Project Management approach.
Experience Requirements
The selected candidate for this position must have demonstrated success in several areas, including:
Bachelor’s degree in Data Analytics, Statistics, Applied Math, Computer Science, Computer Information Systems or Management Information Systems, Marketing, Psychology or related field; or an equivalent combination of education and experience.
5 years’ experience in a data analyst role.
Experience with enterprise reporting tools (i.e. MS BI Suite).
Two years of experience using SQL with preference to Microsoft T-SQL.
2 years of experience with statistical analysis using statistical packages for analyzing datasets (Excel, SPSS, R, SAS etc.).
2 years of experience visualizing and presenting data.
Desired requirements include:
Master’s degree in Statistics, Business, Computer Science, Economics, Engineering, Mathematics or other quantitative disciplines.
Experience in the non-profit fundraising space.
Familiarity with statistical algorithms such as linear and logistic regression, decision trees, neural networks, etc.
2 years of project management/consulting experience.
Experience working in an Agile SCRUM environment.
2 years’ experience building dashboards.
2 years of experience conducting forecasting models.
You Need To Know
Aside from the unparalleled benefits of working for The Ohio State University and working in the diverse, smart, safe, fun and growing city of Columbus, Ohio, this opportunity will provide exceptional rewards that arise from working for a land grant institution where you will truly feel the impact of your work.
Closing Statement
The Ohio State University is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation or gender identity, national origin, disability status, or protected veteran status.
How to Apply
Please click the "Apply Now" button on this page to find out more about University Advancement and apply online.
Questions may be directed to Greg Bright, Recruiter, at bright.159@osu.edu .
Oct 08, 2019
Full-time
Reporting to the Director, Reporting and Analytics, the Senior Data Analytics Consultant provides fundraising data analysis and reporting services for the executive leadership team of the Development arm of the Office of Advancement.
The Sr. Data Analytics Consultant will be primarily responsible for the development and implementation of measurement and analytics strategies designed to ensure appropriate operational models; to monitor and evaluate applicable metrics to compare and analyze data to support strategic fundraising decisions and process improvement; to ensure communication with senior leadership and synthesize data into useful and insightful information; and to write and automate tools and scripts to increase efficiency and reduce manual efforts.
The Sr. Data Analytics Consultant will design and build data visualizations using diverse data sets and will be instrumental in developing and translating analysis, data modeling and ad hoc decision support to fulfill the needs of the development organization. This includes data analysis and reporting to enhance operational efficiency, encouraging data driven decisions and promoting a higher level of data consumption as well as best practices to improve services and processes of strategic importance to the Development team.
Provides significant data analysis using both descriptive and predictive statistical analysis expertise for the Development leadership team. This work includes, but is not limited to, responsibility for the ongoing design and maintenance of monthly Development performance reports and the fundraising dashboard. It further includes conducting significant data analysis and data mining required to understand the results found and communication of insights to leadership.
This work is accomplished using visual query tools, custom built standard outputs, Microsoft SQL Reporting Services tools, data analysis tools like SPSS or Excel and Tableau.
Position highlights include opportunities to accomplish the following:
Responsibilities:
Data Analysis and Data Mining (40%)
Use statistical methods to analyze fundraising data to identify statistically significant patterns and trends that generate actionable insights
Provide high-confidence-level forecasts that allow the business to make informed decisions
Perform analysis and interpretation of data to demonstrate fundraising outcomes, within specified timeframes and frequencies
Report, Dashboard and Scorecard Creation (40%)
Gather requirements, create queries, build reports and dashboards that integrate multiple sources of data, identify actionable insights and conclusions, and translate complex results into simple visualizations that will empower department leaders to take decisive action
Develop trend analysis reports that monitor key performance indicators and compares them to internal and external benchmarks and uses this data to assist leadership in decision-making, planning and implementing performance improvement strategies Convene colleagues to share information and best practices.
Analyze report results with a focus on explaining changes, inconsistencies and any patters that are identified.
Become an established Subject Matter Expert within the Organization (20%)
Work collaboratively with Development leadership to understand and design analytical approaches to open-ended strategic business problems and communicates the findings to key stakeholders through reports, presentations, storytelling and thoughtful discussion;
Collaborate with the Development leadership team in order to identify trends and opportunities to improve and maximize fundraising revenue
Serve as a technical and educational resource to others on fundraising data and benchmarks, modeling, data acquisition and rapid analysis for insight generation
Performance Objectives
First 1-3 months
Demonstrate basic knowledge and understanding of the higher education advancement industry, with particular emphasis on the major gift fundraising component in particular.
Demonstrate intermediate level understanding of the t-SQL language, SQL Server Reporting Services and Tableau.
Demonstrate basic understanding of the advancement data warehouse.
First 3-6 months
Demonstrate intermediate knowledge and understanding of higher education major gift oriented fundraising.
Assume technical responsibility for the monthly fundraising suite of reports and being transition of existing t-SQL extract – Excel legacy reports to SSRS and / or Tableau.
Assume technical responsibility for the existing SSRS based Fundraising Dashboard and all linked reports.
First 12 months
Demonstrate intermediate knowledge and understanding of the higher education advancement industry.
Assume analysis responsibility for monthly fundraising performance analysis.
Assume business evolution responsibility for monthly reports and the fundraising dashboard.
Why Join Ohio State Advancement Now?
In 2016, The Ohio State University concluded the most successful fundraising effort in its history, with contributions from what is believed to be the most donors ever to a higher education campaign. The But for Ohio State Campaign raised over $3 billion from more than 750,000 donors, shattering the goal of $2.5 billion. Ohio State is now six months away from the public kickoff of the next campaign which coincides with the celebration of the university’s 150th birthday. All members of Advancement are part of creating an inclusive culture that inspires an exceptionally diverse and talented team and are measured on their adherence to the following core competencies: leadership, continuous improvement, teamwork and collaboration, and communication/interpersonal effectiveness.
More about Advancement Reporting and Analytics
Reporting and Analytics (R&A) is one part of the Business Intelligence and Data Science department totaling 15 full-time staff within Advancement. R&A is comprised of 10 staff members with nearly 100 years combined experience working in the Advancement and Enterprise Reporting professions. We are an extremely collaborative group possessing particular technical expertise in t-SQL, SSRS and Tableau. The larger BI team also then possesses extensive experience in Market Research and Data Sciences. Those groups are similarly collaborative in their approach and give the larger BI team experience in market research and advanced statistical techniques. Finally our in group project manager is guiding us in the implementation of the Agile Project Management approach.
Experience Requirements
The selected candidate for this position must have demonstrated success in several areas, including:
Bachelor’s degree in Data Analytics, Statistics, Applied Math, Computer Science, Computer Information Systems or Management Information Systems, Marketing, Psychology or related field; or an equivalent combination of education and experience.
5 years’ experience in a data analyst role.
Experience with enterprise reporting tools (i.e. MS BI Suite).
Two years of experience using SQL with preference to Microsoft T-SQL.
2 years of experience with statistical analysis using statistical packages for analyzing datasets (Excel, SPSS, R, SAS etc.).
2 years of experience visualizing and presenting data.
Desired requirements include:
Master’s degree in Statistics, Business, Computer Science, Economics, Engineering, Mathematics or other quantitative disciplines.
Experience in the non-profit fundraising space.
Familiarity with statistical algorithms such as linear and logistic regression, decision trees, neural networks, etc.
2 years of project management/consulting experience.
Experience working in an Agile SCRUM environment.
2 years’ experience building dashboards.
2 years of experience conducting forecasting models.
You Need To Know
Aside from the unparalleled benefits of working for The Ohio State University and working in the diverse, smart, safe, fun and growing city of Columbus, Ohio, this opportunity will provide exceptional rewards that arise from working for a land grant institution where you will truly feel the impact of your work.
Closing Statement
The Ohio State University is an equal opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation or gender identity, national origin, disability status, or protected veteran status.
How to Apply
Please click the "Apply Now" button on this page to find out more about University Advancement and apply online.
Questions may be directed to Greg Bright, Recruiter, at bright.159@osu.edu .
Associate Provost for Institutional Research Harvard University Cambridge, Massachusetts
Harvard University (Harvard) seeks applications and nominations for the position of Associate Provost for Institutional Research (Associate Provost). Reporting to the Deputy Provost, the Associate Provost leads a team of senior statisticians and analysts who will provide both external and internal reporting expertise for the University.
As leader of Harvard’s Office of Institutional Research (OIR), the Associate Provost will serve as the central internal liaison for the office with other Harvard departments, provide evidence to the Office of the President and Provost (OPP) in support of strategic priorities, and provide analysis capacity to the broader Harvard University community on behalf of OPP. The Associate Provost will ensure ongoing review and shaping of the office’s policies and practices to reflect the changing needs of the department's core functions, and provide leadership for the office’s projects, programs, and reporting methodologies that support key stakeholders. Additionally, the Associate Provost will be the University’s key contact for and coordinator of the University’s accreditation process.
The Associate Provost will focus attention on critical research and policy issues by setting the strategic direction and content for the office's projects, data governance policies, and communications; serving as the key contact for the office with other Harvard departments and leading meetings as the senior department leader; enhancing and extending the office's influence by providing strategic management of partnerships, research convenings, and events; representing the office at local and national conferences and on committees; supervising, coaching, and developing a team of analysts and interns; providing leadership to ensure Harvard’s delivery of accurate and timely reports to the Federal Government and to key data exchange organizations; presenting the work of the office to senior leadership and others within Harvard and to external peers; and in general, developing and implementing creative new ways to support and advance the office’s mission and functions to ensure that OIR’s work moves forward and is integrated into the larger priorities of the University.
Since its founding in 1636, Harvard has been devoted to excellence in teaching, learning, and research, creating knowledge and developing leaders across a breadth of disciplines that make a difference globally. The University has twelve degree-granting schools in addition to the Radcliffe Institute for Advanced Study, offering a truly global education. The University enrolls over 20,000 degree seeking candidates, including undergraduate, graduate, and professional students, and counts more than 360,000 alumni around the world. In 2018, Harvard inaugurated its 29th President, Dr. Lawrence S. Bacow.
The ideal candidate will bring strong analytical skills and a sophisticated understanding of effective, rigorous institutional research in the current higher education context as well as a collaborative leadership style and the capacity to work and communicate productively with multiple stakeholders across diverse perspectives. The Associate Provost must be flexible, intellectually curious, and possess a strong commitment to customer service, while leading, managing, and developing both staff and processes to best meet the needs of a complex organization.
TO APPLY
Please click the "Apply Now" button on this page to begin the application process.
Harvard University has retained the national executive search firm Isaacson, Miller to assist in this search. All inquiries, nominations, and applications should be sent in confidence to:
Dan Rodas, Partner
Carrie Alexander, Managing Associate
Keith Mason, Associate
Isaacson, Miller
Boston, Massachusetts
Harvard University is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, gender identity, sexual orientation, pregnancy and pregnancy-related conditions, or any other characteristic protected by law.
Sep 24, 2019
Full-time
Associate Provost for Institutional Research Harvard University Cambridge, Massachusetts
Harvard University (Harvard) seeks applications and nominations for the position of Associate Provost for Institutional Research (Associate Provost). Reporting to the Deputy Provost, the Associate Provost leads a team of senior statisticians and analysts who will provide both external and internal reporting expertise for the University.
As leader of Harvard’s Office of Institutional Research (OIR), the Associate Provost will serve as the central internal liaison for the office with other Harvard departments, provide evidence to the Office of the President and Provost (OPP) in support of strategic priorities, and provide analysis capacity to the broader Harvard University community on behalf of OPP. The Associate Provost will ensure ongoing review and shaping of the office’s policies and practices to reflect the changing needs of the department's core functions, and provide leadership for the office’s projects, programs, and reporting methodologies that support key stakeholders. Additionally, the Associate Provost will be the University’s key contact for and coordinator of the University’s accreditation process.
The Associate Provost will focus attention on critical research and policy issues by setting the strategic direction and content for the office's projects, data governance policies, and communications; serving as the key contact for the office with other Harvard departments and leading meetings as the senior department leader; enhancing and extending the office's influence by providing strategic management of partnerships, research convenings, and events; representing the office at local and national conferences and on committees; supervising, coaching, and developing a team of analysts and interns; providing leadership to ensure Harvard’s delivery of accurate and timely reports to the Federal Government and to key data exchange organizations; presenting the work of the office to senior leadership and others within Harvard and to external peers; and in general, developing and implementing creative new ways to support and advance the office’s mission and functions to ensure that OIR’s work moves forward and is integrated into the larger priorities of the University.
Since its founding in 1636, Harvard has been devoted to excellence in teaching, learning, and research, creating knowledge and developing leaders across a breadth of disciplines that make a difference globally. The University has twelve degree-granting schools in addition to the Radcliffe Institute for Advanced Study, offering a truly global education. The University enrolls over 20,000 degree seeking candidates, including undergraduate, graduate, and professional students, and counts more than 360,000 alumni around the world. In 2018, Harvard inaugurated its 29th President, Dr. Lawrence S. Bacow.
The ideal candidate will bring strong analytical skills and a sophisticated understanding of effective, rigorous institutional research in the current higher education context as well as a collaborative leadership style and the capacity to work and communicate productively with multiple stakeholders across diverse perspectives. The Associate Provost must be flexible, intellectually curious, and possess a strong commitment to customer service, while leading, managing, and developing both staff and processes to best meet the needs of a complex organization.
TO APPLY
Please click the "Apply Now" button on this page to begin the application process.
Harvard University has retained the national executive search firm Isaacson, Miller to assist in this search. All inquiries, nominations, and applications should be sent in confidence to:
Dan Rodas, Partner
Carrie Alexander, Managing Associate
Keith Mason, Associate
Isaacson, Miller
Boston, Massachusetts
Harvard University is an equal opportunity employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, disability status, protected veteran status, gender identity, sexual orientation, pregnancy and pregnancy-related conditions, or any other characteristic protected by law.
Job Overview:
Texas Monthly is seeking an experienced and passionate data analyst to support successful digital product development, audience growth, and audience engagement. A successful candidate will possess significant experience with Google Analytics, BI tools, SQL, reporting design, and analytical methodologies in order to effectively track, analyze, and develop strategies to grow traffic, deepen engagement, and scale reader loyalty. This role with work closely with editorial, product, technical, and marketing teams to foster a culture of data-driven decision making.
Job responsibilities include, but are not limited to:
Interpret data, analyze results using statistical techniques, and provide ongoing reports regarding all aspects of web traffic and certain marketing activities
Translate data analysis into actionable insights
Ensure data integrity and champion improvements
Proactively conduct deep dive investigations and discover areas for optimization
Become the go-to team member for all data-related decision making by the marketing, editorial, and executive teams
Establish new KPIs and monitor existing KPIs related to all content and audience development initiatives
Be responsible for organization and quality of our data warehouses, Google Tag Manager, Google Analytics, Parse.ly and our Customer Data Platform
Consistently learn and improve your skills in data analytics and related development with off-hours research and share your knowledge with the team regularly
Help translate data into business decisions and insight
Proactively manage and report on metrics and key business goals
Write your own SQL or code necessary for reporting purposes
Discover what questions need to be asked and seek to answer them
Successful candidates will possess the following skills/abilities:
Familiar with Google Analytics, Google BigQuery, Google Optimize, Google Tag Manager, Parse.ly, Power BI (or another BI solution)
Familiar with ETL pipelines
Familiar with HubSpot
Proficient with SQL
Eager and capable of effectively communicating analysis and findings with other team members and stakeholders
Ability to create data feeds and build reporting dashboards in Tableau, Power BI, Data Studio or other dashboarding systems
Prior experience with customer acquisition and leveraging data to optimize for specific metrics
You must love to find the hidden gold and glean business direction from data!
Demonstrated consistent improvement and movement toward goals and a grand vision
Strong communication skills
Education/Experience:
Math, Statistics, or Marketing degree or comparable professional experience
At least 2 years’ experience in a similar role
Application Process:
If you are a qualified candidate and interested in this position, we encourage you to apply by submitting a cover letter and resume with the job title in the subject line.
NO PHONE CALLS OR WALK-INS ACCEPTED. TEXAS MONTHLY IS AN EQUAL OPPORTUNITY EMPLOYER.
Sep 19, 2019
Full-time
Job Overview:
Texas Monthly is seeking an experienced and passionate data analyst to support successful digital product development, audience growth, and audience engagement. A successful candidate will possess significant experience with Google Analytics, BI tools, SQL, reporting design, and analytical methodologies in order to effectively track, analyze, and develop strategies to grow traffic, deepen engagement, and scale reader loyalty. This role with work closely with editorial, product, technical, and marketing teams to foster a culture of data-driven decision making.
Job responsibilities include, but are not limited to:
Interpret data, analyze results using statistical techniques, and provide ongoing reports regarding all aspects of web traffic and certain marketing activities
Translate data analysis into actionable insights
Ensure data integrity and champion improvements
Proactively conduct deep dive investigations and discover areas for optimization
Become the go-to team member for all data-related decision making by the marketing, editorial, and executive teams
Establish new KPIs and monitor existing KPIs related to all content and audience development initiatives
Be responsible for organization and quality of our data warehouses, Google Tag Manager, Google Analytics, Parse.ly and our Customer Data Platform
Consistently learn and improve your skills in data analytics and related development with off-hours research and share your knowledge with the team regularly
Help translate data into business decisions and insight
Proactively manage and report on metrics and key business goals
Write your own SQL or code necessary for reporting purposes
Discover what questions need to be asked and seek to answer them
Successful candidates will possess the following skills/abilities:
Familiar with Google Analytics, Google BigQuery, Google Optimize, Google Tag Manager, Parse.ly, Power BI (or another BI solution)
Familiar with ETL pipelines
Familiar with HubSpot
Proficient with SQL
Eager and capable of effectively communicating analysis and findings with other team members and stakeholders
Ability to create data feeds and build reporting dashboards in Tableau, Power BI, Data Studio or other dashboarding systems
Prior experience with customer acquisition and leveraging data to optimize for specific metrics
You must love to find the hidden gold and glean business direction from data!
Demonstrated consistent improvement and movement toward goals and a grand vision
Strong communication skills
Education/Experience:
Math, Statistics, or Marketing degree or comparable professional experience
At least 2 years’ experience in a similar role
Application Process:
If you are a qualified candidate and interested in this position, we encourage you to apply by submitting a cover letter and resume with the job title in the subject line.
NO PHONE CALLS OR WALK-INS ACCEPTED. TEXAS MONTHLY IS AN EQUAL OPPORTUNITY EMPLOYER.
