Senior Data Consultant

Campana & Schott Inc. is the New York City-based innovation hub of the Campana & Schott Group, a privately held, 30-year-old management and technology consulting firm with over 600 employees across Europe and the US. We create tangible results for our clients by designing digital solutions including business transformation, digital workplace, customer insights and analytics and creating novel ways of working. In the U.S., Campana & Schott focuses on healthcare and pharmaceuticals, combining digital and technology innovation with change management and transformation to create new momentum.

We are seeking a full-time Senior Data Consultant to join a small, fast-moving team in New York. This is a role where depth in data is what sets you apart — whether you’ve grown up as a technical data analyst, a data engineer, or a data architect.

In this role you’ll move across the full data spectrum: shaping data pipelines and models, designing schemas and taxonomies for client engagements, and turning ambiguous business questions into sound data architecture. Just as importantly, you’ll work as a consultant — managing clients and stakeholders and communicating clearly with both technical and non-technical audiences. As client demand pushes us to bring more of our data delivery in-house, you’ll help shape and grow a team of data engineers and consultants, and play a central role in how we deliver data work end to end.

If you enjoy solving complex data problems, and are looking for a place to grow your breadth and depth of expertise, this role is for you.

Passion
We approach every single project with enthusiasm – we thrive on new challenges and taking the perspective of our clients and their people.
Diversity
We value the diversity of the people in our company – irrespective of nationality, family situation, sexual orientation, religion, or age. Our diversity benefits us all – we want to see things from your perspective!
Respect 
We treat each other with respect and as equals – regardless of our age, position in the hierarchy, or role in the company. We’re all on first name terms and are always available for our colleagues.

• Work across the full data lifecycle on client engagements — from data pipelines and models to schemas, taxonomies, and data architecture.
• Translate ambiguous business questions into sound, scalable data solutions.
• Take ownership of key data deliverables and see them through to a high-quality result.
• Partner with clients and stakeholders, communicating clearly with both technical and non-technical audiences.
• Contribute to consulting engagements end to end, including research, analysis, deliverable creation, and continuous status reporting.
• Help shape and grow a budding team of data engineers and consultants, sharing your experience as the practice expands.
• Be fluent in working with AI tools (e.g., ChatGPT, Copilot, Claude, Gemini) on a daily basis.
• Engage in internal initiatives to shape our growing U.S. organization.

Join a dynamic team with a Start-Up atmosphere supported by strong roots of 30 years of successful business in Europe. If you are looking for a fast-paced working environment with exciting and innovative mandates around business transformation and if you are enjoying working closely with great colleagues and great clients, then this is a unique opportunity for you.

Professional & Personal
You can expect excellent project work and a trusting atmosphere with your colleagues supervisors where you are challenged to contribute to impactful projects across the Project, Program, and Portfolio Management service spectrum of our NY-based team. 

Live Collaboration
Mentoring from senior professionals and engagement in an active exchange of knowledge with over 600 consultants worldwide in forums and special expertise groups.

Compensation
The salary range for this position is $120,000 to $132,000 per year and total compensation for this role includes base salary, annual discretionary performance bonus, and a comprehensive benefits package described below.
We expect total annualized compensation for New York City-based employees to be approximately the following:

• Base salary between $120,000 - $132,000 p.a.. Placement within this range will vary based on experience and skill level 
• Annual discretionary performance bonus between 0-20% 

In addition, we offer a comprehensive benefits package, including:

• 25 days of PTO p.a.
• 10 company paid holidays p.a.
• 5 days of professional development p.a.
• Option for employees to make personal contributions to a 401(k) plan, as well as 401(k) matching offered by Campana & Schott
• Attractive health benefits
• Annual company trip and regular team events

All qualified applicants will receive consideration for employment without regard to age, race, creed, color, national origin, ancestry, marital status, sex, affectional or sexual orientation.

• Bachelor’s or Master’s degree in Computer Science, Data Science, Engineering, or a related field.
• 2-5 years of hands-on experience in a data-focused role as a technical data analyst, data engineer, or data architect.
• Programming skills (e.g., Python, SQL) relevant to data manipulation, transformation, and pipeline development.
• Experience with cloud data platforms such as Azure, Databricks, AWS, or Snowflake.
• Experience with data modeling: designing AI-ready schemas, taxonomies, and data structures that balance performance with flexibility.
• Experience with data governance, data quality, or compliance frameworks.
• An appetite to grow into a strong data architecture and client-facing consulting profile.
• Strong communication skills: you can explain technical concepts clearly to both technical and non-technical audiences.
• Analytical mindset, entrepreneurial spirit, and self-motivated working attitude.
• Ability to effectively manage your time and tasks in a fast-paced environment.
• Willingness to travel.

Nice-to-Haves

• Experience designing data schemas or taxonomies for marketing or omnichannel commercial use cases.
• Experience designing data schemas or taxonomies for marketing or omnichannel commercial use cases.
• Familiarity with orchestration and transformation tools (e.g., Airflow, dbt).
• Previous experience in a client-facing or collaborative team environment.
• Life sciences, healthcare, or pharmaceuticals experience.