Data Analyst Finance (VBA, Power Query, Power BI, Python) 4+ years of experience)

At DuPont, our purpose is to empower the world with essential innovations to thrive. We work on things that matter. Whether it’s providing clean water to more than a billion people on the planet, producing materials that are essential in everyday technology devices from smartphones to electric vehicles, or protecting workers around the world. Discover the many reasons the world’s most talented people are choosing to work at DuPont. Why Join Us | DuPont Careers

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!

On May 22, 2024, we announced a plan to separate our Electronics and Water businesses in a tax-free manner to its shareholders. On January 15, 2025, we announced that we are targeting November 1, 2025, for the completion of the intended separation of the Electronics business (the “Intended Electronics Separation”)*. We also announced that we would retain the Water business. We are committed to ensuring a smooth and successful separation process for the Future Electronics business. We look forward to welcoming new talent interested in contributing to the continued success and growth of our evolving organization.

(1)The separation transactions are subject to satisfaction of customary conditions, including final approval by DuPont's Board of Directors, receipt of tax opinion from counsel, the filing and effectiveness of Form 10 registration statements with the U.S. Securities and Exchange Commission, applicable regulatory approvals, and satisfactory completion of financing.  For further discussion of risks, uncertainties and assumptions that could impact the achievement, expected timing and intended benefits of the separation transactions, see DuPont’s announcement.

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

DuPont offers a comprehensive pay and benefits package. To learn more visit the Compensation and Benefits page.