Share this Job

Lead BI Architect

Date: Feb 14, 2021

Location: Davidson, NC, US

Company: MSC Industrial Supply

Build a better career with MSC. 
Serving customer and community starts with the very best people doing their very best work. That is precisely what we have at MSC Industrial Supply Co., a leading North American distributor of metalworking and maintenance, repair, and operations (MRO) products and services. Watch HERE to find out why you should work at MSC and join us as we continue to build a diverse and inclusive workplace. 

Requisition ID : 5458 

Employment Type : Full Time         

Job Category : Information Technology                                             

Work Location :  Davidson, NC (CSC) 

State or Province : North Carolina (US-NC)     

Potential Work Location : United States : North Carolina : Davidson 


JOB TITLE: BI Architect Lead


At MSC, we are growing our Analytics team and investing in forward-thinking BI and Data Analytics solutions. As we build out the team, we are looking for a smart and innovative leader who is self-sufficient and thrives in ambiguity, has experience in Analytics, and can drive results across MSC bridging business and technical areas. This is an opportunity to be a part of a special milestone, help us build the future of Analytics at MSC, and ignite a data-driven culture.The BI Architect will plan the information architecture and solution a design utilizing enterprise technologies and open source programming languages. This role will be the guide for architectural principles and standards around information delivery and integrations. The BI Architect owns business intelligence solution architecture, design, development, implementation for MSC. With the partnership across other areas, such as Data Engineering, Infrastructure & Operations, this role will provide feedback on the data models to ensure optimal performance with BI solutions. Additionally, this role will have direct reports in their squad consisting of on and offshore team members.



  • Owns business intelligence solution architecture, design, development, implementation, and administration with the partnership with Data Engineering in the design of databases and data warehouses to ensure interoperability with BI solutions.
  • Provides technical leadership and guidance to BI Developers
  • Performs metadata modeling, and develop complex integrated data sets from disparate data sources with an expert utilization of SQL or BI platforms.
  • Builds and maintains schema objects and abstraction layer on top of various, changing enterprise data assets.
  • Interprets and assists in designing normalized and dimensional data modeling as well as experience implementing metadata solutions, and bi-temporal data models.
  • Manages and prioritizes work load of BI Developers by coordinating incoming work assignments with appropriate associates.
  • Collaborates with business users to define requirements and reporting specifications and provide technical report assistance.
  • Supports end-user training and provide second-line support for users who develop reports on behalf of their departmental colleagues.
  • Automating processes using powershell shell, batch scripts, or similar.
  • Contributes to and applies standards and governance of Business Intelligence processes
  • Acts as a liaison to the business user community, promoting the use of the data warehouse and its associated tools.
  • Fosters the MSC Culture in the department and throughout the company to ensure fulfillment of MSC’s vision and unity of purpose.
  • Participation in special projects and performs additional duties as required



  • Bachelor’s degree in Computer Science, Information Technology, Systems Analysis or a related study. Master’s degree strongly preferred.
  • Minimum seven years of wide-ranging analytics experience, in areas such as SQL based analytics, business intelligence and reporting, (machine learning/ statistical modeling is a plus
  • Minimum of three years of experience in designing and deploying enterprise-wide scalable operations on Cloud Platforms (AWS, GCP, Azure).
  • Minimum two years of experience with Infrastructure as a service (IaaS), Platform as a Service (PaaS) solutions development.
  • Systems integration with 3rd party platforms (i.e. Salesforce, SAP)
  • Experience with software design & implementation including CI/CD (Continuous Integration and Deliver) and Testing/QA



  • Strong Agile / Design Thinking / Rapid Prototyping experience •Experience with DevOps process (exposure to GitHub, Jenkins or other CI/CD tools)
  • Strong Knowledge about Agile techniques: User Stories, Continuous Integration, Test Driven Development, Continuous Testing, Pairing, Automated Testing, Burn Down Metrics, Velocity etc.
  • Strong knowledge of software development processes and procedures to understand team needs includes fundamentals of iterative and incremental development
  • Expertise or interest in architecting IoT solutions relating to sensors, cloud connectivity, AI (Artificial Intelligence), Machine Learning, and physical device communication. (Preferred)
  • Expertise or Interest in one or more specific IoT / embedded / M2M (Machine to Machine) industry (i.e. automation, asset tracking, safety, etc.)



  • A valid driver’s license and the ability to travel up to 15% of the time may be required.



Why MSC  
People. Collaboration. Insight. That’s how you build something that works.

Built on a foundation of trust, MSC works side by side with our customers to help them drive business results. With more than one million product offerings and 75+ years of experience across industries, MSC strives to help our customers achieve greater productivity, profitability, and growth through inventory management and other innovative supply chain solutions. 

We care about our associates and have programs in place to help our 6,500+ team members achieve their potential. When you join our team, you will receive rewards and recognition for your contributions, training and professional development opportunities, as well as a variety of benefits to support you and your family's health, well-being, and financial future.

If you are inspired to learn, take risks, and succeed as a team, you can build a better career at MSC.

Equal Opportunity Statement 
At MSC, we are committed to providing an environment of mutual respect where equal employment opportunities are available to all qualified applicants and our associates without regard to race, color, religion, age, sex, national origin, disability, protected veteran status, sexual orientation, gender identity/expression or any category protected by applicable law.                    


Nearest Major Market: Charlotte
Nearest Secondary Market: Concord