Data Analyst with Tableau
Remote
Long Term
The Data & Insights Analyst is a dedicated data resource supporting the Office of Innovation’s idea portal and pipeline, managed in Qmarkets. This role owns daily portal data integrity, weekly and monthly pipeline reporting, and the build-out of automated dashboards and visual management tools that give leadership real-time visibility into portfolio health. By taking on recurring data extraction, analysis, and reporting, this role frees the Operations Principal to focus on the people and process elements of the pipeline including stakeholder engagement, process design, and portfolio strategy. Between now and 2027, this role is central to maturing OOI’s data infrastructure to move from manual, static reporting to automated, self-service analytics that scale with the growing pipeline. The Analyst is expected to work proactively, surfacing data reports and insights to the Operations Principal and Innovation Director on a daily/weekly cadence.
Desired Experience & Skills
• 10+ years in data analysis, business intelligence, or operations/reporting roles; experience with pipeline, CRM, or idea-management data a plus
• Strong critical thinking and analytical problem solving skills with the ability to produce insights and surface trends independently; identifies and raises QA/QC concerns proactively to leadership
• Hands-on data analysis, automation, and dashboarding skills required; direct experience with Smartsheet BI or Qmarkets strongly preferred
• Comfortable building repeatable, automated reporting processes rather than one-off manual analysis
• Proactive self-starter — expected to surface data, issues, and status to the Operations Principal and Innovation Director daily/weekly without prompting
• Clear, organized communicator who can hand off analysis-ready data and insights on a set cadence
Key Responsibilities
Daily Portal & Pipeline Management
• Own portal data integrity: ensure ideas are in the correct stage/state, the live idea tracker matches the portal, and new-idea intake (team notification, tracker entry, owner assignment) is handled same-day
• Partner with Qmarkets and Operations Principal to keep pipeline data clean and resolve portal errors; maintain an issue log
• Manage PMO-style management on active ideas: track communications to/from portal and innovate address, and open action items per idea, ensure follow-ups don’t fall through the cracks, and flag stalled ideas to the Operations Principal and Innovation Director for intervention
• Run a regular status update to the Operations Principal and Innovation Director: new/changed ideas, open items, stalled ideas needing escalation, and follow-ups completed
Reporting & Data Analysis
• Extract and analyze pipeline data weekly: idea counts by stage/state and campaign (Ideate, Modernize, Funding, Strategic Initiative, Innovate), plus submitter and ownership stats
• Expand this monthly to include OU distribution and thematic analysis, and help deliver a finished report in the standard template, with the Operations Principal signing off on data structure and content before it’s finalized
Dashboard Automation & Visual Management
• Priority deliverable: build a real-time dashboard (Directly in Qmarkets, Smartsheet, or BI tool, — preferred order) covering campaign distribution, first-pass yield, cycle time by stage/campaign, overall portfolio health (on track / at risk / off track), and other metrics finalized by Operations Principal and Director
• Automate the weekly/monthly reporting cycle above so data no longer needs to be pulled and analyzed by hand
• Work with Qmarkets to automate real-time status reporting for ideas in implementation
Other
• Support portal admin work as needed: new campaign setup, committee review bodies, and translating review criteria into portal scoring/voting, education and news portal updates
• Participate in regular check-ins with the Operations Principal, Innovation Director, Qmarkets, and OOI stakeholders, and field ad hoc data requests as they arise
Munesh
770-838-3829,
CYBER SPHERE LLC
