Job Openings BI Specialist

About the job 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

Or refer someone