Sr. BI & Data Architect [Fixed - Term Contract]

Tasks

• Architect Omni semantic layer for self service analytics
• Architect transformation framework with delta live tables or python sql pipelines
• Build ci cd pipelines for data model testing validation and deployment
• Build executive level dashboards as bi developer
• Configure serverless sql warehouse for performance
• Design and implement Unity Catalog structure
• Govern databricks compute with z ordering liquid clustering and partition design
• Lead legacy sql migration to databricks lakehouse
• Optimize query performance using spark execution plans and spark ui
• Recommend performance and cost improvements to senior leadership
• Reduce data skew and optimize join strategies
• Refactor legacy sql into modular spark pipelines
• Translate business questions into scalable data solutions

Perks/Benefits

• N/A

Skills/Tech-stack

Apache Spark | CI/CD | Data Skew | Databricks | Delta Lake | Delta Live Tables | Delta Live) | Dimensional Modeling | Execution Plans | File Management | GitHub Actions | Liquid clustering | Omni | Partitioning | Python | Query Optimization | SQL | SQL Warehouse | SQL Warehouses | Semantic Modeling | Serverless SQL | Serverless SQL Warehouse | Snowflake Schema | Spark Execution Plans | Spark UI | Star Schema | Unity Catalog | VACUUM | Z-Order