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

Overview

The Data Analyst/Developer will develop automated data solutions, create comprehensive dashboards, and use advanced Excel functionalities. The role involves collaborating with various teams to translate data needs into actionable intelligence.

What you'll do

• 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.
• 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.
• 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.
• 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.

What you'll need

• 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.
• 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.
• Intermediate experience with Power Query including M language for data transformation.
• Familiarity with connecting Power Query to various data sources, such as databases and APIs.
• Ability to perform data cleansing and manipulation through Power Query.
• 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.
• 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.
• Strong analytical and problem-solving skills with attention to detail.
• Excellent communication skills and the ability to work collaboratively with diverse teams.

Nice to have

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

Details

• Location: Hyderabad, Telangana.
• Work from office (WFO) in Hyderabad.
• Employment type: Full-time.