Data Consultant - Denodo

Joining Capco means joining an organisation that is committed to an inclusive working environment where you’re encouraged to #BeYourselfAtWork. We celebrate individuality and recognize that diversity and inclusion, in all forms, is critical to success. It’s important to us that we recruit and develop as diverse a range of talent as we can and we believe that everyone brings something different to the table – so we’d love to know what makes you different. Such differences may mean we need to make changes to our process to allow you the best possible platform to succeed, and we are happy to cater to any reasonable adjustments you may require. You will find the section to let us know of these at the bottom of your application form or you can mention it directly to your recruiter at any stage and they will be happy to help.

About Capco

Capco is a global technology and business consultancy, focused on the financial services and energy sectors. We are passionate about helping our clients succeed in an ever-changing industry.

We are:

• Experts in capital markets, banking and payments, wealth and asset management and energy.
• Deep knowledge in financial services offering, including e.g. Finance, Risk and Compliance, Financial Crime, Core Banking etc.
• Committed to growing our business and hiring the best talent to help us get there
• Focus on maintaining our nimble, agile and entrepreneurial culture

YOUR CAPCO DAY

• Engage business stakeholders to determine which tables and datasets are needed, identify and assess source systems, and design and build the corresponding virtual tables in Denodo.
• Publish secure, reliable services, define caching and freshness strategies, and document lineage and data contracts to meet agreed service-level objectives.

YOUR CAPCO FIT 

• Practical experience with Denodo as a data virtualization platform: connecting heterogeneous sources (including Snowflake), designing base and derived virtual views, defining caching and freshness, optimizing push-down execution, publishing services (for example Java Database Connectivity, Open Database Connectivity, and Representational State Transfer), and implementing security at the semantic layer.
• Proficient in data discovery and profiling: evaluate source systems, assess data quality, interpret metadata, map business terms to physical fields, prototype joins and aggregations, and reconcile discrepancies.
• Strong Structured Query Language skills for querying, diagnostics, and performance analysis.
• Experience defining semantic models, dataset naming conventions, data contracts, documentation, and lineage.
• Observability and monitoring of semantic-layer usage and performance; cost awareness and continuous improvement.
• Governance knowledge: role-based access control, masking, and row or column policies applied in the semantic layer.
• Versioning and deployment: Git-based version control, environment promotion, and continuous integration and continuous delivery for virtualization artifacts.
• Lead stakeholder interviews and requirement workshops; translate needs into clear dataset specifications and acceptance criteria.
• Create mock tables, data dictionaries, and clear design documents; run demos and iterate based on feedback.
• Drive user acceptance testing, training, and onboarding for analysts and business users.
• Collaborate across platform, engineering, and analytics teams; share knowledge and support governance processes.
• Results orientation with measurable service-level objectives and continuous improvement.
• Fluency in English plus fluent German (for Zürich based candidates) or fluent French (for Geneva based candidates).

Ready to take the Next Step 

If this sounds like you, we would love to hear from you.  This is an opportunity to make a difference and contribute to a highly successful company with a significant growth trajectory.