Senior Snowflake Engineer

About Bramcolm, LLC

Founded in 2003, Bramcolm, LLC has been at the forefront of IT solutions for two decades, consistently delivering cutting-edge services tailored to meet the evolving needs of businesses. Based in Indianapolis, IN, our boutique firm has built a reputation for excellence in the IT services and consulting industry.

At Bramcolm, we are committed to leveraging advanced technologies such as AI, machine learning, and cloud computing to deliver efficient, scalable, and user-friendly solutions. Our collaborative approach involves working closely with clients to understand their unique needs and tailor our services accordingly. We value creativity, agility, and excellence, fostering a culture that encourages continuous learning and growth.

Our team comprises talented professionals from diverse backgrounds who are passionate about making a positive impact through technology. We offer a supportive work environment with opportunities for professional development, career advancement, and the chance to work on meaningful projects across various industries.

Position Summary

The Bramcolm team is seeking a Senior Snowflake Engineer with deep expertise in Snowflake data architecture and a strong command of cloud technologies. You will design, develop, and maintain scalable data environments that serve as the foundation for our analytics and business intelligence solutions.

Given our support for a diverse range of clients, you will have the opportunity to engage in projects across different domains. This means the role may involve participation in entirely unrelated projects, requiring a high degree of flexibility and adaptability. You will need to quickly understand new data sources, business processes, and industry-specific requirements to deliver effective data solutions.

As a key member of our team, you will collaborate closely with cross-functional teamsincluding data analysts, data scientists, software developers, and business stakeholdersto ensure the integrity, availability, and reliability of our data systems.

What You'll Do

• Architect, design, and optimize Snowflake data warehouses and other cloud-based data platforms, leveraging Infrastructure as Code (IaC) principles.
• Establish robust data modeling practices (e.g., dimensional modeling, schema design) and define metadata management and governance frameworks.
• Develop and manage end-to-end data pipelinesensuring efficient ingestion, transformation, and delivery of large-scale datasets.
• Implement data quality controls, validation checks, and alerting mechanisms to maintain accuracy and consistency.
• Enforce data security measures, privacy regulations, and industry compliance standards within all data solutions.
• Collaborate with cross-functional teams to gather data requirements and translate them into scalable Snowflake architectures.
• Adapt rapidly to projects spanning various domains, aligning each data solution with project-specific goals and regulatory guidelines.
• Communicate with internal and external stakeholders to provide technical guidance and actionable insights on Snowflake best practices.
• Monitor data performance, troubleshoot issues, and implement proactive measures to ensure system reliability.
• Continuously learn and adopt new tools, technologies, and methodologies to address evolving data needs in diverse industries.

Requirements

Required Skills

• Bachelor's or Master's degree in Business, Data Science, Statistics, Computer Science, or a related field.
• Minimum of 5 years of experience in data architecture, data warehousing, or a similar role.
• Proven expertise with Snowflake, including performance tuning, micro-partitioning, and advanced security features.
• Proficiency and knowledge in various programming languages such as Python, Java, or Scala.
• Experience with cloud platforms (AWS, Azure, or GCP) and IaC tools (Terraform, GitHub Actions, Jenkins).
• Familiarity with related cloud data services (e.g., Redshift, S3) and best practices for distributed data processing.
• Understanding of data security, privacy regulations, and compliance standards.
• Proven experience working with large and complex datasets and working knowledge of data engineering concepts like ETL and data ingestion methodologies.
• Strong analytical and problem-solving skills with attention to detail with minimal supervision and a commitment to delivering high-quality work.
• Excellent communication and presentation abilities and the ability to work collaboratively in a team environment.
• High degree of flexibility and adaptability to work on diverse projects across different domains.

Other Requirements

This is a hybrid role, offering the flexibility to work from home and from the office located in Boston, MA.

Must be legally authorized to work in the United States.

Must pass background check.

Must pass Criminal background check.

Must pass CORI check for CJIS Certification.