Reporting to the BI Manager, the BI Solution Architect elaborates and implements BI and Data Warehousing strategy, architecture and solutions to support informational business requirements. The BI Solution Architect is responsible to oversee and participate in the implementation, technical design, development, testing, execution, on-going support and maintenance of the BI Solutions. The incumbent works with the BI team members to identify potential data sources, complex transformation rules, provides guidelines and establishes best practices. The BI Solution Architect works in collaboration with the Enterprise Architecture group.
- Transform the business requirements into BI solutions
- Provide in-depth expertise in technical design, development, testing and deployment and mentor BI Developers in applying related processes and best-practices
- Oversee the implementation of the data models, ETL’s, metadata definitions, as well as on-going maintenance and support
- Participate in data modeling activities
- Ensure compliance with Enterprise Architecture, ITS and security standards and methodologies
- Deliver and maintain technology roadmaps that provide robust solutions which meet or exceed requirements and IT service levels agreements, and consider vendor roadmaps
- Responsible for the overall technical design including dynamic data cleansing, validation, monitoring, automated recovery and automation of software delivery processes
- Responsible for compatibility between the BI components and other operational systems. Interfaces with Development team for integration involving other applications
- Responsible for promoting the BI capabilities to the McGill community
- Stay abreast overall on related technologies and ensure solutions meet required technical design and specifications and that development deliverables adhere to best practices and standards
Minimum Education & Experience: Other Qualifying Skills And/Or Abilities: Strong leadership and demonstrated effective communication, writing, planning and coordination skills. Minimum 3 years as BI architect, including data modeling in SQL Server Data Warehouse environment. Expertise with the Microsoft BI stack (on-premises and cloud) Expertise using ETL tools and deep understanding of ETL concepts, standards and best practices. Experience in the development of Enterprise Date Warehouse/Business Intelligence. Experience with Oracle databases (version 11g and 12c). Experience with performance optimization including SQL tuning. Strong understanding of all Data Warehouse concepts. Knowledge of relational and star schema modeling (Data Vault is an asset) Firm sense of accountability and ownership. Experience with Version Control Systems, Continuous Integration and Continuous Deployment. Knowledge of Software Delivery Life Cycle approaches (Agile, DevOps, ITIL are assets) and methodologies (Macroscope Productivity Center an asset). Attention to detail, diligent and rigorous work methods. Self-motivated, fast learner and demonstrated ability to work on different projects concurrently and to establish priorities. Good team player with strong focus on delivering results to meet the business needs. Ability to coach, mentor and advise. Knowledge of the higher education sector (an asset). Strong leadership with ability to facilitate and drive technical discussions. Excellent verbal and written communication skills - English (spoken and written) - French (spoken). Reference Number: Salary Range: Faculty/Unit: How To Apply:
688 Sherbrooke Street West, 16th floor
*Current employees: please indicate your McGill ID number in your application.*
McGill applicants, covered by the McGill Non-Unionized, Non-Academic Personnel Policies and Procedures, must apply to a regular M and Excluded position within ten (10) working days of the date of publication to maintain internal priority. McGill University hires on the basis of merit and is strongly committed to equity and diversity within its community. We welcome applications from racialized persons/visible minorities, women, Indigenous persons, persons with disabilities, ethnic minorities, and persons of minority sexual orientations and gender identities, as well as from all qualified candidates with the skills and knowledge to productively engage with diverse communities. McGill implements an employment equity program and encourages members of designated groups to self-identify. Persons with disabilities who anticipate needing accommodations for any part of the application process may contact, in confidence, Professor Angela Campbell, Associate Provost (Equity and Academic Policies) at email@example.com or 514-398-1660.