Job Description: Data Architect ETL & Data Quality (Sales Compensation Transformation)
Job Title: Technology Architect | ETL & Data Quality | ETL - Others
Work Location: Houston, TX 77002
Contract Duration: 6 Months
Experience Level: > 10 Years
Position Overview
We are seeking an experienced Data Integration Architect to lead the design, architecture, and implementation of enterprise data integration solutions. This role is pivotal in supporting WM's major Sales Compensation platform transformation from Varicent to Captivate.
The ideal candidate will define the overarching integration architecture, data flows, transformation frameworks, source-to-target mappings, and robust data governance standards. You will oversee inbound and outbound data exchanges across a complex landscape encompassing SAP, Oracle HR, Salesforce, payroll systems, MAS feeds, and various other enterprise applications.
Core Responsibilities
The subcon will primarily shoulder, execute, and drive the following technical pillars:
AWS Integration: Architect and execute data pipelines and workflows leveraging AWS (specifically AWS Glue).
Data Transformation (dbt): Design, implement, and optimize transformation models using dbt (data build tool) for scalable analytics engineering.
Snowflake Architecture: Build, manage, and optimize modern cloud data warehousing solutions on Snowflake.
Required Skills & Qualifications
Must-Have Technologies:
Cloud & Data Warehousing: AWS, Snowflake
Analytics Engineering: dbt
Ecosystems & Source Systems: SAP, Oracle HR, Salesforce, payroll systems, and MAS feeds.
Nice-to-Have Skills:
Additional Project Details
Compliance: Drug test details are not required.
Work Environment: Hybrid work arrangement based out of Houston, TX.