Business Intelligence Analyst

**Job Title**

Business Intelligence Analyst - Based in Lower Mainland, British Columbia with occasional travel involved (passport required)

**Reports To**

Information Systems Manager

**Job Overview**

**Key Responsibilities**
- Designing and developing enterprise-wide data analysis and reporting solutions
- Develop processes and procedures to ensure business solutions meet strategic goals
- Participate in the development of performance and economic indicators based on the company’s strategy
- Promote the understanding of company data and propose innovative solutions
- Provide data visualization techniques such as dashboards and reports
- Manage internal and external company resources
- Develop data cleansing rules for the company, reviewing and validating data
- Develop proof of concept and prototype to validate need
- Maintain and adapt implemented solutions over time
- Manage the integrity and validity of information contained in the data warehouse and source systems
- Write and document business requirements, functional requirements, and design specifications
- Continuously improve existing business processes and strive to develop new ones to improve efficiency

**Qualifications**

Education
- Bachelor’s degree with specialization in Business Information Systems, Computer Science or Data Science, or Master’s degree in Business Intelligence
- 5 years of experience

Competencies
- Strong business intelligence best practices in:

- Data Warehouse
- Data Loading (ETL)
- Data Visualization **Proficiency in SQL Server technologies (TSQL, SSIS, SSAS, SSRS), Tableau or equivalents**
- Understand different software systems such as CRM, ERP, MRP
- Knowledge of an AGILE project management methodSkills
- Methodical and detailed
- Strong people skills, customer service oriented
- Strong problem-solving and management skills
- Proactive, forward-thinking
- Bilingual a strong asset (French, English)
- Technical writing ability
- Excellent written and oral communication

**The offer**
- Competitive salary - we take great pride in offering our workforce the best benefits and compensation packages in our industry, and we think you will too.
- Healthcare and Dental for single, couple or family coverage
- Insurance benefits and employee assistance program
- Group RRSP - save for retirement - you are eligible after 1 year of continuous employment and Convoy matches your contribution based on years of service
- Time Off - Everyone needs time away from work to recharge and be with family and friends - receive a generous amount of paid holidays
- Employee Referral Bonus Program
- Paid training/tuition reimbursement - Ready to further your education?
- Open door policy in a supportive and encouraging work environment
- Overtime available in peak periods
- Internal Promotions

**Additional information**

**Company Overview**

Convoy Supply, founded in 1972, is a leading wholesale distributor of construction materials with over 40 locations across North America. Convoy prides itself on being the most responsive, problem solving and fun place for our customers to conduct business.

**Job Types**: Full-time, Permanent

Additional pay:

- Bonus pay

**Benefits**:

- Dental care
- Disability insurance
- Employee assistance program
- Extended health care
- Life insurance
- Vision care

Schedule:

- 8 hour shift
- Monday to Friday

Application question(s):

- Are you legally able to work in Canada without restriction?
- What is your COVID 19 vaccination status?
- Briefly describe your experience in data management.
- Are you experienced in Tableau?