Data Warehouse Architect Remote

Data Warehouse Architect | Philippines

Description

Peak Support, an outsourcing firm serving some of today’s most innovative companies, is seeking a **Data Warehouse Architect** to join our team in the Philippines.

Peak Support manages customer service and back-office teams for high-growth companies. Founded in 2015, we are a 4x Inc. 5000 company and a Certified Great Place to Work, with 2,000 team members in the Philippines, Colombia, Eastern Europe, and the U.S.

**Why Peak Support?**

If you want to work for high-growth companies, Peak Support is the place to be. Our clients range from early-stage startups with fewer than five employees to unicorns with valuations well over $1 billion to old-line companies re-imagining themselves. We have been profitable from day one and we are proud that in our first five years, we grew entirely through client referrals.

We are dedicated to providing exceptional service to our clients AND an exceptional work environment for our team members. We don’t do this with ping pong tables or video games. We do it by creating a positive, encouraging and performance-driven culture that enables our team members to build rewarding, long-term careers.

Peak Support is actively working to create a diverse, equitable and inclusive company. Applicants will be considered without regard to race, color, religion, gender, gender identity or expression, disability, sexual orientation, national origin, age, or veteran status.

**Work from Home PLUS**

Peak Support offers all the convenience of working from home, with the benefits of working for an established organization with an exceptional team and tremendous opportunities for growth.

Peak Support has been 100% remote since day one, so we have built a culture and a set of processes that support the success of our remote team members. When we can, we get together in person. We believe that building offline relationships is critical to successful online work.

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

**What you'll do**:
**Data Platform Architecture & Development**:

- Architect and build scalable, efficient, and reliable data warehouses in Azure Synapse, focusing on transforming raw data into actionable insights.
- Design, develop, and maintain ETL pipelines using Azure Data Factory, ensuring smooth data integration from multiple sources into the Synapse environment.
- Take a hands-on lead in developing solutions for data collection, processing, and storage that align with business and strategic goals.

**Database Performance Monitoring & Optimization**:

- Monitor the performance of databases, identifying and resolving performance bottlenecks to ensure optimal database functionality.
- Make necessary adjustments, such as indexing, query optimization, and partitioning, to ensure databases are running smoothly and efficiently.

**Backup and Disaster Recovery Management**:

- Ensure regular backups of the organization’s data are performed, and test backups for recoverability.
- In the event of a disaster, manage the restoration of data quickly and accurately to minimize downtime.

**Data Security and Integrity**:

- Implement robust security measures, such as access controls, encryption, and auditing, to protect both internal and client data.
- Ensure data integrity by enforcing data validation rules, resolving conflicts, and maintaining consistency across the database.

**Database Troubleshooting**:

- Troubleshoot and resolve complex database issues, including data corruption, system failures, and performance-related problems, ensuring mínimal disruption to business operations.

**Collaboration and Stakeholder Engagement**:

- Work closely with IT leadership and key business partners to develop an understanding of business needs and requirements, and translate them into technical solutions.
- Maintain a practical, working knowledge of business processes and how data platforms can support operational goals and decision-making.

**Cloud Platform Administration**:

- Abide by best practices and strategies for platform administration, particularly in cloud environments like Azure, ensuring high availability, security, and efficiency of data platforms.
- Support the administration of cloud-based systems and manage ongoing platform health and performance.

**Documentation and Training**:

- Provide clear and thorough documentation for the data platforms, ETL processes, and security protocols.
- Lead training efforts, ensuring all technical and non-technical team members are well-versed in platform capabilities and best practices.

**Innovat