Strong SQL skills for data manipulation and query optimization.
Good knowledge of Visual Studio Code development.
Knowledge of data warehouse architectures, design patterns, and performance tuning techniques.
Familiar with Power BI or other BI reporting tools.
Expertise in data integration and data quality.
Experience in data integration and data quality.
Hands on experience on unified data analytics platform with Azure Databricks, Databricks Workspace user interface, managing Notebooks which use Delta Lake.
Excellent analytical and organization skills.
Excellent verbal and written communication skills.
Job Description :
Design and develop data warehouses and data marts to support data analysis and reporting.
Develop SQL based data processing pipelines which includes, but not limited, SQL functions, tables, and views.
Implement defined technology best practices and guidelines.
Create data validation rules on source data to confirm the data has correct and/or expected values.
Perform data profiling of source data to identify data quality issues and anomalies, business knowledge embedded in data, gathering of natural keys, and metadata information.
Leverage Databricks to optimize and accelerate processing and analytics tasks.
Collaborate with Databricks Administrators and Platform engineers to ensure optimal performance of data processing pipelines executed on Databricks.
Implement data quality rules and data governance policies to ensure data accuracy and consistency.