Senior Data Analyst - Public Service Coordinator I

Location: Augusta,Maine,United States

Office of Cannabis Policy (OCP)

Senior Data Analyst - Public Service Coordinator I 

Opening Date: February 18, 2025

Closing Date:  March 4, 2025

Job Class Code: CA28
Grade: 28
Salary: $66,206.40 – $94,057.00/Annually
Position Number: 004601205

JOB DESCRIPTION:  

This position reports directly to the Office of Cannabis Policy’s Director of Data Analytics.

The Senior Data Analyst will perform consultative services working with State agencies to gather, process and aggregate data that will directly influence the policies and processes adopted by the OCP.  The Senior Data Analyst will produce complex data queries and a wide variety of electronic dashboards, charts and business reports.  The Senior Data Analyst will also be responsible for determining the best way to present selected metrics to OCP leadership and will serve as a mentor to other Data Analytics team members.  The Senior Data Analyst will resolve operational and data related issues that may arise in the track and trace, licensing, and compliance systems so that the OCP can best achieve their goals and objectives.

Specific duties include:

• Collects, analyzes and organizes complex datasets, facilitates electronic data exchanges with a wide variety of agencies and systems, and produces summaries, reports and informational dashboards.
• Carries out data collection, data clean-up, and report development assignments related to OCP’s data lake.
• Develops effective, sustainable, and repeatable data management processes and trains other staff on these processes.
• Monitors OCP’s data lake and related data feeds and system interfaces to ensure proper operation.
• Actively works to safeguard sensitive and/or confidential data housed in OCP related systems, reports, electronic dashboards, databases, and websites. 
• Partners directly with Office of Information Technology (OIT), OIT-Project Management Office, Professional and Financial Regulations and/or external software vendors to support OCP related initiatives.
• Monitors OCP’s licensing, track-and-trace and compliance systems and related data feeds and system interfaces to ensure proper operation.
• Trains OCP staff and contractors on the proper use of OCP systems and provides operational assistance when necessary.
• Performs business and/or data analysis tasks as assigned by OCP senior leadership.
• Serves as a mentor for other Data Analytics staff and advises OCP leadership of potential enhancements to existing systems and/or processes that would better support our operational needs and overall mission.
• Accurately captures OCP business processes, translates business processes into system and/or data requirements, and develops project plans to help ensure that developed solutions match evolving rules, regulations, and procedures.
• Identifies and advises OCP senior leadership of emerging industry trends and related public health and/or public safety issues related to cannabis. 
• Facilitates the development of performance measures; integrates performance measures into business processes; and tests, audits, and validates system improvements.

KNOWLEDGES, ABILITIES AND SKILLS REQUIRED:

• Knowledge of statistical analysis techniques
• Proficient in SQL
• Proficient in a programming language used for data analysis (e.g. Python, R)
• Proficient in Microsoft 365 (Word, Excel, PowerPoint)
• Proficient in Microsoft Power BI
• Experience with Microsoft Azure, or other cloud hosting platform
• Knowledge of database design principles & tools
• Knowledge of and ability to implement export, transform, load (ETL) processes
• Ability to work effectively within an agile project management system.
• Ability to autonomously translate feedback from non-technical stakeholders into technical requirements.
• Ability to organize work and document progress.
• Ability to write technical documentation and reports.
• Ability to work independently with minimal supervision.
• Ability to serve as a technical mentor to other t