Intelligence Reporting & Automation Manager

Position summary The Intelligence Reporting & Automation Manager leads the reporting function within the Strategic Intelligence team and is responsible for the design, delivery, and automation of intelligence reporting across the firm. This role translates complex data, analytical outputs, and external intelligence into clear, actionable reports and briefings that support business decision-making and serve as the primary delivery layer for intelligence across the firm. The Manager develops scalable reporting frameworks, automates workflows, and establishes standards that enhance the efficiency and quality of reporting outputs. This role partners with stakeholders across the firm to deliver insights that inform strategic initiatives and operational priorities, ensuring reporting outputs are aligned with business needs and evolving firm priorities, while leading and developing a team focused on delivering consistent, high-quality intelligence. Job duties and responsibilities Own and manage the catalog of intelligence reporting, including ad hoc and standard data reports, AI-augmented narrative briefings, and blended formats that combine quantitative data with synthesized external content. Advance the firm's reporting quality and scalability through automation, self-service, and standardization. Partner with Strategic Insights analysts to support the development of new metrics, models, and personalized insights, and identify effective methods for delivering information to guide firm leadership. Define and maintain a library of report types, each with design standards, target audiences, and production processes. Shape deliverables using a consultative approach by assessing stakeholder needs and calibrating outputs to audience sophistication, exercising independent judgment and discretion to determine appropriate outputs and delivery methods. Design and automate repeatable reporting workflows to enable team output to scale with demand without proportional increases in manual effort. Build AI-augmented pipelines that synthesize structured firm data with unstructured external content (e.g., news, filings, and market signals) to generate intelligence products such as client relationship briefings, competitive snapshots, and matter-context summaries. Apply LLM-based workflows, RAG, or MCP techniques to expand the types of intelligence the team can produce at scale. Identify opportunities to replace or augment manual report production through automation or self-service tools and lead the development of those capabilities. Manage the queue of reporting and intelligence requests, including setting expectations, scoping requests, and ensuring timely delivery aligned with user needs. Partner with internal business units — Finance, Strategy, Client Value, Marketing, HR, and IT — to identify emerging analytics needs and deliver insights that inform decision-making. Create and maintain reporting standards, guidelines, and best practices, and audit and manage the BI dashboard library to ensure accuracy and relevance. Support ad hoc data analysis projects and assist users across departments in answering data-related questions. Ensure appropriate human review of AI-generated content and maintain alignment with firmwide data governance practices in coordination with the Data Architect, Data Integrity Lead, and Strategic Insights Leader. Develop and maintain a consistent internal brand for all intelligence deliverables. Lead, mentor, and develop a junior team (potentially supplemented with contractors), with a focus on building systems that scale output rather than executing requests individually. Perform other duties as assigned. Job duties and responsibilities included are not exhaustive and may be supplemented as necessary. Reed Smith reserves the right to revise or modify job duties and responsibilities at any time. Requirements Education Bachelor's degree in Data Science, Analytics, Computer Science, Statistics, Information Systems, or a related field required. Equivalent experience will be considered. Experience Minimum of 5 years of experience in business intelligence, reporting, or analytics delivery, including at least 3 years of experience managing teams. Demonstrated experience owning a reporting and delivery function, including designing formats, managing request queues, and building systems that scale output. Experience translating complex analytical work into clear, executive-ready reports and briefings. Hands-on or leadership experience working with structured data (e.g., SQL, data warehouses) and unstructured content (e.g., documents, news feeds, filings, or other text corpora), including evaluating information and ensuring quality inputs are utilized. Experience with approaches for grounding LLM outputs in firm and external data, including Model Context Protocol (MCP), retrieval-augmented generation (RAG), or similar integration architectures. Experience working in a professional services or legal environment preferred. Skills Proficiency in building and maintaining dashboards and reports using data visualization tools (e.g., Tableau or Power BI), with an understanding of visualization best practices and UI/UX principles. Familiarity with AI and LLM platforms (e.g., ChatGPT, Claude, Copilot, Gemini), including prompt engineering, MCP, RAG, and AI pipeline development. Strong SQL skills, including querying and manipulating data from relational databases and data warehouses (Snowflake preferred), with familiarity with DAX, data architecture, and ETL processes. Advanced Excel skills for data analysis and manipulation, with familiarity with the broader Microsoft Office Suite. Familiarity with project management tools and user acceptance testing (UAT) processes, as well as Python or similar scripting languages for data transformation, automation, and integration tasks. Strong written and verbal communication skills, with the ability to interact effectively with all organizational levels. Strong analytical and problem-solving skills. Ability to organize and prioritize workload and manage multiple priorities in a fast-paced environment. Demonstrated ability to lead and develop team members, including in a remote or hybrid work environment. High degree of professionalism, discretion, and sound judgment, with the ability to respond effectively in dynamic or sensitive situations. Additional information Supervisory responsibilities Information Analyst(s), assigned contractor(s) Equipment used Personal computer and other office equipment such as telephone, calculator, copier, scanner, etc. Essential job functions Ability to sit or stand for extended periods and perform tasks requiring prolonged and/or extensive computer use. Ability to use computers, telecommunications, and digital collaboration tools to perform core job responsibilities. Ability to engage in effective and professional communication. Ability to analyze complex information while maintaining attention to detail, managing multiple priorities, and exercising sound judgment in decision-making. Ability to access, use, and safeguard confidential and sensitive information while performing job responsibilities in work environments that support confidentiality, privacy, and information security requirements. Ability to work extended hours and in the office as required to meet business or project needs. Working conditions Works remotely. Occasionally called upon to work hours in excess of your normal daily schedule. Potential for in-office work requests as needed, so proximity to the office is important. Pay ranges This represents the presently anticipated low and high end of Reed Smith's pay range for this position. Actual pay may vary based on various factors, including but not limited to location and experience. Pittsburgh, Miami, Richmond, Texas, Atlanta: $140,000 - $171,000 Chicago, Philadelphia, Wilmington: $150,000 - $183,000 Tysons, Princeton, Washington, D.C., Boston: $161,000 - $195,000 Employee benefits overview Our comprehensive benefits package includes: 401(k) Retirement Plan Medical Insurance Health Savings Account (HSA) Virtual Health Services Dental Insurance Vision Insurance Accident Insurance Hospital Indemnity Insurance Critical Illness Insurance Life Insurance Short-Term Disability Coverage Long-Term Disability Coverage Flexible Spending Accounts (FSA) Lyra Health Employee Assistance Program (EAP) Paid Family Leave (for eligible Exempt and Non-Exempt staff) Transportation Benefit Back-up Child Care Services College Coach Program Pet Insurance Paid Sick Time (for Exempt staff) Paid Time Off (available to all full-time, non-temporary employees) Reed Smith offers a challenging work environment, business casual dress code, and a total compensation package that includes a competitive salary, flexible benefits program, tuition assistance, and generous 401(k) plan. Reed Smith is an Equal Opportunity Employer with Core Values of Integrity, Excellence, Teamwork & Respect, Innovation, and Impact. Reed Smith also provides reasonable accommodations in accordance with law, including in the application and interview process. Qualified candidates only. No search firms.