Technical Editor

Work Mode: Full-time, in-person

Reporting To: VP – Software

Job Description

We are looking for a hands-on Technical Lead Engineer to lead the design, development, and delivery of our Head-End System (HES), Meter Data Management (MDM), and Smart Metering platform. The role requires strong backend engineering expertise, deep understanding of smart metering and utility systems, and the ability to guide a development team through architecture, implementation, integration, testing, deployment, and production support.

The ideal candidate will have practical experience building scalable IoT or utility platforms involving smart meter communication, DLMS/COSEM protocols, real-time data acquisition, validation, event processing, command execution, and integration with enterprise systems such as billing, NMS, OMS, and analytics platforms.

Key Responsibilities

• Lead end-to-end technical development of HES, MDM, AMI/AMR, and smart metering modules.
• Design scalable backend architecture for meter communication, data ingestion, validation, processing, storage, and reporting.
• Implement and guide development of DLMS/COSEM IEC 62056 based meter communication.
• Integrate with smart meters, DCUs/gateways, billing systems, NMS, OMS, analytics systems, and third-party utility platforms.
• Lead Java/Spring Boot backend development using REST APIs, messaging queues, socket programming, and distributed system patterns.
• Design high-volume data pipelines for interval data, events, alarms, billing reads, and meter health data.
• Ensure performance, scalability, fault tolerance, database optimization, and reliable production operations.
• Mentor developers, review code, define engineering standards, and guide sprint-level technical execution.
• Work with product, project, QA, deployment, and customer teams to convert utility requirements into robust technical solutions.
• Own technical troubleshooting for production issues, performance bottlenecks, device communication failures, and integration defects.
• Prepare technical documentation, architecture diagrams, API specifications, and deployment guidelines.

Required Skills

• 6+ years of software development experience, including 3+ years in smart metering, HES, MDM, AMI, IoT, or utility platforms.
• Strong hands-on experience with Java, Spring Boot, REST APIs, JDBC/JPA, multithreading, backend system design, debugging, performance tuning, and production support.
• Practical experience with DLMS/COSEM, IEC 62056, Gurux or similar frameworks, smart meter communication, meter reads, events, commands, and remote operations.
• Strong understanding of communication protocols such as TCP/IP, socket programming, FTP/SFTP, MQTT/HTTP, and related integration patterns.
• Experience with Kafka/RabbitMQ, MySQL/MariaDB, MongoDB, Redis, ClickHouse, Apache Solr, or similar messaging and data platforms.
• Knowledge of scalable architecture, including clustering, replication, load balancing, caching, retries, failover, monitoring, and large-scale time-series data handling.
• Experience leading backend engineering teams, owning technical delivery, reviewing code, and mentoring developers.
• Preferred: experience with utility/DISCOM projects, AMISP programs, billing engines, prepaid metering, NMS/OMS, energy accounting, cloud services, CI/CD, Docker/Kubernetes, observability, and cybersecurity for smart metering systems.

Education Requirement

Bachelor’s degree in Computer Science, IT, Electronics & Communication, Electrical Engineering, or a related engineering discipline is preferred. Candidates with strong hands-on HES/MDM, AMI, DLMS/COSEM, IoT, or utility software experience may be considered even with a different academic background.

Key Responsibilities

Reporting & Analytics Development

• Design, develop, and maintain complex reporting solutions serving mission-critical emergency

response operations

• Build interactive dashboards and data visualizations that transform large datasets into

actionable insights

• Develop advanced analytics features including trend analysis, predictive metrics, and

operational intelligence

• Create self-service reporting capabilities enabling stakeholders to access critical data

independently

• Implement real-time and scheduled reporting systems with appropriate caching and

optimization strategies

SQL & Database Architecture

• Write and optimize complex SQL queries involving multiple joins, subqueries, CTEs, window

functions, and aggregations

• Review existing database architectures and identify performance bottlenecks and optimization

opportunities

• Design and implement database schema enhancements to support evolving reporting

requirements

• Develop and maintain stored procedures, functions, and views optimized for reporting

workloads

• Perform comprehensive query performance analysis and implement tuning strategies across

PostgreSQL and AWS Aurora environments

• Create efficient indexing strategies and data access patterns for large-scale datasets

• Establish data modeling best practices for dimensional and transactional reporting needs

Performance Optimization

• Conduct systematic performance analysis of reporting queries processing millions of records

• Implement query optimization techniques including execution plan analysis, index tuning, and

query refactoring

• Design and implement data aggregation strategies, materialized views, and summary tables for

improved performance

• Monitor and optimize database performance metrics including query response times, resource

utilization, and concurrency

• Develop ETL processes and data pipelines optimized for reporting and analytics workloads

• Implement caching strategies and data archival policies to maintain optimal system

performance

Technical Collaboration

• Partner with Product and stakeholder teams to translate business reporting requirements into

technical solutions

