Senior Data Warehouse and Integration Engineer
Goods & Services1 month ago
Remote, Mexico or Remote, ColombiaSenior
Responsibilities
- Design, develop, maintain, and troubleshoot SQL Server databases, stored procedures, views, jobs, and related database objects.
- Design and support enterprise data warehouse architecture, schemas, data models, and data flows.
- Improve data warehouse scalability, performance, maintainability, reliability, and data integrity.
- Support production operations, including failures, performance issues, data quality issues, and downstream dependencies.
- Troubleshoot SSIS, ETL processes, APIs, files, feeds, integrations, and scheduled data processes.
- Design reliable data movement across source systems, staging layers, data warehouses, and reporting platforms.
- Investigate production database, warehouse, integration, and reporting issues and drive root-cause resolution.
- Reconcile report and data discrepancies against source systems.
- Review database, warehouse, and integration changes for dependencies and downstream impact.
- Define and execute technical testing for database, warehouse, and integration changes.
- Support DEV, TEST/UAT, and PROD deployments, including rollback planning.
- Build monitoring, failure detection, retry, and recovery processes for automated integrations and warehouse processes.
- Maintain documentation for databases, warehouse architecture, integrations, jobs, reports, data flows, and support procedures.
- Coordinate with Development, BA, PM, Applications, Infrastructure, and Support teams.
- Track status, dates, blockers, risks, dependencies, testing, validation, deployment, and supportability for assigned work.
Requirements
- Strong Microsoft SQL Server experience and advanced T-SQL skills.
- Experience with data warehouse design, architecture, dimensional modeling, and enterprise data modeling.
- Experience supporting data warehouses and troubleshooting production database and data issues.
- Experience with stored procedures, views, functions, and SQL Agent jobs.
- Experience with SSIS, SSISDB, or equivalent ETL technologies.
- Experience designing ETL architectures, data pipelines, data integrations, and data movement.
- Experience with data reconciliation, reporting support, query performance, and optimization.
- Experience with root-cause analysis, data lineage, dependency analysis, APIs, files, feeds, and system integrations.
- Experience with production database support, deployments, and change management.
- Experience with Azure data services where applicable.
- Experience with enterprise data warehouse environments, complex operational, financial, or regulatory reporting, multi-system integrations, large production SQL environments, or data warehouse modernization is desirable.
Tech Stack
AzureMicrosoft SQL Server
Categories
Data Engineering
About Goods & Services
Goods & Services is a product design and engineering consultancy that builds market-ready digital products, data systems, and connected hardware for enterprises, including highly regulated sectors like life sciences and financial services. The privately held firm, founded in 2013 and headquartered in Atlanta, monetizes through consulting engagements spanning software development, product strategy, AI, and process optimization, delivering end-to-end design, build, and modernization work.