Principal BI Architect

The BI Architect will design and implement a robust data infrastructure for effective reporting and analysis, requiring deep knowledge of data modelling, ETL, visualization, and BI best practices. This strategic role demands strong technical skills and excellent communication to translate business needs into impactful BI solutions.

Essential Duties and Responsibilities:

This list of duties and responsibilities is not all-inclusive and may be expanded to include other duties and responsibilities as deemed necessary.

• Designs and architects comprehensive BI and data warehousing solutions, including data models, ETL/ELT pipelines, and data storage systems
• Collaborates with stakeholders across different departments to understand their data and reporting needs and translate them into technical specifications
• Develops and maintains data standards, policies, and procedures to ensure data quality, integrity, and security
• Leads the development and implementation of ETL/ELT processes to extract, transform, and load data from various source systems into the data warehouse
• Designs and implements data visualization dashboards and reports that provide actionable insights to business users
• Evaluates and recommends BI tools and technologies to meet the organization's evolving needs
• Optimizes BI systems for performance, scalability, and reliability
• Troubleshoots and resolves data-related issues and provide ongoing support for BI solutions
• Stay up to date with the latest trends and technologies in business intelligence and data warehousing
• Mentors and provides guidance to other members of the BI team
• Participates in the planning and execution of data governance initiatives
• Documents all aspects of the BI architecture, including data models, ETL processes, and reporting solutions
• Will perform additional responsibilities when required