Senior Data & Analytics Consultant

Senior Data & Analytics Consultant – Ampersand Consulting

About Ampersand

Ampersand is a forward-looking consulting partner that empowers clients and consultants to thrive in the age of AI. We are based in South Florida, value curiosity and progress, and deliver measurable impact through deep technical and business skills. This opportunity focuses on Operational Support & Data Insight across client engagements.

• Work with real client datasets to generate insights used in executive decision-making
• Build dashboards, reports, and data-backed recommendations
• Support workflow design, operational organization, and delivery execution
• Collaborate with consultants and technical leads to address complex challenges
• Exposure to AI and automation initiatives (not required to own advanced AI builds)

• Formal consulting background — prior experience at a recognized firm (Big 4 or comparable).
• Experience operating in structured consulting environments, managing clients, and delivering within methodologies.
• Strong SQL skills (joins, CTEs, aggregations, data modeling fundamentals)
• Proficiency in Python for data cleaning, transformation, and exploratory analysis
• Experience 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 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 work streams, 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.

• Exposure to AI tools, LLMs, or agentic AI concepts
• Familiarity with Salesforce Marketing Cloud
• Experience with cloud data tools (Snowflake, Redshift, Big Query)
• Background in process mapping, operations design, or workflow improvement
• Understanding of MLOps fundamentals such as model deployment or environment management

• 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

You re someone who:

• Is…