Data Scientist

The Ohio State University

Columbus, OH

Summary:

The Office of Advancement’s Data Science team delivers wisdom in data by interacting with partners to translate problems into analytical solutions.  The team delivers advanced solutions utilizing a variety of data sources and types to craft compelling and scalable advanced analytical and machine learning products that increase awareness, engagement, advocacy, and fundraising results for the university.

The Data Scientist works with analytic and business partners in a multi-faceted environment combining higher education, fundraising, engagement, and marketing to develop strategy and deliver actionable, data-driven insights and solutions. They conceptualize and create analytic strategies for complex issues, design flexible and reusable analytic tools and models, manage multiple projects simultaneously, operationalize their findings and models, translate work products into meaningful guidance, develop and deliver presentations and data visualizations, and communicate effectively with business partners.

This position serves as a technical contributor for advanced data analytics initiatives, creating value to leadership by compiling and analyzing business data from within Advancement and the university using our CRM, digital engagement platforms and other internal and external sources to provide a 360-degree view of our constituents.  They are responsible for generating solutions to existing business challenges and studying the business to ask (and answer) questions nobody has asked before.

Reporting to the Associate Director, the Data Scientist is expected to be a strong technician who keeps abreast of current practices and trends, and is able to translate technical jargon in a professional manner when working with and presenting recommendations to a diverse group of business partners and clients. This position must exhibit agility when competing and/or shifting priorities exist. They must demonstrate a desire to create business value over all else, even when the competitor is statistical elegance.  Conversely, they show continual improvement of theoretical and applied skills with evidence of a desire to continue technical learning and growth – both as a statistician and a business professional.

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.

Duties and Responsibilities:

70%   Advanced Analytics and Predictive Modeling – Evaluate the current operational environment and identify opportunities to leverage advanced analytics.  Consult with business partners to understand, align, and deliver analytic work to support business objectives and priorities. Complete data science projects from start to finish, including data blending and wrangling, exploratory analysis, feature creation and selection, and model training and evaluation.  Build and deploy prototypes to demonstrate solutions and prove concepts.

Proactively identify and test sources of new data.  Utilize advanced SQL to create complex datasets.  Manage, acquire, clean, and blend data from multiple sources to support analyses. Handle missing data and transform and explore data for understanding and further analyses.  Build re-usable scripts to automate and create efficiencies. Leverage a wide range of data analysis, machine learning, and statistical modeling algorithms and methods to solve business problems, develop new predictive models and scoring, and provide insight and direction.  Identify the right algorithms and statistical techniques for specific projects based on the business problem and any limitations. Blend techniques as needed for optimal performance.

Develop best-in-class solutions, tools, and data visualizations that answer strategic questions.  Work with colleagues to operationalize models and products where possible. Create, package, and communicate analytic work using appropriate medium for relevant insights, including impactful story line and applicable data visualizations.  Create training documentation.  Consult with business partners and end-users on interpreting, understanding, and applying scoring and analysis to ensure all teams are as effective as possible. Easily explain concepts in a non-technical way that the audience can understand.

Build scripts, documentation, packages, and systems for repeatable, reusable and reproducible analyses.  Demonstrate excellent organization skills throughout the development of analytical solutions by following team standards for documentation, code management, project organization, etc.

20%   Analytical Strategy – Work with the Associate Director to develop and implement data strategy, department standards, and best practices; identify opportunities for external data acquisition; and propose effective data architecture and technology infrastructure to support analytical activities and increase operational efficiency.  Ensure consistency of approach related to data extraction, analysis techniques, and key findings. Work with the Associate Director to develop internal documentation for commonly used data tables and files.  Identify and communicate existing gaps or issues in the data.

Promote data-driven culture by developing documentation and training materials to continually educate and promote existing data products and data usage among Advancement and university staff. Actively contribute to the continuous learning mindset of the organization by bringing in new ideas and perspectives that stretch the thinking of the group.  Serve as a technical resource and subject matter expert to others in advanced analytics, statistics, and machine learning.  Build and keep up with the knowledge of literature, practices, and techniques in data science communities, as well as continually grow knowledge and understanding related to Advancement and university business areas. Understand Advancement and university information systems and be a subject matter expert on the data and its usage.

