Book a demo
Menu
Sign in

Solutions

Colleges & universitiesB-schools (MBA & PGDM)Online universitiesEdtech & skillingEmployersStudentsVCs & accelerators

Resources

BlogMock testsInterview questionsHire freshersJob description templatesHR letter formatsComparisonsAlternativesWhite-label & mobile app

Company

Pricing

Power BI developer job description template

A job description for a fresher Power BI developer, with an intern version, screening questions on measures and data models, and a simple way to check that a candidate’s numbers are right.

Post this job freeDownload WordDownload PDF

In short

In the first months, a fresher Power BI developer connects to data sources, cleans them in Power Query, builds a simple star-schema model, writes basic DAX measures and publishes reports with a scheduled refresh, all reviewed by a senior. Ask for Power BI Desktop practice, SQL basics and the habit of matching every total to its source. Keep advanced DAX, gateways and service administration outside the must-haves.

Power BI developer job description template

Fill in your company details once and both versions below update: the full-time job for freshers and the internship. Copy the one you need into your job post.

Nothing you type leaves this browser.

1. Full-time Power BI developer (fresher)

Power BI developer (fresher)

Company: [Company name]
Location: [Location] · Work mode: [Work mode]
Employment type: Full-time
CTC: [CTC for the full-time role]
Joining: [Joining date] · Apply by: [Apply by]

About [Company name]

[About your company]

About the role

Managers at [Company name] make decisions every week from the reports they open, and the [Team] team is hiring a fresher Power BI developer to build and look after them. You will connect to our data sources, shape the data in Power Query, build and test a data model, write DAX measures and publish to the Power BI service. A senior developer reviews every report, and you will agree each figure with the business user who owns it.

What you will do

  • Connect Power BI Desktop to the team’s sources, such as database tables, Excel workbooks and SharePoint folders, using the access a senior sets up
  • Clean and shape data in Power Query by checking the agreed row definition and duplicate key before removing records, fixing data types and dates, handling blanks and naming each applied step so a colleague can follow it
  • Build a star-schema model with fact and dimension tables, a date table and one-to-many relationships, hide key and helper columns that report users do not need, and leave personal data out of the model unless a senior approves it
  • Write basic DAX measures, such as totals, averages, a year-to-date figure and a comparison with last month, and test each one on a small sample before using it
  • Design report pages that each answer one question, with a clear title, a few headline numbers, a trend and a breakdown, and the same number formats on every page
  • Publish reports to a development workspace first, move them to the workspace managers use after a senior’s review, and pin key visuals to a dashboard when a manager wants one screen
  • Schedule data refreshes in the Power BI service, read the refresh history each morning and log every failure with its cause, such as expired credentials or a column renamed at the source
  • Apply the row-level security rules a senior defines, test each regional role and share reports only with approved users or groups. Confirm that restricted viewers have suitable permissions, since workspace Admin, Member and Contributor roles are not restricted by row-level security
  • Reconcile each report with its source system or the owner’s own sheet after every change, and record the date, the check and any difference found
  • Handle change requests from business users by making the change in a copy, showing the before and after, and updating a one-page note on sources, refresh time, measure definitions and owner

What we are looking for

  • Hands-on use of Power BI Desktop: importing data, shaping it in Power Query and building a multi-page report, in a course, an internship or a project of your own
  • Data modelling basics: fact and dimension tables, the level of detail each row represents, one-to-many relationships and when a star schema helps
  • Basic DAX: SUM, CALCULATE with a filter, DIVIDE and one date function, and the difference between a measure and a calculated column
  • SQL basics: reading a table, joining two tables, and grouping and filtering rows, enough to check a total at the source
  • Excel pivot tables and lookups, used to cross-check a report total
  • Chart sense: picks a chart to suit the question, labels axes and units, and keeps each page uncluttered
  • The habit of checking: you compare a total with its source before showing it, and say so when a figure does not match
  • A Power BI report you can walk through, from its sources and model to its measures; if the data is private, describing it is enough

