AI-Enabled Business Analyst

WHAT YOU'LL DO

At Attention Arc, we believe technology should amplify human expertise, not replace it.

As our AI-Enabled Business Analyst, you'll combine analytical thinking, data expertise, business curiosity, and practical knowledge of AI to improve how our agency operates.

You'll work directly with department leaders, managers, and employees to understand how work actually gets done. You'll ask thoughtful questions, map workflows, examine decision points, and identify opportunities to simplify processes, connect data, and eliminate repetitive work.

This role is different from a traditional media analyst position. While our client-facing analysts focus on account-specific challenges and performance, you'll focus on opportunities that benefit the broader agency. You'll look for recurring challenges across teams and clients, then help develop solutions that can be reused, scaled, and continuously improved.

You'll work with data from multiple systems, write SQL queries, use platforms such as Snowflake, and apply AI tools to make information more accessible and useful. Whether you're combining three datasets into one reliable reporting process, improving a planning calculator, or helping a team develop better AI prompts, your focus will be on solving real business problems.

You don't need to be a full-stack software developer. You do need to be comfortable working with data, understanding technical systems, learning new tools, and translating business needs into practical solutions.

Most importantly, you'll be curious enough to ask why a process exists, thoughtful enough to understand the decisions behind it, and resourceful enough to find a better way.

Your impact will be measured by the clarity you create, the time you save, the processes you improve, and the value your solutions bring to people across Attention Arc.
Key Responsibilities

Business Workflow Discovery & Process Optimization

• Meet with department leaders, managers, and employees to understand their daily responsibilities, recurring tasks, operational challenges, and business objectives.
• Analyze existing workflows to identify manual processes, duplicated effort, inefficiencies, disconnected systems, and opportunities for improvement.
• Develop process maps, workflow diagrams, and decision trees that document how work moves through the agency and how decisions are made.
• Ask thoughtful questions to uncover the underlying business problem rather than simply automating an existing process.
• Identify opportunities to standardize and simplify processes across departments and client teams.
• Translate business challenges into clear requirements for data solutions, AI applications, workflow automations, and process improvements.
• Evaluate potential solutions based on feasibility, expected time savings, accuracy, scalability, and business impact.
• Collaborate with stakeholders to test proposed improvements and ensure solutions fit how employees actually work.

Data Analysis, Integration & Optimization

• Work with data from multiple internal and external sources to support agency-wide operational improvements.
• Use SQL and Snowflake to query, join, transform, validate, and organize datasets.
• Combine information from multiple sources into consolidated datasets, reports, or workflows that reduce manual effort and improve accuracy.
• Identify opportunities to simplify recurring data preparation, reconciliation, and reporting processes.
• Analyze data structures and relationships to understand how information flows between systems.
• Build and improve data-driven tools, calculators, templates, and reporting processes that support business decision-making.
• Support the development of reusable data models and standardized reporting approaches that can benefit multiple departments or client teams.
• Investigate data quality issues, inconsistent definitions, missing information, and process gaps that affect reporting or operational efficiency.
• Collaborate with Analytics, Data Engineering, and Technology colleagues on more complex integrations and data infrastructure needs.
• Document data sources, transformation logic, calculations, and assumptions to support accuracy and repeatability.

AI Enablement & Prompt Optimization

• Identify practical opportunities to use generative AI and large language models (LLMs) to improve agency workflows.
• Work with teams to understand the inputs, business context, rules, and desired outputs needed for effective AI-assisted processes.
• Develop, test, and refine prompts that help employees complete recurring tasks more consistently and efficiently.
• Create structured prompt templates, instructions, and repeatable AI-assisted workflows for common business needs.
• Partner with Media Planning and other departments to explore how AI can support research, information synthesis, plan development, reporting, and operational tasks.
• Evaluate AI-generated outputs for accuracy, consistency, usefulness, and alignment with business requirements.
• Help determine when AI is an appropriate solution and when better data organization, process redesign, or conventional automation would be more effective.
• Explore tools such as ChatGPT, Microsoft Copilot, Claude, Gemini, and other relevant AI platforms.
• Document successful AI use cases and help make them accessible to employees across the agency.
• Apply responsible AI practices, including appropriate human review, data privacy, and information security.

Workflow Automation & Business Solutions

• Identify repetitive tasks and recurring operational challenges that could be improved through automation.
• Develop or configure practical solutions using spreadsheets, SQL, AI platforms, workflow automation tools, and lightweight scripting where appropriate.
• Help simplify multi-step processes by connecting data sources, standardizing inputs, and reducing manual handoffs.
• Build and improve operational tools such as calculators, trackers, reporting templates, data preparation workflows, and AI-assisted processes.
• Explore automation platforms such as Power Automate, Zapier, Make, or similar tools to streamline recurring activities.
• Work with technical colleagues when a solution requires more complex software development, system integrations, or engineering support.
• Test solutions with end users to ensure they produce accurate results and are practical to maintain.
• Monitor implemented workflows and identify opportunities for continued improvement.

Agency-Wide Efficiency & Operational Innovation

