Hiring.Camp

Senior Data Warehouse and Integration Engineer

Goodsservices

·

Oct 9, 2026

Location
Mexico-Remote, Colombia-Remote · Colômbia, São Paulo, Brazil · Mexico, Mexico
Workplace
Remote
Department
Professional Services
Seniority
Senior
Source
Greenhouse

Description

About Goods & Services
  
Goods & Services is a product design and engineering company. 

We solve mission-critical challenges for some of the world’s largest enterprises, with deep expertise in highly regulated industries—including life sciences and financial services. Our design-led approach allows us to apply cutting-edge capabilities in AI, Data and Hardware Engineering to companies of any size. 

Headquartered in the United States, we operate regional development centers in Mexico and the United Kingdom. This global footprint—anchored by our nearshore model—enables us to deliver at scale with the speed, efficiency, and cultural alignment our clients expect.

At Goods and Services, we value diversity and are committed to creating an inclusive workplace where everyone can thrive. We are proud to be an Equal Opportunity Employer and welcome qualified applicants from all backgrounds.

About the job
  
Goods & Services is looking for a Senior Data Warehouse and Integration Engineer responsible for database engineering, data warehouse architecture and support, data integration, reporting support, production troubleshooting, and technical delivery. This role requires someone who can independently own complex DB/data work from investigation and design through production completion and ongoing support. The biggest need is database/data integration ownership and production troubleshooting, followed by data warehouse architecture and reporting. The role needs someone to be comfortable with the existing on-prem/Microsoft environment while also helping us move toward more modern Azure-based solutions.

What you’ll do:

  • Design, develop, maintain, and troubleshoot SQL Server databases, stored procedures, views, jobs, and related database objects.
  • Design and support enterprise data warehouse architecture, data models, schemas, and data flows.
  • Evaluate and improve data warehouse structure, scalability, performance, and maintainability.
  • Support data warehouse production operations, including failures, performance issues, data quality issues, and downstream dependencies.
  • Support and troubleshoot SSIS, ETL processes, integrations, APIs, files, feeds, and scheduled data processes.
  • Design reliable data movement between source systems, staging layers, data warehouse environments, and reporting platforms.
  • Investigate production database, data warehouse, integration, and reporting issues and drive them to root cause and resolution.
  • Reconcile report and data discrepancies against source systems.
  • Review database, warehouse, and integration changes for dependencies and downstream impact.
  • Support query performance, data integrity, reliability, and production stability.
  • Define and execute technical testing for database, warehouse, and integration changes.
  • Support DEV, TEST/UAT, and PROD deployments, including rollback planning where needed.
  • Build monitoring, failure detection, retry, and recovery processes for automated integrations and warehouse processes.
  • Maintain documentation for critical databases, warehouse architecture, integrations, jobs, reports, data flows, and support procedures.
  • Work directly with Development, BA, PM, Applications, Infrastructure, and Support teams.
  • Maintain clear status, target dates, blockers, risks, and next steps for assigned work.
  • Escalate risks and dependencies early instead of allowing work to remain indefinitely in investigation.
  • Ensure completed technical work is tested, validated, documented, deployed, and supportable.

What you’ll need:

  • Strong Microsoft SQL Server experience
  • Advanced T-SQL
  • Data warehouse design and architecture
  • Dimensional modeling and enterprise data modeling
  • Data warehouse support and production troubleshooting
  • Stored procedures, views, functions, and SQL Agent jobs
  • SSIS / SSISDB or equivalent ETL experience
  • ETL architecture and data pipeline design
  • Data integration and troubleshooting
  • Data reconciliation and reporting support
  • Query performance and optimization
  • Production database support
  • Root cause analysis
  • Data lineage and dependency analysis
  • APIs, files, feeds, and system integrations
  • Production deployment and change management
  • Azure data services where applicable

Nice to have:

  • Enterprise data warehouse environments
  • Complex operational, financial, or regulatory reporting
  • Multi-system integrations
  • Large production SQL environments
  • Data warehouse modernization or redesign initiatives

     