• Conduct code reviews focused on SQL quality, performance, and best practices

• Provide technical guidance to development teams on reporting architecture and database

optimization

• Document database schemas, reporting architectures, and optimization strategies

• Collaborate with DevOps on database infrastructure, monitoring, and scaling initiatives

Required Qualifications

Experience & Background

• 8+ years of software engineering experience with significant focus on reporting, analytics, or

business intelligence

• 5+ years of hands-on experience writing complex SQL in production environments

• 3+ years working with large-scale databases (millions+ records) and optimizing query

performance

• Proven track record developing enterprise reporting solutions and analytics platforms

• Experience conducting database architecture reviews and implementing performance

improvements

Technical Expertise - SQL & Databases

• Expert-level SQL proficiency including complex joins, subqueries, CTEs, window functions, and

advanced aggregations

• Deep PostgreSQL expertise with production experience in query optimization and performance

tuning

• Strong understanding of database internals including execution plans, indexing strategies, and

query optimization

• Experience with AWS Aurora or other cloud-based PostgreSQL solutions

• Proficiency in stored procedures, triggers, functions, and database programming

• Advanced knowledge of database design principles, normalization, and dimensional modeling

• Experience with database performance monitoring and profiling tools

• Strong programming skills in PHP (Yii framework or similar MVC frameworks preferred)

• Solid experience with Vue.js or similar modern JavaScript frameworks for building reporting

interfaces

What You'll Work With

• Databases: PostgreSQL, AWS Aurora, multi-tenant architectures

• Backend: PHP (Yii framework), RESTful APIs

• Frontend: Vue.js (Vue 2/3), modern JavaScript, data visualization libraries

• Infrastructure: AWS (RDS, Aurora, S3, Lambda), Postgres

• Tools: Git/GitHub, JIRA, Agile development workflows

Work Location

Hyderabad, India - On-site position with flexible working arrangements to accommodate both India

and onsite teams

Scorpion Detective Agency is a professional investigation firm with over 15 years of industry experience, providing reliable and confidential private investigation services across Delhi. We specialize in Background Verification, Missing Person Investigations, Employee Theft Investigations, and Surveillance Services, delivering accurate and evidence-based results for our clients.

Position Overview

We are seeking a dedicated and detail-oriented Private Investigator to join our team. The ideal candidate will be responsible for conducting field investigations, gathering evidence, performing surveillance activities, and preparing detailed reports while maintaining the highest standards of confidentiality and professionalism.

Key Responsibilities

• Conduct surveillance and field investigations as assigned.
• Perform background verification and due diligence checks.
• Collect, analyze, and document evidence accurately.
• Investigate employee misconduct, theft, and fraud-related cases.
• Assist in missing person investigations and information gathering.
• Prepare detailed investigation reports and maintain case records.
• Coordinate with clients and provide case updates when required.
• Ensure all investigations are conducted legally and ethically.
• Maintain strict confidentiality of client information and case details.

Requirements

• Bachelor's degree preferred (not mandatory for experienced candidates).
• Strong observation, analytical, and problem-solving skills.
• Good communication and report-writing abilities.
• Ability to travel for field investigations when required.
• Knowledge of surveillance techniques and investigation procedures is an advantage.
• Basic computer proficiency for documentation and reporting.
• Honest, trustworthy, and highly professional attitude.

Experience

• Freshers with strong interest in investigations may apply.
• 1–5 years of experience in private investigation, security, law enforcement, or related fields is preferred.

Location

• Delhi NCR

Employment Type

• Full-Time

Why Join Us?

• Opportunity to work on diverse and challenging cases.
• Hands-on experience in professional investigations.
• Growth opportunities within a reputed detective agency.
• Supportive and confidential work environment.

Salary

• Competitive salary based on experience and skills.

Key Responsibilities:

• Source potential candidates through LinkedIn, job portals, social media platforms, and other recruitment channels.
• Screen resumes and conduct initial telephonic or virtual interviews to assess suitability.
• Coordinate and manage the complete interview process with hiring managers.
• Negotiate salary offers and support candidates throughout the onboarding process.
• Maintain accurate and updated records in the Applicant Tracking System (ATS).

Qualifications & Skills:

• Minimum 2+ years of hands-on experience in recruitment or talent acquisition.
• Strong working knowledge of multiple job portals and sourcing techniques.
• Excellent communication, interpersonal, and negotiation skills.
• Ability to manage multiple positions and meet hiring deadlines effectively.

Key Skills and Requirements

· Minimum 3+ years of hands-on experience in Node.js and Express.js

· Bachelor Degree in Computer Science OR in related field B.sc - IT/ BCA /MCA/B.Tech/M.Tech

· Programming experience in Web Application development with Node.js and Express.js

· Must have experience in JavaScript, Node.js, Express.js or have extensive exposure in any MVC framework

· Expert in MySQL and Store Procedures

· Knowledge of REST API / Web API protocol

