Presales Analyst

DATA ANALYST

About:

Role:

Requirements:

Location-MUMBAI

Kindly note that candidates who have graduated in 2022 and 2023 only will be considered for the role who are based in Mumbai, immediate joiners

JD - Data Operations Analyst

What is the job and team like

• As a Data Operations Analyst we manage business reporting of numerous teams, constantly monitor performance
• Checking the integrity of the revenue reporting done by the different systems for the correct profitability to be
• reported to the CXOs
• Send reports periodically and alert stakeholders for changes in the key performance metrics
• Allocate efforts to different Business Implementations that help build Profit/Loss statement for the Financials.
• Track crucial data points which affect the core of the business and escalate it to senior stakeholders

Roles and Responsibilities

• Graduate in IT Background(BE/BSc IT/ BCA) 2022 and 2023 graduates only
• Executing a set of business processes daily/weekly/monthly as per Business requirement.
• Provide ad-hoc data support on any urgent reports and material in an expedited manner
• Maintain a list of open tasks and escalations, and send updates to the relevant stakeholders
• Have an eye for detail, should have the ability to look at numbers, spot trends and identify gaps
• Identify efficient and meaningful ways to communicate data and analysis through ongoing reports and dashboards
• Proficiency in SQL, Excel and any statistical and analytical tools such as SAS, SPSS is a big plus
• Managing master data, including creation, updates, and deletion.
• Ability to work in a fast paced, technical, cross functional environment
• Familiarity with Internet Industry and Online Advertising Business is a plus

Ideal candidate

• Import and export large volume of data to database tables as required
• Should be able to write Data Definition Language or Data Manipulation Language SQL commands
• Develop programs, methodologies to get analyzable data on a regular basis
• Good team player and multi-tasker
• Should have the ability to learn and adapt to change
• Self-starter Must be productive with minimal direction
• High-level written and verbal communication sk

Job Details

Work mode- In office

Must have skills - SQL, MS Excel, Communications

Senior Database (PL/SQL)

Work Experience: 8+ Years

Number of Vacancies: 2

Location:

CTC: As per industry standards

Job Position: Oracle PLSQL Developer.

Required: Oracle Certified Database Developer

Key Skills:

• Must have basic knowledge in SQL Queries, Joins, DDL, DML, TCL, Types, Object, Collection Developer. Basic Oracle PLSQL programming experience (Procedures, packages, functions, exceptions.
• Develop, implement, and optimize stored procedures and functions using PLSQL
• Writing basic Queries, Package, Procedures, Functions, Triggers, Ref Cursors, Using Oracle 11g to 19c features, including triggers, stored procedures, queries, SQL Code, and design (stored procedures, functions, packages, tables, views, triggers, indexes, constraints, collections, bulk collects, etc..).
• Must have basic knowledge in PL/SQL Developer tool.
• Basic knowledge of MySql & Mongo DBA
• Strong communication skills
• Good interpersonal and teamwork skills
• PL/SQL, stored, procedure, functions, trigger
• Bulk Collection
• Utl_file
• Materilized View
• Performance handling
• Usage of Hint in Queries
• JSON (json object, json table, json queries)
• BLOB CLOB concept
• External table
• Dynamic SQL

Role and Responsibilities

• Build a low latency serving layer that powers DataWeave's Dashboards, Reports, and Analytics functionality
• Build robust RESTful APIs that serve data and insights to DataWeave and other products
• Design user interaction workflows on our products and integrating them with data APIs
• Help stabilize and scale our existing systems. Help design the next generation systems.
• Scale our back end data and analytics pipeline to handle increasingly large amounts of data.
• Work closely with the Head of Products and UX designers to understand the product vision and design philosophy
• Lead/be a part of all major tech decisions. Bring in best practices. Mentor younger team members and interns.
• Constantly think scale, think automation. Measure everything. Optimize proactively.
• Be a tech thought leader. Add passion and vibrance to the team. Push the envelope.

Skills and Requirements

• 8- 15 years of experience building and scaling APIs and web applications.
• Experience building and managing large scale data/analytics systems.
• Have a strong grasp of CS fundamentals and excellent problem solving abilities. Have a good understanding of software design principles and architectural best practices.
• Be passionate about writing code and have experience coding in multiple languages, including at least one scripting language, preferably Python.
• Be able to argue convincingly why feature X of language Y rocks/sucks, or why a certain design decision is right/wrong, and so on.
• Be a self-starter—someone who thrives in fast paced environments with minimal ‘management’.
• Have experience working with multiple storage and indexing technologies such as MySQL, Redis, MongoDB, Cassandra, Elastic.
• Good knowledge (including internals) of messaging systems such as Kafka and RabbitMQ.
• Use the command line like a pro. Be proficient in Git and other essential software development tools.
• Working knowledge of large-scale computational models such as MapReduce and Spark is a bonus.
• Exposure to one or more centralized logging, monitoring, and instrumentation tools, such as Kibana, Graylog, StatsD, Datadog etc.
• Working knowledge of building websites and apps. Good understanding of integration complexities and dependencies.
• Working knowledge linux server administration as well as the AWS ecosystem is desirable.
• It's a huge bonus if you have some personal projects (including open source contributions) that you work on during your spare time. Show off some of your projects you have hosted on GitHub.