Senior Software Engineer

Design and implement scalable data architectures using Microsoft Azure
• Build and manage data warehouse/Lakehouse solutions with Azure Data Lake Storage
• Develop conceptual, logical, and physical data models aligned with business needs
• Implement star and snowflake schemas for efficient analytics and reporting
• Build and optimize complex stored procedures in Microsoft SQL Server using T-SQL
• Apply advanced SQL techniques including joins, CTEs, and window functions
• Optimize query performance using execution plans and query tuning techniques
• Design indexing strategies (clustered, non-clustered, column store) for performance improvement
• Implement table partitioning and efficient data distribution for large datasets
• Optimize ETL/ELT pipelines for scalability, reliability, and cost efficiency
• Monitor and resolve performance issues such as blocking, deadlocks, and long-running queries
• Implement Slowly Changing Dimensions (SCD Type 1 & 2) for historical tracking
• Ensure data quality, governance, validation, and security compliance
• Develop dashboards and reports using Microsoft Power BI and collaborate with stakeholders
• Lead and mentor data engineers, driving best practices, code reviews, and architectural decisions

Must-Have Skills:
• Strong hands-on experience with Microsoft Azure data services
• Design and implementation of scalable Azure data architectures
• Strong understanding of Enterprise data warehouse architecture
• Lakehouse architecture patterns & Data ingestion and transformation frameworks
• Batch and incremental data processing.
• Mandatory expertise in: Conceptual, logical, and physical data modelling
• Dimensional modelling techniques Star schema design Snowflake schema design
• Fact and dimension modelling
• Slowly Changing Dimensions:
• SCD Type 1
• SCD Type 2
• Data normalization and denormalization principles