Associate, Software Engineer

Roundglass Foundation; Sahibzada Ajit Singh Nagar; On-site; INR 900,000 - 1,300,000; Full time

Job summary

Roundglass Foundation in Mohali, India is seeking an Associate, Software Engineer to contribute to the Impact Analytics team. You will build dashboards and data models using Power BI and Metabase, while crafting robust backend services in Node.js.

You will design star and snowflake schemas, write DAX/MDX measures, and develop RESTful APIs, ensuring data quality and scalable analytics across BI platforms. You'll implement ETL/ELT pipelines, optimize query performance, and collaborate with

Qualifications

• Minimum B.Tech in Computer Science or equivalent.
• 2–3 years of professional software development and BI engineering experience.
• Power BI: hands-on experience building reports, dashboards, datasets, and dataflows.
• DAX & MDX: ability to write complex measures and MDX queries.
• Semantic modeling: star/snowflake schemas and slowly changing dimensions.
• Metabase: experience creating questions and dashboards.

Responsibilities

• Design, develop, and maintain dashboards in Power BI and Metabase.
• Build semantic/dimensional data models (star and snowflake schemas) to support self-service analytics.
• Develop DAX measures, calculated columns, and MDX queries for multi-dimensional analysis.
• Optimize report performance through query tuning, aggregation strategies, and incremental refresh.
• Collaborate with business teams to translate requirements into clear, actionable visualizations and metrics.
• Design, develop, and maintain RESTful APIs using Node.js (Express or similar frameworks).
• Apply REST principles, versioning, authentication (JWT/OAuth2), and standardized error handling.
• Write clean, modular, well-documented code with unit and integration tests.
• Integrate third-party APIs and internal services to support reporting, automation, and workflow pipelines.
• Design normalized OLTP schemas and denormalized OLAP/reporting schemas based on use case.
• Write efficient SQL queries across MySQL and PostgreSQL.
• Implement ETL/ELT pipelines to move data between transactional systems and analytics layers.
• Ensure data quality, consistency, deduplication, and integrity across distributed sources.
• Configure and extend low-code data platforms such as NocoDB to deliver rapid application backends.
• Work with workflow/BPM tools to model and automate business processes.
• Build integrations between low-code platforms, APIs, and BI tools to create end-to-end solutions.

Skills

Power BI

DAX

MDX

Node.js

REST APIs

SQL

Dimensional Modeling

NocoDB

XState

Camunda

Git

Metabase

Education

B.Tech in Computer Science

Tools

MySQL

PostgreSQL

Swagger

Postman

Git

OpenAPI

Job description

Associate, Software Engineer

S.A.S. Nagar (Mohali), India

About the role

We are looking for a hands‑on Software Engineer to join our Impact Analytics team. The ideal candidate will combine strong backend development skills in Node.js with deep expertise in business intelligence, dimensional data modeling, and self‑service analytics platforms such as Power BI and Metabase.

What you’ll do

• Design, develop, and maintain interactive dashboards, paginated reports, and KPI scorecards in Power BI and Metabase.
• Build robust semantic/dimensional data models (star and snowflake schemas) to support self‑service analytics.
• Develop DAX measures, calculated columns, and MDX queries for multi‑dimensional analysis and complex business logic.
• Optimize report performance through query tuning, aggregation strategies, and incremental refresh.
• Collaborate with business teams to translate requirements into clear, actionable visualizations and metrics.
• Design, develop, and maintain RESTful APIs using Node.js (Express or similar frameworks).
• Apply REST principles, versioning, authentication (JWT/OAuth2), and standardized error handling consistently.
• Write clean, modular, well‑documented code with appropriate unit and integration tests.
• Integrate third‑party APIs and internal services to support reporting, automation, and workflow pipelines.
• Design normalized OLTP schemas and denormalized OLAP/reporting schemas based on use case.
• Write efficient SQL queries, schema design, views, and indexes across MySQL and PostgreSQL.
• Implement ETL/ELT pipelines to move data between transactional systems and analytics layers.
• Ensure data quality, consistency, deduplication, and integrity across distributed sources.
• Configure and extend low‑code data platforms such as NocoDB to deliver rapid application backends.
• Work with workflow and BPM tools (e.g., XState, Camunda, n8n, Power Automate) to model and automate business processes.
• Build integrations between low‑code platforms, APIs, and BI tools to create end‑to‑end solutions.

Requirements

• Minimum B.Tech in Computer Science or Equivalent.
• 2–3 years of professional experience in software development and BI engineering.
• Power BI: hands‑on experience building reports, dashboards, datasets, and dataflows.
• DAX & MDX: demonstrated ability to write complex measures, calculated columns, and MDX queries.
• Semantic/dimensional modeling: solid understanding of star schema, fact/ dimension tables, surrogate keys, and slowly changing dimensions.
• Metabase: experience creating questions, dashboards, models, and managing permissions.
• REST API design: good grasp of RESTful principles, HTTP semantics, authentication, and API documentation (OpenAPI/Swagger/Postman).
• Database programming: strong SQL skills with MySQL, PostgreSQL, or equivalent; ability to design schemas from scratch.
• NocoDB or similar low‑code tools: working exposure to setting up bases, views, and API endpoints. (Nice to have)
• Workflow/BPM tools: exposure to at least one (XState, Camunda, n8n, Power Automate, or similar). (Nice to have)
• Version control: comfortable with Git, branching strategies, and pull‑request workflows.
• Experience in API integration with mobile app is plus.