Data Analysis
2.29K subscribers
39 photos
41 files
224 links
I will provide you with the latest jobs related to the data and tech industry.
Free content, pdf , career counselling, 1:1 career
Guidance . Everything will be free
Download Telegram
#Hiring for #BusinessAnalyst

Job Posting Start Date: 10 Jan 2025
Location: Gurgaon, HR, IN
Company: InterGlobe Aviation Ltd

Department: Digital
Base Location Gurgaon
Work Mode: On-site
Travel required: No



Required Skills And Qualifications:

Six or more years of experience in analytics and systems development
High proficiency with SQL, Tableau, Power BI and database management
Proven analytical abilities
Experience in generating process documentation and reports
Excellent communication skills, with an ability to translate data into actionable insights
Prior Aviation experience is recommended



Apply Link : https://jobs.goindigo.in/job/Gurgaon-Business-Analyst-HR/34385844
Wave Infratech is hiring for Data analyst - Excel
Job description
Key Responsibilities:


1. Data Analysis and Reporting:
Utilize professional Excel skills to analyze and prepare detailed reports, dashboards, and insights for management decision-making.

2. Project Management:-
Work on new projects and initiatives, from ideation to execution, ensuring timely delivery and alignment with business goals.

3. Technology Adoption:
Stay updated with the latest technologies and industry trends, and drive the adoption of new tools and platforms within the organization.
Provide support in implementing and optimizing billing engines and other operational software.

4. Innovation and Idea Generation:
Proactively contribute new ideas and strategies to improve business processes, enhance customer experience, and drive revenue growth.
Conduct feasibility studies and market research to assess the viability of new business ideas.

Preferred Attributes:
Strong analytical and critical-thinking skills.
Ability to manage multiple projects and priorities simultaneously.
Creative thinking and an entrepreneurial spirit to contribute to business growth


Company Websites:- www.thewavegroup.com


Kindly mail Resume at (pankaj.kumar@waveinfratech.com)
๐Ÿ‘3โค1
We're Hiring: Senior Executive - E-Commerce! ๐Ÿ›’๐Ÿ“ˆ

๐Ÿ”น Role: Senior Executive - E-Commerce
๐Ÿ“ Location: Gurgaon
๐Ÿ’ผ Experience: 2+ years

What Youโ€™ll Do:
Manage cataloging & product listings across major e-commerce platforms
Maintain & update product masters with support from Brand Managers
Handle new product listings and ensure seamless execution
Optimize E-content (Base Content, KVs, A+ Content) for maximum impact
Collaborate with designers to create engaging customer experiences

Share your CV on aarti.rana@adglobal360.com
โค2
must know these formula in #excel
๐Ÿ‘3โค2
SSTX is hiring
Job Title: MIS Executive
Location: Noida Sector 132
Experience: 3+ Years
Employment Type: Full-Time

share the resume at -
ashish.singh@sstx.in
rohit.k@sstx.in
๐Ÿš€ TransOrg Analytics is hiring ! ๐Ÿ“Šโœจ

Join the dynamic team in Gurgaon for exciting opportunities in data and analytics:

๐Ÿ”น Analyst (2-3 Years)

๐Ÿ”น Data Scientist (3-5 Years)

๐Ÿ”น Lead Data Scientist (6-9 Years)


send your profile to varnika.chauhan@transorg.com.
๐Ÿ‘2
๐Ÿš€ MongoDB is Hiring โ€“ Senior Business Systems Analyst

Req ID - 1263096719

Gurugram, Haryana, India ๐ŸŒŸ


Join team at MongoDB as we redefine CRM excellence!
This role can be based in our Gurgaon office or remotely across India.
๐Ÿ“Œ What Youโ€™ll Do:
โœ… Be a Salesforce expert (Sales Cloud, Forecasting, Deal Management)
โœ… Analyze user journeys & optimize processes
โœ… Build scalable, cross-functional solutions
โœ… Collaborate with teams like Sales, Finance & more
๐ŸŽฏ What Weโ€™re Looking For:
๐Ÿ’ป Expertise in Salesforce configuration (flows, automation, reports)
๐Ÿ” Strong analytical and problem-solving skills
โšก Agile mindset with a focus on continuous improvement

๐Ÿ“ง Interested?
https://www.mongodb.com/careers/jobs/6707614
๐Ÿ‘1
SQL Query Execution: Understanding the Order for Efficient Queries*

SQL queries are the backbone of data analysis, and understanding their execution order is crucial for optimizing performance and ensuring accurate results.

Hereโ€™s a detailed breakdown of the 7-Step Execution Process and some valuable tips for optimization:

---

1. FROM/JOIN: Selecting Data Sources

