Junior Data Intelligence Analyst (Power Query & VBA)

US Tech Solutions - New York, NY

Full-time - Entry Level

New York, NY

Administrative and Support Services

About the position

The Junior Data Intelligence Analyst will support the finance team by conducting data and financial analysis, utilizing advanced Excel functions, and collaborating with cross-functional teams. This role is designed for individuals eager to leverage data analytics tools, including Power Query and VBA, to drive business decisions and contribute to the financial success of the organization.

Responsibilities

• Conduct basic data and financial analysis to support business decisions.
• Utilize Excel for data manipulation, analysis, and reporting.
• Assist in the development and maintenance of financial models.
• Collaborate with cross-functional teams to gather and analyze data.
• Prepare and present findings to stakeholders in a clear and concise manner.
• Support ad-hoc analysis and reporting requests.

Requirements

• Proficiency in Excel, including advanced functions and data analysis tools such as Power Query and VBA.
• Strong analytical and problem-solving skills.
• Excellent communication and presentation skills.
• Ability to work independently and as part of a team.
• Attention to detail, motivation, and exceptional work ethic.

Nice-to-haves

• Experience with programming languages such as Python or R.
• Familiarity with Business Intelligence (BI) platforms (e.g., Power BI, Tableau).
• Understanding of database architecture concepts.
• Previous experience in a finance or data analysis role.