10%   Other duties as assigned

Required:

• Bachelor’s degree in Data Science, Data Analytics, Statistics, Applied Math, Computer Science, Computer Information Systems or Management Information Systems, Marketing, or Psychology preferred
• Five+ years of analytics or data science experience in a business environment to include at least three years’ experience building, validating, and leveraging machine learning models and at least two years’ experience analyzing and synthesizing data and presenting usable insights and recommending courses of action;
• Proficiency in modern analytics programming languages, like R and/or Python, as well as data extraction, manipulation, and programming using SQL
• Strong foundation knowledge statistics/applied mathematics leveraged in a business or marketing setting
• Proven success translating ambiguous business problems into a conceptual analytical and technical architecture
• Strong skills manipulating missing / corrupt / unstructured data from multiple data sources to deliver key insights

Desired:

• Advanced degree in Data Science, Statistics, Business, Computer Science, Economics, Engineering, Mathematics or other quantitative disciplines
• Two+ years’ experience visualizing and presenting data for stakeholders using advanced data visualization tools like Tableau, D3 or Shiny, etc.
• Experimental test design experience;
• Experience with natural language processing
• Knowledge of full life cycle development for advanced analytic projects including experience using agile frameworks
• Experience working with digital analytics data and projects
• Experience migrating statistical models into production environments and/or integrating advanced analytics into production processes
• Understanding of enterprise data warehouse, big data, cloud, BI & analytics, content management, and data management
• Experience in the higher education or non-profit fundraising space.

In accordance with the Disaster Preparedness and University State of Emergency Policy 6.17 this position has been designated as an essential position.

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:

If you are interested in being considered for the position, review the full job description and qualifications and apply online at https://osujoblinks.com/r3qa

Senior Data Analytics Consultant

The Ohio State University

Columbus, OH

Position Overview

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

1)     Demonstrate basic knowledge and understanding of the higher education advancement industry, with particular emphasis on the major gift fundraising component in particular.

2)     Demonstrate intermediate level understanding of the t-SQL language, SQL Server Reporting Services and Tableau.

3)     Demonstrate basic understanding of the advancement data warehouse.

First 3-6 months

1)     Demonstrate intermediate knowledge and understanding of higher education major gift oriented fundraising.

2)     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.

3)     Assume technical responsibility for the existing SSRS based Fundraising Dashboard and all linked reports.

First 12 months

1)     Demonstrate intermediate knowledge and understanding of the higher education advancement industry.

2)     Assume analysis responsibility for monthly fundraising performance analysis.

3)     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. Learn more here:  https://hr.osu.edu/careers/.

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 visit www.advancement.osu.edu to find out more about University Advancement and apply online https://osujoblinks.com/ehqt. Questions may be directed to Greg Bright, Recruiter, at bright.159@osu.edu.

Here at Scotts Miracle-Gro there is no such thing as a typical day.  Our culture is constantly energized by new and exciting growth opportunities and at a rapid pace.  Every Associate plays an important role in providing innovative solutions for today’s gardeners and growers and contributing new ideas to improve operations. In our company you need grit, it is what we were founded on over 150 years ago and is what keeps us growing. Regardless of your level in the organization there is a platform for your voice to be heard and the ability to influence change. Family, community and hard working values are weaved into all that we do. Come grow with us, where we develop and nurture the next generation of leaders. ​

We are looking for a Performance Marketing Analyst who will join our Performance Marketing team. This position will be based at The Scotts Miracle-Gro world headquarters in Marysville, a suburb of Columbus, OH. Not familiar with Columbus? Visit columbusregion.com/columbus-2020/

