Job Description

Hello Everyone!

Greetings from Kriya Nextwealth Private limited.

We're Hiring for the below position.

Position: Business Analyst

Company Profile: Kriya NextWealth Private Limited. ('KRIYA') is an impact sourcing service provider that bridges the gap between automation and manual work, providing solutions for some of the world's biggest e-commerce provider. Kriya was started in the year 2010, and saw steady growth, having delivered niche projects for international clients KRIYA currently has four delivery centers located in Chittoor (Andhra Pradesh), Vellore (Tamil Nadu),Mysuru, Bangalore & Hubli (Karnataka) with a workforce of more than 1600. Kriya operates in the areas of data preparation and pre-processing for AI/ML models, voice-based services, computer vision, and allied services.

Qualification:
Bachelor's or Master's degree in mathematics, Statistics, Computer Science, Economics, or related field Shift- 9am to 6pm with 2 days Weekends weekly off. Experience- 3yrs of Experience with relevant domain

Analytical Skills:

1. Understanding Business Questions:

Clarify objectives and determine what the business aims to achieve.

Ask specific, relevant questions to gather the necessary information.

Identify stakeholders and understand how they will use the information.

2. Data Identification:

Use lookup tables to find and categorize dimensions.

Determine appropriate data sources for analysis.

Ensure data relevance to align with business questions.

3. Data Analysis Process:

Define the problem and effectively articulate the business question.

Collect relevant data from various sources.

Clean and ensure the quality and integrity of the data.

Interpret results and provide actionable insights and recommendations.

4. Business Process Improvement:

Identify opportunities for process improvement through data analysis.

Implement solutions that streamline operations or enhance business outcomes based on analytical findings.

SQL Concepts:

• Metrics and Dimensions :

Identify and work with quantitative measurements.

Categorize data using qualitative attributes

• Table Relationships :

Understand and apply one-to-one, one-to-many, and many-to-many relationships in SQL.

Use junction tables to manage many-to-many relationships.

• Distinguishing Dimensions and Metrics in SQL Queries :

Utilize the WHERE clause to filter rows based on dimension values.

Apply the HAVING clause to filter groups based on aggregate metric values.

• In-built SQL Functions :

Posses working knowledge of in-built SQL functions

Ability to appropriately use the in-built SQL functions to achieve the desired result

5. SQL Interpreter and Query Interpretation :

Understand how the SQL interpreter processes queries: parsing, syntax check, optimization, and execution.

Steps to interpret a query:

Identify the tables involved.

Determine the joins between tables.

Understand the filter conditions in the WHERE and HAVING clauses.

Identify any aggregate functions and grouping.

Check for sorting and limiting clauses.

• Subqueries:

Create and utilize subqueries to perform complex data retrieval.

Understand the different types of subqueries: scalar, column, row, and table subqueries.

Integrate subqueries within SELECT, FROM, WHERE, and HAVING clauses to refine results.

Soft Skills:

Effective communication - both verbal and written skills - and presentation skills.

Ability to work independently and collaboratively in a fast-paced environment.

Experience:

3+ years of hands-on experience as a Business Analyst.

3+ years of hands-on experience in developing and executing SQL queries, query optimization, table indexing, multi-table joins and nested queries, good grasp of SWL data types, stored procedures

Location: Mysuru

No. 331-B, KIADB, Hebbal Industrial Estate, Layout, Mysuru, Karnataka 570018 Contact: Jerome D Pearl : 8667441743/9003878621

Job Types: Full-time, Permanent

Pay: From ?600,000.00 per year

Benefits:

• Health insurance
• Leave encashment
• Provident Fund

Schedule:

• Morning shift

Supplemental pay types:

• Overtime pay
• Yearly bonus

Education:

• Bachelor's (Preferred)