MogiSBT Global
Jr. Data Architect/Engineer
On-siteFull-time
About the job
Job Description • Ingest data from sources such as Microsoft SQL Server (BOSS) 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 • Develop an MCP server enabling AI agents to query Gold-layer data marts, including catalog/metadata access...