Power BI Developer

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

ResponsibilitiesDashboard & 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

ns 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

ion 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

ions Required Skills & Experience Core Technical Sk

• ills Minimum 3+ years hands-on experience with Power BI Desktop and Se
• rviceExpert-level proficiency in DAX (Data Analysis Express
• ions)Advanced skills in Power Query (M language) for data transform
• ationStrong understanding of data modeling principles and best prac
• ticesExperience with Power BI Service administration and deplo
• ymentKnowledge of SQL and relational database con

cepts Data & Analytics Expe

• rtise Experience designing dimensional data models (star/snowflake sc
• hemas)Understanding of data warehousing concepts and methodo
• logiesProficiency in data visualization principles and UX best pra
• cticesKnowledge of statistical analysis and business m
• etricsExperience with performance optimization and query
• tuningFamiliarity with data quality and validation tech

niques Additional Technical

• Skills Experience with Azure services (Azure SQL, Synapse Analytics, Data F
• actory)Knowledge of T-SQL for database queries and stored pro
• ceduresFamiliarity with Python or R integration in P
• ower BIUnderstanding of REST APIs and custom data con
• nectorsExperience with version control (Git) for Power BI p
• rojectsKnowledge of Power Platform integration (Power Apps, Power Au

tomate) Desired Certifications & Exp

• erience Microsoft Certified: Power BI Data Analyst Associate
• (PL-300)Microsoft Certified: Azure Data Engineer Associate
• (DP-203)Experience with Power BI Embedded and white-label s
• olutionsKnowledge of Tabular models and Analysis
• ServicesFamiliarity with DirectQuery vs Import mode opti
• mizationExperience with composite models and aggr

egations Ideal CandidateProfile 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

iverables 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'llWork 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

on 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

king reports Industry-Specif

• ic Solutions Logistics: Supply chain analytics, delivery performance, route
• optimizationRetail: Sales analytics, inventory turnover, cust
• omer insightsHealthcare: Patient outcomes, resource utilization, operation
• al efficiencyManufacturing: Production metrics, quality control, O
• EE dashboardsFinance: P&L statements, cash flow analysis, varia

nce 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

ics dashboards Engagement Details Cont

• ract Structure Contract Type: Independent Contractor
• (B2B preferred)Location: Fully Remote (NZ-based preferred for time
• zone alignment)Engagement: Project-based and/or monthly retain
• er arrangementsRate: Competitive hourly/daily rates base

d on experience Hours: Flexible, based on project requirements and deadlines