Vantage Data Centers 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.
Position Overview:
Vantage is looking for a mid-level Data Infrastructure and Systems Specialist to support business operations utility billing team by managing projects, own the end-to-end integrity, automation, and scalability of our energy metering and billing data ecosystem. This role bridges automation scripting, database administration, cross-functional collaboration, and billing operations, ensuring accurate ingestion, processing, and delivery of physical meter data from Building Management Systems (BMS) into internal Postgres and MSSQL databases. You will design scalable data models, automate critical workflows, support monthly billing cycles, and collaborate cross-functionally to drive operational efficiency, compliance, lead cross-functional design and onboarding of new builds to ensure operability, maintainability, billability, and efficiency, build scalable data models and automate processes.
Essential Job Functions:
Design and implement tables, views, stored procedures, and functions to support reporting tools and downstream applications
Own schema evolution for internal SQL databases.
Write, maintain, and version-control comprehensive database documentation (CoreDB, configurations, and changes).
Perform user access management on database servers as directed.
Develop and maintain backend services in Python, Golang, and Java to support billing operations, sustainability tracking, and global software development (GSD) initiatives.
Build and optimize internal automation tools using Bash and Python to streamline billing workflows, data reconciliation, and manual task reduction.
Manage GitHub-hosted tools and automations with Azure Data Lake integration, leveraging CI/CD for repeatability and scalability.
Monitor and maintain end-to-end data pipelines from Ignition to Postgres and MSSQL databases.
Perform data validation, interpolation, and reconciliation of meter readings; automate corruption/missing data handling.
Support monthly billing cycles, including statement generation, accuracy verification, and timely invoicing.
Lead new building onboarding through configuration uploads, database provisioning, and data validation.
Act as the primary point of contact for sample bill verification and data-related inquiries.
Oversee commissioning and customer build-out to enable compliant billing and reporting.
Review and approve critical tickets, changes, releases, and processes (including meter anomaly detection) to ensure accuracy and standards compliance.
Troubleshoot meter data discrepancies, conduct root-cause analysis across systems (Site → BMS → Acquisition → Databases), and implement corrective actions.
Partner with Application Support (AS) and Development teams to enhance data correction workflows and operational efficiency.
Collaborate with Digital Products team on process automation, programming fixes, and system improvements.
Handle ad hoc data requests from management and cross-functional teams to meet business and customer needs.
Duties:
Database Development: Create and maintain database objects (tables, views, procedures, functions); manage schema changes via Liquibase CI/CD.
Documentation & Access: Update CoreDB and config documentation; manage user access per DBA requests/guidelines.
Automation & Scripting: Develop backend services using Python/Golang/Java services and create Bash/Python scripts for billing automation, statement generation, and scheduled jobs.
Pipeline Oversight: Monitor ingestion from BMS/Ignition into Postgres/MSSQL; validate end-to-end data flow and configuration uploads.
Data Quality & Reconciliation: Interpolate missing data, resolve discrepancies, perform root-cause analysis, and automate error handling.
Billing Support: Generate/review monthly statements, verify billing accuracy, support invoicing and sample bill validation.
Onboarding & Commissioning: Configure new buildings, create databases, validate data, oversee customer build-out for billing readiness.
Data Analysis Quality Assurance: Review meter anomalies and work with the responsible parties resolving them; conduct data backups for audits.
Cross-Functional Collaboration: Partner with AS, Dev, and Digital Products teams; resolve metering issues using Ignition and related tools.
Ad Hoc Support: Fulfill management and team data requests; troubleshoot urgent metering or pipeline issues. Provide support when requested
Continuous Improvement: Identify process gaps and implement enhancements that reduce errors, increase efficiency, and improve overall reliability.
Job Requirements:
Bachelor’s degree in a quantitative field (Statistics/Data Science, Computer Science, Data Engineering, or related field) or Engineering, or, equivalent experience
2-3 years production database administration experience with any of the following databases: MySQL, MariaDB, PostgreSQL, Microsoft SQL Server
Intermediate to advanced skills in creating queries for reporting on MySQL/SQL & MS Excel
Aptitude to become an expert in querying databases and implementing new/upgrading software applications
Proven to be highly accurate and thorough in all tasks
Strong organizational and communication skills, excellent problem-solving, logical process thinking and ability to multi-task in a fast-paced, dynamic environment and contribute quickly is required
Genuine drive and motivation with a “can do” attitude. Results-driven and committed to the future growth of Vantage, committed to our customer’s success and to your own career growth
Proficiency in SQL, Python, Golang, Java, Bash, and database performance tuning.
Experience with Liquibase, GitHub, Azure DevOps, and Azure Data Lake.
Physical Demands and Special Requirements:
The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.
While performing the duties of this job, 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 or kneel; talk and hear. The employee must occasionally lift and/or move up to 25 pounds.
#LI - Hybrid
#LI-PV1
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.
Don't meet all the requirements? Please still apply if you think you are the right person for the position. We are always keen to speak to people who connect with our mission and values.
Vantage Data Centers is an Equal Opportunity Employer
Vantage Data Centers 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 Data Centers.