The Performance Marketing Analyst will serve as an integral member of the Performance Marketing team. As a member of the team, this position will work in a collaborative environment with other subject matter experts to deliver a range of support including but not limited to media operations, media execution and media optimization.

This position will primarily support paid media with a focus on brand media and performance media digital campaigns. The role will also support broader digital analytics including Scotts owned-channel digital platforms.

In this role you will:

• Implement digital campaigns. Experience with Facebook Ad Accounts, Facebook Business Manager, Google Adwords and Google Campaign Manager a strong plus. From campaign setup including operational and execution support across various digital media campaigns
  • Implement classification mappings
  • Define taxonomy standards
  • Validate campaigns across various agency partners
  • Validate 3rd party marketing pixels are firing correctly
  • Ensure ad trafficking is following all standards
• Work with Media Team to execute media pre-campaign workflow and timelines, including operational project tasks, creative deliverable tasks, and creative asset execution timelines to ensure on-time launches for all programs
• Partner with Marketing Services and Media agencies to monitor reporting on media performance including surfacing proactive learnings for the broader Marketing team
  • On a weekly basis, share audience insights reports with all media partners
• Partner in Media Mix Analysis for brand strategy alignment and data validation as needed
  • On a weekly basis, ensure all data is QA’ed and mapped appropriately
• Collaborate with owned channel stakeholders sharing any appropriate digital programs that could be repurposed and to ensure appropriate online destinations for digital programs
• Aid Performance Marketing & Analytics team in developing monthly Marketing Performance Reviews for each SBU
  • Critical for the role to have strong presentation skills. This would include the actual construction of the presentation
• Work with Media Team to reconcile budget and ensure documented processes are followed
• Assist in developing and implementing a 2POE (2nd pair of eyes) process for Performance Marketing and Analytics Team and help develop a 2-3 deep plan for coverage within the team. Responsible for documenting these processes
• 40% Work with advertising partners, media agencies, creative agencies and Marketing Services team to ensure the timely creation and development of digital advertising
• 40% Support in monitoring, tracking and providing regular reports on DTC advertising performance and make optimization recommendations in season and often
• 20% Create Performance Marketing and Analytics analysis and presentations

The perfect person will have:

• Minimum of four years of professional experience in marketing, direct sales or related marketing field
• Education equivalent to Bachelor’s Degree or higher; marketing focus a plus
• Fundamental knowledge of digital media, web development, and creative digital production
• Fundamental knowledge of ad trafficking through Google, Facebook, Amazon, and other channels
• Strong organizational skills; ability to handle multiple tasks, meet deadlines and manage priorities – Experience using JIRA a plus
• Strong presentation skills including both the creation and delivery of content
• Experience with these platforms strongly preferred: Facebook Ads Manager, Facebook Business Manager, Google DoubleClick Campaign Manager, Google Adwords, Adobe Analytics

What we do for our associates (just to list a few cool ones):

• Offer extremely competitive benefits including: Health, Dental and Vision coverage.
• Onsite wellness center which includes: 2,400 sq. ft. fitness center, Walgreens pharmacy and Doctor’s office.
• Beautiful campus and corporate offices designed like a log cabin offering free coffee, chef run cafe and the best crushed ice!
• Unbelievable 401K match and discounted stock purchasing program.

Not interested in this role? Stay up to date on future opportunities by joining our ScottsMiracle-Gro and Hawthorne Gardening talent networks.

Scotts is an EEO Employer, dedicated to a culturally diverse, drug free workplace.

EEO/AA Employer/Minority/Female/Disability/Veteran/Sexual Orientation/Gender Identity

Notification to Agencies:

Please note that the Scotts Miracle-Gro company does not accept unsolicited resumes from recruiters or employment agencies. In the absence of a signed Master Service Agreement, and specific approval to submit resumes to an approved requisition, the Scotts Miracle-Gro company will not consider or approve payment regarding recruiter fees or referral compensations.

The Digital Analytics Consultant role will be responsible for client management, advanced implementations of Google Analytics, auditing and troubleshooting existing configurations, and reporting, dashboards and education to improve clients’ digital marketing initiatives.

