AI-Enabled Business Analyst

Technology & Analytics | The Builders and Translators

We are a 1,000-piece puzzle. Each of us is essential, interconnected, and intentionally designed. Together, we create something powerful: media that matters, growth that lasts, and a culture we are proud to build.

As part of our Technology & Analytics team, you are one of the Builders and Translators, turning complex data, emerging technologies, and innovative ideas into practical solutions that help our entire agency work smarter. You connect human expertise with the power of technology, finding smarter ways to use data, simplify processes, and help our people make better decisions.

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 document how information and responsibilities move through a workflow.

Problem-Solving & Resourcefulness: You focus on the problem before the tool. You can evaluate different approaches, experiment with solutions, and identify practical improvements without overcomplicating the work.

Communication & Translation: You can turn technical or analytical findings into clear explanations that help colleagues understand the problem, the opportunity, and the recommended solution.

Collaboration & Relationship Building: You enjoy working across disciplines, listening to different perspectives, and developing solutions that reflect how people actually work.

Learning Agility & Curiosity: You're interested in emerging AI technologies and motivated to explore how new capabilities can solve meaningful business problems.

Organization & Follow-Through: You can manage multiple initiatives, document your work, follow through on commitments, and take ownership of assigned projects.

Attention to Detail & Accountability: You care about data accuracy, reliable processes, and the quality of your recommendations. You test assumptions, validate results, and take responsibility for the work you deliver.

WHO YOU ARE

At Attention Arc, how you work is just as important as what you deliver. Our core competencies define the skills and behaviors that drive strong performance and meaningful impact:

• Credibility: You bring strong analytical foundations, data fluency, and thoughtful problem-solving to your work. You validate information, question assumptions, and develop recommendations grounded in reliable data and a clear understanding of business needs.
• Clarity: You make complex information easier to understand. You document workflows, organize data, explain decision points, and communicate recommendations in ways that help colleagues see what needs to change and why.
• Connection: You build positive relationships across teams by listening, collaborating, and asking thoughtful questions. You recognize that effective solutions begin with understanding the people, processes, and business challenges behind the work.
• Care: You approach your work with accountability, empathy, and attention to detail. You consider how process changes affect employees, protect sensitive information, and develop solutions that make people's work easier and more effective.
• Culture & Character: You bring curiosity, initiative, and a willingness to challenge existing processes constructively. You embrace feedback, learn through experimentation, and contribute to a culture where people share ideas, support one another, and continuously improve.

Together, these behaviors define what it means to do great work here, building trust, driving impact, and creating a culture where people and ideas thrive.

WHO WE ARE

We're a media agency built for brands that value intention. At Attention Arc, we combine deliberate media craft with technology designed to amplify it. We build trusted partnerships so every decision stays aligned with what matters most. Media doesn't fail because of technology. It fails when intention is missing. That's why we exist.

To restore intention to media.

At 160 people across four offices in Phoenix, Durham, Irvington, and New York City, we occupy a deliberate sweet spot: big enough to handle major brands and complex business, nimble enough to actually move, make decisions, and drive impact. No unnecessary layers. No slow-moving bureaucracy. Just sharp thinking, fast execution, and tech-enabled.

Our culture is shaped by our values:

• All In: We show up with intensity and ownership.
• No Sidelines: We collaborate without ego or boundaries.
• Move With Curiosity: We ask why, explore boldly, and learn fast.
• Truth With Heart: We communicate with honesty and empathy.

OUR COMMITMENT TO INCLUSION

At Attention Arc, we believe people do their best work when they feel they belong. Inclusion isn't just about representation, it's about creating an environment where people feel seen, supported, and comfortable showing up as themselves.

We value different lived experiences and perspectives, and actively create space for those voices to shape our work. We're committed to building an agency where everyone has a genuine seat at the table and is trusted to step in and contribute, fostering collaboration, encouraging curiosity, and creating opportunities for people to take ownership and make an impact.

Because when people feel heard, respected, and confident to step forward, we all move forward together.

WHAT WE OFFER

Compensation: The estimated range for this role is $100,000 to $120,000. Compensation packages are based on the skill level and experience each candidate brings to the role.

We're committed to rewarding our people fairly and supporting their growth with intention. Our salaries are competitive, thoughtfully benchmarked, and designed to ensure equity across roles, experience, and impact. Growth at Attention Arc isn't tied to a calendar, it's driven by performance, progress, and potential. We continuously invest in our people through ongoing feedback, development, and opportunities to take on more, so you can keep building your career in meaningful ways.

We know that great work starts with people who feel genuinely supported, inside the office and out. Our benefits are designed with your whole self in mind: your health, your family, your financial future, and your wellbeing day to day. We're committed to making sure that everyone at Attention Arc has what they need to thrive, not just professionally, but personally.

Here's what you can expect:

• Flexible Paid Time Off
• Comprehensive Medical, Dental, and Vision plans
• Competitive Parental Leave that gives you time to bond with your family
• Hybrid work model with in-office collaboration
• Mental health support
• Annual agency contribution to 401(k)
• Flexible Spending Accounts (FSAs) and Healthcare FSA
• Commuter benefits and corporate discounts
• Carrot Fertility and family-building support
• Employee Assistance Program (EAP)
• Casual work environment, team building, and other social events

LOCATION

We operate on a hybrid, in-office model designed to foster collaboration, mentorship, and hands-on learning. Employees are expected to work from the office three days per week (Tuesday, Wednesday, and Thursday) to fully experience the energy of our teams and build meaningful connections.

Candidates must reside in and be able to commute to one of the following office locations, three days a week:

• Irvington, New York

RIGHT TO WORK IN THE US

You must be authorized to work in the United States for any employer. At this time, we are not sponsoring or providing assistance with obtaining work authorization.