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: Bachelor’s degree in computer science, Data Science, Statistics, Mathematics, or a related field. A minimum of 4 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) is a plus. Knowledge of machine learning principles is an advantage. Understanding of data warehousing concepts and methodologies. Join our Talent Community to stay connected with us! Qnity is an equal opportunity employer. Qualified applicants will be considered without regard to race, color, religion, creed, sex, sexual orientation, gender identity, marital status, national origin, age, veteran status, disability or any other protected class. If you need a reasonable accommodation to search or apply for a position, please visit our Accessibility Page for Contact Information. Qnity offers a comprehensive pay and benefits package. To learn more visit the Compensation and Benefits page.
INTRODUCTION: Qnity partners with customers at the cutting edge of technology to enable breakthroughs across AI, advanced computing, and advanced connectivity between and within next-generation devices. From groundbreaking solutions for semiconductor chip manufacturing, to enabling high-speed transmission within complex electronic systems, our high-performance materials and integration expertise make tomorrows technologies possible. WHY JOIN US Our purpose is to empower the world with essential innovations to thrive. We work on things that matter! Get to know our Purpose and make it yours by bringing innovations to market that improve the world, share a commitment to sustainability that makes our planet better and give back to communities in which we work and live. Get to Experience a collaborative environment where teamwork is celebrated with flexibility that enhances balance and an inclusive atmosphere that is welcoming to all! Have the opportunity to chart your own course, challenge yourself, and acquire new capabilities to build a rewarding and fulfilling career. We reward employees with competitive pay and incentives to recognize skills, competencies, and contributions to business results. ROLE DEFINITION: We are looking for new resources for Plant Cost Analyst team within Financial Shared Service Center (FSSC) at Hyderabad location. This will support our strategy of centering plant cost accounting and providing standard financial service to business partners. RESPONSIBILITIES DESCRIPTION: Your key responsibilities will be: • Provide monthly transaction inputs to close process orders. • Responsible for the monthly closing of plant ledgers • Building and validating total product cost by SKU, developing cost standards, participating in the standards cost revaluation process and effectively linking this information to the outlook and PO processes. • Works with various accounting and reporting systems, such as SAP, BI and Business Warehouse to accomplish tasks and must be able to manipulate and organize data for effective presentation. • Analyzes data and translates into meaningful information. Provides management and financial statement users with relevant, comparable, and accurate data for decision making. • Provides support to Operations, including cost analysis, inventory control, product unit cost reporting, identification and tracking of cost savings initiatives and financial reporting for special projects. • Responding to questions on Operations spending, product cost, period expense and proper cost/capital investment project accounting. • Participates on projects and team initiatives that improve the manufacturing cost accounting practices and procedures. • Adheres to internal control policies and procedures. JOB QUALIFICATIONS Semi or Fully Qualified CMA • Bachelors Degree - preferred in Accounting / Auditing / Finance / Economics / Business • Domestic accounting education (bachelor) with well-known Finance & Economics college • 3~5 years cost accounting or general ledger accounting experience in manufacturing environment, preferred in foreign invested companies. • Good language skill in English, both speaking and writing. • Knowledgeable of Costing, Variance Analysis and Management Reporting, Budgeting. • Expertise in SAP and Excel preferred. • Regular communication, collaboration, and engagement with all members of the plant and peers • Self-motivated, proactive, and able to take pressure. • Must be able to operate within a team environment. • Should be comfortable to work in 2:00 PM to 11:00 PM IST shift and evening shift during month end closing for 3-4 days. • Should be comfortable to work in Hybrid work environment (3 days from office, 2 days remote). Qnity is an equal opportunity employer. Qualified applicants will be considered without regard to race, color, religion, creed, sex, sexual orientation, gender identity, marital status, national origin, age, veteran status, disability or any other protected class. If you need a reasonable accommodation to search or apply for a position, please visit our Accessibility Page for Contact Information.