Grant McCormick

About

Business Intelligence Architect at Microbiome Labs (Novonesis Group). This site is my corner of the web — resume, writing, and selected work in one place.

Grant McCormick

Business Intelligence Architect

I enable innovation and solve problems using my passion to serve. · Christiansburg, Virginia, United States

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.

  • Business Intelligence Architect at Microbiome Labs (Novonesis Group) — BI systems, not just dashboards
  • Full analytics stack: Snowflake, Microsoft Fabric, Power BI semantic models, KNIME + Python automation
  • Version-controlled BI: PBIP/TMDL under Git, AI-assisted modeling, CI/CD into Fabric
  • B.S. Biology: Microbiology — Tennessee Technological University

Resume

Experience, skills, certifications, and education.

Experience

  1. Business Intelligence Architect

    Microbiome Labs (Novonesis Group)

    Early 2026 — Present · 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. Sales Force Effectiveness Specialist

    Novonesis

    April 2024 — Early 2026 · 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.
  3. Laboratory Manager II

    Novonesis

    October 2022 — May 2024 · Salem, Virginia, United States

    • Managed laboratory operations spanning procurement, service agreements, chemical hygiene, equipment and project management, inventory control, sample logistics, and supplier auditing.
    • Cross-functional role interfacing with internal customers and external stakeholders.
  4. Laboratory Manager I

    Novonesis

    August 2021 — October 2022 · Salem, Virginia, United States

  5. People and Technology Consultant

    REMAX ONE, LLC

    February 2024 — Present · United States

    • Building relationships and processes with realtors to enable their success using kvCORE to harness leads, build automations, and run outbound marketing cadences.
  6. Direct Marketing Specialist

    LeafFilter Gutter Protection

    July 2023 — August 2023 · Christiansburg, Virginia, United States

  7. Business Owner

    Impacted Imaging

    May 2019 — August 2021 · Cookeville, Tennessee, United States

    • Added value to real estate professionals' listings by producing quality photo and video packages.
  8. Teacher Assistant

    Tennessee Technological University

    January 2020 — May 2021 · Cookeville, Tennessee, United States

    • Communicated lesson material and guided students through hands-on experiments in a BSL-II medical microbiology teaching laboratory.
  9. Research Assistant

    Tennessee Technological University

    January 2020 — May 2020 · Cookeville, Tennessee, United States

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

Skills

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

Education

Blog

Notes on data, systems, and building things — latest: “SAMPLE POST — Hello, world”

Portfolio

Selected work: a Snowflake→Fabric migration, custom Power BI visuals, narrative DAX.

Snowflake → Microsoft Fabric migration

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

Power BI custom visuals for 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
  • Power BI
  • GeoJSON

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
  • Semantic modeling
  • Power BI