Apply on Employer Site

Mid-Ohio Food Collective · 3 weeks ago

Senior Manager of Data and Analytics

Grove City, OH

Full-time

Onsite

Mid, Senior Level

$93K/yr - $93K/yr

7+ years exp

Mid-Ohio Food Collective (MOFC) is focused on ending hunger through data-driven solutions. The Senior Manager of Data and Analytics will enable the collection, analysis, and use of data across the organization, designing and managing critical data systems and leading initiatives to enhance data utilization for strategic decision-making.

Non-profit Organization Management

Comp. & Benefits

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

Qualification

Data architectureData engineeringData scienceAmazon Web Services (AWS)SnowflakeFiveTranAirflowDBTPythonMySQLTableauRLAMP architectureHTMLCSSJavaScriptJQueryD3Highcharts

Required

Bachelor's Degree in Computer Science or Data Science or a related technical discipline or equivalent experience required

7+ years of technology experience with at least 5+ years in a data architecture, data engineering, or data science role required

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

Preferred

Advanced degree in data science, business analytics, or equivalent work experience preferred

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

Experience with one or more of the following: MySQL, 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)