3+ Query optimization Jobs in Chennai | Query optimization Job openings in Chennai

Job Title : Analytics Engineer

Experience : 6+ Years

Location : Gurgaon | Bangalore | Ahmedabad | Chennai

Work Mode : Work From Office

Employment Type : Contract (6 Months)

About the Role :

We are looking for an experienced Analytics Engineer to design, develop, and optimize scalable data models and analytics solutions that drive business decision-making. The ideal candidate should have strong expertise in SQL, dbt, data modeling, data quality, and modern analytics engineering practices.

Mandatory Skills :

SQL, dbt, Data Modeling, Data Warehousing, ETL/ELT, Query Optimization, Data Quality, Git, CI/CD, Analytics Engineering, Data Transformation, Data Governance, Stakeholder Management.

Key Responsibilities :

• Design and maintain scalable data warehouse models, data marts, and analytical datasets.
• Build and optimize data transformation pipelines using SQL and dbt.
• Develop high-performance SQL queries using CTEs, Window Functions, Complex Joins, and Analytical Functions.
• Implement data quality checks, testing frameworks, and governance best practices.
• Manage end-to-end analytics development lifecycle, from requirement gathering to deployment.
• Work with Git, CI/CD pipelines, and version control best practices.
• Collaborate with business and technical stakeholders to deliver reliable analytics solutions.
• Troubleshoot and optimize data pipelines, models, and query performance.

Required Skills :

• 6+ years of experience in Analytics Engineering, Data Engineering, or related roles.
• Strong expertise in SQL and query performance optimization.
• Hands-on experience with dbt (Data Build Tool).
• Strong understanding of data modeling and data warehousing concepts.
• Experience with Git, CI/CD, and software development best practices.
• Knowledge of data quality frameworks, testing, and validation techniques.
• Ability to independently manage design, development, testing, documentation, and deployment.

Preferred Skills :

• Experience with cloud-based data platforms.
• Exposure to orchestration and scheduling tools.
• Understanding of data governance and compliance frameworks.
• Experience in performance tuning and cost optimization.
• Prior mentoring or technical leadership experience.

What We're Looking For :

• Strong analytical and problem-solving skills.
• Excellent communication and stakeholder management abilities.
• Ability to work independently in a fast-paced environment.
• Passion for building scalable, reliable, and high-quality analytics solutions.

This Is NOT a Typical Java Role If your experience is mostly CRUD APIs, controller wiring, or shallow service layers — this role is not for you. We are looking for a top tier backend engineer who thrives on: 

* Designing complex algorithms 

* Building high-performance, memory-efficient systems 

* Owning deep backend logic that actually moves the needle 

You will work close to the core engine of the product, not the edges.

What You’ll Be Trusted With 

* Architect and build backend systems that must perform under load 

* Design and implement custom algorithms for real-world, non-trivial problems 

* Solve performance bottlenecks involving CPU, memory, I/O, and concurrency 

* Build backend services where latency, throughput, and correctness matter 

* Own document & PDF processing pipelines end-to-end:     

-Composition     

-Rendering     

-Optimization     

- High-volume generation 

* Make hard technical decisions and stand by them

Non-Negotiable Skills 

* Exceptional Java expertise (Core Java, Spring Boot, Java 8+) 

* Strong command over:     

• Data structures & algorithms 
• Multithreading & concurrency models     
• JVM internals & memory management 

* Proven experience building custom algorithms (this will be evaluated) 

* Deep backend engineering experience with Spring / Spring Boot 

* Strong understanding of:     

• API design principles     
• Fault tolerance & resilience     
•  Performance tuning & profiling 

* Ability to reason about time complexity, space complexity, and trade-offs 

* Strong database fundamentals (query optimization, indexing, transactions) 

* Experience with message brokers (ActiveMQ, Kafka, RabbitMQ) 

* Exposure to Kubernetes-based deployments or large-scale microservices 

Interview Focus (Be Prepared) 

* Algorithm design & problem solving 

* Deep Java fundamentals 

* System design discussions (backend-heavy) 

* Performance tuning scenarios 

* Real-world debugging and optimization challenges