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

Tasks

• Architect Omni semantic layer for self service analytics
• Build CI CD pipelines for data model deployment
• Build transformation pipelines with Delta Live Tables or Spark
• Configure Serverless SQL Warehouse for cost performance
• Create executive dashboards in BI contexts
• Design and implement Unity Catalog governance structure
• Implement data performance features Z-Ordering Liquid Clustering partitioning
• Migrate legacy SQL into governed Databricks Lakehouse pipelines
• Optimize Spark query performance using execution plans
• Optimize join strategies reduce data skew
• Recommend performance and cost optimizations for leadership
• Translate stakeholder business questions into data solutions

Perks/Benefits

• Fixed-term contract
• Remote work opportunity

Skills/Tech-stack

CI/CD | Data Governance | Data Lineage | Databricks | Delta Lake | Delta Live Tables | Delta Live) | Dimensional Modeling | Execution Plans | Git | GitHub Actions | Liquid clustering | Omni | Optimize | PySpark | Query Execution | Query Optimization | Query execution plans | SQL | SQL Warehouse | Semantic layer | Serverless SQL | Serverless SQL Warehouse | Snowflake Schema | Spark | Star Schema | Unity Catalog | VACUUM | Z-Order