SQL Developer + DWH
at US management consulting firm headquartered in Evanston,

Similar jobs (10)
We are looking for a skilled Node.js Developer with PHP experience to build, enhance, and maintain ERP and EdTech platforms. The role involves developing scalable backend services, integrating ERP modules, and supporting education-focused systems such as LMS, student management, exams, and fee management.
Key Responsibilities
Develop and maintain backend services using Node.js and PHP.
Build and integrate ERP modules for EdTech platforms (Admissions, Students, Exams, Attendance, Fees, Reports).
Design and consume RESTful APIs and third-party integrations (payment gateway, SMS, email).
Work with databases (MySQL / MongoDB / PostgreSQL) for high-volume education data.
Optimize application performance, scalability, and security.
Collaborate with frontend, QA, and product teams.
Debug, troubleshoot, and provide production support.
Required Skills
Strong experience in Node.js (Express.js / NestJS).
Working experience in PHP (Core PHP / Laravel / CodeIgniter).
Hands-on experience with ERP systems.
Domain experience in EdTech / Education ERP / LMS.
Strong knowledge of MySQL and database design.
Experience with authentication, role-based access, and reporting.
Familiarity with Git, APIs, and server environments.
Preferred Skills
Experience with online examination systems.
Knowledge of cloud platforms (AWS / Azure).
Understanding of security best practices (CSRF, XSS, SQL Injection).
Exposure to microservices or modular architecture.
Qualification
Bachelor’s degree in Computer Science or equivalent experience.
3–6 years of relevant experience in Node.js & PHP development
About Root Node
We’re an early-stage startup building intelligent tools for planning, scheduling, and optimization—starting with timetabling and warehouse logistics. Backed by deep domain expertise and a growing customer pipeline, we’re now building our core tech team. This is not just a coding job — it's a chance to build something meaningful from the ground up.
About the job
- Design and implement robust backend systems and APIs using Java or similar backend language and Spring Boot or equivalent frameworks
- Integrate backend services with existing custom ERP systems
- Work closely with the founder on product architecture, feature prioritization, and go-to-market feedback
- Take full ownership of features — from system design and development to deployment and iterative improvements
- Help shape our engineering culture and technical foundations
You're a Great Fit If You:
- Have 3+ years of experience in backend development
- Are strong in Java or similar languages (e.g., Kotlin, Go, Node.js)
- Have solid experience with Spring Boot or equivalent backend frameworks
- Have integrated with ERP or enterprise systems in production environments
- Are comfortable with both SQL (PostgreSQL) and NoSQL (MongoDB)
- Understand REST API development, authentication, Docker
- Have an entrepreneurial mindset — you're excited about ownership, ambiguity, and making decisions that shape the product and company
- Want more than just a job — you want to build, solve, and learn rapidly
What We Offer
- Competitive salary
- High degree of ownership and autonomy
- Ability to shape the tech and product direction from Day 1
- Transparent and fast decision-making culture
- A builder’s environment — solve real-world problems with real impact
You will also be responsible for integrating the front-end elements built by your co-workers into the application. Therefore, a basic understanding of front-end technologies is necessary as well.
- Design and Build Web Applications.
- Prior experience of custom APIs creation and good command with MySQL is required.
- CodeIgniter & Laravel prior knowledge is required.
- Collaborate with cross-functional teams to define, design, and ship new features.
- Work with outside data sources and API.
- Should be able to develop the application with effective coding with minimal errors/bugs.
- Work on bug fixing and improving application performance.
- Ability to be a self-starter, prioritize your work, stay organized, self-motivating and work and motivate well in a team environment is critical.
- Should be able to manage the whole project solely or in the team.
- Develop, implement, and maintain applications developed around the Shopify/Shopify Plus platform.
- Knowledge of Ajax, Liquid, HTML, CSS, JS, JQuery is mandatory requirements.
- Knowledge for Wordpress Theme customization, Plugins installation.
- Answer various questions from our clients and attend the solution delivery meetings with the team.
- Contribute to quality control activities with the team.
- Take part in the improvement of standards within the Shopify practice.
- Creative and open to new ideas.
- Adaptable and willing to learn new techniques.
Responsibilities:
- Ability to work in an existing codebase and collaborate with a diverse team
- Experience in building enterprise-scale backend REST APIs with frameworks such as Nest.js & Express.js using an API-first paradigm
- Intimate knowledge of crafting highly performing database queries
- Hands-on experience implementing relational database structures, including tables, indexes, views, etc.
- A mindset towards building systems for the cloud and DevOps fundamentals
- Working knowledge of cloud infrastructure services is good to have. If not then willingness to learn should be there.
- Focus towards building security, performance, and scalability into services from the beginning
- Experience with debugging code and troubleshooting technical issues in order to craft appropriate solutions
Responsibilities
- Writing clean and secure modular codes that have undergone strict testing and evaluation.
- Maintaining and designing databases effectively.
- Build efficient, testable, and reusable PHP modules
- Solve complex performance problems and architectural challenges
- Write quality code with robustness and re-usability for secured web applications and web services (REST and SOAP) for mobile apps.
- Ability to work in a team environment as well should be able to manage a team.
- Must meet the deadline.
Requirements
- Strong hands on experience with PHP Laravel framework
- Knowledge of object oriented PHP programming
- Must have strong experience with API (Web Services) development using JSON, RESTFUL.
- Understanding of MVC design patterns
- Should be best at writing and understanding complex queries using any of two from - MySQL, NoSQL, MongoDB, PostgreSQL, T-SQL.
- Basic understanding of front-end technologies, such as JavaScript, HTML5, and CSS3
- Proficient understanding of code versioning tools, such as Git, SVN.
- Excellent communication and problem-solving skills.
Technical Skills
- PHP 5.X/7.X, MySQL, Stored Procedures, Ajax, GIT, SVN, Doctrine 2, JSON, jQuery, JavaScript,HTML5, CSS, XML
- PHP Framework: CodeIgniter/Zend Framework/Yii/Symfony
- JS Framework: AngularJs
- Operating Systems: Linux (Ubuntu)/ Windows
- WEB Server: XAMPP, LAMP
- Payment Gateways Integration: Knowledge of Multiple Gateway
- 3rd Party API Integration
Role & Responsibilities Shall Include
- Solid OOP & design patterns background
- Strong database skills, proficient in SQL, RDBMS concepts such as indexing, transactions,concurrency, locking, performance tuning
- Solid understanding of security concepts when developing and deploying modern web applications
- Service Oriented Architecture, designing, developing, and using RESTful APIs
- Experience with server-side and client-side application frameworks like CodeIgniter, Angular etc.
- Experience with advanced JavaScript concepts, libraries and frameworks, e.g. asynchronous request handling, partial page updates, and AJAX.
- Experience with all aspects of product development lifecycle.
- Familiarity with Scrum & Agile project methodologies.
- Excellent written, oral, and visual communication skills.
- Bachelor’s degree in a related field or industry equivalent.
- Experience writing semantic, modular interfaces with HTML5, CSS3, JavaScript, and jQuery that meet W3C standards, experience with responsive CSS











