Business Analyst 1

Position Overview and Responsibilities

The role involves daily activities such as extracting transactional data from relational databases using intermediate-level SQL queries. Candidates will import substantial query results directly into Microsoft Excel for in-depth analysis. They are responsible for summarizing complex operational metrics through Excel Pivot Tables and Power Query tools. Additionally, they will create clear visual charts and dashboards to present historical performance trends. The role requires translating detailed data into concise business insights and reports that are accessible to non-technical team members.

Mandatory Qualifications and Skills

• Proficient in SQL at an intermediate level to retrieve and manipulate data.
• Advanced knowledge of Microsoft Excel, specifically with formulas and creating Pivot Tables.
• Experience with tools such as DBeaver or Oracle SQL Developer is needed for database interaction.

Education and Other Requirements

• A bachelor's degree or an equivalent level of professional experience is required.

Disqualifications

• Applicants lacking experience with SQL and Microsoft Excel will not be considered suitable.