Role Overview: The Endpoint Inventory & Test Automation Specialist will engineer automated cross-platform asset reconciliation pipelines and establish automated release validation and lab reset frameworks.
Position Attribute
Specification Details
Job Title
Endpoint Inventory & Test Automation Specialist (Systems Integration L3)
Work Location
Onsite: London / Toronto/Winnipeg
Tools & Platforms
ITSM & CMDB: ServiceNow CMDB, CSDM framework
Inventory Sources: Microsoft Intune, MECM SQL / WQL, Microsoft Graph API, Ready Track
Lab Virtualization: Hyper-V, Azure DevTest Labs, Vagrant
Test Automation: PowerShell, Pester
Required Technical Stack & Qualifications
Experience Level: 6+ years in IT asset management (ITAM/CMDB) engineering, cross-platform data reconciliation, and systems testing automation.
ITSM & CMDB: Strong technical working knowledge of ServiceNow CMDB tables, CSDM framework, and data normalization engines.
Data Pipeline & APIs: Proficiency in querying and extracting endpoint inventory datasets via MECM SQL/WQL, Microsoft Graph API, and Ready Track exports.
Lab Virtualization: Hands-on capability automating virtualized test sandboxes using Hyper-V, Azure DevTest Labs, or Vagrant.
Test Frameworks: Demonstrated experience authoring automated test harnesses using PowerShell and the Pester testing framework.
Key Responsibilities & Deliverables
Cross-Source Reconciliation: Architect automated pipelines synchronizing device inventory records across Microsoft Intune, MECM (SCCM), ServiceNow CMDB, and Ready Track.
Stale Device Lifecycle Automation: Codify automated workflows to consistently identify, quarantine, and decommission stale, duplicate, or unmanaged endpoint records across directory and asset databases.
Compliance Reporting Data Engine: Eliminate manual spreadsheet reconciliation prior to executive audits, producing authoritative, repeatable datasets reflecting true compliance posture.
Automated Test Lab Resets: Author infrastructure-as-code and PowerShell automation to instantly provision, baseline, and reset test environments (Hyper-V / Azure DevTest Labs).
Automated Acceptance Testing: Develop repeatable automated test validation suites (Pester / PowerShell) evaluating OS image integrity, core app compatibility, and security agent coexistence.
Audit Evidence Automation: Codify automated logging, screenshot capture, and test evidence collection to support release readiness and CAB go/no-go decisions.
Certifications
ServiceNow Certified System Administrator (CSA) or ITIL v4 Asset/Configuration Management certification preferred.