The first step in executing a SQL query is to identify the data sources. This involves specifying the tables from which to retrieve data and defining any joins required to combine these tables. Joins allow you to merge rows from two or more tables based on a related column between them.

Example:
sql
SELECT *
FROM customers
JOIN orders ON customers.customer_id = orders.customer_id;

---

2. WHERE: Filtering Rows

After selecting the data sources, the next step is to apply filters using the WHERE clause. This clause allows you to specify conditions that must be met for a row to be included in the results.

Example:
sql
SELECT *
FROM customers
WHERE country = 'USA';

---

3. GROUP BY: Grouping Data

The GROUP BY clause is used to group rows that have the same values in one or more columns. This is typically used in conjunction with aggregate functions like SUM, AVG, and COUNT.

Example:
sql
SELECT department, AVG(salary) AS average_salary
FROM employees
GROUP BY department;

---

4. HAVING: Filtering Grouped Data

After grouping data, you can use the HAVING clause to filter these groups based on conditions. Unlike WHERE, which filters individual rows, HAVING filters groups of rows.

Example:
sql
SELECT department, AVG(salary) AS average_salary
FROM employees
GROUP BY department
HAVING AVG(salary) > 50000;

---

5. SELECT: Retrieving Desired Columns

The SELECT clause specifies which columns to include in the output. It can also include calculations or aggregate functions.

Example:
sql
SELECT name, email, SUM(purchase_amount) AS total_spent
FROM customers
JOIN orders ON customers.customer_id = orders.customer_id
GROUP BY name, email;

---

6. ORDER BY: Sorting Results

Once the data is selected, you can sort it using the ORDER BY clause. This allows you to arrange rows in ascending or descending order based on one or more columns.

Example:
sql
SELECT *
FROM employees
ORDER BY salary DESC;

---

7. LIMIT: Restricting Output

Finally, the LIMIT clause is used to restrict the number of rows returned in the result set. This is particularly useful for retrieving a subset of data for testing or previewing purposes.

Example:
SELECT *
FROM employees
ORDER BY salary DESC
LIMIT 10;


---

Common Pitfalls to Avoid

1. Relying on DISTINCT for Data Cleaning: While DISTINCT can remove duplicate rows, it should not be used as a primary method for data cleaning. Instead, focus on addressing the root causes of data duplication.

2. Using ORDER BY in Subqueries: This can lead to inefficient queries. Instead, apply ORDER BY to the outer query.

3. Unnecessary SELECT \*: Avoid selecting all columns unless necessary. Specify only the columns you need to reduce data transfer and improve performance.

4. Not Leveraging Table Statistics: Regularly update table statistics to ensure the query optimizer has accurate information for choosing the best execution plan.

5. Ignoring Execution Plans: Always review execution plans to identify bottlenecks and optimize queries accordingly.

---

### Pro Tips for Optimization

1. Always Check Execution Plans: Use tools like EXPLAIN to analyze how your queries are executed and identify potential bottlenecks.

2. Use Appropriate Indexes: Indexes can significantly speed up query execution by allowing the database to quickly locate specific data.

3. Leverage Partitioning: If available, partitioning can improve query performance by reducing the amount of data that needs to be scanned.

4. Monitor Query Performance Metrics: Keep an eye on metrics like execution time, CPU usage, and memory consumption to identify areas for improvement.

5. **Use CTEs for Better
๐Ÿ‘1
Readability:** Common Table Expressions (CTEs) can simplify complex queries and improve readability.

---

### Optimization Checklist

- Are JOINs Optimized? Ensure that joins are correctly optimized to reduce unnecessary data scans.
- Is the WHERE Clause Selective? Use indexes to make the WHERE clause more efficient.
- Are Indexes Being Used? Regularly check if indexes are being utilized effectively.
- Is GROUP BY Necessary? Avoid unnecessary grouping to reduce computational overhead.
- Can HAVING Conditions Move to WHERE? If possible, move conditions to the WHERE clause for better performance.

---

### Learning Resources

For those looking to enhance their SQL skills, here are some valuable resources:

- DataLemur Tutorials: Offers interactive SQL challenges and interview prep materials.
- Ankit Bansalโ€™s YouTube Channel: Provides SQL interview questions and solutions.

By mastering the order of SQL query execution and applying these optimization strategies, you can significantly improve your data analysis skills and write more efficient queries. Letโ€™s discussโ€”how do you optimize your SQL queries? ๐Ÿ’ฌ

