Business Intelligence Architect

BI Architect

Our client is looking for a BI Architect to join their Analytics group where you will develop high-scale BI solutions aligned with our strategic goals. In this role, you’ll collaborate with leadership, engineers, analysts, product managers, and BI teams to address complex data requirements. Reporting to the Director of Data Architecture, you’ll play a key role in shaping our clients BI architecture landscape. This is a 12-month contract open to candidates Canada-wide.

Responsibilities:

• Lead the design and development of BI solutions, including data warehousing, analytical pipelines, and data modeling.
• Ensure BI products are scalable, maintainable, and aligned with business needs.
• Work closely with team members to translate business requirements into technical specifications.
• Develop and manage analytical pipelines using Python and SQL, integrating data from multiple sources into a unified platform.
• Design cloud-based data warehousing solutions (e.g., Snowflake, Amazon Redshift, Google BigQuery) to efficiently handle large data volumes.
• Optimize BI processes to accelerate insights, improve efficiency, and identify automation opportunities.
• Provide data-driven recommendations to support strategic decision-making.
• Ensure seamless integration of BI products with existing infrastructure to maintain smooth data flow.
• Implement robust data security measures, including access controls, backup, recovery, and governance policies.
• Establish and promote best practices for data quality, integrity, storage, indexing, and query performance.
• Create and refine intuitive dashboards, reports, and wireframes for data visualization.
• Lead efforts to optimize BI solutions for efficient data processing and retrieval.
• Maintain detailed documentation of BI solutions, covering design, development, and maintenance processes.
• Conduct training sessions to empower end users in effectively utilizing BI solutions.
• Evaluate and recommend BI tools and platforms that support scalability and innovation.
• Stay updated on industry trends, emerging BI technologies, and best practices.

Qualifications:

• Proven experience in designing and implementing BI architectures in large-scale environments.
• Expertise in columnar and MPP databases (e.g., Snowflake, Google BigQuery).
• Strong proficiency in SQL and Python.
• Deep understanding of ETL processes, data modeling, and data warehouse design.
• Knowledge of data governance, security best practices, and compliance.
• Experience managing large datasets while ensuring high data quality.
• Strong communication skills to collaborate with stakeholders and technical teams.
• Familiarity with CI/CD tools (e.g., Jenkins, GitLab) is a plus.
• Ability to optimize business processes using BI solutions.