About the Team:
Capco’s Data Team helps our clients transform every aspect of their business. We are highly skilled at formulating data strategy, defining business and technology initiatives across the data management lifecycle, and aligning multi-year strategic roadmaps with client’s business goals. As digital technologies advance and regulations tighten, today’s consumers – and, therefore, today’s businesses – are becoming more aware of the importance of good quality data. We work to establish holistic ways to effectively manage data through the modern data supply chain and facilitate consumption through analytics, modelling, AI, machine learning, dashboarding, and reporting.
About the Job:
As a member of our Data Team, you will work across Capco’s different domains and solution offerings to help break down large problems, develop approaches and solutions. As a Principal Consultant Tech Lead, you will work with our clients to architect, design and implement complex cloud and big data solutions.
What You’ll Get to Do:
- Architect and design complex data solutions on Snowflake, Data Sharing, Data Exchange, Snowflake Internal Marketplace, including data models, data ingestion pipelines, and data transformations, ensuring best practices and scalability.
- Build and Implement Big Data principles/solutions on MS Fabric/OneLake.
- Integrate Snowflake data platform with Non-snowflake clients (Vice-Versa.)
- Design data structures and optimize data organization within Snowflake to support efficient querying and analysis.
- Design standard Datawarehouse models using Star schema and Data Vault practices and support SCD-2 scenarios.
- Implement ETL/ELT processes to integrate data from various sources into Snowflake and MS Fabric/OneLake, ensuring data quality and consistency.
- Monitor and optimize Snowflake queries, data loading strategies, and warehouse configurations to maximize performance.
- Implement data security measures within Snowflake to protect sensitive data, adhering to industry regulations and compliance standards.
- Set up and maintain continuous integration and continuous delivery pipelines for Snowflake applications.
- Work closely with cross-functional teams like business analysts, product managers, and data scientists to understand data requirements and translate them into technical solutions.
- Lead and mentor a team of engineers on Snowflake development, providing technical guidance, code reviews, and problem-solving support.
What You’ll Bring with You:
- Experience designing, building and implementing architectural strategies.
- An understanding of Snowflake internals for any customization using configuration changes
- Experience with Cloud-native Application/Big Data principles and experience building Cloud-native data solutions using AWS/Azure cloud stack.
- Strong understanding of open data formats like Iceberg and delta for specific Investment banking use cases.
- Experience building Data Mesh and Data Products, publishing/consuming data products on Marketplace using Snowflake or AWS or Azure.
- Experience using AWS stack using S3, Glue, Lambda, Snowflake platform on AWS, Redshift and Glue catalog.
- Strong understanding of Azure stack (ADLS2.0, ADF2.0, Synapse)
- Programming experience in Python and Pyspark, Java, Notebook development using VSCode and performance improvement practices.
- Excellent communication and collaboration skills to work with diverse teams.
- Proven ability to lead technical projects and mentor junior engineers.
Why Capco?
A career at Capco is a chance to help reshape the competitive landscape in financial services. We launch new banks, transform existing ones, and help our clients navigate complex change. As consultants, we work on the front-end business design all the way through to technology implementation.
We are the largest Financial Services focused consultancy in the world, serving everyone from global banks to emerging FinTechs, from strategy through digital transformation, design, business consulting, data and analytics, cyber, cloud, technology architecture, and engineering.
Capco is a young and growing firm. We maintain an entrepreneurial spirit and growth mindset, and have minimal bureaucracy. We have no internal silos that get in the way of your career opportunities or ability to focus on our clients and make a difference to the business. We offer the opportunity for everyone to learn rapidly, take on tough challenges, and get promoted quickly. We take pride in our creative, collaborative, diverse, and inclusive culture, where everyone can #BYAW.
We offer highly competitive benefits, including medical, dental and vision insurance, a 401(k) plan, tuition reimbursement, and a work culture focused on innovation and creation of lasting value for our clients and employees.
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.
#LI-Hybrid
New York Pay Range
$151,000—$195,000 USD
Top Skills
What the Team is Saying
What We Do
Capco, a Wipro company, is a global management and technology consultancy specializing in driving transformation in the energy and financial services industries. Capco operates at the intersection of
business and technology by combining innovative thinking with unrivalled industry knowledge to fast-track digital initiatives for banking and payments, capital markets, wealth and asset management, insurance,
and the energy sector. Capco’s cutting edge ingenuity is brought to life through its award-winning Be Yourself At Work culture and diverse talent.
TRUSTED ADVISORS - Our collaborative and entrepreneurial approach position us as trusted long-term partners to our clients.
DEEP EXPERTISE - Clients look to us for clear guidance, proven expertise, and the support they need to set their companies up for success.
DISRUPTIVE SOLUTIONS- We do not provide off -the-shelf answers to clients’ challenges. Instead, we work in close collaboration to understand the issues, and craft disruptive, bespoke solutions.
ACCOUNTABILITY AND OWNERSHIP - We recognize every client has distinct needs and expectations, and we take ownership and accountability for the solutions we design, build, and deliver.
Why Work With Us
We support and encourage an inclusive culture, entrepreneurial outlook and independent thinking. Capco is not about organizational charts and rigid hierarchies – we want all employees to feel that Capco is their firm to own and run. We believe diversity powers innovation. Be Yourself At Work (#BYAW) is an integral and underlying part of our culture
Gallery
Capco Offices
Hybrid Workspace
Employees engage in a combination of remote and on-site work.
.jpg)
