What are the responsibilities and job description for the Data & Analytics Consultant position at Ampersand Consulting?
Who We Are
At Ampersand, our vision is to be a recognized, trusted consulting partner that empowers both clients and consultants to thrive in the age of AI — known for innovation, measurable impact, and a culture built on curiosity and progress. Our consultants are problem-solvers who combine deep technical expertise with business acumen to deliver outcomes that matter.
Rooted in South Florida, we're an innovative team that values authenticity and entrepreneurial spirit. We embrace ambiguity, lead with empathy, and aren't afraid to push boundaries. Our strength lies in our diversity of thought and our commitment to doing what's right for our clients.
About This Opportunity
We're seeking a Consultant focused on Operational Support & Data Insight to strengthen our analytics capabilities and operational frameworks across client engagements. This role is ideal for someone with 2 years of hands-on experience in data analysis, reporting, or analytics-driven operations who wants to contribute meaningfully to client delivery while expanding their skills in modern data and workflow tools.
You will work across projects to analyze datasets, build insights, support operational excellence, and contribute to the structures that help our clients operate more intelligently.
What Makes This Role Different
You will:
Data & Analytics Skills
Immediate Impact (Months 1-3)
You're someone who:
For immediate consideration, please include:
About Ampersand
Ampersand is proud to be an equal-opportunity workplace. We value diversity and always treat all employees and job applicants based on merit, qualifications, personality, and talent. We do not discriminate on the basis of race, religion, ancestry, color, national origin, gender, sexual orientation, gender identity, age, citizenship, marital status, veteran status, or disability status.
At Ampersand, our vision is to be a recognized, trusted consulting partner that empowers both clients and consultants to thrive in the age of AI — known for innovation, measurable impact, and a culture built on curiosity and progress. Our consultants are problem-solvers who combine deep technical expertise with business acumen to deliver outcomes that matter.
Rooted in South Florida, we're an innovative team that values authenticity and entrepreneurial spirit. We embrace ambiguity, lead with empathy, and aren't afraid to push boundaries. Our strength lies in our diversity of thought and our commitment to doing what's right for our clients.
About This Opportunity
We're seeking a Consultant focused on Operational Support & Data Insight to strengthen our analytics capabilities and operational frameworks across client engagements. This role is ideal for someone with 2 years of hands-on experience in data analysis, reporting, or analytics-driven operations who wants to contribute meaningfully to client delivery while expanding their skills in modern data and workflow tools.
You will work across projects to analyze datasets, build insights, support operational excellence, and contribute to the structures that help our clients operate more intelligently.
What Makes This Role Different
You will:
- 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
- Gain exposure to AI and automation initiatives without being required to own advanced AI build work
Data & Analytics Skills
- 2 years of experience in analytics, data operations, or technical consulting
- 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)
- Experience supporting project operations, documentation, and deliverable tracking
- Comfort navigating spreadsheets, CSVs, JSON, and varied client data formats
- Ability to gather requirements and organize information in a structured way
- Strong attention to detail, accuracy, and validation discipline
- Ability to manage multiple tasks and shifting priorities with accountability
- Clear verbal and written communication skills
- Ability to present analyses simply and confidently
- Comfort collaborating with cross-functional teams and client-facing partners
- Professional presence and readiness to contribute to a consulting environment
- 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
Immediate Impact (Months 1-3)
- 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 energized by turning raw data into clear, structured insights
- Enjoys applying Python and SQL to real-world business problems
- Values organization, structure, and clear communication
- Learns quickly and brings initiative when navigating new tools or challenges
- Thrives in a team environment and collaborates well across functions
- Wants to deepen expertise in analytics within a consulting environment
- Competitive base salary ($70,000 - $90,000)
- 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
For immediate consideration, please include:
- Your resume highlighting experience in SQL, Python, data analysis, and analytics operations
- A brief statement about your interest in data and consulting
- Preference given to those who provide any relevant dashboards, code samples, or portfolio projects
About Ampersand
Ampersand is proud to be an equal-opportunity workplace. We value diversity and always treat all employees and job applicants based on merit, qualifications, personality, and talent. We do not discriminate on the basis of race, religion, ancestry, color, national origin, gender, sexual orientation, gender identity, age, citizenship, marital status, veteran status, or disability status.
Salary : $70,000 - $90,000