DCIM Analyst
Summary
Analyze and reconcile power circuit data for data centers, using SQL and ETL to validate records and telemetry, while maintaining asset labeling standards and traveling to sites for audits.
About the Position:
We are seeking a DCIM Analyst to support the DCIM team in improving the accuracy, completeness, and usability of power and asset data across Cologix's data center portfolio. This hands-on, junior-level role combines data analysis, field validation, and operational support. The analyst will reconcile physical power circuit inventories, NetSuite power circuit records, DCIM branch circuit monitoring devices, and telemetry/metering data to maintain a reliable source of truth for power provisioning, monitoring, and billing.
A primary focus will be the Power Circuit Audit and Correction program, using SQL, ETL/data transformation, structured audit files, and system exports to identify and resolve record discrepancies and align usage telemetry to the correct physical and customer circuits. The role will also support Cologix's asset identification program by maintaining labeling standards, operating a Cologix-owned 100W CO2 laser to produce lamacoid signage for cabinets and critical infrastructure, and helping administer the internal label request and fulfillment process. Regular travel to Cologix data center sites will be required.What You'll Do:
- Maintain and reconcile physical power circuit audit/inventory data, aligning each physical circuit to the appropriate NetSuite power circuit record, customer/service order information, cabinet or space ID, DCIM/branch circuit monitoring (BCM) device, and telemetry source.
- Use SQL and ETL/data-transformation techniques to extract, normalize, compare, and validate power circuit, provisioning, and telemetry datasets; create exception reports that identify records requiring investigation or correction.
- Investigate missing, duplicate, excess, stale, or incorrectly provisioned power records and unmapped usage data; coordinate corrections with Operations, NetSuite/Development, Billing/Revenue Assurance, Customer Experience, IT, and other stakeholders.
- Prepare and validate standardized bulk-upload/provisioning files for power circuit additions, changes, and disconnects, and support recurring data-quality scripts, metrics, and alerts that identify when source systems no longer align.
- Support on-site physical power circuit audits and validation activities with Operations and qualified electrical personnel, maintaining a living source of truth and accurate telemetry mappings for billing, overage workflows, utilization monitoring, capacity visibility, and critical-infrastructure alarms.
- Develop and maintain enterprise asset-labeling standards, templates, naming conventions, and production documentation for cabinets and critical infrastructure.
- Operate a 100W CO2 laser and associated software to produce lamacoid asset signage, including job setup, variable-data/CSV merges, material preparation, quality control, routine cleaning, troubleshooting, and safe equipment operation.
- Help design, administer, and improve the internal label request workflow for Operations, including intake, prioritization, production tracking, material planning, quality control, fulfillment, and opportunities for automation.
- Document repeatable procedures and collaborate across technical and business teams to continuously improve power-data accuracy, asset identification, and process efficiency.
What makes you a good fit: (Qualifications)
- Bachelor's degree in Data Science, Data Analytics, Information Systems, Engineering, Business Analytics, or a related field, or equivalent practical experience.
- Foundational to intermediate SQL skills, including the ability to work with joins, filters, aggregations, and structured relational data.
- Strong Microsoft Excel skills and experience organizing, cleaning, reconciling, and validating large or complex datasets.
- Working knowledge of ETL/data-transformation concepts and the ability to move data accurately between spreadsheets, databases, and enterprise-system exports/imports.
- Strong analytical and troubleshooting skills, high attention to detail, and the ability to trace discrepancies back to their source.
- Ability to learn data center electrical and power-circuit terminology and work safely in active data center, warehouse, and technical environments while following site procedures.
- Effective written and verbal communication skills and the ability to work independently while collaborating with technical and business teams.
- Reliable and organized, with the ability and willingness to travel regularly to Cologix data center sites for audits, data validation, and program implementation.
- Experience with Python (including pandas), Power BI, R, or similar analytics and reporting tools.
- Exposure to NetSuite, DCIM, EPMS, branch circuit monitoring, metering/telemetry platforms, or other enterprise asset and facilities systems.
- Familiarity with data center power distribution concepts such as UPS systems, panels/PDPMs, busways, voltage, amperage, breakers, redundancy, and cabinet-level power monitoring.
- Experience with revenue assurance, billing reconciliation, service-order data, or other work where record accuracy has a direct financial impact.
- Experience with LightBurn, CO2 laser/engraving equipment, lamacoid/Rowmark materials, CNC/signage production, scripting, process automation, structured data imports, APIs, or Git/GitHub.
Nice to have qualifications:
As published by lever
Resume/CV, Full name, Email, Phone, Current location, Current company, LinkedIn URL, Portfolio URL, Gender, Race, Veteran status, DisabilityHow do you know if you have a disability? A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to: Alcohol or other substance use disorder (not currently using drugs illegally) Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS Blind or low vision Cancer (past or present) Cardiovascular or heart disease Celiac disease Cerebral palsy Deaf or serious difficulty hearing Diabetes Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders Epilepsy or other seizure disorder Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome Intellectual or developmental disability Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD Missing limbs or partially missing limbs Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS) Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities Partial or complete paralysis (any cause) Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema Short stature (dwarfism) Traumatic brain injury
- Are you legally authorized to work in the United States? choose one
- Will you now, or in the future, require sponsorship of an employment visa (e.g. H-1B visa status) choose one
- Home Address written answer
- What is your expectation for annual base salary?