Business Analyst

1. **Data Integration & Analysis**
- Gather, consolidate, and analyze financial data from structured databases via csv or excel.
- Combine various data sources (including manually captured data), using Microsoft Power Query and Excel to create meaningful, actionable reports and visualizations.
- Work closely with cross-functional teams (Finance, Sales, Operations) to understand current and future business needs.
2. **Dashboard Creation & Management**
- Develop intuitive, real-time dashboards for the General Manager and executive team to monitor business health.
- Implement metrics and KPIs to measure supply (consultant availability) vs. demand (sales pipeline and project requirements).
- Monitor and report on variance between forecasted capacity and actual utilization.
3. **Forecasting & Capacity Planning**
- Collaborate with the Sales team, Operations and Finance to align consultant availability with upcoming project demands.
- Create forecasting models to anticipate staffing needs, project delays, and resource constraints.
- Recommend strategies to optimize resource utilization and address potential capacity shortfalls to meet financial targets.
4.** Process Automation**
- Identify opportunities to automate repetitive tasks and streamline data flows using Microsoft Power Platform (Power Automate, Power Apps) and SharePoint.
- Design, build, and maintain automation solutions that enhance the efficiency and reliability of data management and reporting.
5. **Documentation & Training**
- Document existing and new processes, ensuring knowledge transfer and consistency in data handling.
- Train end-users and stakeholders on newly implemented dashboards, reports, and automated workflows.
- Provide ongoing support to ensure smooth adoption of tools and processes.
6. **Continuous Improvement**
- Continuously assess the effectiveness of existing tools, processes, and reporting structures.
- Propose and implement enhancements based on best practices, industry standards, and evolving business needs.
- Stay current on relevant software, technologies, and trends in data analytics and automation.
**Qualifications & Requirements**
- **Education & Experience**
Bachelor's degree in business administration, Finance, Computer Science, or a related field (or equivalent work experience).
Minimum 3 years of experience in a Business Analyst or related role, preferably in consulting, professional services, or IT industries.
- **Technical Skills**
Proficiency in Microsoft Power Platform (Power BI, Power Automate, Power Apps) and Microsoft Tools, such as SharePoint, Lists, OneDriver and Teams.
Advanced Excel skills (PivotTables, Power Query, etc.) and familiarity with SQL or other data querying languages.
- **Analytical & Communication Skills**
Proven ability to interpret complex data sets, identify trends, and provide actionable insights.
Excellent problem-solving skills with a keen attention to detail.
Strong communication and presentation skills to effectively interface with stakeholders at all levels.
Ability to work cross-functionally and build relationships across diverse teams (Finance, Sales, Operations, HR, etc.).
- ** Soft Skills**
Self-starter with the ability to manage multiple projects and deadlines.
Agile mindset with a willingness to pivot quickly when business needs change. Strong organizational and time-management skills.
Team player with a proactive attitude and eagerness to learn.
**Why Join Us?**
- Opportunity to play a pivotal role in shaping the company’s data-driven strategy.
- Collaborative, inclusive work environment with a focus on professional growth.
- Competitive compensation and benefits package.

---