Data Scientist

About Climate Connect Digital

Our team is inspired to change the world by making energy greener, and more affordable. Established in 2011 in London, UK, and now headquartered in Gurgaon, India. From unassuming beginnings, we have become a leading energy-AI software player, at the vanguard of accelerating the global energy transition.

In 2020,  we were acquired by ReNew Power, India’s largest renewables developer. Following ReNew’s NASDAQ listing in summer 2021, Climate Connect Digital has been newly formed as a fully independent subsidiary. With backing from ReNew for an ambitious and visionary new strategy, for rapid growth.

Our mission has technology at its core and involves unlocking value by leveraging information technology and AI/ML across the energy ecosystem. However, the world is still nascent in using such technologies in the energy sector to create massive value for all stakeholders.

How do you fit in 

As we start into our first strong growth phase, we are looking for a Data Engineer to build the data infrastructure to support business and product growth.

You are someone who can see projects through from beginning to end, coach others, and self-manage. We’re looking for an eager individual who can guide our data stack using AWS services with technical knowledge, communication skills, and real-world experience.

The data flowing through our platform directly contributes to decision-making by algorithms & all levels of leadership alike. If you’re passionate about building tools that enhance productivity, improve green energy, reduce waste, and improve work-life harmony for a large and rapidly growing finance user base, come join us!

Job Responsibilities:

• Iterate, build, and implement our data model, data warehousing, and data integration architecture using AWS & GCP services
• Build solutions that ingest data from source and partner systems into our data infrastructure, where the data is transformed, intelligently curated and made available for consumption by downstream operational and analytical processes
• Integrate data from source systems using common ETL tools or programming languages (e.g. Python, Scala, Node.js etc.)
• Develop tailor-made strategies, concepts and solutions for the efficient handling of our growing amounts of data
• Work iteratively with our data scientist to build up fact tables (e.g. container ship movements), dimension tables (e.g. weather data), ETL processes, and build the data catalog

Job Requirements:

• 4+ years of Experience designing, building and maintaining data architecture and warehousing using GCP/AWS services
• Authoritative in ETL optimization, designing, coding, and tuning big data processes using Apache Spark, R, Python, C# and/or similar technologies
• Experience managing GCP/AWS resources using Terraform
• Experience in Data engineering and infrastructure work for analytical and machine learning processes
• Experience with ETL tooling, and migrating ETL code from one technology to another will be a benefit
• Experience with Data visualization / dashboarding tools as QA/QC data processes
• Independent, self-starter who thrives in a fast pace environment

What’s in it for you

We offer competitive salaries based on prevailing market rates. In addition to your introductory package, you can expect to receive the following benefits:

• Remote-first work culture
• Flexible working hours and leave policy
• Learning and development opportunities
• Medical insurance/Term insurance, Gratuity benefits over and above the salaries

At Climate Connect, you get a rare opportunity to join an established company at the early stages of a significant and well-backed global growth push.

We are building a remote-first organisation ingrained in the team ethos. We understand its importance for the success of any next-generation technology company. The team includes passionate and self-driven people with unconventional backgrounds, and we’re seeking a similar spirit with the right potential.

What it’s like to work with us

You become part of a strong network and an accomplished legacy from leading technology and business schools worldwide when you join us. Such as the Indian Institute of Technology, Oxford University, University of Cambridge, University College London, and many more.

We don’t believe in constrained traditional hierarchies and instead work in flexible teams with the freedom to achieve successful business outcomes. We want more people who can thrive in a fast-paced, collaborative environment. Our comprehensive support system comprises a global network of advisors and experts, providing unparalleled opportunities for learning and growth. 

HIRING SQL Developers with max 20 days Of NOTICE PERIOD

Job ID: TNS2023DB01

Who Should apply?

• Only for Serious job seekers who are ready to work in night shift
• Technically Strong Candidates who are willing to take up challenging roles and want to raise their Career graph
• No DBAs & BI Developers, please

• Exposure to the latest technology
• Opportunity to work on different platforms
• Rapid Career Growth
• Friendly Knowledge-Sharing Environment

• BE/MTech/MCA/MSc
• 2yrs Hands Experience in MS SQL / NOSQL
• Immediate joiners preferred/ Maximum notice period between 15 to 20 days
• Candidates will be selected based on logical/technical and scenario-based testing
• Work time - 10:00 pm to 6:00 am

Note: Candidates who have attended the interview process with TnS in the last 6 months will not be eligible.

1. Technical Skills Desired:
   1. Experience in MS SQL Server, and one of these Relational DB’s, PostgreSQL / AWS Aurora DB / MySQL / any of NoSQL DBs (MongoDB / DynamoDB / DocumentDB) in an application development environment and eagerness to switch
   2. Design database tables, views, indexes
   3. Write functions and procedures for Middle Tier Development Team
   4. Work with any front-end developers in completing the database modules end to end (hands-on experience in the parsing of JSON & XML in Stored Procedures would be an added advantage).
   5. Query Optimization for performance improvement
   6. Design & develop SSIS Packages or any other Transformation tools for ETL

1. Functional Skills Desired:
   1. The banking / Insurance / Retail domain would be a
   2. Interaction with a client a

