Data Engineer

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 pipelines—ensuring 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 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 Monitor data performance, troubleshoot issues, and implement proactive measures to ensure system reliability Communicate with internal and external stakeholders to provide technical guidance and actionable insights Work closely with data analysts, data scientists, software developers, and business stakeholders Continuously learn and adopt new tools, technologies, and methodologies to address evolving data needs Required Qualifications 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 in programming languages such as Python, Java, or Scala Experience with cloud platforms (AWS, Azure, or GCP) and IaC tools (Terraform, GitHub Actions, Jenkins) Understanding of data security, privacy regulations, and compliance standards Strong analytical and problem-solving skills with attention to detail Excellent communication and presentation abilities Preferred Qualifications Experience with public health data analytics and government sector projects Familiarity with public sector compliance frameworks (HIPAA, FISMA, FedRAMP) Experience working with government reporting standards or large-scale government data systems Knowledge of data governance, metadata management, and quality frameworks Experience with Tableau and other data visualization platforms Location & Requirements 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 #J-18808-Ljbffr Bramcolm, LLC