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 MOFCs 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 MOFCs 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 MOFs 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 organizations data.

QUALIFICATIONS:

Education and Certifications: Advanced degree in data science business analytics or equivalent work experience preferred. Bachelors 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.

Required Experience:

Senior Manager