Our company was started with one principle – we are going to provide the best workplace for the best people and as long as we keep our eyes on this #1 goal, all other things will fall into place. This strategy has been extremely successful and we are thrilled to be #1 Employer in Ohio, #1 for Cincinnati, and ranked on national lists such as Ad Age’s Best Places to Work and Inc 5000 Fast Growing Companies (4 years strong).

If you are looking for a place that you can drive impact, be a part of an amazing culture, and have your hands in digital analytics — this might just be the perfect match for you.

Things you will be doing as the Analytics Consultant:

• Identify client objectives and map suitable analytics solutions, ensure that all required performance data can be reliably tracked and reported
• Produce analytics audit reports for corrective or advanced GA tracking and data collection architectures
• Deliver reports and findings to clients in-person or via conference calls
• Educate clients on the importance of online measurement & provide best practice guidance for technical aspects of analytics
• Provide instruction on campaign tagging and additional on-site tracking
• Provide guidance to data analysts to produce marketing dashboards via Google Docs, Excel and various APIs (e.g. Google Analytics)
• Train clients on Suite 360 products such as Google Analytics, Google Tag Manager and Google Data Studio
• Assist the product team with Tag Governance and other technical products
• Work with some of the largest brands in the CPG, Retail, and News & Media Industries.

Join InfoTrust and find out why it is so exciting to join a fast-growing technology company. 

Requirements

The successful Digital Analytics Consultant will have the following background & skills:

• You have a Bachelor’s degree in analytics, statistics, marketing, or other related field
• You have experience utilizing and implementing Google Analytics AND/OR Adobe Analytics — We can only consider you if have experience with at least one of these platforms
• Tech Savvy: you pick up new technology quickly and have experience in web design, tag governance, or similar technology
• You are a great communicator, with the ability to talk with clients and other partners
• Real passion for helping clients solve complex business and marketing questions
• You can work independently and prioritize multiple projects
  Project Management experience would be a plus
• You are a self-starter that seeks knowledge and expertise in digital analytics

Location: Due to the recent recognition from the State of Ohio and the Job Creation Grant, we prefer that our next hire is in the Ohio area. Our physical location is in Cincinnati, but we are considering expanding our remote base in Columbus.

Other than an awesome culture, and free lunch, we also offer: Free Health, Dental and Vision Insurance (seriously), Unlimited PTO, Flexible Work Schedule, a generous Parental Leave policy, 401K with match, Tuition Reimbursement, Gym reimbursement and much, much more.

InfoTrust is committed to a diverse workforce and we are an equal opportunity employer. We evaluate applicants regardless of an individual’s age, race, color, gender, religion, national origin, sexual orientation, disability, or veteran status.

Social Media Production Manager

The Ohio State University

Columbus, Ohio

The Social Media Production Manager is responsible for producing visual and creative content for enterprise social media platforms while remaining fluent in social media tactics, video and multimedia production, and staying current with industry trends. This position partners with multimedia, designers and writers to develop creative assets that can be leveraged on enterprise accounts and across the campus community, and provides coverage for events on campus as necessary. They will assist with social media policy implementation as it relates to maintaining brand standards across the campus environment. This role will require occasional evening and weekend work.

A member of the University Marketing team and reporting to the Senior Director of Social Media, they must possess strong written and verbal communication skills, be able to handle multiple projects with changing priorities and work in a collaborative matrix organization.  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.

Duties and Responsibilities:

60%   Develop and manage creative, visual content production for content on YouTube, Facebook, Twitter, LinkedIn, Instagram and Snapchat, with potential to add new platforms. This role will be responsible for co-producing social video content, including storyboarding, shoot coordination and SEO optimization with an eye toward specific audience-centric channel strategies. Partner with multimedia, designers and writers to develop creative assets that can be leveraged on enterprise accounts and across the campus community for relevant campaign work. Execute paid content boosting, digital campaigns and test-and-learn opportunities. Provide coverage for events on campus as necessary.

