UST is hiring for a data-focused technical role in Pune, suitable for professionals with strong SQL, Python, Excel, data validation, and analytical problem-solving skills. The opportunity is particularly relevant to candidates interested in working with complex datasets, calculation models, automation, and utility or energy-related applications.
π Job Overview
- π’ Company: UST
- πΌ Role in hiring announcement: Data Analyst
- π Job ID: 64517
- π Location: Pune, India
- π― Experience: Announcement says 3β6 years; job portal says 3β5 years; detailed description contains differing requirements
- π οΈ Core Skills: SQL, Python, Microsoft Excel, Data Analysis, Data Validation, Data Processing and Debugging
- π Openings: 1, as stated in the supplied listing
- π Location Requirement: Candidates must be based in Pune, according to the hiring announcement
π’ About UST
UST is a global digital transformation and technology services company that works with organizations to develop software, modernize technology systems, and solve business challenges through engineering and digital solutions. For data and software professionals, UST opportunities can involve application development, data processing, automation, testing, and business-focused problem-solving. This particular job description emphasizes the accuracy of utility tariff calculations, reliable data handling, and improving processes through SQL and Python. The role appears more development-oriented than a conventional reporting-only Data Analyst position. Candidates should therefore review the full responsibilities carefully and determine whether the recruiter is hiring for the advertised Data Analyst position or the detailed Utility Tariff Developer role.
π Why Is This Role Good for Experienced Professionals?
- π Advanced SQL exposure: Work with joins, subqueries, aggregations, common table expressions (CTEs), relational databases, and large datasets.
- π Practical Python development: Build scripts for data processing, validation, automation, troubleshooting, and reducing manual effort.
- β‘ Specialized domain knowledge: Learn how utility rates, tariff models, and billing calculations work if assigned to the tariff-focused project.
- π Data-quality ownership: Investigate inconsistencies, validate input data, identify calculation mismatches, and improve reliability.
- π End-to-end development lifecycle: Participate in requirement analysis, implementation, testing, deployment, and production support.
- π€ Cross-functional collaboration: Work with developers, analysts, QA, product teams, and business stakeholders.
- π Career progression: Develop skills relevant to Data Analyst, SQL Developer, Python Developer, Data Engineer, or utility-domain software roles.
π οΈ Skills Required
- ποΈ SQL: Complex queries, joins, CTEs, subqueries, aggregations, data transformations, and troubleshooting.
- π Python: Scripting, data processing, automation, validation, debugging, and reusable program development.
- π Microsoft Excel: Formulas, pivot tables, data comparison, and analysis.
- 𧩠Relational databases and data modelling: Understand tables, relationships, data structures, and data integrity.
- π Data validation and debugging: Identify missing records, duplicate values, inconsistent inputs, and unexpected outputs.
- π Process automation: Reduce repetitive manual tasks and improve processing accuracy. Preferred additional skills
- β‘ Utility tariff, energy, rate calculation, and billing concepts.
- π Power Query, Excel macros, ETL, and data-processing workflows.
- π Shell scripting and Agile/Scrum practices.
- π Technical documentation, production support, and regression validation.
π― Expected Interview Rounds at UST
- π Round 1 β Recruiter screening: Discuss your experience, SQL/Python proficiency, Pune location, notice period, and interest in the position.
- π§ Round 2 β SQL technical assessment: Practise joins, CTEs, subqueries, window functions, aggregations, duplicate detection, and queries to identify mismatched records.
- π Round 3 β Python and data analysis: Prepare scripts for data cleaning, comparing datasets, validating records, handling exceptions, and automating repetitive tasks.
- π Round 4 β Excel and business scenarios: Review pivot tables, lookup functions, advanced formulas, and techniques for comparing large datasets.
- β‘ Round 5 β Domain and managerial discussion: For the tariff-focused role, expect possible questions about billing discrepancies, calculation logic, data quality, debugging, and working with business stakeholders. The actual process may differ depending on the hiring team and the final role being offered.
π° Expected Salary Range
The supplied listing does not mention an official salary band. As a broad, indicative estimate for Pune-based professionals, candidates may research approximately βΉ7β16 LPA for data analyst or SQL/Python-focused positions requiring relevant experience. More specialized development responsibilities or strong utility-domain expertise may affect compensation. This is not a confirmed UST salary range; the final offer depends on the actual role, experience criteria, interview performance, and company pay structure.
π Preparation Tips
- π Practise real SQL problems: Write queries to find duplicate bills, compare actual versus calculated amounts, identify missing records, and aggregate results by customer or billing period.
- π Build a Python validation script: Load two datasets, compare their records, flag mismatches, and generate a summary report. Be ready to explain your logic and exception handling.
- β‘ Understand tariff calculations: If applying for the detailed developer role, revise how rates, consumption, billing periods, and business rules can affect a final bill.
- π Strengthen Excel skills: Practise pivot tables, lookup formulas, conditional logic, and data comparison.
- π§ͺ Prepare a data-quality example: Explain a real problem you investigated, the root cause, the corrective action, and how you prevented recurrence.
- π Connect analysis to business impact: Describe how automation or a query improved accuracy, reduced manual effort, or shortened processing time.
π Resume Tips for This Opportunity
- β Put SQL, Python, Data Analysis, Data Validation, Excel, and Debugging prominently in your skills section.
- π Include measurable achievements, such as processing time reduced, records validated, manual effort saved, or data-quality improvementsβonly when supported by your actual work.
- 𧩠Describe projects where you analysed complex datasets, automated data checks, or resolved mismatches between expected and actual results.
- β‘ If you have energy, utility, tariff, or billing experience, explain the business workflow and your contribution clearly.
- π Mention Power Query, ETL, Excel macros, or production support only if you have relevant hands-on experience.
- π― Tailor your resume to the confirmed position: a Data Analyst resume should emphasize analysis and insights, while a Utility Tariff Developer resume should highlight SQL/Python development, calculation logic, debugging, and validation.
π¨ How to Apply
π Application Link: Click Here
π€ Referral Tip
Want to improve your chances of getting noticed?
Connect with someone at UST and request a referralβit can significantly enhance your visibility in the hiring process.
Interested candidates should search for UST Developer III β Software Engineering, Job ID 64517, through USTβs official careers portal or apply through the recruiter who shared the announcement. No application URL was included in the supplied details, so verify the role and eligibility before submitting your resume.
π Final Thoughts: This opening may be valuable for professionals who enjoy solving data problems through SQL, Python, and structured analysis. However, because the announcement and detailed job description contain different titles and experience requirements, confirm the exact role and required years of experience before applying.
