Data Analyst - Mid Level at Lumos

Lumos offers clean and affordable solar power to a market of 1.3 billion potential customers who live off the electricity grid.Lumos enables people to replace hazardous and expensive kerosene generators and lanterns with modern solar electricity that can power lights, cellphones, fans, computers, TVs and other small electronic devices (all at once, every day). By offering Solar Power as a Service, Lumos offers homes and small businesses a simple and affordable way to pay for electricity in small installments using their mobile phones

Role Overview

• We are seeking a proactive and insight-driven Data Analyst with strong hands-on experience in Python, SQL, and Advanced Excel. 
• This role is ideal for someone who thrives in a fast-paced environment, takes full ownership of data problems, and transforms raw data into meaningful insights that drive business decisions. 
• You will work with minimal supervision and play a key role across data extraction, transformation, reporting, and analytics.

Key Responsibilities

• Extract, clean, transform, and validate data from multiple sources using SQL, Python, and Excel
• Design and maintain efficient ETL processes to support reporting and analytics needs
• Build insightful reports, dashboards, and analytical outputs that support operational and strategic decisions
• Perform exploratory data analysis to identify trends, patterns, risks, and opportunities
• Translate business questions into clear analytical approaches and actionable insights
• Ensure data accuracy, consistency, and integrity across reports and datasets
• Collaborate with cross-functional teams to understand data requirements and deliver solutions
• Continuously improve data processes, reporting efficiency, and analytical methods

Required Skills & Qualifications

• Strong proficiency in SQL for querying, aggregations, and performance-aware data extraction
• Practical experience using Python for data manipulation and analysis (e.g., pandas, numpy)
• Advanced Excel skills (Power Query, Pivot Tables, formulas, data modeling)
• Solid understanding of data cleaning, transformation, and basic ETL concepts
• Ability to work independently, prioritize tasks, and deliver with minimal supervision
• Strong analytical thinking with a problem-solving and solution-oriented mindset
• Excellent attention to detail and data accuracy

Preferred Attributes:

• Ownership mindset with a strong sense of responsibility for outputs and outcomes
• Comfortable working in a fast-paced, dynamic, and evolving environment
• Curious, creative, and proactive in identifying better ways to use data
• Strong communication skills with the ability to explain insights to non-technical stakeholders
• Willingness to learn new skills, grow and give back to the business in same measure

What Success Looks Like:

• Reliable, accurate, and timely reporting
• Actionable insights that influence decisions
• Improved data efficiency and reduced manual effort

Method of Application