Skills

AzureSQLSQL ServerETLChange Management

Similar Jobs

30

Senior Data Warehouse Developer

ITtude·Remote

Senior Associate, Identity & Access Management – Identity Data Warehouse (IDW)

NT Careers·Tempe, Arizona·Hybrid

1d ago

Senior Warehouse Associate- Data Center Operations

WESCO International·Stafford, Virginia·Onsite

4d ago

Senior Data Warehouse Architect

Datamatics Technologies·Stockholm, Sweden·Onsite

2w ago

Senior Data Warehouse Architect

Datamatics Technologies·Malmö, Skåne·Onsite

2w ago

Senior Data Warehouse Architect

Datamatics Technologies·Göteborg, Västra Götaland·Onsite

2w ago

Senior Associate - Data Engineer - Data Warehouse Solutions

Oaktree·India·Hybrid

1mo ago

(Senior) Oracle Data Warehouse / BI-Developer (m/w/d)

virtual7 GmbH·Karlsruhe, Baden-Wurttemberg·Hybrid

1mo ago

Senior Data Warehouse Engineer

Fingerprint·Remote·Remote

Senior Solutions Architect (EDW Enterprise Data Warehouse Migrations)

Databricks·Berlin, State of Berlin +1·Remote

Senior Solutions Architect (EDW Enterprise Data Warehouse Migrations)

Databricks·France +1·Remote

Senior Solutions Architect (EDW Enterprise Data Warehouse Migrations)

Databricks·France +1·Remote

Senior Solutions Architect (EDW Enterprise Data Warehouse Migrations)

Databricks·Amsterdam, North Holland +1·Remote

Senior Solutions Architect (EDW Enterprise Data Warehouse Migrations)

Databricks·France +1·Remote

Senior Data Engineer (Big Data & Data Warehouse)

Caixa Mágica Software·Lisbon, None·Remote

Lead Assistant Manager - Data Warehouse Architect / Sr BI Architect

EXL Talent Acquisition Team·Noida, Uttar Pradesh·Hybrid

3mo ago

Lead Assistant Manager - Data Warehouse Architect / Sr BI Architect

EXL·Noida, Uttar Pradesh·Hybrid

3mo ago

Senior Data Warehouse Developer - PFS

Black Rock·N12 - 40 W 57th St New York, NY 10019

3mo ago

Data Warehouse Sr. Manager

The Huntington·US·Onsite

4mo ago

Senior Data Warehouse Developer

Calgary Homeless Foundation·Calgary, Alberta

4mo ago

Senior Data Engineer (w/m/d) – Data Integration, Data Warehouse

WARDOW GmbH·Potsdam, Brandenburg

6mo ago

Senior Data Warehouse Modeller

Kingfisher2·Warsaw, Mazovia

9mo ago

Sr Data Warehouse Developer

Rochester is our namesake and·US

10mo ago

Senior Consultant (m/w/d) Data Warehouse Design | Senior Data Analyst

Mid Gmbh

11mo ago

Senior Data Warehouse Engineer

Steampunk Inc.·McLean, Virginia·Remote

1y+ ago

Senior Data Engineer - Data warehousing/Python/AI

Depository Trust Company·Tampa, Florida

3mo ago

(Senior) Consultant SAP Data Warehousing (m/w/d)

PCS Beratungscontor AG·Dortmund, North Rhine-Westphalia +3·Remote

1y+ ago

Senior Data Engineer - (GCP & Lakehouse Architecture) - On Site - Octopus by RTG

robusta·Riyadh, Riyadh Region·Onsite

6d ago

Senior Architect Data Engineering and Lakehouse Platforms - Houston Hybrid

Referral Publicisgroupe·Houston, Texas·Hybrid

1mo ago

Senior Data Engineer - Data Lakehouse Lead

Camlin·Parma, Emilia-Romagna

1mo ago