Purpose
The BI Developer reports into the Manager, Business Intelligence
The BI Developer will be responsible for planning, development, implementation, and maintenance of the organization’s Microsoft Power BI environment and Business Intelligence report development and user reports analysis. They will work closely with Business Analysts and Stakeholders to drive requirements and deliver solutions that meet and exceed those requirements. They will also work with Database/ETL Programmer to implement their designs.
Key Areas of Accountability
• Monitor and investigate new versions, technologies and techniques as well as advises management on adoption strategies
• Work closely with Business Analysts and stakeholders to understand and document business and data requirements
• In concert with the Business Data Analyst, identify appropriate sources of Data Warehouse data
• Design, develop, implement metadata management processes, and best practices
• Design, develop and schedule/automate reports to internal and external stakeholders
• Ensure implementation of best practices for data warehouse environments
• Implementation of Microsoft Power BI data models, reports, and dashboards
• Develop, document, and execute test plans
• Resolve issues and inconsistencies in the data
• Searching for causes of incompatibility between the warehouse and other systems
• Identify software patches and upgrades and collaborate with IT to ensure the organization’s BI environment is fit for purpose and fit for growth
• Administer user access and security
• Collaborate with Data Engineer to tune the analytics environment for optimal performance
Qualifications
Education / Certifications / Licenses
• Bachelor’s Degree in technical or business discipline or equivalent experience
• Microsoft Power BI certification highly preferred
Experience
• 3-5 years of Microsoft Power BI development/administration experience. Must have current experience with Microsoft Power BI, Microsoft Power Automate, Microsoft SSRS, Microsoft Power BI Report Builder and demonstrate experience building paginated reports
• 6+ years of overall experience within the Business Intelligence/Data Warehousing space
• Strong background with entity relational and dimensional modeling, star schema design, and meta data modeling
• Experience defining data and user class security for reports and packages
• Experience translating business requirements into functional requirements, and translating those into reporting objects and reporting data requirements
• Solid experience in BI and Data Warehousing concepts OLAP, Cubes, etc.
• Solid hands-on experience creating tools with ad hoc reporting capabilities
• Experience in design patterns, development methodologies, delivery models etc.
• Knowledge of IT concepts, strategies, and methodologies, architectures, and technical standards
• Knowledgeable in new and emerging business intelligence and visualization technologies
• Preferred candidates should have data modeling, metadata management and Microsoft SSIS experience
Skills
• Fluent in SQL (SqlServer / SSIS)
• Strong relational database skills
• Strong communication skills and interpersonal skills
Compensation
• The base salary offered for this role is $82,000 to $100,000 per annum and can vary based on job-related expertise, qualifications, experience and internal equity.
• Eligible for Armstrong Collective’s discretionary bonus program
Eligible Benefits
Armstrong Collective supports our team members’ health and wellness by providing a comprehensive medical plan with 100% employer paid premiums, some of which includes:
- Medical, Dental, Vision, Life Insurance
- Short term disability, long term disability benefits
- Travel emergency assistance
- Vacation time and sick time
- Up to 5% RRSP and/or TSFA match
- Two complimentary annual train tickets after first year of employment
Armstrong Collective, Rocky Mountaineer and Canyon Spirit are an equal opportunity employer, driven by our values of creating meaningful moments, being one team, and achieving extraordinary outcomes. Our strong company culture supports our vision of a diverse, open, safe, and respectful workplace. We celebrate diversity and are committed to creating an inclusive environment for all team members. If you require any accommodation during the application process or throughout your employment, please let us know. We will work with you to ensure your needs are met and to create a supportive environment.
Please ensure to opt-in for text messages when you apply in order to receive interview updates.