EXPLORE YOUR NEXT CHAPTER
PMO Automation & Reporting Engineer
RedCloud Consulting
Source: Headcount Labs · original listing ↗
Job data: Headcount Labs, ODbL 1.0. Job descriptions belong to their employers.
Posted Oct 22
About this role
RedCloud seeks a PMO Automation & Reporting Engineer (Physical Security Design & Delivery) to support immediate client operations. Location: EMEA Overview: We are seeking a PMO Automation & Reporting Engineer to join a small PMO (3-4 people) supporting global data center physical security design and delivery programs. Our PMO spends too much time on manual data manipulation: status compilation, cross-tool reconciliation, and report assembly. This is a builder role. You will replace that manual work with automations, apps, and dashboards, help evaluate and migrate to a new project management platform, and prototype AI-enabled workflows. You report to the PMO Lead. Responsibilities include but are not limited to: • Build and maintain automations using Google Apps Script and similar tools (APIs, webhooks, scheduled jobs) to eliminate manual data entry and reporting • Design and support AppSheet apps for intake, issue tracking, approvals, and field-facing workflows • Integrate project tools, spreadsheets, and data sources so data flows without re-keying • Build and maintain Looker Studio dashboards covering portfolio status, schedule, risk, issue aging, and operational KPIs • Own the data model behind reporting: field definitions, refresh logic, and data quality checks • Prototype AI-assisted workflows in Google AI Studio and Gemini (summarization, issue classification, document extraction) and recommend what is worth productionizing • Support requirements gathering, evaluation, and migration if we move off Asana, including data mapping and rebuilding workflows, integrations, and reports • Keep project data accurate across concurrent programs (status, risks, issues, milestones) • Document everything you build so it stays supportable • Work with engineering, program managers, technical writers, design vendors, and integrators to capture requirements and drive tool adoption Required knowledge, skills, and abilities: • 3+ years building automations, internal tools, or reports in a business or operations setting • Hands-on scripting experience that automates real workflows (Google Apps Script ideal; JavaScript or Python with strong Workspace/API work acceptable) • Hands-on Looker Studio experience (Looker, Power BI, or Tableau acceptable with demonstrated ability to ramp quickly) • Hands-on AppSheet experience (Power Apps or similar low-code acceptable with demonstrated ability to ramp quickly) • Strong Google Sheets and relational data modeling skills • Experience with a project management tool and its data (Asana, Jira, Smartsheet, or similar), including API or export-based integration • Ability to turn messy operational problems into requirements and working tools • Clear communication with technical and non-technical stakeholders • Be prepared to walk through tools you have built Preferred knowledge, skills, and abilities: • SQL and BigQuery • REST APIs, webhooks, JSON • Building with LLM tools (Google AI Studio, Gemini API) in a business context • PMO, program operations, or project controls experience on technical programs • Experience configuring or migrating a project management platform • Exposure to construction, engineering, or data center delivery • Familiarity with physical security systems (access control, video, intrusion detection, low-voltage infrastructure). Helpful but not required; we can teach the domain. Individual pay is determined by factors including job-related skills, experience, and relevant education or training. Benefits and bonus information can be found at https://www.redcloudconsulting.com/careers RedCloud requires employees have the legal ability to work in the country hired during their employment period. During onboarding, proof of eligibility to work in the applicable country will be requested. RedCloud does not provide visa sponsorship. About Us: RedCloud Consulting is a global business and technology consulting firm supporting clients across North America, Europe, Asia-Pacific, and the Middle East. For more than two decades, RedCloud has partnered with organizations ranging from high-growth mid-market companies to global enterprises, helping them solve complex business and operational challenges—leveraging modern data platforms, artificial intelligence, and secure digital foundations to drive smarter decisions and scalable outcomes. Anchored in a foundation of integrity-based consulting , RedCloud brings together senior-level experts who work side by side with client teams to design and implement durable, high-impact solutions. Our approach emphasizes trust, accountability, and long-term value—balancing stability, growth, and innovation to help organizations operate securely and confidently in an increasingly complex global environment. RedCloud delivers a comprehensive range of services across its core practices: Data & AI, Delivery Excellence, Digital Solutions, Marketing & Sales, Privacy, Security, Data Center and Critical Infrastructure Security, and Strategy & Transformation . As our clients expand globally, so do we—providing consistent, expert support across regions while remaining agile, collaborative, and deeply invested in client success. Recognized for both performance and culture, RedCloud has been named #1 Best Company to Work For in Washington (Mid-Sized Businesses) by Seattle Business Magazine , a “Fastest Growing Company” multiple times on the Inc. 500/5000 list, and recognized by Consulting Magazine as a Leader in Technology Consulting.