- Plano, Texas, United States
- On-site
- Contract · Associate
- $10K–$10K per month
- 3+ years
Build a new greenfield data platform integrating internal systems using a Medallion Architecture.
Compensation
Payrate: $10,400/m DOE
Responsibilities
- Ingest data from sources such as Microsoft SQL Server and Oracle into the Bronze layer, implementing CDC-based incremental ingestion
- Develop dbt models for the Silver layer including cleansing, standardization, deduplication, and data quality testing
- Develop Gold layer business-specific data marts and migrate existing Alteryx transformation logic
- Configure Apache Iceberg tables and a REST Catalog, including schema evolution and time travel support
- Develop and operate Apache Airflow DAGs, managing dependencies, scheduling, and failure notifications
Requirements
- Nice to have: Airbyte
- Nice to have: Fivetran
- Nice to have: Apache Polaris
- Nice to have: OpenMetadata
- Nice to have: DataHub