Part-Time Data Analyst

Part-Time Data Analyst & Power BI Developer (with Data Engineering Skills)Location: Remote (India)Engagement: Part-Time (15–25 hours/week to start)Company: StrategyCFOCompensation: Competitive, based on skill and experienceAbout the RoleStrategyCFO is looking for a part-time, highly skilled Data Analyst who can independently own analytics and reporting work across Power BI, SQL, Google Sheets, and basic data engineering/integration tasks.You will support multiple ongoing client projects by building dashboards, automating data flows, cleaning and modelling real-world datasets, and ensuring that reporting is accurate, reliable, and scalable.This role is ideal for someone who prefers part-time, flexible hours, and enjoys building solutions end-to-end without heavy supervision.Key Responsibilities1. Power 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 accuracy2. SQL (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 BI3. Google 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 QA4. Data 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 pipelines5. Data 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 reportingRequired SkillsTechnicalStrong Power BI skills (DAX, modelling, relationships, Power Query)SQL (joins, aggregations, window functions, transformation logic)Google Sheets (advanced formulas and structuring)API integrations (JSON handling, endpoints, authentication)Automation tools (Make.com, Apps Script, Pipedream or similar)AnalyticalAbility to interpret real-world business datasetsStrong logical thinking and ability to design KPIsGood pattern recognition and data storytellingSoft SkillsWorks independently with minimal guidanceStrong attention to detailComfortable with asynchronous communicationAbility to meet deadlines in a part-time schedulePreferred (Not Mandatory)Experience with CRMs, ERPs, or accounting systems (e.g., Odoo, Xero, Dear, JobNimbus, Shopify)Exposure to multi-system data integrationPython for data automation (nice to have)Prior part-time / consulting / freelance experienceEngagement DetailsPart-time role to start (15–25 hours/week)Flexible working hours (IST)Remote-onlyOption to convert to long-term / ongoing engagement based on performanceWork spans multiple industries (e-commerce, solar, home improvement, FMCG, etc.)