Sr. Data Analyst

Roles and Responsibilities
● Research and develop advanced statistical and machine learning models for
analysis of large-scale, high-dimensional data.
● Dig deeper into data, understand characteristics of data, evaluate alternate
models and validate hypothesis through theoretical and empirical approaches.
● Productize proven or working models into production quality code.
● Collaborate with product management, marketing and engineering teams in
Business Units to elicit & understand their requirements & challenges and
develop potential solutions
● Stay current with latest research and technology ideas; share knowledge by
clearly articulating results and ideas to key decision makers.
● File patents for innovative solutions that add to company's IP portfolio

Requirements
● 4 to 6 years of strong experience in data mining, machine learning and
statistical analysis.
● BS/MS/PhD in Computer Science, Statistics, Applied Math, or related areas
from Premier institutes (only IITs / IISc / BITS / Top NITs or top US university
should apply)
● Experience in productizing models to code in a fast-paced start-up
environment.
● Expertise in Python programming language and fluency in analytical tools
such as Matlab, R, Weka etc.
● Strong intuition for data and Keen aptitude on large scale data analysis

● Strong communication and collaboration skills.

In this role, you will be part of a growing, global team of data engineers, who collaborate in DevOps mode, in order to enable Merck business with state-of-the-art technology to leverage data as an asset and to take better informed decisions.

The Merck Data Engineering Team is responsible for designing, developing, testing, and supporting automated end-to-end data pipelines and applications on Merck’s data management and global analytics platform (Palantir Foundry, Hadoop, AWS and other components).

The Foundry platform comprises multiple different technology stacks, which are hosted on Amazon Web Services (AWS) infrastructure or on-premise Merck’s own data centers. Developing pipelines and applications on Foundry requires:

• Proficiency in SQL / Java / Python (Python required; all 3 not necessary)
• Proficiency in PySpark for distributed computation
• Familiarity with Postgres and ElasticSearch
• Familiarity with HTML, CSS, and JavaScript and basic design/visual competency
• Familiarity with common databases (e.g. JDBC, mySQL, Microsoft SQL). Not all types required

This position will be project based and may work across multiple smaller projects or a single large project utilizing an agile project methodology.

Roles & Responsibilities:
• Develop data pipelines by ingesting various data sources – structured and un-structured – into Palantir Foundry
• Participate in end to end project lifecycle, from requirements analysis to go-live and operations of an application
• Acts as business analyst for developing requirements for Foundry pipelines
• Review code developed by other data engineers and check against platform-specific standards, cross-cutting concerns, coding and configuration standards and functional specification of the pipeline
• Document technical work in a professional and transparent way. Create high quality technical documentation
• Work out the best possible balance between technical feasibility and business requirements (the latter can be quite strict)
• Deploy applications on Foundry platform infrastructure with clearly defined checks
• Implementation of changes and bug fixes via Merck's change management framework and according to system engineering practices (additional training will be provided)
• DevOps project setup following Agile principles (e.g. Scrum)
• Besides working on projects, act as third level support for critical applications; analyze and resolve complex incidents/problems. Debug problems across a full stack of Foundry and code based on Python, Pyspark, and Java
• Work closely with business users, data scientists/analysts to design physical data models

About us

