Product Analyst

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

1. Minimum 2.5 years of experience as a Python Developer.
2. Minimum 2.5 years of experience in any framework like Django/Flask/Fast API
3. Minimum 2.5 years of experience in SQL/ Postgress
4. Minimum 2.5 years of experience in Git/Gitlab/Bit-Bucket
5. Minimum 2+ years of experience in deployment (CICD with Jenkins)
6. Minimum 2.5 years of experience in any cloud like AWS/GCP/Azure

• Design, build web crawlers to scrape data and URLs.
• Integrate the data crawled and scraped into our databases
• Create more/better ways to crawl relevant information
• Strong knowledge of web technologies (HTML, CSS, Javascript, XPath, Regex)
• Understanding of data privacy policies (esp. GDPR) and personally identifiable information
• Develop automated and reusable routines for extracting information from various data sources
• Prepare requirement summary and re-confirm with Operation team
• Translate business requirements into specific solutions
• Ability to relay technical information to non-technical users
• Demonstrate Effective problem solving and analytical skill
• Ability to pay attention to detail, pro-active, critical thinking and accuracy is essential
• Ability to work to deadlines and give realistic estimates

Skills & Expertise

• 2+ years of web scraping experience

• Experience with two or more of the following web scraping frameworks and tools: Selenium, Scrapy, Import.io, Webhose.io, ScrapingHub, ParseHub, Phantombuster, Octoparse, Puppeter, etc.
• Basic knowledge of data engineering (database ingestion, ETL, etc.) 
• Solution orientation and "can do" attitude - with a desire to tackle complex problems.

• Experience implementing large-scale ETL processes using Informatica PowerCenter.
• Design high-level ETL process and data flow from the source system to target databases.
• Strong experience with Oracle databases and strong SQL.
• Develop & unit test Informatica ETL processes for optimal performance utilizing best practices.
• Performance tune Informatica ETL mappings and report queries.
• Develop database objects like Stored Procedures, Functions, Packages, and Triggers using SQL and PL/SQL.
• Hands-on Experience in Unix.
• Experience in Informatica Cloud (IICS).
• Work with appropriate leads and review high-level ETL design, source to target data mapping document, and be the point of contact for any ETL-related questions.
• Good understanding of project life cycle, especially tasks within the ETL phase.
• Ability to work independently and multi-task to meet critical deadlines in a rapidly changing environment.
• Excellent communication and presentation skills.
• Effectively worked on the Onsite and Offshore work model.