Senior Data Engineer (Databricks)

Job title: Senior Data Engineer (Databricks)

Contract :Short term Experience: 6+ years Location : Remote Role Summary The

Senior Data Enginee r is responsible for designing, building, and optimizing enterprise data platforms, data warehouses, and lakehouse solutions. The role focuses on transforming raw data into reliable, scalable, and analytics-ready datasets using Microsoft Azure, SQL Server, Databricks, and Power BIThe position also involves mentoring junior engineers, collaborating with business stakeholders, and designing modern cloud-based data architectures Key Responsibilities Data Architecture

• Design scalable data architectures for enterprise application
• Build normalized transactional databases and dimensional data warehouse
• Design and implement Lakehouse architecture using Databrick
• Develop cloud-based data platforms on Microsoft Azure Database Developme
• ntDevelop and optimize SQL Server database
• Write advanced T-SQL queries, stored procedures, functions, and view
• Perform SQL performance tuning
• :Query optimization
• Index optimization
• Execution plan analysis
• Database performance improvements Data Engineering
• Build ETL/ELT pipeline
• Create Source-to-Target mapping
• Clean, transform, and aggregate large dataset
• Develop Databricks notebooks for
• Data ingestion
• Data transformation
• Analytics
• Machine Learning deployment Data Warehousing
• Design enterprise data warehouse
• Implement
• :Kimball methodology
• Inmon methodology
• Develop dimensional models
• Fact tables
• Dimension tables
• Star schema
• Snowflake schema Azure Development Work with Azure services such a
• Azure SQL Databaes
• Azure Data Factory (ADF)
• Azure Synapse Analytics
• Azure Data Lake
• Azure Stream Analytics Databricks
• Unity Catalong
• Databricks Sql
• Databricks Workflows
• Delta Sharing
• Apache Spark
• Python
• Delta Lake Reporting &
• BIDevelop Power BI dashboard
• Build enterprise reporting solution
• Support business intelligence initiative .Required Skil SQL & Databases
• Microsoft SQL Server
• T-SQL
• Stored Procedures
• Views
• Function
• Triggers
• SQL Performance Tuning
• Query Optimization
• Indexing
• Database Desing
• Normalization
• Transactional Databases Data Engineering
• ETL / ELT
• Data Pipelines
• Data Transformation
• Data Integration
• Source-to-Target Mapping (STTM)
• Data Aggregation
• Data Validation Data Modeling & Warehousing
• Relational Data Modeling
• Dimensional Data Modeling
• Star Schema
• Snowflake Schema
• Fact & Dimension Tables
• Enterprise Data Warehouse
• Data Marts
• Kimball Methodology
• Inmon Methodology Big Data Technologies
• Apache Spark
• Databricks
• Delta Lake
• Unity Catalog
• Databricks SQL
• Databricks Workflows
• Delta Sharing Cloud Technologies
• Microsoft Azure
• Azure SQL Database
• Azure Data Factory
• Azure Synapse Analytics
• Azure Data Lake Storage
• Azure Stream Analytics Programming
• Python
• SQL Business Intelligence
• Power BI
• Dashboard Development
• Data Visualization
• Business Intelligence