Description

You design and oversee data solutions for the organization, ensuring architectural integrity and compliance.

This role is on-site.

Responsibilities

• Design Snowflake data mart architecture for TRIMS integration and Category Analysis datasets.
• Lead source-to-target mappings and database schema designs.
• Provide technical oversight for SQL transformation logic replacing Tableau Prep flows.
• Produce architecture diagrams, data models, and technical documentation.
• Ensure compliance with EDP architecture standards and data governance policies.

Required Skills

• 8+ years in database architecture and data warehousing.
• 3+ years with Snowflake data warehouse architecture.
• Experience designing data marts and relational data models.
• Proficiency in complex SQL, stored procedures, and database objects.
• Experience with Azure Data Factory.
• Familiarity with data governance practices.
• Experience working within Agile software development environments.

Preferred Skills

• Experience with Source-to-Target Mapping (STTM) documentation.
• Experience integrating data warehouses with enterprise applications or APIs.

Key Skills

Education

Bachelor's degree