Data Architect

🔥 22 minutes ago

🗽 New York – Remote

🗽 New York – Remote

💵 $95k - $110k / year

⏰ Full Time

🟡 Mid-level

🟠 Senior

🚰 Data Engineer

👻 Ghost score 21%

What it means: the chance that no one is really hiring for this job.How to read it: 60% or higher means we think this is a ghost. Lower scores are less of a worry.How we score it: age, reposts, open roles vs team size, how fast jobs close, and whether pay is listed.Fine print: an estimate from public data, not a judgment of the company. Real jobs can score high, so treat it as a hint, not a fact.

Apply Now

Find Similar Remote Jobs

UtiliSave LLC

WebsiteLinkedInAll Job Openings

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

📊 Check your resume score for this job

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

Upload Resume