Enterprise Data Warehouse Architect

New Brunswick

The Job

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.

Essential Duties and Responsibilities:

  • 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
    • SSRS, PowerBI
  • 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.

Qualifications:

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.

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.