MS BI Developer Skill Set – List of Knowledge and Abilities

What I have for you here today is a different kind of stuff. We will take a look at what should BI developer working on Microsoft technologies be able to do. I put up together a list of knowledge and abilities which I consider important for this job. I gave each skill rating (1-10) according to its influence and importance.

I want to say in advance that this is only my personal opinion. Value of some knowledge can be different depending on your environment and also on seniority.

Ideal BI Developer Skill Set

As I already said, everything depends on environment and seniority. To put it simple, you will need different skills in each company. It only depends on what your actual job will be, with whom you will work and what will be your responsibility level.

Lower is a list of skills that, in my opinion, mean a good senior candidate able to lead a team and serve complex BI needs of mid-large companies. With lower seniority comes lower requirements. But the key skills are still needed by the employer. Junior candidate is required to be ready to learn and able to process new knowledge.

Skill Is a key factor? Field of skill
Steep and growing-in-time learning curve Yes Soft skills
Time management and work organization Yes Soft skills
Effective analysis and information synthesis Yes Soft skills
Knowledge of data warehouse concepts Yes Data warehouse
Data modeling and data architect tools Yes Data warehouse
SQL queries for advanced users Yes T-SQL
Procedures, functions in T-SQL programming knowledge Yes T-SQL
Excel pro No Self service BI
Company processes knowledge No Miscellaneous
Accounting and controlling knowledge (financial) No Miscellaneous
SSIS Yes Data warehouse
SSRS, SSAS (both) Yes Data warehouse
Language – English Yes Miscellaneous
Script optimization, automation (Job agent) No T-SQL
Power BI, Power Query, PowerPivot (all) Yes Self service BI
Ability to communicate effectively and empathy Yes Soft skills
SQL Server Administration incl. SSRS settings, backup, etc. No Data warehouse
MDX, DAX, M (one) No Self service BI
Windows server Administration No Data warehouse
SharePoint No Miscellaneous
C# No Miscellaneous
HTML No Miscellaneous
JSON/XML No Miscellaneous

BI Developer Wage (Czech Republic)

BI developer is a hard and responsible job. Developer builds or helps to build architecture meant to aid in management decision making (data, reporting). This job hold quite big operational risk. The risk is that anytime an error occurs, the consequences for the company are significant. Management decisions are based on data and it is therefore not sensible to make savings on this position. It is actually the same with accountant or lawyer 🙂

BI payouts and payouts in general IT are rising in the last few years. Current job market situation only helps the growth as the market is coping with lack of IT personnel. According to freely available information, situation is as follows:

  • Average gross wage is 47 000 CZK
  • BI Developer wage is dependent on local situation and seniority. It moves in range between 30 – 100 000 ++ (big space for growth)
  • Mid-senior position Prague/Brno 45 000 – 70 000
  • Junior position 30 000 a fast growth
  • International projects 100 000 +
Rate this post
Category: Don't Miss Out Sample Reports in power BI SQL Server Tags:

About Ing. Jan Zedníček - BI Developer, Finance controller

My name is Jan Zedníček and I work as a BI Developer at Kentico Software in Brno. Mostly you can see me there working in the office, but I also work partly as a freelancer. I have been working as a freelancer for many companies for more than 5 years, but Kentico is the matter of my heart. I used to work as a financial controller at companies like Aero Vodochody, banking and I also used to be a bond program manager in Unicapital Investment group. When I am not at work, I like playing volleyball, chess, doing a workout in the gym and I enjoy tasting of best quality rums. I am trying to summarize all my knowledge on this website not to forget them (because of the rum effect, you know =) and to put them forward to anyone. Don´t worry about asking for help or writing some comments.

Leave a Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.