KASHII UPDATEZ Everyday Student Requirements & Python Coding Tutorials by Python Kashi
JD #4161
Applications open Internship

Data Analyst

Zenix Solutions

  • Remote
  • 4 LPA
  • Fresher (0-1 Yrs)
  • Posted Today
HR
Recruiter contact
Recruiter / hiring contact
No public email in this post. Use a source-linked contact instead.

About the role

Zenix Solutions is a fast‑growing technology and consulting firm headquartered in Bengaluru, India, with a presence across major Indian metros. The company specializes in delivering end‑to‑end digital transformation services to clients in finance, retail, healthcare, and logistics. Over the past few years, Zenix has built a reputation for leveraging cutting‑edge analytics, cloud platforms, and automation to solve complex business problems, earning multiple industry awards for innovation and client satisfaction.

The work culture emphasizes continuous learning, collaborative problem‑solving, and a strong focus on delivering measurable business impact.

As a Data Analyst at Zenix Solutions, you will be at the heart of the decision‑making engine for both internal teams and external clients. The role involves turning raw, heterogeneous data into clear, actionable insights that drive strategic initiatives. You will work closely with business stakeholders to understand reporting needs, extract and cleanse data from multiple sources, and build interactive visualizations that tell a compelling story.

Your analyses will directly influence product road‑maps, marketing strategies, and operational efficiencies, making you a key contributor to the company’s success.

Key Responsibilities

  • Collect, organize, validate, and process data from multiple internal and external sources to ensure high data quality.
  • Design and develop interactive dashboards, visual reports, and performance summaries using Power BI, Tableau, and advanced Excel functionalities.
  • Perform exploratory data analysis to uncover trends, patterns, and business opportunities.
  • Collaborate with cross‑functional teams and clients to define analytical objectives and reporting requirements.
  • Translate complex analytical findings into clear, non‑technical narratives for senior leadership and client presentations.
  • Implement SQL queries and stored procedures to retrieve and manipulate large datasets efficiently.
  • Apply statistical techniques and basic predictive modeling to support data‑driven decision making.
  • Maintain documentation of data pipelines, reporting logic, and dashboard versioning.
  • Continuously monitor and improve existing reports for accuracy, performance, and relevance.
  • Stay updated with the latest data visualization trends and recommend tool enhancements.

Tech Stack: SQL, Microsoft Excel (including Power Query & Power Pivot), Power BI, Tableau, Python (pandas, matplotlib), basic statistical packages (R or Python’s statsmodels), Git for version control.

Growth Path: Starting as a Data Analyst, high performers can progress to Senior Analyst, Analytics Lead, and eventually to roles such as Data Scientist, Business Intelligence Manager, or Product Analytics Head, depending on skill development and business needs. Zenix offers structured mentorship, certification sponsorships, and exposure to multi‑industry projects to accelerate career growth.

Why Join Zenix Solutions? You will gain hands‑on experience with diverse clients and real‑world business problems, work in a collaborative environment that values innovation, and receive professional development support including industry‑recognized certifications. The flexible remote work policy, competitive health benefits, and a culture that encourages work‑life balance make Zenix an attractive place for fresh talent to launch a rewarding analytics career.

Eligibility & process

Who can apply

Graduates (B.Tech/B.E., B.Sc., B.Com, BBA) in Computer Science, Information Technology, Statistics, Mathematics, Economics or related fields; Minimum 60% aggregate (or CGPA 6.5/10); Batch 2025‑2027; No active backlogs at the time of joining; Strong analytical mindset and willingness to learn.

Skills & stack

SQL Microsoft Excel Power BI Tableau Data Visualization Statistical Analysis Business Acumen Python

Selection process

  1. Round 1: Aptitude & Logical Reasoning
  2. Round 2: Technical Interview (SQL, Excel, BI tools)
  3. Round 3: HR Interview (fit & culture)

Prep kit

20 resources
Study material 4
Company-specific guides 4
Likely coding questions 4
Round-wise strategy 4
Round 1: Online Assessment (OA) Aptitude, Quantitative Logic & 2 Coding Problems Focus on accuracy and speed. Practice arrays, strings, and standard arithmetic puzzles.
Round 2: Technical Interview 1 Core Tech Stack (SQL, Microsoft Excel, Power BI, Tableau, Data Visualization, Statistical Analysis, Business Acumen, Python) & Live Code Tracing Explain your thought process aloud. Analyze time & space complexities before coding.
Round 3: System Design & Problem Solving Database Schemas, APIs & Architecture Basics Clarify edge cases, diagram schemas cleanly, and discuss scalability trade-offs.
Round 4: HR & Cultural Fit Discussion Zenix Solutions Core Values, Learning Agility & Offer Terms Demonstrate passion, strong communication, and readiness for full-time collaboration.
Technical questions 5
What is the difference between WHERE and HAVING clauses in SQL? Answer
Model answer: WHERE filters rows before any groupings are applied, while HAVING filters aggregated groups after GROUP BY has executed.
Explain SQL Window functions: ROW_NUMBER(), RANK(), and DENSE_RANK(). Answer
Model answer: ROW_NUMBER() assigns unique sequential integers. RANK() assigns identical ranks to ties and skips ranks. DENSE_RANK() assigns identical ranks to ties without skipping rank numbers.
How do you handle NULL and missing values during data cleaning in Python/Pandas? Answer
Model answer: Use .isna().sum() to identify missing values. Impute with mean/median using .fillna() or remove with .dropna(subset=[...]) depending on variance impact.
What is the difference between Star Schema and Snowflake Schema in Data Warehousing? Answer
Model answer: Star Schema has denormalized dimension tables directly connected to the central Fact table. Snowflake Schema normalizes dimension tables into sub-dimensions to minimize redundancy.
How do you calculate MoM (Month-over-Month) growth in SQL? Answer
Model answer: Use LAG(revenue, 1) OVER (ORDER BY month) to fetch the previous month's revenue and compute (revenue - prev_revenue) / prev_revenue * 100.
Behavioural & HR questions 3
Why do you want to join Zenix Solutions as a Data Analyst?
Highlight Zenix Solutions's market reputation, recent tech innovations, and how your skills in SQL directly solve their team's objectives.
Describe a challenging bug or academic project roadblock and how you resolved it.
Use the STAR method: Situation (project context), Task (what needed solving), Action (specific tools/logic applied), Result (quantifiable positive outcome).
How do you handle strict deadlines or sudden scope changes?
Explain your prioritization strategy, proactive communication with mentors/peers, and agile mindset.
Zenix Solutions 4 LPA
Recruiter Resume Apply
Chat Chat with Kashii