bi developer

bi developer Job Description Template

Our company is looking for a bi developer to join our team.

Responsibilities:

  • Perform root cause analysis of data issues and troubleshoot technical difficulties;
  • Make suggestions to improve layouts;
  • General model integrity checks;
  • Test and debug programs;
  • Design and develop ETL processes by performing detailed analysis using the ingestion toolsets of the organisation;
  • Present results to the business unit leader in a preferred tool (such as Office suite, BI report or dashboard);
  • Work with data sources (raw data);
  • Transform large data sets from various business systems and consolidate it in meaningful BI Models;
  • Identify data anomalies and communicate back to the data owners;
  • Monthly management reporting;
  • Define the requirements for analysis within a given business area;
  • Develop and maintain various BI Models for decision making purposes;
  • Interpretation of specifications received (including data models, if applicable;
  • Model reloads and distribution setup;
  • Provide users with correct data to do their analysis on.

Requirements:

  • Dimensional modellng;
  • At least 3 years of data warehouse ETL experience;
  • TSQL;
  • Knowledge and experience of structured data, such as entities, classes, hierarchies, relationships and metadata;
  • Agile / SCRUM experience advantageous;
  • At least 2 years experience in a similar role;
  • 4 years’ in BI Development;
  • Database design savvy – OLTP and Data warehouse;
  • Predictive and descriptive analytical modelling skills;
  • SQL server;
  • Designing self service BI solutions;
  • Microsoft.NET, Visual Basic, Excel;
  • Experience with data visualization and visualization tool(s);
  • Preferred – Korn shell scripting, Python/Java, SQL;
  • Degree or Diploma in IT sector.