The Opportunity

Toronto, ON
Information Technology
Full-time - Permanent

We are looking for a Senior Data Warehouse Architect to assist with our Microsoft BI Data warehouse projects.

This individual must be a strong data architect (modeler), focused on assessing our clients' environment and requirements with the ability to design a Microsoft Data Warehouse architecture in alignment with Microsoft BI best practices to support a full Data Warehouse implementation. The design will involve conceptual, logical and physical data modeling.

This position will work closely with clients and end-users to examine existing processes and develop automated solutions, including specifying program and data flows.

What you'll do


Conduct client assessment engagements to document requirements, points of pain, gaps and other business and technical input that will support recommendations and a future state Microsoft Azure BI Architecture.

Lead activities around data analysis, data profiling, data extraction (validation and transformation rules) and integration of data from multiple disparate sources into a robust and scalable data model.

Provide leadership for ensuring data quality and integrity.

Design and deliver a solutions architecture based on the Microsoft BI technology stack, specifically:

Microsoft SQL Server architecture and development

Experience with DAX development

SSAS cubes using DAX and MDX

SSIS, T-SQL, Stored Procedures, or other ETL tools


Work with business users and business analysts to gather requirements in different forms including: interviews, facilitated sessions and documented data structures.

Act as technical lead to assess clients' current state environment and offer estimates and recommendations for improvement.

Provide data warehouse and business intelligence subject matter expertise and leadership, including leadership to the project team. The project team most often includes business analysts, ETL and BI report developers.

Direct responsibility of managing the implementation team.

Provide data analysis and data modeling expertise.

Transform business requirements into functional data warehouse design requirements, including the data warehouse data model (logical and physical).

Ensure common application architectural framework across different subject areas and conformance with best practices. Proven experience in designing and deploying conformed dimensions is a must.

Consult with key individuals across multiple projects regarding the usage and application of business intelligence and data warehousing architectural standards.

Develop logical and physical data models from business requirements.

Provide input and architectural guidance for ETL architecture and processes.

Implement data quality and data governance processes.

Evaluate, recommend and implement Business Intelligence Tools to meet technical and business requirements.

Ensure architecture and applications meet performance and scalability requirements.

What you'll need


The requirements listed below are representative of the knowledge, skill, and/or ability required.

Strong knowledge and hands on experience developing data warehouse data models, including, a strong, proven track record of relational and dimensional modeling.

Previous experience with SQL Server 2014/2016 is required.

Hands on experience with T-SQL and SSIS/SSAS is required.

MDX, PowerBI experience required.

Azure knowledge an asset.

Detail oriented with excellent organization and analytical skills.

Ability to prioritize work and meet deadlines.

Ability to establish and maintain effective working relationships with clients, project team members, supervisors, and employees from other departments.

Bachelor s degree in computer science, information system, computer engineering or equivalent working experience is required.

8+ years hands on working experience in data modeling, including 5+ years experience as a lead data warehouse architect.

5+ years experience in implementing BI tools.

We're looking for

Core Skills

Analytical PowerBI Windows Azure Team Player T-SQL SQL Server Organizational Skills MDX Data Modeling SSIS/SSAS

A little bit about us

T4G Limited

T4G's head office is located in Toronto, ON with offices in Halifax, NS, Moncton, NB, Saint John, NB and Vancouver, BC.

We are a diverse collection of tech experts, creative thinkers, and consultants who are driven to produce exceptional change. We pride ourselves on our end-to-end technology solutions-if you need it, we make it happen.

T4G Limited was established in 1996. Initially, our expertise and solutions were tailored to the retail sector, with service offerings in BI and development. Over the years, we have hired truly amazing talent and broadened our capabilities.

Now our work spans the key areas of technology and marketing that businesses rely on today, including digital marketing, custom development, managed services, and leadership on the forefront of data science. We support companies across multiple verticals, including retail, travel, financial services, communications, and the public sector.

T4G Limited is a privately held Canadian company with more than 220 employees, with offices across Canada and a customer base that spans North America.

Are you interested?

Work With Us

Why T4G? 

It's more than just a job. T4G is a collaborative, values-focused organization where people care deeply about each other, their work, and our clients. We take pride in cultivating an open and inspiring environment that respects every individual and encourages them to grow personally and professionally.

A career with T4G means a place where your ideas are heard and valued, and where you're given the support to make them come to life, all surrounded by some of the brightest people in the industry.