Senior Snowflake Engineer Position

Company Overview

xFact, Inc. is a rapidly expanding organization dedicated to providing innovative solutions to Government agencies.

We strive to foster a culture of innovation, collaboration, and continuous learning.

Job Requirements

The ideal candidate will possess extensive knowledge of Snowflake data architecture and be skilled in designing scalable data environments.

With a focus on supporting a diverse range of public sector organizations, you will have opportunities to engage in projects across multiple domains.

This requires the ability to quickly adapt to new data sources, business processes, and industry-specific requirements.

Responsibilities

• Design, develop, and maintain scalable data environments that serve as the foundation for our analytics and business intelligence solutions.
• Leverage Infrastructure as Code (IaC) principles to architect, design, and optimize Snowflake data warehouses and other cloud-based data platforms.
• Establish robust data modeling practices and define metadata management and governance frameworks.
• Develop and manage end-to-end data pipelines to ensure efficient ingestion, transformation, and delivery of large-scale datasets.
• Implement data quality controls, validation checks, and alerting mechanisms to maintain accuracy and consistency.
• Ensure data security measures, privacy regulations, and industry compliance standards are implemented 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.
• Monitor data performance, troubleshoot issues, and implement proactive measures to ensure system reliability.
• Stay up-to-date with emerging technologies and methodologies to address evolving data needs in diverse industries.

Requirements

• Bachelor's or Master's degree in a relevant field.
• Minimum 5 years of experience in data architecture, data warehousing, or a similar role.
• Expertise with Snowflake, including performance tuning, micro-partitioning, and advanced security features.
• Knowledge of 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 relevant to public sector data.
• Proven experience working with large and complex datasets and knowledge of data engineering concepts like ETL and data ingestion methodologies.
• Strong analytical and problem-solving skills with attention to detail and commitment to delivering high-quality work.
• Ability to work in a fast-paced environment with flexibility and adaptability.

Work Environment

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

The specific days in the office will be determined based on team needs and individual preferences.

Salary and Benefits

Please include a brief statement of your salary expectations to help us understand your goals.

We offer dental insurance, Flexible Spending Account Plan (FSA), 13 days paid state & federal holidays, and Paid Family and Medical Leave.