30%   Provide consultation and coordinate social media campaigns with campus social media communicators, as well as external influencers. Assist with social media policy implementation as it relates to maintaining brand standards across the campus environment. Maintain Ohio State’s brand voice and character, tailored to defined audiences on respective platforms.

10%   Other duties as assigned, to include staying abreast of new and emerging social media tools, platform capabilities, etc. to share within the enterprise.

Required:

Bachelor’s degree in marketing, communications, multimedia, video production, journalism or related field, or an equivalent combination of education and experience; 3+ years of professional social media or multimedia marketing experience; Proficiency in developing multimedia assets tailored to social media channels; Proven ability to produce for creative, visual storytelling; Strong understanding of content marketing and reputation management

Desired:

Experience with audience-centricity, integrated marketing planning; Ability to interpret social media analytics, develop insights and optimize; Working knowledge of social media paid boosting and advertising; Experience with crisis management and communication

Please visit www.advancement.osu.edu to find out more about University Advancement and apply online for job opening number 449278 at https://osujoblinks.com/pzc2. Questions may be directed to Greg Bright, Recruiter, at bright.159@osu.edu.

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.

Senior Web Marketing Analyst – Strategy

You have a life. We like that about you.
At OCLC, we believe you’ll do the best work of your life when you’re living the best life possible.

We work hard to build the technology that connects thousands of today’s libraries. But we also work hard to make a job at OCLC a meaningful part of a balanced life- not a substitute for one.

The Job Details are as follows:

Discover.  Innovative.  Collaborate.  Inform. A few words we use to describe a career at OCLC.

OCLC, a worldwide library services organization headquartered in Dublin, Ohio, is a leader in information technologies and innovative online services. With office locations around the globe, OCLC employees are dedicated to offering premier services and software to help libraries cut costs while keeping pace with the demands of our information-driven society.

The Senior Web Marketing Analyst is a member of the Web Marketing team within OCLC’s Corporate Marketing group. This team manages the OCLC website to build effective use of our technology platforms to meet marketing and sales needs, while anticipating and planning for future needs to best reflect OCLC’s technology leadership and our global library community.

You will work with marketing colleagues and cross-functional internal partners to make the website the hub of a multi-faceted digital marketing program incorporating search marketing, social media, email, forms, member engagement, and more. The strategy focus of this position is responsible for driving and articulating the program effectiveness by analyzing current strategies, recommending and implementing optimizations for the website to improve integration with digital campaigns, and interpreting and detailing measurements.

Excellent candidates will have knowledge and experience with leading efforts in:

Working with marketing and sales teams to understand business goals and themes in order to develop strong digital marketing strategies with specific KPIs,
Developing content strategies and architecture that effectively drive lead conversion and customer engagement, and
Continuously improving digital marketing strategies by capturing and analyzing appropriate data and metrics to interpret trends and optimize results.
Responsibilities:

Web marketing: Work closely with internal teams and digital marketing partners, helping to integrate and align marketing campaigns and content across social media, email marketing, sales, and other marketing teams.
Web strategy and planning: Review, recommend, and implement strategic web solutions, including content, layout, and architecture improvements, coordinating strategy and execution with marketing, sales, design, and development.
Content management and architecture: Develop the content strategy and information architecture of the website based on user needs, analytics data, and marketing best practices.
Search and SEO: Use and champion SEO best practices and keyword strategies. Analyze data from external search engine consoles and website search reporting to inform content and keyword strategies.
Qualifications:

Bachelor’s degree in Marketing or related field
5+ years experience in website content creation and management
3 years experience with website content marketing, customer journeys, and marketing technology tools
Experience planning, creating, and implementing personalized or targeted content and using targeting tools such as Adobe Target or Optimizely
Demonstrated knowledge of HTML coding and website content layout best practices
Experience with web analytics tools
Experience with and demonstrated knowledge of SEO concepts, content testing, and optimization
Strong desire to continue to learn and grow
Embraces change and able to react quickly to program alterations and task modifications
Strong organizational and analytical skills
Excellent writing, editing, verbal, and interpersonal skills
Able to engage stakeholders at various organizational levels and effective in promoting ideas while exhibiting tact and sensitivity
Excels at working collaboratively with team members and colleagues as well as independently
Desirable But Not Required:

