Junior Analyst-1

The Solenis interview process typically starts with a timed online aptitude test covering logical reasoning, quantitative aptitude, and verbal ability. Successful candidates move to a technical interview where they are evaluated on SQL query writing, Snowflake concepts, Power BI dashboard creation, and data modeling fundamentals. The final HR round assesses cultural fit, communication skills, and career aspirations. Candidates report a moderate difficulty level and recommend practising real‑world data scenarios.

Solenis promotes a collaborative and inclusive work culture where innovation is encouraged and employee growth is a priority. The company offers flexible hybrid work arrangements, regular skill‑upgradation programs, and a focus on work‑life balance through on‑site amenities and supportive policies.

Graduates (B.Tech/B.E., B.Sc., B.Com, BBA) in Computer Science, Information Technology, Electronics, Data Science or related streams. Minimum 60% aggregate or CGPA 6.5/10. Freshers from 2023‑2025 batches are preferred. No active backlogs at the time of joining. Strong analytical mindset and proficiency in SQL, Power BI, and Snowflake are essential.

Round 1: Online Aptitude Test (Logical Reasoning, Quantitative, Verbal) → Round 2: Technical Interview (SQL, Snowflake, Power BI, Data Concepts) → Round 3: HR Interview (fitment, cultural alignment)

Solenis is a global leader in water and hygiene solutions, offering a comprehensive portfolio that spans water‑treatment chemicals, process aids, functional additives, cleaners, disinfectants, and advanced monitoring and control systems. Headquartered in Wilmington, Delaware, the company operates 78 manufacturing facilities across more than 160 countries and employs over 23,000 professionals worldwide. Recognised as a 2025 Best Managed Company Gold Standard honoree, Solenis combines deep industry expertise with a strong focus on sustainability, helping customers improve operational efficiency, product quality, asset protection, and environmental stewardship. The Global Excellence Centre (GEC) in Hyderabad serves as a strategic hub that supports Solenis’ worldwide operations across IT, analytics, finance, and other critical business functions. Situated in the heart of India’s IT corridor, the GEC provides a vibrant work environment equipped with world‑class infrastructure such as an on‑campus gym, recreation zones, creche services, and excellent public‑transport connectivity. Employees benefit from a culture that encourages continuous learning, cross‑functional collaboration, and rapid career progression within a stable, yet fast‑growing organisation. **Role Summary** As a Junior Analyst‑1, you will be part of the Business Intelligence team, responsible for turning raw data into actionable insights that drive strategic decisions across Solenis’ global business units. You will design, develop, and maintain interactive Power BI dashboards, craft complex SQL queries, and work closely with Snowflake to model and manage cloud‑based data warehouses. The role demands a blend of technical acumen, analytical thinking, and strong communication skills to translate business requirements into robust data solutions. **Key Responsibilities** 1. Design, develop, and maintain interactive Power BI dashboards and reports for various business stakeholders. 2. Write complex, optimized SQL queries (CTEs, joins, sub‑queries) to extract, transform, and analyse data. 3. Model, query, and manage Snowflake cloud data warehouses, ensuring efficient storage and retrieval. 4. Build and maintain ETL/ELT pipelines to integrate data from multiple sources. 5. Collaborate with business users to understand reporting needs and translate them into technical specifications. 6. Ensure data accuracy, consistency, and governance across all reports and dashboards. 7. Automate data refresh schedules and monitor pipeline health. 8. Perform root‑cause analysis on data discrepancies and implement corrective actions. 9. Document data definitions, processes, and technical specifications for knowledge sharing. 10. Stay updated with emerging BI tools and best practices to continuously improve reporting capabilities. **Tech Stack**: SQL (advanced), Snowflake, Power BI (DAX), ETL tools, Azure/AWS cloud services, Git for version control. **Growth Path**: Starting as a Junior Analyst, you can progress to Analyst, Senior Analyst, BI Lead, and eventually to Managerial roles overseeing analytics strategy for the entire enterprise. **Why Join Solenis?** The company offers competitive compensation, a clear career ladder, exposure to global projects, and a supportive environment that values innovation and sustainability. Joining Solenis means working on real‑world problems that impact water safety and environmental health worldwide, while enjoying a balanced work‑life culture and ample learning opportunities.