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.