1. Knowledge in a Cloud Platform (AWS / Azure)
2. Knowledge on version control system (SVN / Git)
3. Exposure to Quality and Process Management
4. Knowledge in Agile Methodology

1. Soft skills: (additional)
   1. Team building (attitude to train, work along, and mentor juniors)
   2. Communication skills (all kinds)
   3. Quality consciousness
   4. Analytical acumen to all business requirements
   5. Think out-of-box for business solution

Job Description:

We are looking for a Big Data Engineer who have worked across the entire ETL stack. Someone who has ingested data in a batch and live stream format, transformed large volumes of daily and built Data-warehouse to store the transformed data and has integrated different visualization dashboards and applications with the data stores.    The primary focus will be on choosing optimal solutions to use for these purposes, then maintaining, implementing, and monitoring them.

Responsibilities:

• Develop, test, and implement data solutions based on functional / non-functional business requirements.
• You would be required to code in Scala and PySpark daily on Cloud as well as on-prem infrastructure
• Build Data Models to store the data in a most optimized manner
• Identify, design, and implement process improvements: automating manual processes, optimizing data delivery, re-designing infrastructure for greater scalability, etc.
• Implementing the ETL process and optimal data pipeline architecture
• Monitoring performance and advising any necessary infrastructure changes.
• Create data tools for analytics and data scientist team members that assist them in building and optimizing our product into an innovative industry leader.
• Work with data and analytics experts to strive for greater functionality in our data systems.
• Proactively identify potential production issues and recommend and implement solutions
• Must be able to write quality code and build secure, highly available systems.
• Create design documents that describe the functionality, capacity, architecture, and process.
• Review peer-codes and pipelines before deploying to Production for optimization issues and code standards

Skill Sets:

• Good understanding of optimal extraction, transformation, and loading of data from a wide variety of data sources using SQL and ‘big data’ technologies.
• Proficient understanding of distributed computing principles
• Experience in working with batch processing/ real-time systems using various open-source technologies like NoSQL, Spark, Pig, Hive, Apache Airflow.
• Implemented complex projects dealing with the considerable data size (PB).
• Optimization techniques (performance, scalability, monitoring, etc.)
• Experience with integration of data from multiple data sources
• Experience with NoSQL databases, such as HBase, Cassandra, MongoDB, etc.,
• Knowledge of various ETL techniques and frameworks, such as Flume
• Experience with various messaging systems, such as Kafka or RabbitMQ
• Creation of DAGs for data engineering
• Expert at Python /Scala programming, especially for data engineering/ ETL purposes

• Work with the application development team to implement database schema, data strategies, build data flows
• Should have expertise across the database. Responsible for gathering and analyzing data requirements and data flows to other systems
• Perform database modeling and SQL scripting

• 8+ years of experience in Database modeling and SQL scripting
• Experience in OLTP and OLAP database modeling
• Experience in Data modeling for Relational (PostgreSQL) and Non-relational Databases
• Strong scripting experience P-SQL (Views, Store procedures), Python, Spark.
• Develop notebooks & jobs using Python language
• Big Data stack: Spark, Hadoop, Sqoop, Pig, Hive, Hbase, Flume, Kafka, Storm
• Should have good understanding on Azure Cosmos DB, Azure DW

High Level Scope of Work :

• Work with AI / Analytics team to priorities MACHINE LEARNING Identified USE CASES for Development and Rollout
• Meet and understand current retail / Marketing Requirements and how AI/ML solution will address and automate the decision process.
• Develop AI/ML Programs using DATAIKU Solution & Python or open source tech with focus to deliver high Quality and accurate ML prediction Model
• Gather additional and external data sources to support the AI/ML Model as desired .
• Support the ML Model and FINE TUNEit to ensure high accuracy all the time.
• Example of use cases (Customer Segmentation , Product Recommendation, Price Optimization, Retail Customer Personalization Offers, Next Best Location for Business Est, CCTV Computer Vision, NLP and Voice Recognition Solutions)

Required technology expertise :

• Deep Knowledge & Understanding on MACHINE LEARNING ALGORITHMS (Supervised / Unsupervised Learning / Deep Learning Models)
• Hands on EXP for at least 5+ years with PYTHON and R STATISTICS PROGRAMMING Languages
• Strong Database Development knowledge using SQL and PL/SQL
• Must have EXP using Commercial Data Science Solution particularly DATAIKU and (Altryx, SAS, Azure ML, Google ML, Oracle ML is a plus)
• Strong hands on EXP with BIG DATA Solution Architecture and Optimization for AI/ML Workload.
• Data Analytics and BI Tools Hand on EXP particularly (Oracle OBIEE and Power BI)
• Have implemented and Developed at least 3 successful AI/ML Projects with tangible Business Outcomes In retail Focused Industry
• Have at least 5+ Years EXP in Retail Industry and Customer Focus Business.
• Ability to communicate with Business Owner & stakeholders to understand their current issues and provide MACHINE LEARNING Solution accordingly.

Qualifications

• Bachelor Degree or Master Degree in Data Science, Artificial Intelligent, Computer Science
• Certified as DATA SCIENTIST or MACHINE LEARNING Expert.