Skip to content

Business Intelligence Architect

Grant
McCormick

I enable innovation and solve problems using my passion to serve.

Roan Mountain, Tennessee, United States

Data is the terrain.
I build the map.

Business Intelligence Architect at Microbiome Labs (Novonesis Group). Resume, writing, and selected work in one place.


I'm on a journey to grow, and serve others along the way. My educational background in microbiology has been a stepping-off point, enabling me to identify systems at play and assess their interactions. I enjoy investigating areas for improvement within the systems around me and am always looking to learn. Being a "Jack-of-a-few-trades" is what I enjoy doing — leveraging my personal and professional experiences to make the biggest impact.

  • Now

    Business Intelligence Architect at Microbiome Labs (Novonesis Group) — building BI systems, not just dashboards.

  • Stack

    Snowflake, Microsoft Fabric, Power BI semantic models, KNIME + Python automation.

  • Practice

    Version-controlled BI: PBIP/TMDL under Git, AI-assisted modeling, CI/CD into Fabric.

  • Background

    B.S. Biology: Microbiology — Tennessee Technological University.

Experience & craft

Roles, skills, certifications, and education.

Where I've worked


  1. January 2026 — Present

    Business Intelligence Architect

    Microbiome Labs (Novonesis Group) · United States

    • Build business intelligence systems, not just dashboards — work spans the full analytics stack: modeling data in Snowflake and Microsoft Fabric, engineering semantic models in Power BI (Direct Lake, DAX, time-intelligence measures), and automating data workflows in KNIME with Python.
    • Moving the organization's BI practice off GUI-driven, one-off report building toward a programmatic, version-controlled discipline: PBIP/TMDL source files under Git, AI-assisted semantic modeling, and CI/CD deployment into Fabric.
    • Focused on the durable layer of BI — governed metric definitions, correct filter logic, and data quality — the layer that survives as AI reshapes how dashboards get authored.
    • Led a Snowflake-to-Fabric migration.
    • Built packaged Power BI custom visuals (TypeScript/D3) for sales territory mapping.
    • Authored narrative DAX measures that turn revenue data into plain-language insight.
  2. October 2026 — Present

    Founder & Owner

    Carver's Gap Holdings · Tennessee, United States

    • Founded Carver's Gap Holdings, a Tennessee holding company that owns and runs independent brands.
    • Kitted: a print-on-demand brand that turns a customer's favorite gun build into tees, prints, stickers and desk mats.
    • Deedio: an off-market real estate platform for Tennessee that connects buyers with owners who want to sell, starting in the Tri-Cities.
  3. April 2024 — January 2026

    Sales Force Effectiveness Specialist

    Novonesis · United States

    • Building data excellence culture to unlock revenue and make information actionable for sales, operations and marketing teams.
    • Curating data apps focused on user experience in the field and in the office.
    • Adding value across the organization by bridging B2B and B2C market data analysis.
    • Build and maintain data pipelines using KNIME and other ETL tools.
    • Optimize data warehouses (e.g., Snowflake) for performance and accessibility.
    • Integrate structured and unstructured data from platforms like Salesforce, Dynamics 365, and SAP HANA.
    • Develop custom data models to support analytics.
    • Create interactive Power BI dashboards using advanced DAX and custom measures.
    • Gather requirements from business users and deliver scalable BI solutions; train and support users in BI tools and best practices.
    • Identify and implement process automation using Python and KNIME.
  4. October 2022 — May 2024

    Laboratory Manager

    Novonesis · Salem, Virginia, United States

    • Managed laboratory operations spanning procurement, service agreements, chemical hygiene, equipment and project management, inventory control, sample logistics, and supplier auditing.
    • Owned CAPEX and OPEX planning for lab equipment and operating budgets, including forecasting, vendor negotiation, and spend tracking.
    • Led cross-functional project management for lab initiatives from scoping through execution.
    • Cross-functional role interfacing with internal customers and external stakeholders.
  5. August 2021 — October 2022

    Lab Assistant

    Novonesis · Salem, Virginia, United States

  6. July 2023 — August 2023

    Direct Marketing Specialist

    LeafFilter Gutter Protection · Christiansburg, Virginia, United States

  7. 2021 — 2022

    Realty Marketing Consultant

    REMAX ONE, LLC · United States

    • Built out kvCORE for the brokerage.
  8. May 2019 — August 2021

    Business Owner

    Impacted Imaging · Cookeville, Tennessee, United States

    • Added value to real estate professionals' listings by producing quality photo and video packages.
  9. January 2020 — May 2021

    Teacher Assistant

    Tennessee Technological University · Cookeville, Tennessee, United States

    • Communicated lesson material and guided students through hands-on experiments in a BSL-II medical microbiology teaching laboratory.
  10. January 2020 — May 2020

    Research Assistant

    Tennessee Technological University · Cookeville, Tennessee, United States

    • Improved taxonomic identification techniques supporting TWRA-funded research.
    • Studied relationships between common amphibian fungal pathogens and salamander cutaneous microbiota.

Skills & tooling


Top skills

  • Data Modeling
  • Semantic Modeling
  • Extract, Transform, Load (ETL)
  • Process Automation
  • GeoJSON / Spatial Analytics

Tools & tech

  • Power BI
  • DAX
  • Microsoft Fabric (Direct Lake, OneLake)
  • Snowflake
  • KNIME
  • Python
  • Git
  • TMDL
  • TypeScript
  • D3
  • Salesforce
  • Dynamics 365
  • SAP HANA
  • kvCORE

Certifications


  • Open Water Scuba Diver
  • Certified Phlebotomy Technician (CPT)
  • National Beef Quality Assurance Certification
  • Remote Pilot Certification

Where I studied


Selected work

A Snowflake→Fabric migration, custom Power BI visuals, narrative DAX.

Platform migration

Snowflake → Microsoft Fabric

Led the organization’s migration from Snowflake to Microsoft Fabric — Direct Lake semantic models on OneLake, deployed through version-controlled CI/CD.

  • Microsoft Fabric
  • Snowflake
  • OneLake
  • CI/CD

Custom visuals

Power BI territory mapping

Packaged Power BI custom visuals built in TypeScript and D3 for sales territory mapping, bringing GeoJSON/spatial analytics into the reporting layer.

  • TypeScript
  • D3
  • GeoJSON

Semantic modeling

Narrative DAX measures

Authored narrative DAX measures that turn revenue data into plain-language insight — governed metric definitions that live in the semantic model, not one-off reports.

  • DAX
  • Power BI

Let's build something meaningful

Modernizing data infrastructure, building executive-level intelligence, or shaping a long-term BI strategy — I'd like to hear about it.