Experience with Adobe Experience Manager content management system
Experience with Adobe Creative Cloud
Experience with Siteimprove website quality and analytics service
Experience with Salesforce Marketing Cloud and/or Pardot marketing technology platforms
Experience with Atlassian Jira project management tool
Experience with website translation process

Senior Data Analytics Consultant

The Ohio State University

Columbus, Ohio

Summary:

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.

The Senior Data Analytics Consultant must have excellent verbal and written communication skills, including excellent customer relationship skill sets with the ability to communicate technical concepts in non-technical business terms, be able to work both independently and as part of a team, have the ability to balance competing priorities, manage multiple concurrent projects, identify problems and anticipate needs, resolve data problems, create and maintain documentation for processes, exceptions, and decision making criteria for projects and ongoing processes and is expected to exhibit strong written and verbal communication skills and behaviors associated with the Office of Advancement’s core competencies: Leadership, Continuous Improvement, Teamwork and Collaboration, and Communication / Interpersonal Effectiveness.

40%     Data Analysis and Data Mining

Uses statistical methods to analyze fundraising data to identify statistically significant patterns and trends that generate actionable insights; Provides high-confidence-level forecasts that allow the business to make informed decisions; Performs analysis and interpretation of data to demonstrate fundraising outcomes, within specified timeframes and frequencies; Prepares and presents reports and recommendations for the leadership team in a manner that is understandable by non-technical and/or non-statistical staff; Partners with other teams and provides data as needed to produce reports/analysis.

40%     Creates Reports, Dashboards and Scorecards

Gathers requirements, creates queries, builds 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; Develops 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; Analyzes report results with a focus on explaining changes, inconsistencies and any patters that are identified.

15%     Subject Matter Expertise

Works 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; Collaborates with the Development leadership team in order to identify trends and opportunities to improve and maximize fundraising revenue; Serves as a technical and educational resource to others on fundraising data and benchmarks, modeling, data acquisition and rapid analysis for insight generation; Develops strong internal relationships with development leadership to assess challenges and opportunities and evangelizes new ideas and insights; Collaborates with leadership, end users, IT and other stakeholders to make recommendations and integrate data discoveries and processes into operational capabilities; Develops presentations to summarize and communicate key messages from complex analyses to senior management, sponsors and colleagues in a succinct, straightforward, easily understood manner; Works independently and collaboratively within the team to achieve the desired outcomes of an analytical project;  Actively contributes to the continuous learning mindset of the organization by bringing in new ideas and perspectives that stretch the thinking of the group; Educates decision-makers to use our data assets more effectively through new tools and techniques; Becomes a subject matter expert and trusted advisor in the fundraising analytics discipline; Be regarded as a strategic thought leader and practical solution implementer;

5%       Other duties as assigned.

Experience:

Required:

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; three years of experience using SQL with preference to Microsoft T-SQL; 5 years of experience using Microsoft’s business intelligence suite or something comparable; 2 years of experience conducting forecasting models; 3 years of experience with statistical analysis using statistical packages for analyzing datasets (Excel, SPSS, R, SAS etc); 3 years of experience visualizing and presenting data for stakeholders using advanced data visualization tools like Tableau, D3 or ggplot, etc.; 2 years’ experience building dashboards;

Desired: 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.

In accordance with the Disaster Preparedness and University State of Emergency Policy 6.17 this position has been designated as an essential position.

To apply, please visit:  https://osujoblinks.com/kso0

Also, please visit http://advancement.osu.edu/ to learn more about the Ohio State University Office of Advancement.

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 identity, national origin, disability status, or protected veteran status.