BI Specialist

Duties and responsibilities: Summary PowerBI development: data processing, modelling, transformation and building Visualizations ETL Development Using ETL tools and Techniques Developing Stored Procedures, views, joins, aggregates, temp tables, etc Understanding and implementing data processing techniques Understanding and implementing data transformation techniques Data Trouble shooting (Source files, Source systems, Databases,Etc) Thorough testing of unit and data set groupings is required Analyse, design and trouble shoot data, visualizations and ETL packages Building reports, dashboards and other visualizations Verbally communicate with team members and other stakeholders, present to small groups Elicit requirements verbally without the benefit of documentation Detail: Understand business requirements in BI context and design data models to transform raw data into meaningful insights Create dashboards and interactive visual reports using Power BI Identify key performance indicators (KPIs) with clear objectives and consistently monitor those Analysing data and present data through reports that aid decision-making Convert business requirements into technical specifications and decide timeline to accomplish Create relationships between data and develop tabular and other multidimensional data models Chart creation and data documentation explaining algorithms, parameters, models, and relations Design, develop, test, and deploy Power BI scripts and perform detailed analytics Perform DAX queries and functions in Power BI Analyse current ETL process, define and design new systems Data warehouse development and work with SSAS, SSIS, and SSRS Redefine and make technical/strategic changes to enhance existing Business Intelligence systems Create customized charts and custom calculations as per requirements Design, develop and deploy business intelligence solutions as per needs Work with users and team members at all levels for performance improvement and suggestions Qualifications and experience:  Bachelors degree in Data Analytics; OR Bachelors degree with Mathematics and/or Applied Mathematics 2 or 3 years working with BI tools, or any data-specific roles. Must have experience in BI tools, have a sound knowledge of database management, SQL querying, data modelling, data warehousing, business intelligence. Experience working ERP solutions would be advantageous. Essential skills: MS PowerBI ETL MS SQL Data Processing Data Transformation Data Analysis Testing BI Support and Analysis Visualizations Presentation and Communication Verbal Requirements Elicitation Database Management MS SSIS Dax Advantageous skills:  Documentation Research and Implementation C# or similar Excel Dimensional Modelling