Senior Data Consultant

Campana & Schott • New York, NY

4d • Onsite

About The Position

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. 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.

Requirements

• 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.
• 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.

Responsibilities

• 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.

Benefits

• 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

What This Job Offers

• Job Type: Full-time
• Career Level: Senior