Good to have

  • Power Query M basics: reading the code behind an applied step and editing it
  • Row-level security: building a role and testing it with the ‘View as’ option
  • Time-intelligence measures beyond year-to-date, such as the same period last year and a rolling three months
  • Accessible report design: alt text on visuals, readable colour contrast and a sensible tab order
  • Familiarity with the measures of one business area, such as sales, collections, stock or attendance

Who can apply

Final-year students and graduates of B.E./B.Tech, BCA, B.Sc, B.Com, BBA, MCA and MBA can all do well, because the role rewards tidy thinking with data more than a particular degree. Commerce and management graduates with strong Excel and one Power BI report they can walk through are worth shortlisting beside computer science graduates.

How to apply

Apply through this job post by [Apply by]. Shortlisted candidates will hear from us about the next steps.

2. Power BI developer internship

Power BI developer intern

Company: [Company name]
Location: [Location] · Work mode: [Work mode]
Employment type: Internship · Duration: [Internship duration]
Stipend: [Stipend for the internship]
Joining: [Joining date] · Apply by: [Apply by]

About [Company name]

[About your company]

About the role

Interns at [Company name] build reports under a mentor, using business data the mentor has approved and cleared of personal details. You will rebuild an Excel report in Power BI, write measures from a given list, check each figure against its source and present one finished report page to the team at the end. [We provide a Windows PC with Power BI Desktop.]

What you will do

  • Rebuild one existing Excel report as a Power BI report page and compare its totals with the original
  • Clean a data export in Power Query and write down each step you took and why
  • Write three or four measures from a list your mentor gives you, such as total sales, order count and average order value, and test each on a small sample
  • Add visuals and slicers to a page your mentor has sketched, then fix the layout after feedback
  • Check the figures against the source after each refresh and list any difference you find
  • Write a half-page ‘how to read this report’ note for the people who will use it
  • Present the finished report page to the team and answer questions on where each number comes from

What we are looking for

  • Studying in any stream, such as B.Com, BBA, BCA, B.Sc or B.Tech, or a recent graduate
  • Has built at least one report in Power BI Desktop, even in a course, and can walk you through its visuals
  • Comfortable with Excel formulas and pivot tables
  • Knows what a relationship between two tables does, or is willing to pick it up in week one
  • Agrees to keep company data confidential and to use only the data your mentor shares

Who can apply

Final-year students and graduates of B.E./B.Tech, BCA, B.Sc, B.Com, BBA, MCA and MBA can all do well, because the role rewards tidy thinking with data more than a particular degree. Commerce and management graduates with strong Excel and one Power BI report they can walk through are worth shortlisting beside computer science graduates.

How to apply

Apply through this job post by [Apply by]. Shortlisted candidates will hear from us about the next steps.

Other titles for this role

Junior Power BI developer, Power BI developer (fresher), Associate BI developer, BI analyst (fresher), Reporting analyst (fresher), Power BI developer trainee.

Screening questions to add to your job post

  1. In an Import-mode model, what is the difference between a calculated column and a measure, and which would you choose for a total? Look for a calculated column being evaluated row by row and stored when the model is processed or refreshed, while a measure is evaluated when queried using the current filter context. For a total that should respond to report filters, expect a measure.
  2. A table shows the right figure on every row, but the total at the bottom looks wrong. What would you check? Look for the measure being evaluated in the total’s filter context rather than automatically summing the displayed row results. Ratios, averages and distinct counts may therefore differ from that sum. A good answer checks the measure and business definition before deciding whether any change is needed.
  3. In a one-to-many relationship from Product to Sales with single-direction filtering, what happens to the sales figures when you select a product? Look for the selected product filtering the matching sales rows through the relationship. Accept a simple example or diagram. Knowledge of bidirectional filtering is an optional extra; do not reject a fresher for not having used it.
  4. How do you check that a number in your report matches its source? Look for a concrete method: the same total from a SQL query or an Excel pivot, for the same dates and filters, with the difference written down. An answer with no method gives you little to judge, so ask a follow-up.
  5. A report refreshes on your laptop, but the scheduled refresh in the Power BI service fails. What do you check first? Look for an answer that starts with the error message, then checks credentials, a file path that exists only on the laptop, a gateway that is offline for on-premises data, or a column renamed at the source. A candidate who has used only Power BI Desktop can still reason through this, so do not require service experience.
  6. What would you put on a single Power BI report page for a regional sales manager, and what would you leave off? Look for the manager’s decisions driving the choice: a few headline numbers, one trend, one breakdown by product or branch and a date slicer, with a reason for leaving other visuals off.

