What are the responsibilities and job description for the Senior Snowflake Engineer position at xFact, Inc.?
THIS IS A HYBIRD ROLE!!
Job Title: Senior Snowflake Engineer
About xFact
xFact, Inc. is a rapidly growing company serving various Government agencies. We are a team of passionate and driven individuals who are committed to building innovative products and services.
At xFact, 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 products and 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 that serve the public good.
Join us at xFact and be a part of a forward-thinking company dedicated to driving innovation in the public sector.
Position Summary
The xFact 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 public sector organizations, 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 teams—including data analysts, data scientists, software developers, and business stakeholders—to 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 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.
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.
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 relevant to public sector data.
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 our office located in North Andover, MA. The specific days in the office will be determined based on team needs and individual preferences.
· Must be legally authorized to work in the United States.
· Must pass Criminal background check.
· Must pass CORI check for CJIS Certification.
As part of your application, please include a brief statement of your salary expectations to help us understand your goals.
Perks working with xFact, Inc.
· Competitive salary and benefits package.
· Health insurance
· Dental insurance
· Vision insurance
· xFact 401(k) Plan
· Flexible Spending Account Plan (FSA)
· Paid time off – accrued.
· Sick Leave.
· 13 days paid state & federal holidays.
· Paid Family and Medical Leave
· Military Leave (USERRA)
· Opportunity to work on cutting-edge technology.
· Work with a talented, empathetic, compassionate, and supportive team.