#SQL #DataAnalytics #QueryOptimization #BigData #InterviewPreparation #DataEngineering
๐Ÿš€Beacon Funding is hiring: Senior Data Analyst (#Remote, India) ๐ŸŒŸ

Join the team and make an impact with your data expertise!

This is a work-from-home opportunity with a shift from 2 PM to 11 PM IST.

๐Ÿ“Œ What Youโ€™ll Do:

โœ… Identify, clean, and combine data to solve business problems

โœ… Build impactful Tableau dashboards and reports ๐Ÿ“Š

โœ… Collaborate with Sales, Executive teams, and more ๐Ÿค

โœ… Develop predictive models using machine learning algorithms ๐Ÿค–

โœ… Optimize workflows and support ETL processes

๐Ÿ“ˆ What Weโ€™re Looking For:

๐Ÿ”น 5-8+ years of experience in data analysis (SQL proficiency required)

๐Ÿ”น Strong Tableau skills for dashboard building and visualization

๐Ÿ”น Knowledge of machine learning algorithms & ETL tools like ADF

๐Ÿ”น Bachelorโ€™s degree in MIS, Mathematics, Statistics, or related field

๐Ÿ’ผ Benefits:

โœจ Competitive salary: โ‚น17-20 LPA

โœจ Group Mediclaim & Parental Insurance Coverage ๐Ÿฅ

โœจ Retirement Benefits (PF & Gratuity) ๐Ÿ’ฐ

โœจ Paid Vacation, Holidays, Overtime Bonus & Profit Sharing ๐ŸŒด


๐Ÿ“ง Apply Now: https://job-boards.greenhouse.io/beaconfunding/jobs/4619158007?gh_src=37385c2d7us
Letโ€™s shape the future of data analytics together! ๐Ÿš€
#Hiring #SeniorDataAnalyst #Tableau #SQL #RemoteWork #DataAnalytics #CareerGrowth
๐Ÿ‘4
Wipro is hiring for Analyst

Role- Analyst HR

Desired Candidate Profile:-
Should be flexible working in Shifts.
Experience- Fresher's / 0 to 1 Yr. Exp (Max)
Qualification- MBA/M.com/B.com/BBA.
Location- Gurgaon (Work from Office Only)

Candidates comfortable with US shifts, can send their CV's to

varsha.kamalapurkar@wipro.com
๐Ÿ‘3๐Ÿ‘Ž1
๐Ÿš€ Zepto is Hiring Product #Analysts for Our Shopping Experience Team! ๐Ÿ›’


What Youโ€™ll Do:
๐Ÿ”น Analyze data to drive reporting and product decisions
๐Ÿ”น Conduct user and competitive research
๐Ÿ”น Run experiments and collaborate closely with engineering and design teams on high-impact projects
What Weโ€™re Looking For:
โœ… Minimum 2+ years as a Product Analyst
โœ… Experience with scaled B2C products (start-up pace is a plus!)
โœ… Strong problem-solving and customer-first mindset
โœ… Data-savvy, detail-oriented, proactive, and collaborative

Apply now:

https://docs.google.com/forms/d/e/1FAIpQLScTwhUSdp225MTRp16UtFyd8CR1SuQeJ7pJjlBfTHysdktW9w/viewform
Blinkit! ๐Ÿ“ฆ is hiring

Looking for Program Managers and Associate Program Managers to join our fast-paced, high-impact team.

looking for:
๐Ÿ”น Minimum 2 years of experience
๐Ÿ”น Strong analytical skills โ€“ Excel & SQL proficiency a must
๐Ÿ”น Comfortable managing multiple KPIs & cross-functional teams
๐Ÿ”น Execution-first mindset with operational rigour
๐Ÿ”น Consulting background (Big 3) is a plus
๐Ÿ”น MBA/Masters not mandatory
๐Ÿ”น Ready to join within 30 days

๐Ÿ“ Location: Blinkit HQ, Gurugram
๐Ÿ“… Apply by: 27th April 2025

Apply here: https://docs.google.com/forms/d/e/1FAIpQLScV6d7Hn4-Fcq5AIa7efhsL56Wf4836CimzJCfUbBXph1XiGw/viewform
๐Ÿš€ Hiring: Power BI Developer (Remote, India) ๐Ÿ“Š

Looking For:
๐Ÿ”น 3+ years of hands-on experience in Power BI development
๐Ÿ”น Strong skills in DAX, data modeling, and report/dashboard creation
๐Ÿ”น Power BI certification (mandatory)
๐Ÿ”น Excellent communication & collaboration skills
๐Ÿ”น Full-time availability, work from home

What Youโ€™ll Do:
โœจ Design, develop, and maintain Power BI reports and dashboards
โœจ Analyze business requirements and translate them into technical solutions
โœจ Collaborate with cross-functional teams to deliver data-driven insights

๐Ÿ“ Location: Remote (India)
๐Ÿ•’ Experience: 3+ Years
๐Ÿ“Œ Employment Type: Full-time

Interested candidates, please share your resume at ๐Ÿ“ฉ Jenifer@kovantech.com
2 Data Analysts to Join Growing Team at sunlife !

Must-have skills:

Strong in Stakeholder Management

Proficiency in Tableau, SQL, Excel, ETL

Solid experience in Data Analysis


Good-to-have:

Familiarity with Snowflake, Salesforce, Productivity Models and Forecasting


You'll get the opportunity to work on impactful projects, drive real business value, and grow in a collaborative environment.

Location: Gurugram (Hybrid 2 days WFO)
Experience level: 5-7 years

please send in your CV to diksha.mahna@sunlife.com
๐Ÿ‘3
๐Ÿš€ Ready to Transform Your Career from Non-Tech to Data Analytics? ๐Ÿš€

Are you working in BPO, sales, calling, or any target-based job, earning around 3 LPA, working 6 days a week, and struggling to get proper time off?

If you feel stuck and want to break into a better, high-growth careerโ€”this is for you!

โœจ Iโ€™m hosting a FREE 1-hour Masterclass on Data Analytics designed specifically for non-tech professionals and freshers who have ZERO experience in analytics or tech.
Why am I doing this? Because I made the same switchโ€”from a non-tech background to a successful career in analyticsโ€”and I know exactly how to guide you!

What youโ€™ll learn:
๐Ÿ”น How to start your journey in analytics (no coding background needed!)
๐Ÿ”น Step-by-step roadmap: Start with MIS(Excel), move to Power BI & SQL, then level up with Python
๐Ÿ”น How to land your first analytics jobโ€”even if youโ€™re currently jobless
๐Ÿ”น Live Q&A: Ask me anything about career transitions, skills, interviews, and more!

If you love working with data and want a career with better pay, growth, and work-life balance, this session is for you!
Iโ€™ll share practical tips, resources, and my personal experience to help you get started. Many attendees have landed jobs within a month after following this path!

Trust me, if you have non-technical experience, you won't be considered a fresher in analytics.

It's better to be average in a very large organization than to be stuck without growth in a small one. Even if you don't become a top data analyst, you'll still be significantly ahead of your current situation. An average analyst is far superior to a top non-technical employee.

FIll the form to book you place , only few people will be part of this session .
https://docs.google.com/forms/d/e/1FAIpQLSffjP0E5HkxkSuOQWLBtr1gnUyNj1_ZlNgaciU5Kp_MN8rL6w/viewform?usp=header
๐Ÿš€ Exciting Opportunity! ๐Ÿš€

Spectral Consultant is Hiring DataAnalyst
๐Ÿ“ Location: Gurgaon | ๐Ÿ’ผ Work Mode: Hybrid

Looking for talented GRADUATES ONLY

๐Ÿ“Œ What We're Looking For:
โœ”๏ธ 2+ years of experience in data analysis, statistical modeling, and data mining (e-commerce preferred)
โœ”๏ธ Strong in #SQL, #Python, Excel; familiarity with R is a plus!
โœ”๏ธ Hands-on with #ABTesting, #PredictiveModeling, and optimization experiments ๐Ÿงช
โœ”๏ธ Collaborative, organized, and skilled in project management ๐Ÿค
โœ”๏ธ Bonus points: Knowledge of finance/accounting, Git, and agile tools (Jira, Confluence, Miro) โœจ

Send your CV or referral to: rachel@spectral.in
Jigsaw is Hiring!

Role:Business Analyst (Healthcare Analytics) ๐Ÿšจ
๐Ÿ“ Location: Delhi
๐Ÿ’ผ Stipend: Up to โ‚น6Lpa
๐Ÿ•˜ Monโ€“Sat, 9 AMโ€“6 PM
๐Ÿ“… Role: 6-month Management Trainee (probation) โ†’ Full-time Business Analyst based on performance
Apply now, drop your CV's at dipti@jigsawinc.in
Data Analysis pinned ยซ๐Ÿš€ Ready to Transform Your Career from Non-Tech to Data Analytics? ๐Ÿš€ Are you working in BPO, sales, calling, or any target-based job, earning around 3 LPA, working 6 days a week, and struggling to get proper time off? If you feel stuck and want to breakโ€ฆยป
๐Ÿš€ AGL - Hakuhodo is hiring a Power BI Developer! ๐Ÿš€

๐Ÿ”น Experience: 2โ€“4 years
๐Ÿ”น Industry: FMCG (preferred)
๐Ÿ”น Salary: Up to โ‚น8 LPA
๐Ÿ”น Location: Gurugram

What weโ€™re looking for:
- Strong expertise in Power BI (DAX, data modelling, dashboarding)
- Hands-on experience with Excel
- SQL skills are a plus


- Candidates with solid project experience will be get back.
share your cv & your project for hearing back from HR
saurabh.mishra@adglobal360.com
โค2