About The Position

IMI Agency is seeking a detail-oriented, analytical, and self-directed Data & Innovation Process Improvement Specialist for its Technology + Innovation Department. This full-time role supports the quality, organization, analysis, and reporting of data across client-facing and internal technology projects. It also helps identify inefficiencies and improve business processes through automation, AI, and Microsoft 365 tools. The position works closely with the Director of Technology + Innovation and cross-functional teams to evaluate processes, recommend improvements, document requirements, build and support Power Automate workflows, improve reporting, support company initiatives, and implement approved AI-enabled solutions responsibly. The successful candidate will demonstrate sound judgment, strong follow-through, and the ability to work with imperfect or inconsistent source data. They will clearly document workflows, assumptions, exceptions, and data-quality issues, and will verify AI-generated outputs before use while protecting confidential and client data. The role requires accuracy, adaptability, effective communication, collaboration, and the ability to manage multiple projects with minimal direction in a remote environment. IMI Agency specializes in marketing programs, promotions, merchandising and operations tools, training, and recognition and reward programs for hospitality clients. The company describes its mission as Building Better Beverage Business™ and emphasizes ethical, transparent, client-focused work.

Requirements

  • Bachelor’s degree in Data Analytics, Business Analytics, Information Systems, Statistics, Finance, Marketing, Business, or a related field, or equivalent relevant experience.
  • Professional experience in data analysis, reporting, data operations, or a similar role.
  • Strong understanding of Microsoft 365, Excel, SharePoint, Teams, and related workflow tools.
  • Experience building and supporting Microsoft Power Automate flows.
  • Ability to clean, normalize, reconcile, and validate data from multiple sources while preserving accuracy and traceability.
  • Strong analytical and problem-solving skills, including identifying patterns, investigating anomalies, and distinguishing source-data issues from calculation or system issues.
  • Experience building or maintaining Smartsheet sheets, forms, reports, dashboards, formulas, and automated workflows.
  • Ability to clearly document workflow logic, field mappings, assumptions, exceptions, and repeatable procedures.
  • Close attention to detail and commitment to accuracy when proofing imports, reports, and calculations.
  • Ability to manage several projects simultaneously, prioritize competing deadlines, and work effectively with minimal direction in a remote environment.
  • Clear, concise written and verbal communication skills, including explaining data findings to nontechnical stakeholders.
  • Strong follow-up and follow-through, with the judgment to ask questions when requirements or source data are incomplete.
  • Professional, service-oriented, and collaborative approach when working with internal teams, clients, and external partners.
  • Ability to adapt to changing project requirements, learn unfamiliar tools, and support evolving technology and data workflows.
  • Demonstrated ethical conduct, maturity, trustworthiness, sound judgment, and ability to receive and implement constructive feedback.
  • Ability to work in a macro-managed environment and complete tasks with high accuracy.

Nice To Haves

  • Experience with Smartsheet, Power Query, Power BI, Microsoft Access, or another data transformation, visualization, or analysis tool.
  • Experience with form creation, automation, or database platforms such as JotForm, Formidable Forms, Zapier, or WordPress.
  • Familiarity with import and export workflows and troubleshooting data transferred between systems.
  • Experience working with geographic, territory, state, or ZIP-code data and matching records by standardized business names or proximity.
  • Experience with master data management, quality control, exception reporting, or repeatable data processes.
  • Knowledge of U.S. beverage alcohol distribution, supplier and distributor relationships, hospitality operations, or food and beverage programs.
  • Experience supporting incentive contests.
  • Project management experience related to technology, reporting, or analytics projects.

Responsibilities

  • Support company initiatives requiring optimized data structures and efficient workflows.
  • Evaluate manual, repetitive, or inefficient processes and recommend practical improvements using AI, automation, Microsoft 365, Smartsheet, and Power Automate.
  • Facilitate process-discovery discussions with internal teams to understand workflows, pain points, data handoffs, approval steps, and reporting needs.
  • Monitor automation performance, troubleshoot issues, identify failure points, and recommend improvements.
  • Maintain, clean, and validate data used in the IMIManage Suite portfolio and related client applications.
  • Prepare data for import by standardizing names, restructuring spreadsheets, mapping fields, removing duplicates, and documenting transformation rules.
  • Investigate data discrepancies, duplicate records, incomplete source files, and unclear data requirements; escalate unresolved questions with supporting detail.
  • Perform quality assurance before and after imports, reimports, updates, and migrations by reconciling row counts, checking required fields, sampling records, and confirming expected results.
  • Analyze large and complex spreadsheets using formulas, pivot tables, filters, conditional logic, and other Excel features to identify actionable insights.
  • Build, maintain, and improve Smartsheet sheets, forms, reports, dashboards, formulas, cross-sheet references, and workflows.
  • Gather and document project requirements, translate them into data structures and reporting logic, and validate completed solutions against stakeholder needs.
  • Coordinate with the technology department’s project manager and account teams to obtain source data, resolve exceptions, and keep data projects moving.
  • Maintain organized project files, field mappings, process documentation, and status updates.
  • Use Microsoft Copilot to create AI agents when needed to assist with data preparation, analysis, documentation, formula development, troubleshooting, and process improvement.
  • Review, test, and validate AI-generated outputs; remain accountable for the accuracy, appropriateness, and completeness of final work and follow company requirements for confidential and client data.
  • Support gamification and incentive programs with data setup, validation, scoreboards, and final promotional reporting in IMIManage Promo, Smartsheet, or related tools.
  • Assist with projects, reporting, implementations, research, testing, and other business needs as required.

Benefits

  • 401(k) with match eligibility required.
  • 18–21 annual company holidays.
  • Three weeks of PTO, comprising 10 vacation days and 5 sick days, plus monthly appointment days.
  • Multiple medical plan options, including a no-cost option for employee coverage.
  • Dental insurance.
  • Vision insurance.
  • Life insurance.
  • Long-term and short-term disability insurance.
  • Supplemental insurance options, including illness, cancer, and legal coverage.
  • Confidential Employee Assistance Program with financial assistance and mapping.
  • Summer Fridays/Refresh Fridays.
© 2026 Teal Labs, Inc
Privacy PolicyTerms of Service