As a Data Architect at Catalyst, you will be a key contributor in the growth of our data analytics platform based on Catalyst’s data warehouse. This position is designed for a motivated and experienced professional who has previously improved enterprise data capabilities while meeting compliance obligations.

Responsibilities

• Data mapping from source systems into the data warehouse.

• Designs, implements, and maintains star and snowflake schemas.

• Database maintenance including backup, restore, patching, and upgrades.

• Database schema work including DDL.

• Database optimization and tuning including plans and index management.

• Troubleshooting and resolution of issues in OLTP and DW environments.

• Work with ETL developers to ensure that data is conforming and reliable.

• Participate in pre-release code reviews with the Development Team.

• Ownership and management of our master data management strategies.

• Follows all compliance obligations.

Skills

• Expert proficiency with MS SQL Server

• Familiar with Vertica

• Knowledgeable in both relational and dimensional data modeling

• Knowledgeable with data warehouse fundamentals

• Familiar with implementing common data quality techniques

• Familiar with AWS and S3

• Familiar with the GoodData BI environment (preferred / not required)

Requirements

• Bachelor’s degree in a technical field 

• Minimum 5 years of experience as an MS SQL Server DBA 

• Must be able to pass a criminal background check