• Look beyond individual client accounts to identify recurring challenges and improvement opportunities across the agency.
• Recognize patterns in how different teams approach similar tasks and identify opportunities for shared solutions.
• Collaborate with Media Planning, Activation, Research, Analytics, Account Services, Ad Operations, Finance, Project Management, and People & Experience.
• Help develop scalable processes and tools that can be used by multiple departments or client teams.
• Partner with department stakeholders to improve consistency, reduce unnecessary complexity, and strengthen operational effectiveness.
• Support initiatives that improve the accessibility, organization, and usefulness of agency data and knowledge.
• Research emerging AI and data technologies and assess their potential application to real agency challenges.
• Develop small-scale prototypes or proof-of-concept solutions to demonstrate opportunities for improvement.
• Share successful approaches and encourage teams to adopt more efficient ways of working.

Cross-Functional Collaboration & Change Enablement

• Build strong working relationships with employees and department leaders by listening, asking questions, and understanding their challenges.
• Translate technical and analytical concepts into clear, approachable language for nontechnical stakeholders.
• Facilitate workflow discussions and help teams articulate business requirements and desired outcomes.
• Demonstrate new tools, data processes, and AI-assisted workflows to employees.
• Create process documentation, decision trees, user guides, and training materials that make new solutions easy to understand.
• Gather employee feedback and use it to improve the usability and effectiveness of implemented solutions.
• Help teams understand how to use AI and automation responsibly and where human judgment remains essential.
• Encourage experimentation, knowledge sharing, and continuous improvement across the agency.

Performance Measurement & Continuous Improvement

• Help define success metrics for operational improvement initiatives, including time saved, reduced manual effort, improved accuracy, faster turnaround, and employee adoption.
• Establish baseline measurements where possible to evaluate the impact of process improvements.
• Monitor the effectiveness of new workflows, data solutions, and AI-assisted processes.
• Collect feedback from stakeholders to understand whether solutions are meeting business needs.
• Identify opportunities to refine, expand, or standardize successful solutions.
• Maintain documentation of active initiatives, completed improvements, and future opportunities.
• Share findings, progress, and recommendations with Technology leadership and department stakeholders.
• Focus on practical, measurable improvements that make the agency more efficient and effective.

WHAT YOU'LL BRING
Experience & Technical Expertise

• 2-4 years of professional experience in business analysis, data analysis, business intelligence, process improvement, operations analytics, or a related analytical role.
• Strong proficiency in SQL, including joining multiple datasets, filtering and aggregating data, writing complex queries, and validating results.
• Hands-on experience working with Snowflake or a comparable cloud data warehouse, including querying, combining, and transforming data from multiple sources.
• Demonstrated ability to understand business workflows, document processes, identify inefficiencies, and recommend practical improvements.
• Experience creating process maps, workflow diagrams, decision trees, or business requirements documentation.
• Experience combining data from multiple systems to support reporting, analysis, or operational improvements.
• Strong Excel or Google Sheets skills, including advanced formulas, data manipulation, and the development of analytical tools or calculators.
• Practical experience using generative AI tools such as ChatGPT, Claude, Gemini, or Microsoft Copilot to support analysis, research, process improvement, or business workflows.
• Experience developing and refining AI prompts to produce accurate, structured, and repeatable outputs.
• Understanding of data quality, validation, data relationships, and basic data transformation principles.
• Ability to translate business needs into analytical requirements, data solutions, and workflow improvements.
• Strong analytical reasoning and structured problem-solving skills.
• Ability to communicate findings and recommendations clearly to technical and nontechnical stakeholders.
• Experience working collaboratively with stakeholders to gather requirements, test solutions, and implement improvements.
• Familiarity with data privacy, information security, and responsible AI practices.
• Bachelor's degree in Business Analytics, Information Systems, Data Analytics, Business Administration, Computer Science, or a related field, or equivalent practical experience.

Preferred Qualifications

• Experience using Python for data manipulation, analysis, scripting, or workflow automation.
• Familiarity with data transformation concepts, ETL/ELT processes, and data pipelines.
• Experience with business intelligence tools such as Power BI, Tableau, or Looker.
• Experience using workflow automation tools such as Power Automate, Zapier, Make, or similar platforms.
• Exposure to APIs, system integrations, or automated data workflows.
• Experience developing operational dashboards, calculators, planning tools, or standardized reporting processes.
• Familiarity with advertising, marketing, media planning, or media agency operations.
• Experience working with data from multiple client accounts, departments, or business systems.
• Exposure to AI-assisted analysis, document processing, information retrieval, or structured prompt workflows.
• Examples of process improvement or data projects that demonstrate measurable gains in efficiency, accuracy, or productivity.

Capabilities

Business Curiosity & Process Understanding: You naturally want to understand how things work and why they work that way. You ask thoughtful questions, examine processes from beginning to end, and look for opportunities to simplify or improve them.

Analytical Thinking & Data Fluency: You are comfortable working with complex information, connecting data from different sources, identifying patterns, and using evidence to support recommendations.

Workflow Mapping & Decision Logic: You can break down a complicated process into clear steps, understand decision points and dependencies, and documen