Digital Automation and Reporting Specialist

Digital Automation and Reporting Specialist Portland Mental Health & Wellness

• 2.7 Portland, OR Job Details Full-time $80,000
• $105,000 a year 17 hours ago Benefits Commuter assistance AD&D insurance Paid holidays Disability insurance Health insurance Dental insurance 401(k) Flexible spending account Vision insurance 401(k) matching Life insurance Qualifications Performance dashboard reports Authentication Dashboard development Data Integration (Data management) Electronic health records (EHR) management Achieving HIPAA compliance Procedural guides Microsoft Power Automate Technical documentation Maintaining patient confidentiality System design HIPAA Data reporting Training material drafting IT experience within healthcare Access control implementation Implementing APIs Data analytics Project management software Technical Proficiency Stakeholder management Full Job Description We recognize the health disparities of people of color, people from working class backgrounds, women and LGBTQ people.

We believe that the experiences of these communities must be valued in the work we do. Hence, we strongly encourage applications from people with these identities or who are members of other marginalized communities. For immediate consideration, please submit a resume and cover letter with our application form . Portland Mental Health & Wellness is a thriving private practice and training practice with four locations in Portland, as well as one location in Salem. We are a collaboration of psychologists, psychiatric prescribers, counselors, marriage and family therapists and our trainees. We emphasize relationship first and foremost and diagnosis and treatment from within that relationship. We strongly emphasize trauma informed care, cultural competency, establishing comfort and safety for patients, and coordination of care with primary care doctors, specialists, pediatricians, schools, and other mental health clinicians. —

Digital Automation and Reporting Specialist Location:

Portland, OR (or remote from OR, WA, CO, FL, or NC)

Supervisor:

Executive Director Employee Classification :

Exempt (Salaried),

Full-Time Hours:

Full-Time, 40 hours per week

Compensation:

range of $80,000 to $105,000 annually DOE —

Primary Function:

PMHW is seeking a full-time Digital Automation and Reporting Specialist to lead the development, management, and optimization of digital forms, workflow automations, reporting tools, dynamic KPI dashboards, and ClickUp-connected systems across the organization. This role is ideal for someone who combines strong technical automation skills with systems thinking, operational problem-solving, data analysis, and careful attention to HIPAA-compliant workflow design. The Digital Automation and Reporting Specialist will be responsible for building and maintaining Cognito Forms, creating and managing automations in Microsoft Power Automate, supporting integration with ClickUp, designing and maintaining dynamic KPI dashboards in Google Data Studio and ClickUp Dashboards, and helping PMHW improve the efficiency, consistency, reliability, and visibility of key administrative and operational workflows. This role requires careful attention to HIPAA-compliant automation design, including secure data handling, appropriate access controls, and thoughtful management of systems that may interact with protected health information. This role requires someone who is highly organized, deadline-driven, and able to independently manage multiple concurrent projects using ClickUp as both a personal/project management tool and a platform for workflow automation design. Over time, this position will also help prepare PMHW for and eventually support API-based integrations with EHR systems as those platforms become available for secure API access. This includes familiarity with the basics of API connectivity, including HTTP requests, authentication methods, webhooks, and structured data exchange across systems.

Essential Functions:

Forms and Workflow Development Design, build, maintain, and improve Cognito Forms for operational, administrative, and clinical-support workflows Translate stakeholder requests into well-structured digital forms with branching logic, calculations, approvals, routing, and data capture workflows Ensure forms are user-friendly, reliable, scalable, and appropriately secured Review and improve existing forms for efficiency, usability, consistency, and maintainability Maintain internal standards for form structure, naming conventions, and organization Automation and Systems Integration Build, maintain, and optimize workflows in Microsoft Power Automate Create and support integrations between Cognito Forms, ClickUp, Google reporting tools, and other operational systems Use, or develop working capability in, Keragon and Make to expand PMHW's automation and integration capacity Develop automations for notifications, approvals, task creation, escalations, reminders, follow-up steps, workflow routing, and reporting support Build and support automations and integrations that rely on foundational API concepts, including HTTP requests, authentication methods, webhooks, and structured data exchange between systems Troubleshoot failures, logic issues, sync problems, and broken dependencies Proactively identify opportunities to reduce manual work and improve operational efficiency through automation ClickUp Administration, Project Management, and Workflow Support Use ClickUp as a project management platform to organize, prioritize, track, and advance automation work across multiple initiatives Manage assigned projects in a timeline-driven and deadline-oriented manner, with clear follow-through and visibility into progress Configure and maintain ClickUp spaces, lists, tasks, custom fields, templates, statuses, dashboards, and related workflow structures Ensure form submissions route accurately into ClickUp for tracking, ownership, accountability, and follow-through Build and maintain automations that use ClickUp as both a project management tool and an operational workflow system Improve workflow visibility and coordination across teams by aligning ClickUp structures with actual operational processes Help develop project tracking practices, task accountability systems, and workflow structures that support timely completion of work KPI Dashboards, Reporting, and Data Analysis Design, build, maintain, and improve dynamic KPI dashboards in Google Data Studio and ClickUp Dashboards Configure ClickUp Dashboards to provide actionable, up-to-date visibility into key operational, billing, project, workflow, and performance metrics Build dashboard structures that allow leadership and teams to monitor trends, priorities, bottlenecks, completion rates, workload, revenue cycle indicators, and other KPIs over time Build reporting structures that support visibility into operational, billing, and performance metrics Analyze billing data and performance data to identify trends, gaps, bottlenecks, and opportunities for improvement Partner with leadership and operational stakeholders to ensure dashboards reflect meaningful and actionable KPIs Help ensure reporting is accurate, current, well-organized, and usable for decision-making Troubleshoot data inconsistencies and support clean, reliable data flow into reporting tools Translate reporting needs into dashboards, data views, and workflow improvements that strengthen accountability and operational insight HIPAA-Aligned System Design Design and maintain automations, dashboards, and reporting systems with strong attention to privacy, minimum necessary access, secure data handling, and compliance-conscious workflow structure Evaluate workflow, dashboard, reporting, and integration designs for privacy and compliance risk before implementation Help ensure sensitive information is handled appropriately across forms, automations, tasking systems, dashboards, reports, and related data flows Document automation logic, system dependencies, dashboard structures, data sources, and data movement in ways that support reliability and accountability Future EHR/API Integration Work Help prepare PMHW's workflow and reporting systems for future API-based integrations with EHR platforms Participate in planning for secure, scalable, and compliant connectivity between forms, automation tools, dashboards, and EHR systems Support the eventual design, testing, documentation, and maintenance of API-driven workflows as EHR access becomes available Collaborate with internal stakeholders and external vendors on future integration opportunities Cross-Functional Support and Improvement Meet with stakeholders to understand workflow, automation, and reporting needs, clarify requirements, and recommend practical solutions Identify inefficiencies, bottlenecks, duplicate work, reporting gaps, and process issues, then redesign workflows or dashboards to improve function Develop SOPs, training materials, and internal documentation Provide support to staff using forms, automations, dashboards, and workflow systems

