About SmartByte Solutions
SmartByte Solutions is a New Zealand owned IT consultancy founded in 2023, specializing in innovative technology solutions including data analytics, web development, Python automation, cloud services, and AI development. We help businesses transform their data into actionable insights and drive informed decision-making across various industries.
Position Overview
We're seeking an experienced
Power BI Developer
to join our team as an independent contractor. This role offers the opportunity to work on diverse data analytics projects, creating compelling visualizations and robust reporting solutions that enable businesses to unlock the full potential of their data.
Key Highlights
* Fully Remote
: Work from anywhere in New Zealand or internationally
* Flexible Engagement
: Project-based or ongoing retainer arrangements
* Diverse Industries
: Work with clients across logistics, retail, healthcare, manufacturing, and more
* Cutting-Edge Projects
: Build interactive dashboards and advanced analytics solutions
* Professional Growth
: Exposure to latest Power BI features and data visualization best practices
Responsibilities
Dashboard & Report Development
* Design and develop interactive Power BI dashboards and report
* sCreate compelling data visualizations that tell meaningful storie
* sBuild paginated reports using Power BI Report Builde
* rDevelop mobile-optimized reports and dashboard
* sImplement drill-through, bookmarks, and advanced interactivity feature
* sDesign executive-level dashboards with KPIs and performance metric
s
Data Modeling & ET
* L
Design and implement efficient data models using DAX and Power Query (
- M)Create complex calculated columns, measures, and tabl
- esBuild star schema and snowflake schema data mode
- lsOptimize data models for performance and scalabili
- tyImplement incremental refresh and data refresh strategi
- esDevelop ETL processes using Power Query transformatio
n
**s
Integration & Deployme**
* nt
Connect Power BI to various data sources (SQL, Excel, APIs, cloud servic
- es)Integrate Power BI with SharePoint, Teams, and web applicati
- onsConfigure and manage Power BI workspaces and a
- ppsImplement Row-Level Security (RLS) and data governance polic
- iesDeploy reports to Power BI Service and manage publishing workfl
- owsCreate and maintain dataflows for centralized data preparat
i
**on
Client Engagement & Supp**
* ort
Gather and analyze business intelligence requirem
- entsTranslate business needs into technical BI solut
- ionsConduct stakeholder workshops and requirement sess
- ionsProvide user training and create comprehensive documenta
- tionTroubleshoot report performance and data is
- suesOffer ongoing support and enhancement recommendat
i
**ons
Required Skills & Experi
en
ce
Core Technical Sk**
* **ills
Minimum 3+
years hands-on experience with Power BI Desktop and Se
- rviceExpert-level proficienc
y in DAX (Data Analysis Express
- ions)Advanced skill
s in Power Query (M lang
uage) for data transform
- ationStrong understandin
g of data mod
eling principles and best prac
- ticesExperience
with Power BI Se
rvice administration and deplo
- ymentKnowledg
e o**
f SQL and relational database con
c
**epts
Data & Analytics Expe**
* rtise
Experience desi
gning dimensional data
models (star/snowflake sc
- hemas)Understandi
ng of data wareh
ousing concepts and methodo
- logiesProficien
cy in data visuali
zation principles and UX best pra
- cticesKnowled
ge of statistical an
alysis and business m
- etricsExperience
with performance optimi
zation and query
- tuningFamiliarity
with data q
uality and validation tech
n
**iques
Additional Technical**
* Skills
Experienc
e wit
h Azure services (Azure SQL, Synapse Analytics, Data F
- actory)Knowle
dge o
f T-SQL for database queries and stored pro
- ceduresFamiliarit
y with
Pyt
h
on or R integration in P
- ower BIUnderstand
ing of RE
ST APIs and custom data con
- nectorsExperienc
e with version
control (Git) for Power BI p
- rojectsKnowle
dge of Power P
latform integration (Power Apps, Power Au
t
**omate)
Desired Certifications & Exp**
* erience
Microsoft Certified: Power BI Data Analyst Associate
- (PL-300)Microsoft Certified: Azure Data Engineer Associate
- (DP-203)Experien
ce with Power BI
Embedded and white-label s
- olutionsKnowl
edge of Tabula
r models and Analysis
- ServicesFamiliari
ty with Dir
ectQ
uery v
s Import mode opti
- mizationExperien
ce with composit
e models and aggr
e
**gations
Ideal Candidate
P
rofile
Professional At**
* tributes
Strong analytical and problem-solvi
- ng skillsExcellent attention to detail and data
- accuracyAbility to translate complex data into simple, actionable
- insightsProactive communication with technical and non-technical sta
- keholdersSelf-motivated with ability to manage multiple projects inde
- pendentlyClient-focused mindset with commitment to quality del
i
**verables
Business Intelligen**
* ce Acumen
Understanding of various business functions (finance, operations,
- sales, HR)Ability to identify trends, patterns, and anomali
- es in dataExperience presenting insights to executive
- leadershipKnowledge of industry-specific KPIs a
- nd metricsAppreciation for data storytelling and narrativ
e
**building
Project Types You'
ll
Work On
Operational**
* Dashboards
Real-time logistics and supply chain
- monitoringSales performance and pipeli
- ne trackingFinancial reporting and budg
- et analysisInventory and warehouse managemen
- t analyticsCustomer behavior and segmentati
o
**n analysis
Executiv**
* e Reporting
C-level executive dashboards with st
- rategic KPIsBoard-level reporting and business
- intelligenceDepartmental performanc
- e scorecardsTrend analysis and foreca
- sting modelsComparative analysis and benchmar
k
**ing reports
Industry-Specif**
* ic Soluti
ons
Logistics: Supply chain analytics, delivery performance, route
- optim
izationRetail: Sales analytics, inventory turnover, cust
- omer insig
htsHealthcare: Patient outcomes, resource utilization, operation
- al efficiency
Manufacturing: Production metrics, quality control, O
- EE dash
boardsFinance: P&L statements, cash flow analysis, varia
n
**ce reporting
Advan**
* ced Analytics
Predictive analytics using AI visuals and R/Pyth
- on integrationWhat-if analysis and sce
- nario modelingCustom visualizations using Power BI
- custom visualsComposite models integrating multipl
- e data sourcesReal-time streaming analyt
i
**cs dashboards
Enga
ge
ment Details
Cont**
* ract Structur
e
Contract Type: Independent Contractor
- (B2B pre
ferred)Location: Fully Remote (NZ-based preferred for time
- zone align
ment)Engagement: Project-based and/or monthly retain
- er a
rrangementsRate: Competitive hourly/daily rates base
d
on e
xperience
Hours: Flexible, based on project requirements and deadlines