My main activities were to develop datasets and visualisations using Power BI (M and DAX included). Additional tasks include to perform Business and Data Analysis to find the correct data sources, scripting queries using T-SQL against SQL Server and, Hive and Impala against the Data Lake to feed the datasets, facing internal customers to gather their requirements and data needs, also, helping my team with the creation of internal processes. Recently, as part of the Big Data project, I have been learning Python to manage and maintain the data migration from SQL Server on-premises sources to Hive and Kudu tables in Cloudera.
Part of my activities also include maintaining and creating SSIS ETL packages/jobs and maintain legacy Data Stage ETL jobs.
Visualisations with Power BI, Project estimations, Business and Data Analysis, Business Processes design and diagramming.
Data Lake in Azure infrastructure/virtualization running in Cloudera with Hadoop/Hive/Impala, SharePoint, SQL Server, DAX, SSIS, Confluence, MS Teams, Cognos, Data Stage.