This job board retrieves part of its jobs from: California Jobs | Texas Jobs | New Jersey Jobs

Find jobs in Pittsburgh

To post a job, login or create an account |  Post a Job

  Pittsburgh Job Bank  

Bringing the best, highest paying job offers near you

previous arrow
next arrow


Velocity Works, LLC

This is a Contract position in Pittsburgh, PA posted March 28, 2021.

We are looking for a BI Data Warehouse Architect! In this role you will use your past skill implementing a data warehouse in a mainly Microsoft environment. As a Business Intelligence team member, you’ll be focusing odata architecture, dimensional modeling, platform architecture, ETL processes, and ensure solutions are scalableThis role iresponsible for the design and architecture of the overall BI solution and associated data structures. You will not have any direct reports in this role. 

Essential Duties and Responsibilities

  • Define technical principles, vision, and standards for data within our BI platform
  • Effectively and objectively research BI technology concepts and tools, making recommendations to relevant stakeholder
  • Develop and evangelize standards used within BI, including Data Warehouse(DW) best practices and design patterns, frameworks and templates, naming conventions and coding standards
  • Develop dimensional modeling best practices, and act as subject matter expert and guide for data models across all areas of the business
  • Ensure the OW design can scale to handle additional data demands and can adapt to new business questions and data sets
  • Understand and make recommendations on the underlying hardware and software platforms that host all layers of BI
  • Define and recommend ETL processes and associated timings
  • Lend technical expertise to dimensional modeling activities
  • Support the development and execution of system design reviewand query/code review processes
  • Help with project-level technical estimates and timelines
  • Help to establish and improve data governance methodologies
  • Performs other duties as assigned by Management



  • B.S. degree in computer science 
  • At least 5 years of relevant BI experience 
  • Experience with Azure or AWS
  • Proven Azure BI stack hands-on experience at an enterprise level 
  • Proven DW analysisdesign, and data-modeling experience
  • Expert-level SQL Server experience
  • Experience working with SSIS, SSRS, SSDT for Visual Studio and related tool
  • Experience with data warehouse/decision  support modeling
  • Experienced at leading dimensional modeling activities, helping to populate the bus matrix, and defining conformed dimensions that will work across multiple data mart 
  • Experience supporting and troubleshooting data flow intfront-end BI dashboard
  • Experience with Agile development methodologies as they apply to BI project


  • VMWare or other Cloud/Virtualization technologies
  • Experience with DAX queries
  • MCSE: Cloud Platform and Infrastructure
  • MCSD: Azure Solutions Architect” certification 
  • SQL Server 2016, PowerBI ProDQS and MOM 201
  • Experience providindata support for predictive analytics project
  • C#/.NET


Powered by JazzHR