Data Warehouse Engineer

Staffing Spot, Inc.; Phoenix (AZ); On-site; USD 80,000 - 110,000; Full time

Job summary

Staffing Spot, Inc. is seeking a Data Warehouse Support professional to monitor and optimize cloud-based data pipelines using SSIS and T-SQL. You will troubleshoot production issues, maintain data integrity, and document runbooks to enable scalable operations.

The role collaborates with onshore teams in a fast-paced environment to design, develop, and test data pipelines for a Cloud Data Warehouse initiative, ensuring timely data refresh and governance compliance.

Qualifications

• Experience maintaining SSIS and T-SQL pipelines.
• Strong debugging and production issue resolution skills.
• Ability to create runbooks and document workflows.
• Familiarity with data governance and cloud data platforms.

Responsibilities

• Monitor and re-run failed data pipelines and workflows.
• Troubleshoot production issues and implement bug fixes.
• Maintain data accuracy and integrity across pipelines.
• Provide daily status reports on pipeline execution.
• Collaborate with onshore teams to resolve incidents.
• Design, develop, and test data pipelines for Cloud Data Warehouse.
• Build batch processing and streaming jobs for timely refresh.
• Define data models and ETL strategies aligned with stakeholders.
• Ensure compliance with data governance and security standards.

Skills

data warehouse

cloud

data

design

operations

root

Job description

Data Warehouse Support

• Monitor and re-run failed data pipelines and workflows to ensure seamless operations on SSIS & T-SQL.
• Troubleshoot and resolve production issues, focusing exclusively on bug fixes.
• Maintain data accuracy and integrity across all pipelines.
• Conduct root cause analysis for recurring failures and document resolutions.
• Provide daily status reports on pipeline execution, highlighting failures, root causes, and applied fixes.
• Collaborate with onshore teams to address critical production incidents.
• Implement temporary workarounds to minimize downtime while working toward permanent solutions.
• Gather and analyze business requirements for business datasets in the cloud.
• Design, develop, and test data pipelines to support Cloud Data Warehouse initiatives.
• Build and optimize batch processing and streaming jobs to ensure timely data refresh.
• Implement Medallion Architecture and design models for structured data processing across different layers.
• Collaborate with onshore teams to establish best practices and reduce technical debt.
• Define data models and ETL strategies in alignment with stakeholder requirements.
• Participate in regular stand-ups and discussions with onshore and offshore teams to ensure seamless collaboration.
• Ensure compliance with data governance policies, security standards, and best practices.
• Develop and maintain comprehensive runbooks to document cloud operations, ensuring clear, step-by-step guidance for troubleshooting and maintenance.
• Standardize and optimize cloud workflows by creating detailed documentation that enhances efficiency, reduces downtime, and supports seamless knowledge transfer across teams.

Skills

• design
• operations
• data warehouse
• cloud
• data
• root