Snowflake Data Engineer

Q1 Technologies, Inc

Boston, MA

JOB DETAILS
SKILLS
Amazon Simple Storage Service (S3), Amazon Web Services (AWS), Architectural Analysis, Caching, Cloning, Cloud Computing, Code Reviews, Communication Skills, Continuous Deployment/Delivery, Continuous Integration, Cost Control, Data Analysis, Data Management, Data Modeling, Data Quality, Data Warehousing, Database Extract Transform and Load (ETL), Database Technology, DevOps, Dimensional Modeling, Documentation, GCP (Good Clinical Practices), Git, Information/Data Security (InfoSec), Microsoft Windows Azure, Performance Tuning/Optimization, Problem Solving Skills, Python Programming/Scripting Language, SQL (Structured Query Language), Service Level Agreement (SLA), Snowflake Schema, Source Code/Configuration Management (SCM), Star Schema, Use Cases
LOCATION
Boston, MA
POSTED
30+ days ago

Job Title: Snowflake Data Engineer- (10 plus years)
Location: Boston, MA, (Onsite)
Job Type: Contract


Job Description:

Competencies: 10+ years experience required
Digital : DevOps
Digital : Snowflake

Role Summary:
We are seeking a hands-on Snowflake Data Engineer to design, build, optimize, and productionize data pipelines and data products on Snowflake for enterprise analytics use cases. The role requires deep expertise in SQL, ELT/ETL orchestration, data modeling (3NF/Star/Snowflake), performance tuning, cost optimization, and secure data sharing in Snowflake. You'll collaborate with Product Owners, Data Architects, Analytics Engineers, and Platform teams to deliver reliable, scalable, and well-governed data solutions for TJX.

Must have:
  • Snowflake (Hands-on Expert):
  • Warehouses, Databases, Schemas, Roles & Grants (RBAC) Stages (internal/external), File Formats, COPY INTO, Snowpipe, Streams & Tasks Time Travel, Cloning, Zero-Copy Clones, Fail-safe awareness Query tuning (clustering keys, micro-partitions, caching, pruning) Secure data sharing, masking policies, tags, governance features BCR, DR, Storage integration and Parameters Materialized / Semantic Views, Dynamic Tables, Stream Lit, Snowflake Architecture SQL Mastery: Strong, production-grade SQL for large-scale transformations.
Good to have:
  • Programming: Python (preferred) for ELT utilities, framework integration, data quality checks; dbt for transformation-as-code is a strong plus.
  • Orchestration: Airflow (preferred) or ADF/Glue/Composer; scheduling, dependencies, retry policies, SLAs.
  • Data Modeling: Dimensional modeling (Kimball), SCD Type 1/2; normalization/denormalization trade-offs; exposure to data vault is a plus.
  • Cloud Platforms: Experience with at least one major cloud (AWS/Azure/GCP) for storage (S3/ADLS/GCS), IAM, networking basics, and secrets management.
  • Version Control & CI/CD: Git workflows, branching, code reviews, packaging, environment promotion.
  • Data Quality: Testing frameworks (dbt tests, Great Expectations) and monitoring/observability.

Soft Skills:
  • Clear communicator, documentation-first mindset, proactive problem solver, vendor-collaboration friendly.

About the Company

Q

Q1 Technologies, Inc

Q1 consists of experienced and recognized experts providing the capability to respond to market demand in order to provide professional services for our clients including Enterprise software implementations, application integration and technical / functional support.

Q1 has steadily grown into a Quality IT services and solutions organization with the average experience of our team being over 10 years. We have continuously met or exceeded client expectations by delivering professional services and project implementations on time and under budget to help clients truly recognize return on investment.

COMPANY SIZE
500 to 999 employees
INDUSTRY
Computer/IT Services
FOUNDED
1990
WEBSITE
http://q1tech.com/