Ampersand Consulting · 4 weeks ago
Senior Data & Analytics Consultant
Ampersand Consulting is an innovative consulting firm focused on empowering clients and consultants in the age of AI. The Senior Data & Analytics Consultant will enhance analytics capabilities and operational frameworks while working with client datasets to generate insights, build reports, and support workflow design.
AdvertisingE-CommerceMarketing
Responsibilities
Work with real client datasets and generate insights used in executive decision-making
Build dashboards, reports, and data-backed recommendations
Support workflow design, operational organization, and delivery execution
Collaborate closely with consultants and technical leads to bring structure to complex challenges
Deliver data analysis using SQL, Python, and BI tools
Support dashboards and reporting used in client updates
Contribute to project operations, documentation, and workflow organization
Learn Ampersand's approach to operational structure and data-driven insights
Analyze datasets, identify patterns, and develop clear visualizations
Support the development of data-backed recommendations for clients
Maintain operational documentation, deliverable trackers, and structured workflows
Assist in process mapping and identifying workflow optimization opportunities
Conduct research on data tools, industry benchmarks, or best practices
Ensure accuracy, clarity, and precision across all deliverables
Qualification
Required
Formal consulting background is essential — must have prior experience at a recognized consulting firm (Big 4 or comparable)
Demonstrated ability to operate in structured consulting environments, manage clients, and deliver work within established methodologies
Strong SQL skills (joins, CTEs, aggregations, data modeling fundamentals)
Proficiency in Python for data cleaning, transformation, and exploratory analysis
Experience working with structured datasets and forming analytical insights
Ability to translate raw data into meaningful trends, narratives, or visualizations
Experience with BI tools such as Tableau, Power BI, or Looker
Understanding of KPIs, reporting structures, data quality, and data hygiene principles
Familiarity with basic data pipeline or data flow concepts (schemas, ETL/ELT basics)
Salesforce data experience, including: Navigating and interpreting Salesforce objects, fields, and relationships; Working with exports (reports, CSVs, object data pulls); Understanding how Salesforce data structures impact downstream reporting and analytics; Ability to partner with Salesforce admins or developers to define requirements and ensure data readiness
Proven experience supporting project operations, including documentation, deliverable management, and status tracking
Comfortable navigating and interpreting spreadsheets, CSVs, JSON, and varied client data sources
Ability to gather requirements, translate them into clear, structured documentation, and support solution design
Strong attention to detail with disciplined accuracy, validation, and quality-control habits
Demonstrated ability to manage multiple workstreams, adapt to shifting priorities, and maintain accountability in a fast-moving consulting environment
Clear, confident verbal and written communication, with the ability to simplify complex analyses for diverse audiences
Experience presenting insights, recommendations, and deliverables directly to clients or senior stakeholders
Comfortable collaborating across cross-functional teams and working with client-facing partners
Professional presence with the judgment, reliability, and poise expected at the Senior Consultant level
Preferred
Exposure to AI tools, LLMs, or agentic AI concepts
Familiarity with Salesforce Marketing Cloud
Experience with cloud data tools (Snowflake, Redshift, BigQuery)
Background in process mapping, operations design, or workflow improvement
Understanding of MLOps fundamentals such as model deployment or environment management
Benefits
Comprehensive health, dental, and vision coverage
Flexible work arrangements that support work-life integration
401(k) with company matching
15 days PTO
Professional development stipend
Company
Ampersand Consulting
Ampersand is a digital transformation partner for large organizations and enterprises ready to turn possibility into progress.
Funding
Current Stage
Early StageCompany data provided by crunchbase