Data Architect

πŸ•’ October 30

πŸ’΅ $95k - $110k / year

⏰ Full Time

🟑 Mid-level

🟠 Senior

🚰 Data Engineer

Where this job comes from

Posted on UtiliSave LLC's careers page β†—UtiliSave LLC's careers page, not through a job board

First seen by Remote Rocketship October 30

Still open on UtiliSave LLC's site. Checked 18 hours ago.

Apply Now
Logo of UtiliSave LLC

UtiliSave LLC

11 - 50 employees

Founded 1991

⚑ Energy

πŸ’Ό Consulting

🀝 B2B

Energy β€’ Consulting β€’ B2B

UtiliSave is a Southampton, NY–based forensic utility bill auditing and recovery firm founded in 1991. It performs zero-risk audits for commercial utility bills (electricity, gas, water, sewer, steam and related taxes/charges), recovering incorrectly applied charges and securing exemptions, tariff optimizations, and meter- and asset-related recoveries. The company reports 35+ years of experience, $700M+ recovered across 16,000+ buildings, a 94% audit-find rate, and serves large energy consumers, ESCOs, property managers, healthcare and education institutions, hospitality, retail/grocery, government, and other commercial sectors. Services include bill auditing & recovery, benchmarking, commercial energy management, tax/exemption reviews, and targeted audits (e. g. , NYC steam), offered on a contingency basis (no fee unless money is recovered).

πŸ“‹ Description

β€’ Design and own the company's data model across SQL Server and Dataverse β€’ Define the target data model for Dynamics 365 CRM before migration β€’ Plan and execute data cleanup and migration, including trusted IDs, matching, deduplication and intake validation β€’ Design and build data flows and integrations between SQL Server, Dataverse, SharePoint, finance systems and the AI platform β€’ Use APIs, Azure services and Power Automate for integrations β€’ Design and maintain permissions across SQL Server, Dataverse, SharePoint and Entra ID β€’ Own the reporting data layer, including Power BI semantic models and history tracking β€’ Support and maintain existing applications and databases during the transition β€’ Bring production integrations under source control, code review, test environments and documentation standards β€’ Use AI-assisted tools such as Claude Code, GitHub Copilot and Cursor for SQL, pipelines, testing and documentation β€’ Track work in JIRA with estimation and task breakdown before development β€’ Write documentation as part of delivery β€’ Collaborate directly with development, AI and IT teams during the company's modernization to an AI-enabled Microsoft workplace

🎯 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 experience, including legacy database migration, matching and dedupe rules, and 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, including semantic models and DAX β€’ 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; Claude Code preferred, Copilot, Cursor or similar accepted β€’ Ability to plan data flows and explain them clearly in writing and verbally to technical and non-technical colleagues β€’ Comfortable working independently in a small, fully remote team β€’ C#/.NET experience, including working inside legacy applications preferred β€’ Python for data work preferred β€’ Utility, energy or billing data experience preferred β€’ Integrations with QuickBooks Online or other finance systems preferred β€’ Microsoft certifications such as PL-600 or DP-600 preferred

πŸ–οΈ Benefits

β€’ Performance based annual bonus β€’ 401(k) with company match β€’ Health/dental/vision insurance β€’ Flexible spending accounts β€’ Paid time off β€’ 11 paid holidays

Apply Now

πŸ“Š Check your resume score for this job

Improve your chances of getting an interview by checking your resume score before you apply.

Similar Jobs

πŸ•’ October 30

Edmunds

501 - 1000

🚘 Automotive

πŸ“± Media

πŸͺ Marketplace

Data Engineer managing Edmunds’ Databricks and AWS data platform. Building ETL, infrastructure-as-code, and operational dashboards supporting automotive insights and AI solutions.

πŸ‡ΊπŸ‡Έ United States – Remote

πŸ’΅ $125k - $159k / year

πŸ’° $50M PRIVATE PLACEMENT VC on 2020-02

⏰ Full Time

🟑 Mid-level

🚰 Data Engineer

πŸ•’ October 30

Hewlett Packard Enterprise

10,000+ employees

🏒 Enterprise

πŸ”§ Hardware

πŸ€– Artificial Intelligence

Presales architect designing and selling HPE data, storage, and cloud solutions. Advising Bay Area and western US enterprise customers through technical discovery, presentations, and proofs of concept.

πŸ‡ΊπŸ‡Έ United States – Remote

πŸ’΅ $137.6k - $284k / year

πŸ’° $1.5G Post-IPO Equity - Hewlett Packard Enterprise on 2025-04

⏰ Full Time

🟑 Mid-level

🟠 Senior

🚰 Data Engineer

πŸ•’ October 30

Hewlett Packard Enterprise

10,000+ employees

🏒 Enterprise

πŸ”§ Hardware

πŸ€– Artificial Intelligence

Presales architect designing and selling HPE data, storage, and hybrid-cloud solutions. Advising Bay Area and western U.S. enterprise customers through technical sales.

πŸ‡ΊπŸ‡Έ United States – Remote

πŸ’΅ $137.6k - $284k / year

πŸ’° $1.5G Post-IPO Equity - Hewlett Packard Enterprise on 2025-04

⏰ Full Time

🟑 Mid-level

🟠 Senior

🚰 Data Engineer

πŸ•’ October 30

Hewlett Packard Enterprise

10,000+ employees

🏒 Enterprise

πŸ”§ Hardware

πŸ€– Artificial Intelligence

Presales architect designing and selling HPE data, storage, and cloud solutions. Advising Bay Area and western US enterprise customers while supporting complex technical sales.

πŸ‡ΊπŸ‡Έ United States – Remote

πŸ’΅ $137.6k - $284k / year

πŸ’° $1.5G Post-IPO Equity - Hewlett Packard Enterprise on 2025-04

⏰ Full Time

🟑 Mid-level

🟠 Senior

🚰 Data Engineer

πŸ•’ October 30

Rheaction

2 - 10

🎯 Recruiter

πŸ‘₯ HR Tech

Senior Software Engineer building high-throughput data pipelines and tooling. Turning complex real-world data into reliable datasets for machine learning and product teams.

Built byΒ Lior Neu-ner. I'd love to hear your feedback β€” Get in touch via DM or support@remoterocketship.com
Follow Remote Rocketship on LinkedInFollow Remote Rocketship on InstagramFollow Remote Rocketship on FacebookFollow Remote Rocketship on TikTok