Develop and visualize data via reports and dashboards by the help of Tableau or Power BI.
Build and support ETL and data warehousing applications and tools.
Managing ETL, writing tests for data analytics code, maintaining and monitoring data consistency.
Design and maintain e-commerce based Data warehouse, Azure Synapse Analytics.
Designing and scheduling SSIS Packages for transferring data from multiple data sources and integrates data based on business logic and to load it in data warehouse.
Develop database packages, procedures, Functions, indexes etc.
Develop and maintain KPIs, Reports and Dashboards.
2+ years of experience in developing visualization solutions with Tableau including DW engineering fields.
Strong proficiency in BI and Data warehouse concepts.
Thorough understanding of data analysis to generate reports by Tableau.
Experience in ETL tool like Microsoft SSIS and Data warehouse principles.
Having knowledge in Dimensional Data Modelling, Cube development and manipulations in SQL Server Analysis Services (SSAS).
Strong knowledge of Data Warehousing methodologies and including star schemas, snowflakes concepts.
Ability to anticipating and adapt to new technologies.
Experience in advanced analytics languages like Python as optional.
Azure Synapse Analytics
Azure Data factory
Azure Analysis Service