Part-Time Business Intelligence Specialist

Job OpportunityWe are seeking a skilled Data Analyst to join our team on a part-time basis. As a Data Analyst, you will play a crucial role in owning analytics and reporting work across various tools and platforms.About the RoleKey Responsibilities:Develop dashboards from scratch using Power BI, including data ingestion, cleaning, modeling, DAX, and visualization.Use Power Query for data transformation and shaping, ensuring well-structured and analytics-ready data models.Write advanced DAX for KPIs, time-intelligence, and business logic, and configure RLS, scheduled refresh, incremental refresh, parameters, etc.Optimize dashboards for performance and accuracy.Work with SQL, writing clean and optimized queries combining multiple datasets, building logic for de-duplication, grouping, time-based metrics, trend analysis, and performing date/time conversions, timestamp harmonization, and business-rule logic.Assist in cleaning and preparing backend datasets for Power BI.Collaborate with Google Sheets, working with operational data, using advanced formulas (QUERY, FILTER, ARRAYFORMULA, REGEX, etc.), structuring sheets for ingestion into Power BI, automating repetitive steps using Apps Script, and building helper/staging sheets for data cleaning and QA.Apply data engineering principles, integrating external systems through REST APIs, normalizing unstructured SaaS data into clean analytics tables, and troubleshooting data flow breaks and ensuring continuity of pipelines.Clean messy, real-world datasets, design clear transformation logic, document data definitions, modelling rules, and key assumptions, and provide quality checks to ensure stable reporting.RequirementsPower BI Development (End-to-End Ownership)Develop dashboards from scratch (data ingestion → cleaning → modelling → DAX → visuals)Use Power Query for data transformation and shapingBuild well-structured, analytics-ready data models (star schema)Write advanced DAX for KPIs, time-intelligence, and business logicConfigure RLS, scheduled refresh, incremental refresh, parameters, etc.Optimise dashboards for performance and accuracySQL (Intermediate to Advanced)Write clean, optimized queries combining multiple datasetsBuild logic for de-duplication, grouping, time-based metrics, trend analysisPerform date/time conversions, timestamp harmonization, and business-rule logicHelp clean and prepare backend datasets for Power BIGoogle Sheets + AutomationWork with operational data stored in Google SheetsUse advanced formulas (QUERY, FILTER, ARRAYFORMULA, REGEX, etc.)Structure Sheets for ingestion into Power BIAutomate repetitive steps using Apps Script (or willingness to learn quickly)Build helper/staging sheets for data cleaning and QAData Engineering Foundations (Lightweight but Practical)Integrate external systems through REST APIs (JSON, tokens, pagination)Use Make.com / Pipedream / Apps Script to automate data ingestionNormalize unstructured SaaS data into clean analytics tablesTroubleshoot data flow breaks and ensure continuity of pipelinesData Cleaning, Structuring & DocumentationClean messy, real-world datasets (duplicates, mismatches, missing fields)Design clear transformation logic from raw data → final modelDocument data definitions, modelling rules, and key assumptionsProvide quality checks to ensure stable reportingBenefitsOpportunity to work with cutting-edge tools and technologiesChance to develop skills in data analysis, visualization, and engineeringCollaborative and dynamic work environmentProfessional growth and development opportunitiesHow to ApplyIf you're passionate about data analysis and eager to contribute to our team's success, please submit your application.