Senior Data Warehouse Architect
New York, NY, 10016
Job Title: Senior Data Warehouse Architect
Location-Type: Remote
Start Date Is: ASAP
Duration: (contract, perm, etc) 3-5 Month Contract
Compensation Range: $90-105/hr
Benefits: Eligible for Health, Dental, Vision, 401K
Must be authorized to work in the U.S. This position is not eligible for sponsorship .
We are seeking an Enterprise Data Warehouse Architect to design and build our first cloud data warehouse on Snowflake for a multi-tenant SaaS platform. This role will own the architecture from the ground up, including data ingestion, modeling, governance, security, tenant isolation, reporting, AI/ML enablement, and secure client data sharing. The ideal candidate is equally comfortable building hands-on and mentoring a team that is new to data warehousing.
Key Responsibilities
- Design and build the Snowflake data platform from scratch, including environments, data layers, RBAC, ingestion, transformations, orchestration, testing, monitoring, and CI/CD.
- Develop pipelines from Microsoft SQL Server, evaluating CDC, Change Tracking, batch, and managed ingestion solutions.
- Establish multi-tenant data architecture and security, including tenant isolation, row-level security, masking, encryption, auditing, retention, and compliance controls.
- Architect solutions for historical data, high-volume reporting, and data archival, reducing the footprint and performance impact on core SQL Server databases.
- Enable embedded/customer-facing analytics and reporting, including scalable query execution, caching, asynchronous processing, and cost controls.
- Build governed data models and semantic layers to support AI/LLM-driven analytics and text-to-SQL, with appropriate security and query guardrails.
- Design secure Snowflake data-sharing solutions for clients, including provisioning, access controls, monitoring, and revocation.
- Partner with engineering and business stakeholders to evaluate Snowflake, AWS, Databricks, Redshift, and lakehouse architectures and make pragmatic technology decisions.
- Mentor engineers new to data warehousing through pairing, code reviews, documentation, runbooks, and knowledge transfer, ultimately transitioning ownership to the internal team.
Required Experience:
- 8 years in data engineering or architecture, including 3 years of production Snowflake experience.
- Proven experience building an enterprise data warehouse from the ground up.
- Strong SQL Server expertise, including CDC/Change Tracking, large-scale data management, and performance optimization.
- Hands-on experience with dbt, data modeling, and modern ingestion/orchestration tools.
- Proven experience designing multi-tenant data platforms with strong tenant isolation.
- Strong background in data security, governance, RBAC, row-level policies, masking, auditing, and compliance.
- Solid AWS experience, particularly S3, IAM, and AWS AI/data services.
- Ability to clearly communicate architectural trade-offs around ELT vs. ETL, batch vs. streaming, warehouse vs. lakehouse, cost, scalability, and data freshness.
Preferred Qualifications:
- Embedded or customer-facing analytics experience.
- Production experience with LLM, text-to-SQL, or AI-powered data products.
- SnowPro Advanced certification.
- Experience with licensing, rights management, royalty, or entitlement data.
- Experience with Power BI, Sigma, Tableau, or similar BI platforms.
-
Data Engineer
Baltimore, MD, 21202
Job Title: Data Engineer Location-Type: Hybrid / Travel – Baltimore, MD (50–75% onsite) Work Hours: 40 Hours/Week Start Date Is: ASAP Duration: Permanent Compensation Range: $100,000–$150,000/year Benefits: Eligible for Medical, Dental, Vision, 401(k),...
Date Posted: 09/25/2026 Recommended
-
Sr. Dev SecOps Engineer
Danboro, PA, 18916
Job Title: Senior DevSecOps Engineer Location-Type: Hybrid - Danboro, PA Start Date: ASAP Duration: Permanent Compensation Range: $140,000 - $160,000/yr Benefits: Health, Dental, Vision, 401K, PTO, Tuition Reimbursement Visa Sponsorship: Not eligible f...
Date Posted: 09/25/2026 Recommended
-
Sr. Dev SecOps Architect
Danboro, PA, 18916
Apply now: Senior DevSecOps Architect, location is Hybrid. The start date is October 1, 2026 at the latest for this 6 Month C2H position. Job Title: Senior DevSecOps Architect Location-Type: Hybrid Start Date Is: October 1, 2026 at the latest Duration:...
Date Posted: 09/25/2026 Recommended
-
Lead BI/Data/Web Developer
New York, NY, 10017
Job Title: Lead BI/Data/Web Developer Location-Type: Hybrid (3 days/week onsite: Mon/Tue/Thu, in NYC or Tysons, VA) Start Date Is: ASAP Duration: Permanent, Direct Hire Compensation Range: $130,000-$155,000/yr Benefits: Eligible for Health, Dental, Vis...
Date Posted: 09/25/2026 Recommended
-
Web Developer
New York, NY, 10016
Title: Web Developer Location: Hybrid NYC or VA - 3 days/ week onsite Duration: Permanent - Direct Hire Salary Range: $130-155 K Benefits: Eligible for Health, Dental, Vision, 401K Must be authorized to work in the U.S. This position is not eligible fo...
Date Posted: 09/25/2026 Recommended
-
Data Platform Tech Lead
Fallriver, MA, 02720
Apply now: Data Platform Tech Lead, location is Remote (Hybrid once a month in Fall River, MA). The start date is ASAP for this permanent position. Job Title: Data Platform Tech Lead Location-Type: Remote (must reside within driving distance of Fall Ri...
Date Posted: 09/25/2026 Recommended
-
Principal Cloud Architect
Newtown Square, PA, 19073
Apply now: Principal Cloud Architect, location is Hybrid (Herndon, VA). The start date is ASAP for this contract-to-hire position. Job Title: Principal Cloud Architect Location-Type: Dulles Corner Blvd. Herndon, VA 20171 (Hybrid - 2–3 Days A Week Onsit...
Date Posted: 09/25/2026 Recommended
-
AI Administrator
New York, NY, 10018
Job Title: AI Administrator Location-Type: Remote (US Based) Start Date Is: ASAP Duration: (contract, perm, etc) 1-2 Month Contract Compensation Range: $60-70/hour W2 Benefits: Eligible for Health, Dental, Vision, 401K Must be authorized to work in the...
Date Posted: 09/25/2026 Recommended
-
SAP Principal Architect
Herndon, VA, 20171
Apply now: Principal Cloud Architect (SAP), location is Hybrid — Herndon, VA (onsite 2–3 days/week, Tue–Thu). The start date is ASAP for this contract-to-hire position. Job Title: Principal Cloud Architect (SAP) Location-Type: Hybrid — Herndon, VA (ons...
Date Posted: 09/25/2026 Recommended
-
SQL Production Support
Centreville, VA, 20120
Apply now: SQL Production Support, location is Remote. The start date is October 5 for this contract position. Job Title: SQL Production Support Location-Type: Remote Start Date Is: October 5 Duration: Contract through December 31 with Potential for Ex...
Date Posted: 09/25/2026 Recommended
-
AI Operations Lead
New York, NY, 10016
Position: AI Agent Platform Lead Location: Hybrid NY, NY; Hartford; CT; Boston, MA; Wellesley, MA; Chicago,IL Duration: 3+ month contract to hire Rate: $75-80/hr W2 Role Summary Our client is seeking a hands-on AI Agent Platform Lead to build and scale...
Date Posted: 09/25/2026 Recommended
-
Senior IT Systems Engineer
Andover, MA, 01810
Job Title: Senior Principal, Information Systems Engineer Location-Type: Hybrid (3x week) – Andover, MA Start Date Is: ASAP Duration: 6 months contract Compensation Range: $75-$80/hour W2 Benefits: Eligible for Health, Dental, Vision, 401K Must be auth...
Date Posted: 09/25/2026 Recommended
-
Software Engineer
New York, NY, 10154
Job Title: Software Developer, Python & Analytics Location-Type: Hybrid, New York, NY (3 days onsite per week) Must reside local to NYC currently, relocation will not be considered at this time. Start Date: ASAP Duration: Contract Compensation Range: $...
Date Posted: 09/25/2026 Recommended
-
AI Project Manager
Wilmington, DE, 19803
Apply now: AI Program & Project Manager, Remote. Start date is ASAP for this 6-12 month contract position. Job Title: AI Program & Project Manager Location-Type: Remote (travel up to 50% required, including potential international; primary travel hub i...
Date Posted: 09/25/2026 Recommended
-
Sr. Business Analyst
New York, NY, 10001
Job Title: Senior Business Analyst Location-Type: Onsite in NYC, NY. Must reside local to NYC - relocation will not be considered at this time. Start Date Is: ASAP Duration: (contract, perm, etc): Full Time Permanent Compensation Range: 95-115k/yr bene...
Date Posted: 09/25/2026 Recommended
-
Active Directory Admin/Engineer
New York, NY, 10022
Job Title: Active Directory Administrator/Engineer Location-Type: Fully Onsite at one of the following locations: 731 Lexington Avenue, New York, NY 10022 120 Park Avenue, New York, NY 10117 919 3rd Avenue, New York, NY 10022 Start Date: ASAP Duration:...
Date Posted: 09/25/2026 Recommended
-
IAM Engineer
Salem, NH, 03079
Apply now: IAM Engineer, Remote (East Coast). Start date is ASAP for this 6-month contract position with option to extend. Job Title: IAM Engineer Location: Remote - East Coast Only! Start Date: ASAP (within 2 weeks of offer) Duration: Contract, 6 mont...
Date Posted: 09/25/2026 Recommended
-
HRIS Analyst
Denver, CO, 80247
Apply now: HRIS Analyst, Remote. Start date is ASAP for this contract position ending May 31, 2027. Job Title: HRIS Analyst Location-Type: Remote Start Date: ASAP Duration: Contract, through May 31, 2027 Compensation Range: $40-45/hr Benefits: Eligible...
Date Posted: 09/25/2026 Recommended
-
Group Product Manager, Platforms
Centerville, VA, 20120
Job Title: Group Product Manager – Platform Location-Type: Remote (U.S. Based) Travel Start Date Is: ASAP Employment Type: Full-Time / Permanent Travel: Approximately 2–3 days per month for team meetings and occasional client visits Compensation Range:...
Date Posted: 09/25/2026 Recommended
-
AI Product Engineer
Charlottesville, VA, 22902
AI Product Engineer Location: Remote – U.S. Employment Type: 6-Month Contract-to-Hire Hours: 40 hours/week; core hours 9:00 AM–3:00 PM ET Travel: None Target Rate: Up to $75/hr, with potential flexibility Conversion Salary: $120K–$140K Benefits: Eligib...
Date Posted: 09/25/2026 Recommended
-
Fractional Network Consultant
Wilmington, DE, 19805
Job Title: Fractional Network Consultant Location-Type: Remote Start Date: October Duration: Contract, 12 weeks Compensation Range: $100-$150/hr W2 Benefits: Eligible for Health, Dental, Vision, and 401K Visa Sponsorship: Not eligible for visa sponsors...
Date Posted: 09/25/2026 Recommended
-
Python AI Developer
New Brunswick, NJ, 08933
Apply now: Python AI Developer, location is Hybrid (Remote with occasional onsite). The start date is ASAP for this contract position. Job Title: Python AI Developer Location-Type: Hybrid (Remote with occasional onsite in NY/NJ/DC/Philly) Start Date Is...
Date Posted: 09/25/2026 Recommended
-
Web Engineer/Consultant
Springfield, VA, 22150
Apply now: Web Engineer / Consultant, location is Onsite. The start date is September 28 for this permanent position. Job Title: Web Engineer / Consultant Location-Type: Onsite – Springfield, VA (5 days/week in secure client environment) Start Date Is:...
Date Posted: 09/25/2026 Recommended
-
Senior Software Design Quality Engineer
Danvers, MA, 01923
Job Title: Senior Software Design Quality Engineer Start Date: ASAP Salary Range: $110,000 - $160,000/year Travel: Onsite 3 days per week in Danvers, MA Benefits: Eligible for Health, Dental, Vision, 401K, PTO Must be authorized to work in the U.S. Thi...
Date Posted: 09/25/2026 Recommended
-
FAST Analyst
Knoxville, TN, 37092
FAST Distribution Operations Specialist / FAST Analyst Employment Type: Contract-to-Hire Location: Remote / Hybrid Schedule: Monday–Friday, approximately 9:00 AM–5:00 PM ET Compensation: $60-65/hr W2 Benefits: Eligible for Health, Dental, Vision, 401K ...
Date Posted: 09/25/2026 Recommended
-
SRE
Herndon, VA, 20171
DevOps Engineer – Platform Operations Location: Remote – EST Hours Contract: 12 months Schedule: 40 hours/week, 8:00 AM–5:00 PM EST Compensation: $65-75/hr Work Authorization: Sole U.S. citizenship required due to the nature of the environment Position...
Date Posted: 09/25/2026 Recommended
-
Digital Marketing Coordinator
Needham, MA, 02494
Job Title: Digital Marketing Coordinator Location-Type: Remote (EST) Start Date: 9/21/2026 Duration: Contract, 6 months Compensation Range: $20-23/ hr Benefits: Eligible for Health, Dental, Vision, and 401K Visa Sponsorship: Not eligible for visa spons...
Date Posted: 09/25/2026 Recommended
-
Lead Software Engineer
Baltimore, MD, 21202
Apply now: Lead Software Engineer, location is Hybrid. The start date is June 22 or June 29 for this 6 month contract-to-hire position. Job Title: Lead Software Engineer Location-Type: Hybrid (3 Days A Week Onsite - at one of the following locations; B...
Date Posted: 09/25/2026 Recommended
-
Sr Account Supervisor (Oncology)
New York, NY, 10011
Job Title: PR Senior Account Supervisor (Health/Oncology) Location-Type: Remote (Preferred: NYC, Chicago, or DC; 3 days/week onsite required if converted to FTE) Start Date Is: ASAP Duration: Contract through EOY (Contract-to-Hire ideal) Compensation R...
Date Posted: 09/25/2026 Recommended
-
Front-End Web Developer
Weymouth, MA, 02189
Apply now: Front-end Web Developer , location is hybrid . The start date is ASAP for this 6 month contract to hire position. Job Title: Front-End Web Developer Location-Type: Hybrid Onsite - Weymouth, MA Start Date Is: ASAP Duration: Contract to Hire C...
Date Posted: 09/25/2026 Recommended