Financial Data

**Job Summary**
Bluestar Professional Services Inc. is a family investment office that invests in small to medium sized Canadian businesses, taking controlling interests to maximize the value of their investments for all stakeholders, including employees, clients and investors.

**What You Will Do**

**Data Management**
- Research data management and data visualization best practices
- Develop and maintain automated reporting solutions using VBA, R, Python, and/or SQL.
- Document processes using Visio to ensure clarity and compliance across financial reporting activities.
- Design, develop and administer SQL Server databases
- Use ETL processes to transfer, cleanse, and assimilate data

**Report Creation**
- Create financial reports and ad hoc analyses
- Conduct in-depth analysis of financial data to identify trends, variances, discrepancies and opportunities for improvement.
- Collaborate with cross-functional teams to gather data and provide insights for business analysis.
- Utilize tools such as Tableau, Power BI, and Microsoft SQL Server to create visualizations / dashboards that support financial reporting.
- Write SQL queries to import data into Power BI and Excel
- Review reports to ensure accuracy
- **Collaboration**
- Share findings and solutions, ensuring clarity and understanding
- Work with leadership to answer business questions
- Work with other team members to solve problems and discuss improvements

**What you bring**:

- 1-2 years experience in financial analysis and/or data analytics
- Post Secondary Education or Undergraduate degree in business, finance, accounting, or data science
- Strong proficiency in data analysis skills with hands-on experience using SQL for querying databases.
- Familiarity with analytical tools such as Tableau, Power BI, R, Python, Oracle, and Bash (Unix shell).
- Strong business analysis capabilities with the ability to translate complex data into actionable insights.
- Detail-oriented mindset with exceptional analytical skills to identify discrepancies or issues within financial data.
- Ability to work collaboratively in a fast-paced environment while managing multiple priorities effectively.
- Strong communication skills and ability to build working relationships in a hybrid environment
- Ability to engage in effective communication and collaboration with various internal teams/stakeholders
- Ability to work autonomously to gather and analyze information, demonstrating a strong sense of ownership and accountability, but appreciate the benefits of being part of a team
- Advanced Microsoft Excel skills
- Ability to travel within the GTA as required

**What we can offer you**:

- Join our team as a Financial Reporting Analyst where your expertise will contribute to our success while providing you with opportunities for professional growth.
- A competitive compensation packages based on experience with vacation and benefits
- Flexible start and finish times with the possibility to periodically work from home after the probationary period
- Bluestar Professional Services Inc._ _adopts an inclusive and accessible environment, and we are committed to providing support to applicants and firm members with disabilities. If you require accommodation at any time during the recruitment, selection, and assessment process, please let us know._

Pay: From $65,000.00 per year

**Benefits**:

- Company events
- Dental care
- Disability insurance
- Extended health care
- Life insurance
- On-site parking
- Paid time off
- Vision care

Ability to commute/relocate:

- Mississauga, ON L4Z 1S1: reliably commute or plan to relocate before starting work (preferred)

**Education**:

- Bachelor's Degree (preferred)

**Experience**:

- financial analysis: 2 years (preferred)

Work Location: Hybrid remote in Mississauga, ON L4Z 1S1