· Understanding HTML, CSS, JavaScript, JQuery, Ajax, JSON, OOPs well enough

· Good to have: React Js.

· Strong coding skills, good analytical and problem-solving skills

· Ability to write clear, concise, well-structured, and well-organized code

· Experience with third-party libraries and APIs(Zoho, Leadsquared, Knowlarity, Exotel, LCode, Karza, Google API, DIGIO, etc)

· Ability to identify weaknesses in existing code and improve it

Plus but not required

· A plus if you have Slide experience with Git Command lines.

· A plus if you have any experience with Github, Gitlab, Bitbucket.

· A plus if you have any experience with UI Design

· A plus if you have any experience with PHP, CodeIgniter

· A plus if you have any experience with React JS/Angular JS

Essential Duties and Responsibilities

· Collaborate with cross-functional teams to define, design, and ship new features

· Work with outside data sources and APIs

· Unit-test code for robustness, including edge cases, usability, and general reliability Work on bug fixing and improving application performance

· Continuously discover, evaluate, and implement new technologies to maximize development efficiency

We are looking for a highly capable machine learning engineer to optimize our machine learning systems. You will be evaluating existing machine learning (ML) processes, performing statistical analysis to resolve data set problems, and enhancing the accuracy of our AI software's predictive automation capabilities.

To ensure success as a machine learning engineer, you should demonstrate solid data science knowledge and experience in a related ML role. A first-class machine learning engineer will be someone whose expertise translates into the enhanced performance of predictive automation software.

Machine Learning Engineer Responsibilities:

Consulting with managers to determine and refine machine learning objectives.

Designing machine learning systems and self-running artificial intelligence (AI) software to automate predictive models.

Transforming data science prototypes and applying appropriate ML algorithms and tools.

Ensuring that algorithms generate accurate user recommendations.

Turning unstructured data into useful information by auto-tagging images and text-to-speech conversions.

Solving complex problems with multi-layered data sets, as well as optimizing existing machine learning libraries and frameworks.

Developing ML algorithms to analyze huge volumes of historical data to make predictions.

Running tests, performing statistical analysis, and interpreting test results.

Documenting machine learning processes.

Keeping abreast of developments in machine learning.

Machine Learning Engineer Requirements:

Bachelor's degree in computer science, data science, mathematics, or a related field.

Master’s degree in computational linguistics, data analytics, or similar will be advantageous.

At least two years' experience as a machine learning engineer.

Advanced proficiency with Python, Java, and R code writing.

Extensive knowledge of ML frameworks, libraries, data structures, data modeling, and software architecture.

In-depth knowledge of mathematics, statistics, and algorithms.

Superb analytical and problem-solving abilities.

Great communication and collaboration skills.

Excellent time management and organizational abilities.

• Develop new user-facing features
• Build reusable code and libraries for future use
• Ensure the technical feasibility of UI/UX designs
• Optimize application for maximum speed and scalability
• Assure that all user input is validated before submitting to back-end
• Collaborate with other team members and stakeholders

• Proficient understanding of web markup, including HTML5, CSS3
• Basic understanding of server-side CSS pre-processing platforms, such as LESS and SASS
• Proficient understanding of client-side scripting and JavaScript frameworks, including jQuery
• Good understanding and knowledge of advanced JavaScript libraries and frameworks, such as AngularJS, KnockoutJS, BackboneJS, ReactJS, DurandalJS etc.
• Good understanding of asynchronous request handling, partial page updates, and AJAX
• Basic knowledge of image authoring tools, to be able to crop, resize, or perform small adjustments on an image
• Proficient understanding of cross-browser compatibility issues and ways to work around them.
• Proficient understanding of code versioning tools, such as Git
• Good understanding of SEO principles and ensuring that application will adhere to them

Responsibilities:

• Consult with users, clients, and other technology groups on issues, and recommend programming solutions, install, and support customer exposure systems
• Apply fundamental knowledge of programming languages for design specifications.
• Analyze applications to identify vulnerabilities and security issues, as well as conduct testing and debugging
• Serve as advisor or coach to new or lower level analysts
• Identify problems, analyze information, and make evaluative judgements to recommend and implement solutions
• Resolve issues by identifying and selecting solutions through the applications of acquired technical experience and guided by precedents
• Has the ability to operate with a limited level of direct supervision.
• Can exercise independence of judgement and autonomy.
• Acts as SME to senior stakeholders and /or other team members

Qualifications:

• Minimum 6 years of total IT experience
• Minimum 4 years of Appian development experience
• Good logical and reasoning skills
• Consistently demonstrates clear and concise written and verbal communication
• Demonstrated problem-solving and decision-making skills
• Ability to work under pressure and manage deadlines or unexpected changes in expectations or requirements
• Ability to read requirements and independently work on a project with minimal supervision

Education:

• Bachelor’s degree/University degree or equivalent experience