Data Analyst

Overview

Talentica Software is a boutique software development company started by industry veterans and ex- IITB grads. At Talentica, we help startups build products. We are techies at heart and thrive on using the latest tools and technologies to solve real-world problems. Owing to our unique space, we deal extensively with industry-defining technologies. Over the last 21 years, the company has worked with over 180+ startups, with most clients based in the US, ensuring many successful exits.

In 2022, Great Place to Work® recognized Talentica Software as India's Great Mid-Size Workplace.

What we're looking for?
We're seeking a passionate Data Analyst to join our team. If you live and breathe SQL, BigQuery, Tableau, and MongoDB, you might just be the perfect fit! We need someone who can manage and optimize our existing data ecosystem, focusing on SQL development for Oracle, BigQuery, and Tableau, alongside working with NoSQL databases like MongoDB. You’ll also contribute to Lakehouse development and will play a key role in ensuring data accuracy while supporting the scalability of our data infrastructure.

What you’ll be doing?
Develop, optimize, and maintain SQL queries for Tableau data sources, ensuring efficient and accurate data delivery.
Write and optimize complex queries for Oracle and BigQuery databases to support business reporting needs.
Work with MongoDB, querying semi-structured data for analytics and reporting purposes.
Collaborate with BI developers and analysts to enhance data processing efficiency and report accuracy.
Develop, maintain and enhance existing ETL/ELT pipelines, ensuring data is ingested, transformed, and delivered efficiently.
Collaborate with cross-functional teams to identify and implement improvements in data workflows
Provide support for troubleshooting and resolving data issues as they arise.
Participate in early development efforts related to Lakehouse architecture initiatives
Assist in preparing existing data workflows for integration with modern cloud-based data platforms.
Stay informed about emerging data technologies and contribute to modernization strategies.
Perform thorough data validation and reconciliation to ensure consistency across different data sources.
Identify and resolve discrepancies by working closely with data analysts and business stakeholders.
Support data quality assurance processes, implementing best practices to improve reliability.

To be successful in this role, you should have:
Qualification: BE/BTech in Computer Science, Data Engineering, or a related field from a top institute (like IIT, NIT, BITS, etc.).
Experience: 5+ years of experience working with SQL and managing data pipelines.

Tech skills:
Advanced SQL skills for query performance tuning and optimization.
Knowledge of ETL/ELT processes and experience optimizing data transformations.
Experience working with relational (Oracle, BigQuery) and NoSQL (MongoDB) databases.
Experience with Python or scripting for automation
Familiarity with cloud platforms such as AWS, GCP, and Azure.
Bonus points for hands-on experience with BI tools like Tableau!

Soft skills:
You should also have strong analytical & problem-solving abilities, excellent communication skills, and the ability to juggle multiple tasks independently in a fast-paced environment.
What you’ll find here?
A culture of innovation: A culture of innovation is at our core — we focus exclusively on cutting-edge development, not maintenance projects. Our strength lies in our technological expertise.
Endless learning opportunities: This is the place to grow. You’ll always have the chance to learn new things and stay on top of the latest trends.
Talented peers: Work alongside experienced graduates from India's top engineering colleges (IITs, NITs, and a few select others).
Work-life balance: We value your well-being and offer flexible schedules with remote work options.
A great culture: Our employees love working here! 82% recommend Talentica to their friends, according to Glassdoor.
Recognition & rewards: We don’t just work hard, we celebrate success. Your contributions won’t go unnoticed. We’ll make sure you're recognized for the amazing work you do.

Talentica is the place to be, if you’re excited about the opportunity to work with a team of talented professionals and take your career to the next level, we’d love to hear from you. Excited to take the next step? Fill in the lead form below and we’ll be in touch soon!