Senior Database Architect: Scalable Data & BI Solutions

Willis Towers Watson; Manila; On-site; PHP 1,200,000 - 2,100,000; Full time

Job summary

Willis Towers Watson is seeking a Database Architect to support client-facing products and data platforms. You will evaluate and evolve database structures for high-concurrency, transactional and big data systems, collaborating with engineering and product teams to translate business needs into scalable designs.

You will lead architecture discussions, promote best practices, and mentor project teams while maintaining governance and standards across multiple datastores and technologies.

Qualifications

• Bachelor's degree and 3+ years of related experience.
• Strong experience in databases, tools and methodologies.
• Experience with database performance evaluation and remediation.
• Develop strategies for data acquisitions, archive recovery and implementation.
• Be able to design and develop Databases, Data Warehouses and Multidimensional Databases.
• Python development experience (Python, PySpark, Spark, Notebook programming…).
• SQL development experience (TSQL, Views, Stored Procedures, Indexes….)
• Experience with browser-based web applications delivered over the Internet that support high user concurrency
• Experience working with large relational databases, big data, structured and unstructured data sets
• Ability to develop database strategies for flexible, high-performance reporting and business intelligence
• Excellent verbal and writing skills, including the ability to research, design, and write new documentation, as well as to maintain and improve existing material
• Some functional knowledge in one or more of the following areas is a PLUS: Talent Management Systems, HR Self-Service, HR Shared Services, HRIS/Payroll, Health & Welfare Administration or Pension Administration, HR Survey systems

Responsibilities

• Work with the Senior Database Architect to define database architecture and communicate those designs to business and engineering partners.
• Analyze existing data design and suggest improvements that promote performance, stability and interoperability.
• Work with product management and business subject matter experts to translate business requirements into good database design.
• Provide database architecture leadership and mentor projects consisting of TW employees and outside contractors
• Maintain the governance model on the database architecture through training, design reviews, code reviews, and progress reviews.
• Participate in the development of Database Architecture and Roadmaps in support of business strategies.
• Establish and maintain database architecture standards and best practices
• Participle in the evaluation of emerging technology and tools

Skills

Database design

Data modeling

Data warehousing

Big data

NoSQL

SQL development

Python development

PySpark

Spark

Data integration

Data analysis

Documentation

Education

Bachelor's degree in relevant field

Tools

Microsoft SQL Server

Oracle

Azure SQL

Azure Databricks

Unity Catalog

Spark

Azure Data Factory

Azure Storage

Azure Data Lake

Azure Synapse

Azure Purview

Job description

Willis Towers Watson is seeking a Database Architect to support client-facing products and data platforms. You will evaluate and evolve database structures for high-concurrency, transactional and big data systems, collaborating with engineering and product teams to translate business needs into scalable designs.

You will lead architecture discussions, promote best practices, and mentor project teams while maintaining governance and standards across multiple datastores and technologies.