Data Warehouse Architect | Philippines

ZipRecruiter; Cambridge; Remote; GBP 60,000 - 90,000; Full time

Job summary

A growing tech company is looking for a Data Warehouse Architect to support their expanding needs. The role focuses on building data warehouses in Azure Synapse, optimizing database performance, and ensuring data security. Candidates should possess extensive experience with Azure services, particularly in data engineering and BI solutions. This position offers an opportunity to innovate and drive improvements in a fully remote setup.

Qualifications

• 6+ years in MSSQL development, preferably in Azure.
• 4+ years in MSSQL database administration, with at least 2 years in Azure management.
• Experience with Azure Synapse, Data Factory, and Microsoft Power Platform.

Responsibilities

• Architect and build scalable data warehouses in Azure Synapse.
• Lead ETL pipeline development using Azure Data Factory.
• Implement security measures for data integrity.

Skills

Azure Synapse

Azure Data Factory

MSSQL

Data Engineering

API Integrations

Microservices

Job description

Peak Support is seeking a Data Warehouse Architect to join our team in the Philippines.

Reporting to the Director of Enterprise Applications & Data, the Data Warehouse Architect will play a crucial role in the delivery, management, and implementation of data platforms, applications, and solutions that support internal teams and clients within a complex, high-growth, multinational environment. This position will focus on architecting and building the data warehouse in Azure Synapse and creating data pipelines in Azure Data Factory.

This position is ideal for a hands-on professional with extensive experience in Azure Synapse, Azure Data Factory, and MSSQL, capable of leading data platform development while ensuring high standards of performance, security, and reliability. You will have the opportunity to shape data architecture and solutions for a growing organization, driving innovation while maintaining a focus on business and technical needs.

Responsibilities include:

1. Data Platform Architecture & Development:

• Architect and build scalable, efficient, and reliable data warehouses in Azure Synapse.
• Design, develop, and maintain ETL pipelines using Azure Data Factory.
• Lead in developing solutions for data collection, processing, and storage aligning with business goals.

1. Database Performance Monitoring & Optimization:

• Monitor database performance, identify, and resolve bottlenecks.
• Implement indexing, query optimization, and partitioning as needed.

1. Backup and Disaster Recovery:

• Perform regular backups and test for recoverability.
• Manage data restoration during disasters to minimize downtime.

1. Data Security and Integrity:

• Implement security measures such as access controls, encryption, and auditing.
• Ensure data integrity through validation, conflict resolution, and consistency maintenance.

1. Database Troubleshooting:

• Resolve complex database issues to ensure minimal business disruption.

1. Collaboration and Stakeholder Engagement:

• Work with IT leadership and business partners to translate needs into technical solutions.

1. Cloud Platform Administration:

• Follow best practices for Azure cloud environment management.
• Support ongoing platform health and performance.

1. Documentation and Training:

• Document data platforms, ETL processes, and security protocols clearly.
• Lead training sessions for technical and non-technical team members.

1. Innovation and Continuous Improvement:

• Explore and implement new technologies to enhance data platform efficiency.
• Promote agile development, testing, and integration practices.

Peak Support and our Work-from-Home PLUS model

We are committed to providing exceptional service and a positive work environment. Our culture is built on creating a supportive, performance-driven environment that fosters long-term careers. We have been 100% remote since inception, with processes that support remote team success.

Requirements:

• 6+ years in MSSQL development, preferably in Azure.
• 4+ years in MSSQL database administration, with at least 2 years in Azure administration.
• 4+ years with Azure BI solutions, including Azure Synapse, Data Factory, Functions, and DevOps; experience with Microsoft Fabric is a bonus.
• 3+ years in Data Warehousing, especially Azure Synapse.
• 3+ years in Microsoft Power Platform (Power BI, Power Apps, Power Automate).
• Experience with API integrations and system service integrations.
• Proficiency in .NET C# coding, with additional skills in Windows services and web development a plus.
• Experience in outsourced contact center/BPO environments is desirable.
• Knowledge of consumption-based services (PaaS, SaaS, IaaS).
• Proven data engineering experience, including building data warehouses, marts, and pipelines.
• Deep understanding of cloud-first platform enablement, APIs, and microservices in Azure.
• Strong organizational, analytical, and detail-oriented skills.