Senior Manager of Data and Analytics

Love data? Want to end hunger?

If so, the Mid-Ohio Food Collective (MOFC) might be the place for you.

JOB SUMMARY

For close to a decade, MOFC has been at the forefront of customer-focused applications advancing MOFC's work and gathering data to answer our biggest questions. As the Senior Manager of Data and Analytics for MOFC, you are responsible for enabling the collection, analysis, and use of data across the organization. Whether executing commands in a console, building a new dashboard, writing code in a legacy system, or scripting the next innovation, your work enables and levels up efforts across our organization. This position crosses disciplines with high level architecture and designs, nitty-gritty data engineering and in-depth data science to solve our biggest problems.

RESPONSIBILITIES:

• Design, build, manage, and maintain critical data systems; a data lake for gathering MOFC's data, a data warehouse for supporting MOFC internal business analytics, and data services to support standard and customized needs of MOFC platforms.
• Explore, mine, catalog, and standardize definitions of data from existing MOFC systems, for use within the organization, business applications, and strategic partners.
• Analyze existing systems and propose enhancements or alternatives for storage options. Provide requirements, business analysis and engineering support where needed to implement enhancements.
• Design MOFC grassroots analytics program to train business managers how to understand, analyze, and use data about their work and department to operate more effectively.
• Collect and aggregate data from new and varying data sources; databases, systems, log files, APIs, spreadsheets, and others using automated and one-off approaches to ingest data and enable insights from strategic partners and other third parties.
• Manage the storage, movement, and cleaning of data for the data lake and provide support for ongoing data acquisition pipelines.
• Manage transformations of known data sources to add additional value and create new summaries for different hierarchies and timeframes.
• Identify opportunities and advocate for the value of analyzing data to enhance organizational strategy by developing innovative solutions leveraging advanced analytics.
• Identify and develop solutions to support Machine Learning and Artificial Intelligence approaches by helping to build training and validation data sets, prototype approaches, and deploying models and predictions into MOFC Platforms.
• Design and implement a data clearinghouse to identify, catalog, produce, and support a known library of MOFC analytics needs, especially the grant planning, reporting, and closing cycles.
• Lead peers in MOFC critical initiatives to expand the use of business intelligence tools, and the use of existing turnkey reporting and specialized analytics tools.
• Provide requirements, business analysis and engineering support as needed for MOFC staff and contractors to accomplish key tasks in producing value for MOF's analytics environment. Delegate work where appropriate, monitor progress, and conduct Quality Assurance.
• Conduct ad-hoc analysis as needed to support the data requests process and answer the most nuanced challenges involving the organization's data.

QUALIFICATIONS:

Education and Certifications: Advanced degree in data science, business analytics, or equivalent work experience preferred. Bachelor's Degree in Computer Science or Data Science or a related technical discipline or equivalent experience required.

Experience: 7 years of technology experience with at least 5 years in a data architecture, data engineering, or data science role required. Experience using Amazon Web Services (AWS) services (AWS Route 53, S3, Athena, Spark, AWS Glue) preferred. Experience with Food Banks, food pantries, nonprofit organizations, and hunger initiatives preferred.

Skills/Competencies: Extensive knowledge of data management concepts, strategies, methodologies, architectures, design patterns, and technical standards. Extensive experience with Snowflake, FiveTran, and Airflow. Extensive experience with DBT/Python. Experience with one or more of the following: MySQL (preferred), Redshift, Aurora, PostgreSQL. Experience with Business Intelligence tools such as Tableau or Power BI. Experience with programming languages such as R or Python. Experience with LAMP architectures (Linux, Apache, MySQL, PHP), web technologies (HTML, CSS, JavaScript, jQuery), and visualization libraries (D3, Highcharts)

JOB CONDITIONS:

Normal office environment.

Mid-Ohio Food Collective is a Drug-Free Workplace.

This job description is not to be construed as an exhaustive statement of accountabilities, duties, responsibilities, or requirements. Any individual may be required to perform any other job-related activities or functions requested by his/her manager, subject to reasonable accommodation. Mid-Ohio Food Collective reserves the right to modify this job description to reflect changes in essential job duties made necessary by changing organizational needs.

Mid-Ohio Food Collective is an Equal Employment Opportunity (EEO) employer and does not discriminate on the basis of race, color, national origin, religion, gender, age, veteran status, political affiliation, sexual orientation, marital status or disability (in compliance with the Americans with Disabilities Act) with respect to employment opportunities

Successful candidate must be able to pass standard background check and drug screening.