Data Analyst/Developer (VBA, Power Query, Power BI, Python)

Qnity; Hyderabad; On-site; INR 900,000 - 1,500,000; Full time

Job summary

Qnity in Hyderabad invites a Data Analyst/Developer to design and implement automated data solutions, build comprehensive dashboards, and enhance Excel-based workflows. You will partner with cross-functional teams to translate complex data needs into clear, actionable insights for business success.

You will apply VBA, Power Query, Power BI and Python to automate processes, develop robust data models, and deliver high-quality analytics—enabling faster, smarter decisions across the organization.

Qualifications

• Bachelor's degree in CS, Data Science, Statistics, or related field.
• At least 6 years in a data-related role with the listed technologies.
• Strong analytical and problem-solving skills with attention to detail.
• Excellent communication and collaboration across diverse teams.

Responsibilities

• Develop and maintain VBA applications to automate repetitive Excel tasks.
• Create Power Query data ETL pipelines and data models.
• Build interactive Power BI dashboards and reports for stakeholders.
• Develop Python scripts using pandas/NumPy for data manipulation.

Skills

VBA

Power Query

Power BI

Python

Education

Bachelor's degree

Tools

SAP Scripting

Job description

Are you looking to power the next leap in the exciting world of advanced electronics? Do you want to help solve problems that drive success in the rapidly evolving technology and connectivity landscape? Then bring your problem-solving, passion, and creativity to help us power the next leap in electronics.

At Qnity, we’re more than a global leader in materials and solutions for advanced electronics and high-tech industries - we’re a tight-knit team that is motivated by new possibilities, and always up for a challenge. All our dedicated teams contribute to making cutting-edge technology possible. We value forward-thinking challengers, boundary-pushers, and diverse perspectives across all our departments, because we know we play a critical role in the world enabling faster progress for all. Learn how you can start or jumpstart your career with us.

Job Title: Data Analyst/Developer (VBA, Power Query, Power BI, Python)

Job Type: Full-time

Job Summary:

The Data Analyst/Developer will play a crucial role in developing automated data solutions, creating comprehensive dashboards, and utilizing advanced Excel functionalities. This position will require collaboration with various teams to translate data needs into actionable intelligence.

Key Areas of Expertise and Responsibilities:

1. Visual Basic for Applications (VBA)

• Responsibilities:
• Develop and maintain complex VBA applications to automate repetitive tasks.
• Incorporate SAP Scripting within VBA to optimize business processes.
• Troubleshoot and debug existing VBA code to ensure smooth functionality.
• Criteria:
• Advanced proficiency in VBA programming.
• Demonstrated experience with SAP interfaces and scripting.
• Ability to write modular, efficient, and maintainable code.
• Knowledge of Excel object model and its functionalities.

2. Power Query

• Responsibilities:
• Utilize Power Query for data extraction, transformation, and loading (ETL) processes.
• Develop and maintain data models in Excel to streamline data preparation.
• Create and optimize Power Query scripts for efficient data processing.
• Criteria:
• Intermediate experience with Power Query including M language for data transformation.
• Familiarity with connecting Power Query to various data sources (e.g., databases, APIs).
• Ability to perform data cleansing and manipulation through Power Query.

3. Power BI

• Responsibilities:
• Create interactive, user-friendly dashboards and reports using Power BI.
• Collaborate with stakeholders to gather reporting requirements and deliver insights.
• Optimize Power BI reports for performance and usability.
• Criteria:
• Intermediate knowledge of Power BI Desktop and Power BI Service.
• Ability to create DAX measures and calculated columns for enhanced analytics.
• Familiarity with data visualization best practices and techniques.

4. Python

• Responsibilities:
• Develop Python scripts to automate data manipulation and Excel-related tasks.
• Utilize libraries such as Pandas and NumPy for data analysis and automation.
• Collaborate with the data team to integrate Python solutions with existing tools.
• Criteria:
• Intermediate proficiency in Python, especially in data manipulation and automation.
• Experience with libraries like Pandas, NumPy, and openpyxl for Excel automation.
• Understanding of APIs and ability to retrieve data programmatically.

Qualifications:

• Minimum bachelor's degree in computer science, Data Science, Statistics, Mathematics, or a related field.
• A minimum of 6 of experience in a data-related role, focusing on the technologies mentioned.
• Strong analytical and problem-solving skills with attention to detail.
• Excellent communication skills and the ability to work collaboratively with diverse teams.

Preferred Skills:

• Experience with SQL and relational databases for data querying and data management.
• Familiarity with other business intelligence tools (like Tableau or QlikView) and ETL tools like Alteryx are a plus.
• Understanding of data warehousing concepts and methodologies.