Vba Analyst

Qnity Electronics, Inc.; Hyderabad; Hybrid; INR 900,000 - 1,500,000; Full time

Job summary

Qnity Electronics, Inc. in Hyderabad is seeking a Data Analyst/Developer to build automated data solutions, dashboards, and Excel-based analytics. The role requires collaborating with cross-functional teams to translate data needs into actionable insights.

You will work with VBA, Power Query, Power BI, and Python to optimize data workflows, develop scalable models, and deliver timely reports that empower business decisions across the organization.

Qualifications

• Bachelor's degree in CS/DS/Statistics/Math or related field.
• At least 6 years of experience in a data-related role.
• Strong analytical and problem-solving skills with attention to detail.
• Excellent communication and collaboration skills.

Responsibilities

• Develop and maintain VBA applications to automate tasks.
• Use Power Query for ETL and data modeling in Excel.
• Create interactive Power BI dashboards and reports.
• Develop Python scripts for data manipulation and automation.

Skills

VBA programming

Power Query

Power BI

Python

Education

Bachelor's degree in CS/DS/Statistics/Math

Tools

SAP scripting

Excel automation

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, were 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. Learn how you can start or jumpstart your career with us.

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.

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

Location: Hyderabad (WFO)

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.