1. Innoviti (http://www.innoviti.com/">innoviti.com) is India’s largest provider of payment solutions to Enterprise merchants. 
2. Processing $10 Bn of payments from 2000 cities. We today have 76% of Enterprise market share. 
3. Enterprises such as Reliance, Landmark Group, Shoppers Stop, Pantaloons, Hamleys, Van Heusen, Louise Phillipe, Madura Garments and several other hundreds of Enterprises are our customers.
4. Our vision is to use technology to unlock the hidden value in payments, helping large and small businesses constantly find new and unique ways to grow faster with lesser efforts.
5. We believe payment transactions are more than money moving pipes.  Whenever a payment happens, it is not only the merchant who makes money, but also the brand whose product was sold and the bank whose payment instrument was used.  A merchant, brand, and bank talk to the same consumer, however there is no easy way for them to talk to each other.  Our technology makes this collaboration happen, and makes it happen at the point of payment. We help them share customers and share marketing budgets, in turn targeting customers better than possible otherwise. By making it happen at the point of payment we ensure for each party that their marketing efforts are translating into sales.
6. Today our technology has helped large businesses grow faster with lesser efforts.  They have been able to offer EMI, BNPL, Cashbacks, Loyalty Point redemption and other offers with merchants, brands and banks participating in it.  Every day new use cases are designed and stitched using our technology platform.
7. Our next target are small merchants.  For them, the problems are far larger and more complex.  They have no means to access the marketing budgets or customers of large brands or banks.  They cannot even cross the regional offices of these businesses.  This is where we come in.  We are bringing the power of the technology created for large merchants to these businesses.  Helping bring the power of large brands and banks with whom we already partner to small merchants.
8. Innoviti’s first target category in this segment is small merchants selling electronic goods – mobiles, durables, laptops etc.  They are struggling the most as their customers find attractive offers online through partner brands and banks, which they can’t match in their stores.  These businesses offer the advantage of touch, feel and explanation in local language.  What they lack is the technology to discover, access customers and attract them with superior offers.
9. GENIE, our smart marketing platform helps them do that.  It is a mobile app that integrates with bank and brands on one end and Google and Facebook on the other.  It not only helps them discover and access customers searching for these products online, but also attract them to their stores with offers better than online.
10. The app was launched in July 2021 and has shown a 100% month-on-month growth, with more than 23% of the merchant’s monthly sales now happening through it.  
11. In the next 5 years Innoviti wants to scale up its GTV from $10Bn to $30Bn, multiplying its revenue 10X.  
12. We want to be recognized in this space as the company that transformed the payments industry by showing ways of extracting value from payment transactions better than anyone else.  We want to be setting the path for the next generation of payment solutions, that will be followed by others.
13. Towards this we need to hire aggressive talented individuals, who firmly believe that no problem is unsolvable.  That there is always a way to solve the toughest of problems.  Those who get excited by solving such tough problems at scale, and seeing the impact of that around them in the market.  Those who feel fulfilled when they see that it is making a difference to the lives of people around them.

 

To drive this roadmap the company is looking for talent who are ready to do what no payments platform has done before and what every payment platform will do thereafter.

 

Would you like to join this journey?

 

 

 

 

 

 

 

Job description:

 

Designation:  Database Administrator

 

Location:  Bangalore

 

Responsibilities

• Provision MySQL instances, both in clustered and non-clustered configurations
• Ensure performance, security, and availability of databases
• Prepare documentations and specifications
• Handle common database procedures, such as upgrade, backup, recovery, migration, etc.
• Profile server resource usage, optimize and tweak as necessary
• Collaborate with other team members and stakeholders

Skills and Qualification:

• Graduate degree in Computer Science, Computer Engineering, or related technical discipline from Tier-1 Institutes

• 4-6 years of proven experience in Database Administration
• Decent experience with recent versions of MySQL
• Understanding of MySQL’s underlying storage engines, such as InnoDB and MyISAM
• Experience with replication configuration in MySQL
• Knowledge of de-facto standards and best practices in MySQL
• Proficient in writing and optimizing SQL statements
• Knowledge of MySQL features, such as its event scheduler
• Ability to plan resource requirements from high level specifications
• Familiarity with other SQL/NoSQL databases such as PostgreSQL, MongoDB, etc. 
• Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases

Personality:

The ideal person for this role would be someone who loves the challenge of an entrepreneurial environment, who has high ownership to be available 24x7 for our customers, who is able to deal with complexity and rapid change and who has large dreams to be part of interesting journey.

 

The person would be self-driven, results-oriented with a positive outlook and impeccable integrity. He/she would have a track record of delivering results consistently in uncertain environments. Excellent communication skills with an ability to manage crucial conversations with senior stakeholders.

 

Retail industry demands “I’ll do it now instead of tomorrow” attitude. Please be prepared for interesting journey if you want to grow fast with no age barriers.

 

Required Skills & Experience:
• 2+ years of experience in data engineering & strong understanding of data engineering principles using big data technologies
• Excellent programming skills in Python is mandatory
• Expertise in relational databases (MSSQL/MySQL/Postgres) and expertise in SQL. Exposure to NoSQL such as Cassandra. MongoDB will be a plus.
• Exposure to deploying ETL pipelines such as AirFlow, Docker containers & Lambda functions
• Experience in AWS loud services such as AWS CLI, Glue, Kinesis etc
• Experience using Tableau for data visualization is a plus
• Ability to demonstrate a portfolio of projects (GitHub, papers, etc.) is a plus
• Motivated, can-do attitude and desire to make a change is a must
• Excellent communication skills

Job Description

 

Experience: 3+ yrs

We are looking for a MySQL DBA who will be responsible for ensuring the performance, availability, and security of clusters of MySQL instances. You will also be responsible for design of database, database architecture, orchestrating upgrades, backups, and provisioning of database instances. You will also work in tandem with the other teams, preparing documentations and specifications as required.

 

Responsibilities:

Database design and data architecture

Provision MySQL instances, both in clustered and non-clustered configurations

Ensure performance, security, and availability of databases

Prepare documentations and specifications

Handle common database procedures, such as upgrade, backup, recovery, migration, etc.

Profile server resource usage, optimize and tweak as necessary

 

Skills and Qualifications:

Proven expertise in database design and data architecture for large scale systems

Strong proficiency in MySQL database management

Decent experience with recent versions of MySQL

Understanding of MySQL's underlying storage engines, such as InnoDB and MyISAM

Experience with replication configuration in MySQL

Knowledge of de-facto standards and best practices in MySQL

Proficient in writing and optimizing SQL statements

Knowledge of MySQL features, such as its event scheduler

Ability to plan resource requirements from high level specifications

Familiarity with other SQL/NoSQL databases such as Cassandra, MongoDB, etc.

Knowledge of limitations in MySQL and their workarounds in contrast to other popular relational databases

We are looking for a Senior Data Analyst who will support our product, sales, leadership, and marketing teams with data collection and organization of data in order to draw conclusions, make predictions, and drive informed decision making.

• The ideal candidate is adept at using large data sets to find opportunities for product and marketing optimization and using data models to test the effectiveness of different courses of action.
• Not just that, you also understand how to clean and organize data for complete analysis and calculations using spreadsheets, SQL Python, and R programming.
• Visualizing and presenting data findings in dashboards, presentations and commonly used visualization platforms must be your strength.

SKILLS YOU MUST HAVE:

• Data Cleansing, Data Analysis, Data Visualization (DataViz), SQL Questioning, Decision-Making, Problem Solving, Data Collection, Data Ethics, Sample Size Determination, Spreadsheet,

RESPONSIBILITIES:

• Work with stakeholders throughout the organization to identify opportunities for leveraging company data to drive business solutions.
• Mine and analyze data from company databases (GOOGLE ANALYTICS, User DB, and 3rd party Marketing Analytics tools) to drive optimization and improvement of product development, marketing techniques, and business strategies.
• Assess the effectiveness and accuracy of new data sources and data gathering techniques.
• Strong understanding of Google Analytics (GA) fundamentals and how to work with raw GA data
• Automate custom data fetching from Google Analytics dashboard to excel sheet and other primary and secondary sources
• Work with complex SQL queries
• Work with Big Query with GA integration to extract data
• Preparing final analysis reports for the stakeholders to understand the data-analysis steps, enabling them to take important decisions based on various facts and trends.
• Filter Data by reviewing reports and performance indicators to identify and correct code problems
• Developing and maintaining databases, data systems reorganizing data in a readable format
• Using statistical tools to identify, analyze, and interpret patterns and trends in complex data sets could be helpful for the diagnosis and prediction
• Assign a numerical value to essential business functions so that business performance can be assessed and compared over periods of time.
• Use predictive modeling to increase and optimize customer experiences, revenue generation, ad targeting, and other business outcomes.
• Develop company A/B testing framework and test model quality.
• Coordinate with different functional teams to implement models and monitor outcomes.
• Develop processes and tools to monitor and analyze model performance and data accuracy.
• Understanding of statistical concepts like Statistical significance, t-test, and z-test for AB testing
• Performing analysis to assess quality and meaning of data
• Preparing reports for the management stating trends, patterns, and predictions using relevant data
• Working with programmers, engineers, and management heads to identify process improvement opportunities, propose system modifications, and devise data governance strategies.
• Robust understanding of Mix panel and Amplitude

Skill requirement:

• 6-8 years of experience in database management and a strong understanding of Google Analytics
• Strong mathematical skills to help collect, measure, organize, and analyze data
• Experience using statistical computer languages (R, Python, MATLAB, SQL, etc.) to manipulate data and draw insights from large data sets.
• Experience analyzing data from 3rd party providers: Google Analytics, Site Catalyst, Coremetrics, Adwords, Crimson Hexagon, Facebook Insights, etc.
• Technical proficiency regarding database design development, data models, techniques for data mining, and segmentation.
• Knowledge of a variety of machine learning techniques (clustering, decision tree learning, artificial neural networks, etc.) and their real-world advantages/drawbacks.
• Knowledge of advanced statistical techniques and concepts (regression, properties of distributions, statistical tests, and proper usage, etc.) and experience with applications.
• Knowledge of data visualization software like Tableau
• Knowledge of how to create and apply the most accurate algorithms to datasets in order to find solutions
• Accuracy and attention to detail
• Adept at queries, advanced excel management, writing reports, and making presentations
• Team-working skills
• Verbal and Written communication skills
• Proven working experience in data analysis

 

Job Role : Associate Manager (Database Development)

Key Responsibilities:

• Optimizing performances of many stored procedures, SQL queries to deliver big amounts of data under a few seconds.
• Designing and developing numerous complex queries, views, functions, and stored procedures
• to work seamlessly with the Application/Development team’s data needs.
• Responsible for providing solutions to all data related needs to support existing and new
• applications.
• Creating scalable structures to cater to large user bases and manage high workloads
• Responsible in every step from the beginning stages of the projects from requirement gathering to implementation and maintenance.
• Developing custom stored procedures and packages to support new enhancement needs.
• Working with multiple teams to design, develop and deliver early warning systems.
• Reviewing query performance and optimizing code
• Writing queries used for front-end applications
• Designing and coding database tables to store the application data
• Data modelling to visualize database structure
• Working with application developers to create optimized queries
• Maintaining database performance by troubleshooting problems.
• Accomplishing platform upgrades and improvements by supervising system programming.
• Securing database by developing policies, procedures, and controls.
• Designing and managing deep statistical systems.

Desired Skills and Experience  :

• 7+ years of experience in database development
• Minimum 4+ years of experience in PostgreSQL is a must
• Experience and in-depth knowledge in PL/SQL
• Ability to come up with multiple possible ways of solving a problem and deciding on the most optimal approach for implementation that suits the work case the most
• Have knowledge of Database Administration and have the ability and experience of using the CLI tools for administration
• Experience in Big Data technologies is an added advantage
• Secondary platforms: MS SQL 2005/2008, Oracle, MySQL
• Ability to take ownership of tasks and flexibility to work individually or in team
• Ability to communicate with teams and clients across time zones and global regions
• Good communication and self-motivated
• Should have the ability to work under pressure
• Knowledge of NoSQL and Cloud Architecture will be an advantage

• Excellent working knowledge on Data Warehousing /Data Migration activity using an ETL tool.
• Strong Data Integration, PostgreSQL/Oracle Database skills, Shell Scripting, Python programming, and development know-how.
• Hands-on experience in working with and generating XML documents.
• Good analytical and business process understanding capability.
• Familiarized with Data Models, Source-Target Data Mapping, Transactional, and Master Data concepts.
• Well-experienced in High level/Detailed design, Performance tuning of ETL jobs.
• Very good communication skills, interpersonal skills, stakeholder management skills, self-motivated, quick learner, team player.
• Exposure to After Sales Business Domain is highly preferred.
• Experience using HP ALM, Jira for ticketing.
• Experience release management

 

Data Engineer: Pluto7 is a services and solutions company focused on building ML, Ai, Analytics, solutions to accelerate business transformation. We are a Premier Google Cloud Partner, servicing Retail, Manufacturing, Healthcare, and Hi-Tech industries.We’re seeking passionate people to work with us to change the way data is captured, accessed and processed, to make data driven insightful decisions. Must have skills : Hands-on experience in database systems (Structured and Unstructured). Programming in Python, R, SAS. Overall knowledge and exposure on how to architect solutions in cloud platforms like GCP, AWS, Microsoft Azure. Develop and maintain scalable data pipelines, with a focus on writing clean, fault-tolerant code. Hands-on experience in data model design, developing BigQuery/SQL (any variant) stored. Optimize data structures for efficient querying of those systems. Collaborate with internal and external data sources to ensure integrations are accurate, scalable and maintainable. Collaborate with business intelligence/analytics teams on data mart optimizations, query tuning and database design. Execute proof of concepts to assess strategic opportunities and future data extraction and integration capabilities. Must have at least 2 years of experience in building applications, solutions and products based on analytics. Data extraction, Data cleansing and transformation. Strong knowledge on REST APIs, Http Server, MVC architecture. Knowledge on continuous integration/continuous deployment. Preferred but not required: Machine learning and Deep learning experience Certification on any cloud platform is preferred. Experience of data migration from On-Prem to Cloud environment. Exceptional analytical, quantitative, problem-solving, and critical thinking skills Excellent verbal and written communication skills Work Location: Bangalore