The pioneer in forensic utility bill auditing. Since 1991 we've recovered $700M+ for 16,000+ commercial buildings, on pure contingency. No recovery, no fee. We're growing, and our in-house software and 35 years of audit data are the engine behind that recovery.
Right now we're moving the whole company to a modern, AI-enabled workplace. That means a new CRM built in-house on, client and utility portals, Microsoft 365 and SharePoint across every department, and AI tools that help our auditors find and recover more. Every one of those projects runs on data, and we need someone to own it.
This is a hands-on role. You'll design the data model for the new platform, clean up and migrate decades of data out of SQL Server, and build the integrations that connect our systems. You'll also keep our existing applications healthy while we get there, because the legacy systems run the business today. You get to work on new technology and carry a working business through the change at the same time.
What you'll be part of
Responsibilities
Requirements
● 5+ years in data engineering, data architecture or database development.
● Strong hands-on SQL Server: T-SQL, schema design and performance tuning.
● Experience with Dataverse or the Dynamics 365 data model: tables, relationships, keys and security roles.
● Built and supported production integrations using REST APIs, Azure Data Factory, Azure Functions, Power Automate or similar.
● Data modeling and data quality in practice: you've migrated a legacy database, written matching and dedupe rules, and set up a single source of truth.
● Data security experience: role-based access and permissions across databases, Microsoft 365, SharePoint and Entra ID.
● Power BI data modeling (semantic models, DAX), beyond building visuals.
● Working knowledge of Microsoft 365 and SharePoint: libraries, metadata, permissions and the Graph API.
● Demonstrated, hands-on use of AI-assisted development tools in real projects, not just familiarity. Claude Code preferred; Copilot, Cursor or similar accepted.
● Able to plan data flows and explain them clearly, in writing and out loud, to developers and non-technical colleagues.
● Comfortable working independently in a small, fully remote team.
NICE TO HAVE
Preferred Qualifications
● C#/.NET experience, including working inside legacy applications.
● Python for data work.
● Utility, energy or billing data experience, including large time-series or meter data.
● Integrations with QuickBooks Online or other finance systems.
● Microsoft certifications such as PL-600 or DP-600.
Benefits
Benefits: performance based annual bonus, 401(k) with company match, health/dental/vision insurance, flexible spending accounts, paid time off, and 11 paid holidays.
Build and deploy AI-driven automation for architectural visualization, precise 3D-to-2D CAD documentation, and studio operations, improving production efficiency while preserving design quality and millimeter-level accuracy.
Lead client consultations, concept design, space planning, and layout coordination for medical and commercial fitouts, balancing functional workflows, compliant materials, and commercial viability.
Produces compliant construction production drawings, roll-forming data, and manufacturing documentation for modular building components, coordinating with engineering and cross-functional teams to support accurate, efficient fabrication.
Design integrated, safety-critical automation architectures for intelligent buildings and industrial processes, connecting building systems and process controls while improving safety, efficiency, and sustainability.
Coordinate healthcare architecture projects from concept through construction, developing design solutions and documentation while supporting client coordination, contract administration, and multidisciplinary project teams.
