Business Data Analytics Specialist - Public Health Data Analyst

State of Maine•Augusta, ME

About The Position

This role is a pivotal member of the OCP’s Data team, tasked with using data to enable the OCP to better monitor and improve the public health posture of its adult use program, as well as with enabling better data-driven policy and enforcement within the OCP’s Medical Cannabis program. To this end, you’ll work with external agencies to expand the breadth and depth of the OCP’s public health data library, conduct data analysis to help answer internal questions from OCP stakeholders, and build dashboards and other reporting tools to help monitor public health outcomes. You’ll also use your demonstrated knowledge and skills in public health to translate often nuanced scientific terminology into real-world insights for non-technical stakeholders. This is a highly collaborative role where you will work with subject matter experts across OCP–including the OCP Chemist and other business teams–to design data collection systems, analyze program outcomes, and integrate data into operational initiatives. The ideal candidate will also be a proactive project manager, capable to translating needs to action items effectively. They will champion robust data management practices throughout OCP and enhance the organizational culture of data-driven decision making. This position reports to the OCP Director of Data Analytics.

Requirements

Ability to obtain, synthesize, and integrate a broad range of data for use in analytic reporting and data-driven policy development.
Knowledge of public health data, including related data governance principles (e.g. HIPAA), data providers, and data formats.
Knowledge of data query languages and related toolsets.
Knowledge of data modeling and data management techniques.
Knowledge of modern research and data analysis techniques and best practices.
Knowledge of program and project management principles, methods, and techniques for developing, scheduling, and coordinating projects and resources.
Ability to develop KPIs and other metrics used for public health monitoring related to cannabis.
Ability to develop charts, graphs, reports, electronic dashboards, and white papers for a variety of audiences.
Ability to gather, analyze, aggregate and present written information from a wide variety of sources.
Ability to provide concise and effective communications to senior leadership and external parties.
Ability to coordinate assignments and monitor progress related to complex research and data analytics projects.
Ability to identify, document and track opportunities for business process improvement.
Ability to interpret statutes, rules, and policies.
Ability to work collaboratively with various stakeholders to reach agreeable solutions and navigate shifting demands.
Ability to organize work, set priorities, and determine resource requirements.
Ability to develop training programs for both internal and external parties.
A six (6) year combination of education, training, and/or professional experience in project management, systems analysis, business analysis, program specialty, or related field.

Nice To Haves

Demonstrated ability to electronically obtain, aggregate, query, analyze and properly manage a broad range of data sets related to public health from disparate sources for use in analytic reporting initiatives.
Demonstrated ability and experience in gathering, analyzing and translating public health data into detailed functional specifications for real-world solutions.
Demonstrated ability to communicate complex concepts to a diverse group of individuals in a logical, methodical, professional, efficient, and effective manner.
Practical experience with modern data query languages, data management toolsets, data scrubbing and data transformation processes, data lakes and/or data warehouses, and data management best practices.
Practical experience with modern data presentation toolsets, including charts, graphs, tables, spreadsheets, reports, and dashboards. (Examples: Microsoft Excel, SQL, Python, and/or Microsoft Power BI).
Demonstrated ability to perform independent research and analysis on complex datasets to identify patterns, trends, and emerging areas of interest or concern.
Demonstrated ability to develop meaningful metrics and/or key performance indicators used to monitor and improve upon a variety of business processes, and to monitor the overall health of systems, business processes, market operations and evolution.

Responsibilities

Utilize modern data query and analysis techniques and toolsets in order to derive public health conclusions, track trends, and identify areas of potential concern for the industry and/or OCP senior leadership.
Work collaboratively across all OCP teams to identify areas for potential public health improvements and develop plans for implementation and measuring progress.
Provide support for OCP’s inventory tracking, compliance, and licensing systems; ensure each systems’ ability to capture, track and export data meets business and reporting needs.
Identify new or evolving trends which have public health and/or safety implications and provide professional summaries and recommendations to OCP senior leadership.
Develop comprehensive charts, graphs, reports, electronic dashboards, whitepapers and other narratives which effectively document research findings, analytical conclusions, and subsequent recommendations.
Present research findings to OCP policy and rule makers, in addition to the Maine State Legislature, the media, and other external stakeholders when required.
Acquire, extract, transform, store and analyze external data sets related to cannabis use and public health trends to assess outcomes at the state, regional and national level.
Develop training and guidance documents for both internal and external parties.
Lead and/or participate in the development of project planning and requirements gathering to support established goals and objectives.
Develop and maintain documentation for data models, processes, and reporting standards to ensure knowledge sharing, consistency and SOP compliance.
Complete complex research projects with minimal direction and/or supervision.
Collaborate with OCP business teams to design data collection methods, tracking systems and analytical approaches that support operational initiatives and public health outcomes.
Provide operational support for OCP staff and management and help to ensure uninterrupted operation of all technical systems and processes.
Other duties as assigned by the Director of Data Analytics or other OCP leadership.

Benefits

Work-Life Balance – Rest is essential. Take time for yourself using 13 paid holidays, 12 days of sick leave, and 3+ weeks of vacation leave annually. Vacation leave accrual increases with years of service, and overtime-exempt employees receive personal leave.
Health Insurance Coverage – The State of Maine pays 85%-100% of employee-only premiums ($11,857.68-$13,950.24 annual value), depending on salary. Use this chart to find the premium costs for you and your family, including the percentage of dependent coverage paid by the State.
Health Insurance Premium Credit – Participation decreases employee-only premiums by 5%. Visit the Office of Employee Health and Wellness for more information about program requirements.
Dental Insurance – The State of Maine pays 100% of employee-only dental premiums ($365.28 annual value).
Retirement Plan – The State of Maine contributes 14.11% of pay to the Maine Public Employees Retirement System (MainePERS), on behalf of the employee.
Gym Membership Reimbursement – Improve overall health with regular exercise and receive up to $40 per month to offset this expense.
Health and Dependent Care Flexible Spending Accounts – Set aside money pre-tax to help pay for out-of-pocket health care expenses and/or daycare expenses.
Public Service Student Loan Forgiveness – The State of Maine is a qualified employer for this federal program. For more information, visit the Federal Student Aid office.
Living Resources Program – Navigate challenging work and life situations with our employee assistance program.
Parental leave is one of the most important benefits for any working parent. All employees who are welcoming a child—including fathers and adoptive parents—receive forty-two (42) consecutive calendar days of fully paid parental leave. Additional, unpaid leave may also be available, under the Family and Medical Leave Act.
Voluntary Deferred Compensation – Save additional pre-tax funds for retirement in a MaineSaves 457(b) account through payroll deductions.
State employees are eligible for an extensive and highly competitive benefits package, covering many aspects of wellness. Learn about additional wellness benefits for State employees from the Office of Employee Health and Wellness.