Data Infrastructure and Systems Specialist, NA

Vantagedc; Denver (CO); Hybrid; USD 90,000 - 130,000; Full time

Job summary

Vantage is seeking a mid-level Data Infrastructure and Systems Specialist to support the Utility Billing team within Business Operations. This role helps ensure the reliability, accuracy, traceability, and automation of energy metering and billing data across North American facilities.

The Specialist coordinates with cross-functional teams to enable accurate ingestion and delivery of meter data into internal databases.

Qualifications

• Develop and support scalable data solutions, owns the data, validates meter readings and configurations.
• Develop backend services and automation using Python, Golang, Java, Bash, and SQL.
• Monitor end-to-end data pipelines from site metering and BMS/Ignition to PostgreSQL and MS SQL.

Responsibilities

• Design and implement database tables, views, stored procedures, and functions used by reporting tools and downstream applications, with DBA coordination.
• Assist with approved schema changes and database deployments using change-management and CI/CD processes.
• Maintain accurate, version-controlled documentation for CoreDB, data structures, and changes.
• Develop and optimize complex SQL queries for high-volume meter-data analysis, reporting and reconciliation.
• Investigate slow or inefficient queries and discrepancies between source and downstream systems.
• Trace data lineage to identify gaps, incorrect mappings, and processing issues.
• Develop and maintain backend services and automation to support billing operations.

Skills

SQL

Python

Golang

Java

Bash

CI/CD

Data modeling

Tools

Liquibase

Azure Data Lake

PostgreSQL

MS SQL Server

Ignition

Job description

About Vantage

Vantage powers, cools, protects and connects the technology of the world's well-known hyperscalers, cloud providers and large enterprises. Developing and operating across North America, EMEA and Asia Pacific, Vantage has evolved data center design in innovative ways to deliver dramatic gains in reliability, efficiency and sustainability in flexible environments that can scale as quickly as the market demands.

Business Operations Department

As a part of the Vantage Operations team, the Business Operations department is responsible for ensuring standards for operation performance, maintaining customer leases, producing monthly customer electivity bills, generating regular reports, and supporting Operational Effectiveness. The Business Operations department also works closely with all Vantage departments to ensure customer success from the construction process through daily operations and delivery activities.

Position Overview

Vantage is seeking a mid-level Data Infrastructure and Systems Specialist to support the Utility Billing team within Business Operations. This role helps ensure the reliability, accuracy, traceability, and automation of energy metering and billing data across North American facilities. The coordinates with cross-functional teams like Construction, Site Operations, Automation, IT Development, Systems Support, and Utility Billing Operations to enable accurate ingestion, processing, validation, and delivery of physical meter data from Building Management Systems (BMS) and Ignition into internal PostgreSQL and Microsoft SQL Server environments. The Specialist develops and supports scalable data solutions, owns the data, validates meter readings and configurations, investigates discrepancies affecting billing and reporting, develops automation solutions, automates critical workflows, and contributes to monthly billing activities to improve billing readiness, compliance, maintainability, and operational efficiency for new and existing facilities.

This role will be based in: Denver, CO, Ashburn, VA or Atlanta, GA and is in alignment with our flexible work policy. (3 days on site required, 2 days flexible).

Essential Job Functions

Data Infrastructure and Database Support

• Support the design and implementation of database tables, views, stored procedures, and functions used by reporting tools and downstream applications, in coordination with the responsible DBA and Global Software Development (GSD) teams.
• Assist with approved schema changes and database deployments for internal SQL environments using established change-management and CI/CD processes, including Liquibase where applicable.
• Maintain accurate, version-controlled documentation for CoreDB, configuration designs, data structures, and implemented changes.
• Support database access requests in accordance with approved DBA processes and security guidelines; database access administration remains with the responsible DBA team.
• Develop and optimize complex SQL queries for high-volume interval meter-data analysis, reporting, validation, reconciliation, and troubleshooting.
• Investigate slow or inefficient queries, unexpected data behavior, and discrepancies between source and downstream systems.
• Trace data lineage from source meter tags to identify gaps, incorrect mappings, and processing issues.

Software Development and Automation

• Develop and maintain backend services and automation solutions using Python, Golang, Java, Bash, and SQL to support utility billing operations, sustainability tracking, scheduled processes, and approved GSD initiatives.
• Build and optimize internal tools that streamline billing workflows, statement generation, data reconciliation, scheduled jobs, and other repeatable activities.
• Maintain GitHub-hosted tools and automations, including Azure Data Lake integrations, using approved version-control and CI/CD practices to promote reliability, repeatability, and scalability.
• Identify recurring manual validation, correction, and reconciliation tasks; develop documented and reusable solutions with appropriate testing, monitoring, and error handling.

Data Pipeline Monitoring and Quality Assurance

• Monitor end-to-end data pipelines from site metering systems and BMS/Ignition through acquisition layers and into PostgreSQL and Microsoft SQL Server/Historian databases.
• Validate data flow, configuration uploads, and meter readings to confirm completeness, accuracy, and availability for billing and reporting.
• Perform data reconciliation and approved interpolation or correction activities for missing, corrupted, or inconsistent readings, and automate error handling where appropriate.
• Investigate meter and data discrepancies, perform root-cause analysis across the Site, BMS, acquisition, and database layers, and coordinate corrective actions with the responsible teams.
• Review meter anomalies and support the resolution of metering issues using Ignition and other approved tools; retain supporting data required for audit