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