Business Systems Analyst

POSITION:         Business Systems Analyst
DIVISION:          Aquilini
DEPARTMENT:   Finance

REPORTS TO:     Director, Financial Reporting Systems
LOCATION:         Vancouver, BC

THE TEAM:
Aquilini Group (“AG”) is a diversified family business founded in Vancouver, BC more than 50 years ago with roots in the real estate development and construction industry. Today the company owns and manages an international real estate portfolio that includes commercial and residential properties, hotels, golf courses, vineyards and blueberry and cranberry farms. In addition to its ongoing pursuits in real estate development and construction, AG has expanded its holdings to include assets in the sports & entertainment, aquaculture, tourist attractions, restaurants, and food & beverage industries.

THE OPPORTUNITY:
APLP has an exciting opportunity for a Business Systems Analyst based in our downtown office in Vancouver. In this newly created role, the Analyst will report directly to the Director, Financial Reporting Systems and be part of the team responsible for the architecture, design, implementation, and continuous improvement of technology solutions. The Analyst will be hands-on in providing and delivering analysis, implementation, support, and integration of BI and financial applications. 

ESSENTIAL DUTIES AND RESPONSIBILITIES:
(other duties may be assigned, as required)

Application Support (build, support, monitor)

• Configures and sets up new modules and features
• Utilizes strong data analytics skills, including the ability to break down data models efficiently
• Manages data governance and data quality to ensure data integrity, cleaning, access, migration, refresh, and backup
• Manages incidents to quickly diagnose and resolve incoming bugs, troubleshoots and remediates issues in data code, processes, or sources
• Updates technical documentation
• Develops database queries and conducts analyses
• Performs mass exports, transformations, and uploads/updates of data
• Managing customizations including objects, fields, workflows, approval process, and validation rules
• Manages release deployments on production of new reports, dashboards, and features

Business Analysis

• Collects business requirements and translates them into technical specifications.
• Updates functional documentation and business flows
• Manages and builds reports and dashboards in conjunction with user input.

 
REQUIRED EXPERIENCE AND QUALIFICATIONS:

• Bachelor’s Degree in Computer Science, Data Science, MIS or related technical fields
• 2+ years on solutions an ERP solution and BI tool
• Must have 2+ years of experience with SSRS/PowerBI
• Experience with MS SQL Server / SQL Database is necessary
• Experience with any Sage 300 ERP is an asset
• Power Automate are an asset
• Proficiency with MS Office productivity tools such as Excel, Access, Power Pivot and Word are essential
• Proficiency with one or more .Net programming languages (Python, C#) and IDE tools such as Visutal Studio/Visual Code is necessary
• Able to collaborate fluently with cross-functional partners
• Is curious and continuously learn and develops oneself   
• Committed to quality and investing in results that add value to the business
• Has a sense of urgency and ability to prioritize an issue/request backlog
• Excellent troubleshooting, communication, problem-solving, time management and organization skills

What We Offer:

At Aquilini, we believe in the importance of a Total Compensation package by ensuring our mix of salary, benefits, and perks are competitive within the market, while also offering a work-life balance.

Our comprehensive benefits package includes Health, Dental, Vision Care, Life Insurance, and AD&D coverage. In addition, you'll have opportunities for access to Rogers Arena events, an on-site gym, parking, select discounts, professional growth and development options, fun staff events throughout the year, and a dynamic and supportive work environment where you can make a tangible impact.