Senior Data Warehouse and Integration Engineer

🔥 20 hours ago

🌐 Mexico, Colombia – Remote

🇲🇽 Mexico – Remote 🇨🇴 Colombia – Remote

⏰ Full Time

🟠 Senior

💻 Solutions Engineer

👻 Ghost score 10%

What it means: how likely this posting is sitting open without active hiring.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

Set Up Email Alert For New Jobs

📊 Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Upload Resume

Goods & Services

WebsiteLinkedInAll Job Openings

201 - 500 employees

Founded 2013

📣 Marketing

📦 Logistics

🏭 Manufacturing

Marketing • Logistics • Manufacturing

Goods & Services is a product design and digital engineering company that helps enterprises design, build, and scale AI-powered products, platforms, and customer experiences. They provide services across Data & Artificial Intelligence, Experience Strategy & Design, and Technology & Engineering (cloud, software, hardware), focusing on modernizing data infrastructure, building digital product ecosystems and global web systems, and delivering enterprise-grade cloud and platform engineering for market-leading B2B clients.

📋 Description

• 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

🎯 Requirements

• 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

🏖️ Benefits

• Equal Opportunity Employer committed to an inclusive workplace • Welcome to qualified applicants from all backgrounds