The BI Developer is responsible for aggregating data from multiple sources in an efficient manner using existing client structures and architecture such as data warehouse, data lakes, etc.
They are also responsible for designing entreprise-level solutions as and when required. They are also expected to document requirements, UAT test cases, data dictionaries for all solutions provided as per SOIT standard templates.
In summary, the role therefore has the responsibility of requirements gathering, development, maintenance, integration and data governance from business systems in the organisation.
They should possess 3 5 years experience in the BI domain.
Skills and Competencies :
Solid knowledge and understanding of Microsoft SQL Server services ranging from SSMS, SSIS, SSAS and SSRS.
Advanced knowledge and understanding of managing data models, DAX queries, creating measures and mapping cardinality in Power BI Desktop.
Capable of performing User Acceptance Test (UAT) by preparing test cases, documentation of the same and conducting training sessions as per customers business requirements.
Understanding business requirements in the BI context and designing data models to meet the business requirements.
Source to target mapping for multiple data sources to target SQL environment as well as associated ETL process. Documentation of transformations as well as data dictionaries.
Sources include EDW, Raw Files, Oracle database, PostgreSQL.
Well-versed in visualizations and their usage charts, tables, maps, filters, slicers, hiding functions, interactions between visuals and so forth.
Set up and maintain live or near-real time data connections with various on-premise systems.
Capable of using all Business Intelligence (BI) tools when creating report view tooltips, sorting, sync slicers, layer and tab orders, drill through, cross filter, conditional formatting, play Axis and design reports for mobile devices.
Capable to do data preparation, which includes identifying, and connect to a data source, change data source settings and selecting an appropriate storage mode.
Basic data modelling using the Power Query Editor for data wrangling, data transformation for the imported data and using Advanced Editor to modify Power Query M code.
Build and maintain OLAP Cube Solutions for advanced super users within the organisation as well as the associated documentation.
Capable of defining and configuring tables and column properties, hierarchy configuration, defining role-playing dimensions using the Power Query Editor.
Able to create and manage workspaces, configure row-level security in Power BI Service.
Able to create measures by using DAX (Data Analysis Expressions.
Knowledge of virtual BI technologies is a value-add. Competency is Denodo would be encouraged.
Highly organized and planned individual.
Team player with the ability to work under pressure and with minimal supervision.
Computer literate with excellent reporting writing skills and knowledge of Microsoft Office (Excel, Word and PowerPoint).
Strong communication and presentation skills, able to engage with individuals at all levels within the organization.
Preferred Certifications and Education :
Degree in computing related discipline or equivalent combination of education and experience.
Certifications in Power BI