Data Infrastructure and Systems Specialist, NA

Vantage Data Centers Management Company LLC; United States; Hybrid; USD 120,000 - 125,000; Full time

Job summary

Vantage Data Centers Management Company LLC is seeking a mid-level Data Infrastructure and Systems Specialist to support the Utility Billing team. You will ensure the reliability and automation of energy metering data across North American facilities, coordinating with Construction, Site Operations, IT, and Billing teams.

Based in Denver, Ashburn, or Atlanta with a 3 on-site / 2 flexible work policy, you will drive data ingestion, validation, and billing readiness for new and existing facilities.

Qualifications

• Bachelor's degree in a quantitative field or equivalent experience.
• 2–3 years of experience supporting production databases, data systems, or data-intensive applications.
• Intermediate to advanced SQL for reporting, data validation, troubleshooting, and reconciliation.
• Advanced Microsoft Excel for data analysis and reporting.
• Proficiency in Python and Bash; Golang and/or Java is a plus.
• Experience with GitHub, Azure DevOps, Azure Data Lake, CI/CD, and Liquibase.
• Understanding of database structures, data pipelines, data quality controls, and performance considerations.
• Strong analytical and problem-solving skills; clear written and verbal communication.

Responsibilities

• Design and support database tables, views, stored procedures, and functions with the DBA and GSD teams.
• Develop and maintain backend services and automation for billing operations and data workflows.
• Monitor end-to-end data pipelines from site meters to PostgreSQL/SQL Server stores; validate data flow and flag issues.
• Perform data reconciliation and automate error handling; investigate discrepancies across layers.
• Support monthly utility billing cycles and ad hoc data requests from management and cross-functional teams.
• Onboard new buildings with data provisioning, validation, and billing readiness testing.
• Collaborate with Construction, Operations, IT, and Data teams to improve data accuracy and system performance.

Skills

SQL

Excel

Python

Bash

Golang/Java

GitHub/Azure DevOps

CI/CD

Data analysis

Communication

Education

Bachelor's degree in a quantitative field

Tools

MySQL

MariaDB

PostgreSQL

MS SQL Server

Liquibase

Azure Data Lake

Ignition

GitHub

Azure DevOps

CI/CD tools

Job description

About Vantage

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 centre 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 specialist 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 and operational review.

Billing Operations Support

Support monthly utility billing cycles, including statement generation, billing-data validation, sample/mock bill verification, accuracy review, and timely invoice preparation. Serve as a primary technical contact for sample/mock billing verification and data-related questions during commissioning activities. Fulfill approved ad hoc data requests from management and cross-functional teams to support business and customer requirements.

New Building Onboarding and Commissioning

Coordinate the data and system activities required to onboard new buildings, including configuration uploads, approved database provisioning requests, data validation, and billing-readiness verification. Partner with Construction, Automation Systems, and other responsible teams to support end-to-end sample/mock billing testing and verification. Support commissioning and customer build-out activities to help ensure that metering data and related systems are operable, maintainable, billable, and suitable for required reporting.

Governance and Cross-Functional Collaboration

Review critical incidents, work orders, changes, releases, and related processes within the role’s area of responsibility to confirm data accuracy, control compliance, and operational readiness. Partner with Application Support, Development, Site Operations, Construction, Digital Products, DBA, and GSD teams to resolve issues and improve data-correction workflows, automation, and system performance. Identify process and control gaps and implement or recommend improvements that reduce errors, increase efficiency, and strengthen the reliability of billing data and supporting systems. Provide timely support for urgent metering, integration, pipeline, and billing-data issues within the role’s scope. Communicate investigation findings, business impact, risks, dependencies, and resolution status clearly to technical and non-technical stakeholders.

Job Requirements

• Bachelor's degree in Computer Science, Data Engineering, Data Science, Statistics, Engineering, or a related quantitative field, or equivalent relevant experience.
• Two to three years of relevant experience supporting production databases, data systems, or data-intensive applications using one or more of the following: MySQL, MariaDB, PostgreSQL, or Microsoft SQL Server.
• Intermediate to advanced SQL skills, including the ability to create queries for reporting, data validation, troubleshooting, and reconciliation.
• Intermediate to advanced Microsoft Excel skills for data analysis and reporting.
• Working proficiency in Python and Bash, with experience in Golang and/or Java; ability to develop and support automation and backend services.
• Experience with GitHub, Azure DevOps, Azure Data Lake, CI/CD practices, and database change-management tools such as Liquibase.
• Understanding of database structures, system integrations, data pipelines, data quality controls, and performance considerations.
• Strong analytical and problem-solving skills, with the ability to investigate issues methodically and translate findings into practical corrective actions.
• High level of accuracy, thoroughness, organization, and attention to detail.
• Strong written and verbal communication skills and the ability to collaborate effectively with technical and non-technical stakeholders.
• Ability to manage multiple priorities and contribute effectively in a fast-paced, dynamic environment.
• Results-oriented and proactive approach, with a commitment to customer success, continuous improvement, and professional growth.

Physical Demands and Special Requirements

The physical demands described below are representative of those that must be met by an employee to perform the essential functions of this position successfully. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. While performing the duties of this role, the employee is occasionally required to stand, walk, sit, use hands to handle or feel objects, reach with hands and arms, climb stairs, balance, stoop, kneel, speak, and hear. The employee must occasionally lift and/or move up to 25 pounds.

Additional Details

• Salary Range: $120,000 - $125,000 Base + Bonus (this range is based on Colorado market data and may vary in other locations)
• This position is eligible for company benefits including but not limited to medical, dental, and vision coverage, life and AD&D, short and long-term disability coverage, paid time off, employee assistance, participation in a 401k program that includes company match, and many other additional voluntary benefits.
• Compensation for the role will depend on a number of factors, including your qualifications, skills, competencies, and experience and may fall outside of the range shown.
• #LI-Hybrid #LI-AG1

Company Culture

Vantage is an Equal Opportunity Employer.

Vantage does not accept unsolicited resumes from search firm agencies.

Fees will not be paid in the event a candidate submitted by a recruiter without an agreement in place is hired; such resumes will be deemed the sole property of Vantage.

We operate with No Ego and No Arrogance. We work to build each other up and support one another, appreciating each other’s strengths and respecting each other’s weaknesses. We find joy in our work and each other, actively seeking opportunities to inject fun into what we do. Our hard and efficient work is rewarded with an above market total compensation package. We offer a comprehensive suite of health and welfare, retirement, and paid leave benefits exceeding local expectations. Throughout the year, the advantage of being part of the Vantage team is evident with an array of benefits, recognition, training and development, and the knowledge that your contribution adds value to the company and our community.