SolarSquare Energy - Data Analyst - SQL / Python

Data Analyst (BI Developer)

Job Description

As a Data Analyst with an analytics engineering focus, you will be the bridge between our raw data and our business stakeholders.

You won't just build dashboards; you will own the entire analytics workflow from modeling and transformation to visualization and deep-dive analysis.

Using your expertise in SQL, Python, and modern BI tools, you will be responsible for creating and maintaining the trusted datasets that the entire company will rely on for decision-making.

You will work closely with our Senior Data Engineer to leverage the data platform, ensuring that the data models you build are robust, reliable, and directly answer the most critical business questions.

Key Responsibilities

• Data Modeling & Transformation : Use dbt to build, maintain, and document robust, reusable data models. You will own the 'T' (Transform) in our ELT pipeline, turning raw data from our data lake into clean, trusted, and analysis-ready datasets.
• Business Intelligence & Dashboarding : Develop, deploy, and maintain insightful and intuitive dashboards using BI tools like Power BI, Tableau, or Metabase. You will be responsible for creating a single source of truth for key business metrics.
• Deep-Dive Analysis : Go beyond dashboards to answer complex business questions. Use your analytical skills in SQL and Python to conduct exploratory analysis, identify trends, and provide actionable recommendations to product, marketing, and leadership teams.
• Stakeholder Collaboration : Partner with business stakeholders to gather requirements, define key performance indicators (KPIs), and ensure your analytical outputs are aligned with their strategic goals.
• Data Quality & Documentation : Work with the Data Engineering team to define data quality tests within the transformation layer. Meticulously document your data models and metrics to foster a culture of data literacy.

Required Skills & Experience (Must-Haves)

Preferred Skills & Experience (Nice-to-Haves)

(ref : hirist.tech)

Skills Required

Matplotlib, Numpy, Pandas, Power Bi, dbt, Tableau, Sql, Python