As a Full Stack Developer in Grid Consulting, you will build and evolve digital applications that accelerate consulting delivery, turning complex consulting workflows, study inputs/outputs, and data-driven insights into secure, scalable software products. This includes end-to-end ownership across UI, backend services, database design, and enterprise-grade authentication/authorization via SSO. You will work closely with consultants, product owners, and domain experts to translate real consulting needs into modern web applications with strong data foundations and clean integrations. Key Responsibilities Full Stack Development • Design, develop, and maintain end-to-end web applications (frontend + Node.js backend + SQL data layer). • Build modular backend services and APIs (REST/GraphQL) to support consulting workflows and integrations. • Develop intuitive, responsive UI experiences to support consultants and stakeholders with clear data visualization and workflow execution. Data & SQL Engineering • Design relational data models and write performant SQL queries for reporting, analytics, and operational workflows. • Implement data access patterns, migrations, and query optimization for performance and long-term maintainability. • Ensure data quality, traceability, and secure handling of sensitive customer/project data. Identity, SSO, and Security • Implement and maintain enterprise authentication and authorization using SSO (e.g., OIDC/OAuth2/SAML patterns) and role-based access control. • Integrate with identity providers (e.g., Entra ID/Azure AD patterns) and ensure secure session/token handling. • Apply secure coding practices and participate in threat modeling, vulnerability remediation, and security reviews. Integration & Engineering Excellence • Integrate internal/external services (data sources, document stores, reporting pipelines, automation) through robust APIs. • Write clean, maintainable, well-tested code with CI/CD practices and code review discipline. • Contribute to architecture decisions across service boundaries, data flow, deployment strategy, and observability. Collaboration • Partner with stakeholders to understand consulting lifecycle needs and ship pragmatic, high-impact features. • Operate effectively in agile, cross-functional teams with evolving requirements and multiple workstreams. Qualifications & Required Skills Education • Bachelor’s/Master’s degree in Computer Science, Software Engineering, or related field (or equivalent practical experience). Must Have • Strong hands-on experience with Node.js (e.g., Express/NestJS patterns), building production backend services and APIs. • Strong proficiency in SQL (schema design, query tuning, joins, transactions, indexing, performance troubleshooting). • Proven expertise implementing SSO and identity flows (OIDC/OAuth2/SAML concepts), token/session management, and RBAC. • Experience designing secure web applications with common OWASP considerations (authz, injection prevention, secrets handling). Full Stack Engineering Foundations • Experience with modern frontend development (e.g., React/Angular/Vue) and building maintainable UI components. • Familiarity with API design, integration patterns, and distributed-system fundamentals (timeouts, retries, idempotency, logging). • Comfortable working with Git-based workflows, CI/CD pipelines, and automated testing practices. Nice to Have (Preferred) • Experience with cloud deployments (containers, Kubernetes, managed databases) and production monitoring/observability. • Experience with data visualization, reporting, or analytics workflows relevant to consulting deliverables. • Familiarity with energy systems / grid domain concepts (helpful, not required).