Minimum Qualifications:

Strong proficiency in Microsoft Power Automate Experience with Cognito Forms design, administration, and workflow logic Experience integrating forms and automations with ClickUp or a comparable task/project management platform Experience using ClickUp or a similar platform to manage projects, timelines, deliverables, and workflow accountability Experience designing, building, and maintaining dynamic KPI dashboards in Google Data Studio, ClickUp Dashboards, or similar reporting tools Ability to configure dashboards that translate operational, billing, project, workflow, and performance data into actionable visibility for leadership and teams Ability to analyze billing data, operational data, and performance data in a way that supports decision-making Familiarity with HTTP requests, webhooks, and foundational API concepts as they relate to workflow automation and systems integration Experience with Keragon and Make, or strong willingness and capacity to learn them quickly Familiarity with HIPAA compliance requirements related to workflow automation, data handling, digital systems, dashboards, and reporting environments Strong organizational, analytical, and troubleshooting skills Demonstrated ability to manage multiple projects and deadlines with strong follow-through Experience working in behavioral health, healthcare, or another privacy-sensitive environment Experience designing workflows, dashboards, or reporting systems involving sensitive or regulated information Experience with process mapping, workflow redesign, or operational systems improvement Experience creating SOPs, user documentation, and staff trainings Familiarity with API-based integrations and structured data flow Experience with or interest in healthcare systems integration and EHR-related workflows Experience working with billing data, revenue cycle reporting, or performance dashboards in a healthcare setting Experience developing dynamic dashboards that monitor trends, completion rates, workload, productivity, revenue cycle indicators, or other operational KPIs over time

Equipment Operated:

Standard office equipment, including computers, copiers, printers, telephones, etc.

Work Environment:

When working from a PMHW office, the position is in a well-lit office environment. Varied activities including sitting, standing, walking, reaching, bending, and lifting.

Mental and Physical Requirements:

Involves sitting approximately 90 percent of the day, walking or standing the remainder. Ability to tolerate mental and emotional distress as an anticipated aspect of the position. May require working under stressful conditions. Portland Mental Health & Wellness offers a competitive benefits package for full time employees that includes: Paid Vacation Time (80 hours per year to start) Paid Health Leave (40 hours per year) Paid Floating Holiday Hours (80 hours per year) Medical and Vision Insurance

• Kaiser Permanente of the Northwest (choice of three plans) Dental Insurance Employer Paid Life and AD&D Insurance Voluntary Additional Life and AD&D Insurance Voluntary Short Term Disability Insurance Voluntary Critical Illness Insurance Voluntary Accident Insurance Flexible Spending Account, Health Care Flexible Spending Account, Dependent Care Commuter Benefit
• Choice of TriMet Pass or Limited Parking Reimbursement 401K Retirement Plan
• Up to 4% Company Match Once Eligible Annual Continuing Education Allowance of $500 Discounted Enrollment with Student Loan Tutor 10% Discount on Vitamins & Supplements Through Fullscript Limited Access to Columbia Sportswear Employee Store OnPoint Community Credit Union Group Banking Benefits — This description is intended to provide only the basic guidelines for meeting job requirements.

Responsibilities, knowledge, skills, abilities, and working conditions may change as the practice's needs evolve. Regular and predictable attendance is an essential function of every job. The requirements described above are representative of those that must be met by an employee to successfully perform the essential functions of this position. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. By signing below, you acknowledge that you are able to perform the Essential Functions of this job, with or without accommodation. If an accommodation is needed, you acknowledge that you have an opportunity to discuss this with Human Resources. Portland Mental Health is an equal opportunity employer. We support and encourage diversity.