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.
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.
Key Responsibilities
Data Architecture & Engineering
- Architect, design, and optimize cloud-native data platforms , including data warehouses (e.g., Snowflake, Redshift, BigQuery) and lakehouse architectures (e.g., Databricks, Delta Lake) , supporting advanced data engineering and machine learning pipelines using Spark .
- Work with Airflow for orchestration of ETL workflows
- Establish robust data modeling practices 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
Technical Leadership
Enforce data security measures, privacy regulations, and industry compliance standards within all data solutionsCollaborate with cross-functional teams to gather data requirements and translate them into scalable Snowflake architecturesAdapt rapidly to projects spanning various domains, aligning each data solution with project-specific goalsMonitor data performance, troubleshoot issues, and implement proactive measures to ensure system reliabilityCommunicate with internal and external stakeholders to provide technical guidance and actionable insightsWork closely with data analysts, data scientists, software developers, and business stakeholdersContinuously learn and adopt new tools, technologies, and methodologies to address evolving data needsRequired Qualifications
Bachelors or Masters degree in Business, Data Science, Statistics, Computer Science, or a related fieldMinimum of 5 years of experience in data architecture, data warehousing, or a similar roleProven expertise with Snowflake, including performance tuning, micro-partitioning, and advanced security featuresProficiency in programming languages such as Python, Java, or ScalaExperience with cloud platforms (AWS, Azure, or GCP) and IaC tools (Terraform, GitHub Actions, Jenkins)Understanding of data security, privacy regulations, and compliance standardsStrong analytical and problem-solving skills with attention to detailExcellent communication and presentation abilitiesPreferred Qualifications
Experience with public health data analytics and government sector projectsFamiliarity with public sector compliance frameworks (HIPAA, FISMA, FedRAMP)Experience working with government reporting standards or large-scale government data systemsKnowledge of data governance, metadata management, and quality frameworksExperience with Tableau and other data visualization platformsLocation & Requirements
Must be legally authorized to work in the United StatesMust pass background checkMust pass Criminal background checkMust pass CORI check for CJIS Certification#J-18808-Ljbffr