What to look for when you shortlist

  • A Power BI file, screen recording or spoken walkthrough, built on public, sample or masked data, with separate fact and dimension tables instead of one flat sheet
  • Measures with plain names and a line saying what each one counts, kept apart from the raw columns
  • Report pages where the title says what is shown and the units and date range are visible, so a manager can read them without help
  • A reconciliation note or sheet that compares report totals with the source, even for a practice project
  • Honest limits, such as ‘I have not set up row-level security’ or a story about a refresh error the candidate fixed
  • Questions about the data: where it lives, who owns it and how often it changes

Mistakes to avoid in this job description

  • Asking for Power BI, Tableau, Qlik and Python at once: name Power BI as the only BI tool you require, say which data source it will read, and move other tools to good to have.
  • Judging a candidate by how a report looks: a polished page can sit on wrong numbers, so ask where each measure comes from and check one total against the source.
  • Setting a practical test with no sample data, or one the candidate cannot run: use a small made-up file, state the time limit and offer a Windows PC, since Power BI Desktop installs only on Windows.
  • Naming no data source: say whether the reports will read a database, Excel exports from finance or sales, or a CRM, and who owns that data, so applicants can prepare for the real work.
  • Letting a fresher publish straight to the workspace managers use: start them in a development workspace and have a senior review each report before it moves across.

Questions about hiring a Power BI developer

What should a fresher Power BI developer know?

Connecting to data and cleaning it in Power Query, a star-schema model, basic DAX measures and readable report pages. SQL basics and Excel pivot tables help in checking totals. Publishing, scheduled refresh, advanced DAX, performance tuning and gateways are learnt on the job. Ask the candidate to walk you through one report they built, from source to visual, or to describe it if the data was private.

How is a Power BI developer different from a data analyst?

A data analyst starts with a business question and answers it with SQL, spreadsheets and a dashboard tool. A Power BI developer builds and maintains the reports and the data model behind them: the connections, the measures and the published pages. One person can cover both roles in a small team. If the work is mostly SQL and open questions, use the data analyst template; if it is mostly the model and the reports, use this one.

How can I test a fresher Power BI developer quickly?

Provide a small fictional sales file, define what each row represents and include an accidental duplicate and a blank date. Supply a verified control total and explain which records it covers. Ask for one report page, sales, order count and average order value measures, and a note on exclusions or unresolved differences. Provide a Windows PC, set the time limit and apply the same marking criteria to every candidate.

How much DAX does a fresher Power BI developer need?

Basic DAX: totals, ratios with DIVIDE, a filtered total with CALCULATE and one date measure, such as year to date or a comparison with last month. Understanding why a measure reacts to the filters on the page matters more than remembering syntax. Advanced patterns can wait. Test the idea with a measure-versus-column question rather than asking for code from memory.

What project suits a Power BI intern?

Give the intern one report to finish: rebuild an existing Excel report in Power BI, match its totals to the original, add a date slicer and finish with a short note on how to read it. Name a mentor, hold a weekly review and end with a demo to the team. LineupX lets you post the internship free of charge and add your own screening questions to the post.

Related

Data analyst job descriptionMIS executive job descriptionBusiness analyst job descriptionData scientist job descriptionHiring guide for this roleInterview questions for this roleHow to write a job descriptionAll job description templates

Post your Power BI developer job free

Paste this job description into a free LineupX job post, add your screening questions and share it with students across 100+ institutions and edtechs. No hidden charges, no limit on jobs.

Post a job freePost an internship free