Solution Architect with Snowflake

C&F is a technology services company providing innovative solutions in Data Management, Big Data, Advanced Analytics and Compliance. With a highly integrated team of 400+ experts, for over 20 years C&F has been delivering superior engineering and premium operations to Fortune 500 companies, primarily in the Life Science industry.

We’re looking for a Solution Architect with Snowflake - Team Lead experience to join our team. The ideal candidate will have a strong background in designing and optimizing data solutions while leading and mentoring a small team of data engineers. You’ll drive the architecture of end-to-end data solutions, ensuring alignment with business and technical goals.

If you thrive in leadership and enjoy empowering your team, we’d love to hear from you!

You will be responsible for:

• Design and Architect Data Solutions using Snowflake, ensuring scalability, reliability, and efficiency.
• Guide the team in creating efficient, high-performance data pipelines, using Snowflake, dbt, and other tools.
• Develop and manage dbt models, including the ability to write, parameterize, and deploy models that align with architectural design.
• Oversee data flow concepts and data modeling best practices, ensuring that architectural decisions meet both business and technical requirements.
• Provide leadership and technical guidance during design reviews to ensure that solutions meet security, scalability, and performance requirements.
• Develop and maintain CI/CD practices to streamline deployment, testing, and monitoring.
• Write and maintain data tests to ensure the quality and reliability of data infrastructure.
• Facilitate cross-functional collaboration to understand business requirements and translate them into technical solutions.

What you will need:

• Strong experience designing and implementing data solutions in Snowflake.
• Proven ability to lead and manage teams, offering mentorship and fostering a collaborative environment.
• Expertise in dbt for model creation, management, and parameterization.
• Experience with PostgreSQL and Oracle databases, including data migration, optimization, and query performance tuning.
• Hands-on experience working with data warehouses, ensuring efficient ETL processes, managing large datasets, and optimizing data storage and retrieval for analytics.
• Advanced understanding of data flow concepts and data modeling.
• Experience with CI/CD practices and their integration into data engineering workflows.
• Hands-on experience with Bash or Python for scripting, automation, and process orchestration.
• Strong communication and leadership skills, with a proven track record of managing and motivating teams.
• Strong problem-solving skills, with the ability to think strategically and adapt to changing project needs.
• Experience in providing technical leadership and architectural guidance during projects.

Nice to have:

• Familiarity with GraphQL API and its integration in data systems.
• Experience with Collibra or Alation for data governance and cataloging.
• Knowledge of Data Quality processes, including testing, scoring, and the importance of data reliability

✨ What we offer:

• Flexible cooperation terms: Choose between full-time employment or a contract-based agreement.
• Professional Development Support: Access a dedicated budget for your professional development and get reimbursed for English classes.
• Remote-First Approach: While we primarily work remotely, we ask employees to be open to occasional office visits (in agreement with their leader).
• Comprehensive Benefits Package: Enjoy private medical care (Medicover/Luxmed), sports memberships (Multisport), and access to the Employee Capital Plan (PPK).
• Exciting Events: Experience the best of C&F Office Days—great food, exciting tournaments, and expert-led sessions during our Happy Tech Hours. Plus, enjoy spontaneous pop-up events like kayaking adventures, guided tours, and family picnics.
• Team-Building Budget: Take advantage of a quarterly budget for team fun—whether it’s dining out, bowling, or any other experience you choose.
• A Vibrant Company Culture: We foster a respectful, collaborative environment that values teamwork over competition. Whether you're seeking a refreshing change from corporate monotony or looking to continue thriving in a positive work culture, you'll find a supportive and engaging workplace here.