Back to jobs

Data Architect

Pay
Pay not listedSimilar roles state $155K–$227K
Work setting
Not stated
Employment
Full-time — employment source
Employment type in the employer’s posting: Full-time
From the employer’s posting

What you’ll work on

Full posting
  • Design the data model across SQL Server and Dataverse, and the target Dynamics 365 CRM model

  • Clean up and migrate legacy data with trusted IDs, matching and dedupe rules

  • Build data flows and integrations across SQL Server, Dataverse, SharePoint, finance and AI systems

  • Design permissions for staff, clients, auditors and AI tools across core systems

  • Support existing applications and databases during the transition

From the employer’s posting
Own the company's data model across SQL Server and Dataverse, and define the target model for our Dynamics 365 CRM before data is migrated into it.
Plan and run data cleanup and migration: one trusted ID for each account, property, utility and contact, clear matching and dedupe rules, and intake checks that stop bad data from coming back.
Plan, design and build data flows and integrations between SQL Server, Dataverse, SharePoint, finance systems and our AI platform, using APIs, Azure services and Power Automate.
Protect the data: design and maintain permissions for staff, clients, auditors and AI tools across SQL Server, Dataverse, SharePoint and Entra ID.
Support and maintain our existing applications and databases during the transition, so the business keeps running while the new platform comes online.

Benefits in the posting

Full benefits wording
  • Benefits: performance based annual bonus, 401(k) with company match, health/dental/vision insurance, flexible spending accounts, paid time off, and 11 paid holidays.

From the employer’s posting.

Apply at UtiliSave

Posting record

Report an error

Actively hiringFirst seen by us 3 days ago, still listed, and not a repost of an earlier posting.

Status in our records
Live
First seen by us
Nov 18, 20263 days ago
Recorded sightings
4
Last seen by us
Nov 21, 2026
Employer says posted
Sep 30, 2026

These dates show when we found the posting. Check the employer’s website to confirm it is still accepting applications.

How this job compares

Pay

$155K–$227K is typical

The middle half of what similar US postings state. This one doesn’t list pay.

From 3,272 postings in the last year. Stated ranges, not salaries paid.

Time since we first saw it

Day 3

Early. Similar jobs usually come down between day 8 and day 57.

From 9,995 similar postings that came down. Coming down is not always a hire.

UtiliSave is hiring

2 open jobs

Open jobs by the week we first saw them, last 12 weeks.

Hiring record

See how this role fits your experience

Add your resume and we’ll mark which of these tools you already use, and point out anything in the posting that could rule you out.

  • C#
  • Python
  • SQL
  • T-SQL
  • Azure
  • Power BI
  • SQL Server
Where the posting names them
Preferred Qualifications ● C#/.NET experience, including working inside legacy applications. ● Python for data work.
● 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.
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 - Own the company's data model across SQL Server and Dataverse, and define the target model for our Dynamics 365 CRM before data is migrated into it. - Plan and run data cleanup and migration: one trusted ID for each account, property, utility and contact, clear matching and dedupe rules, and intake checks that stop bad data from coming back.
- Plan and run data cleanup and migration: one trusted ID for each account, property, utility and contact, clear matching and dedupe rules, and intake checks that stop bad data from coming back. - Plan, design and build data flows and integrations between SQL Server, Dataverse, SharePoint, finance systems and our AI platform, using APIs, Azure services and Power Automate. - Protect the data: design and maintain permissions for staff, clients, auditors and AI tools across SQL Server, Dataverse, SharePoint and Entra ID.
- Plan, design and build data flows and integrations between SQL Server, Dataverse, SharePoint, finance systems and our AI platform, using APIs, Azure services and Power Automate. - Protect the data: design and maintain permissions for staff, clients, auditors and AI tools across SQL Server, Dataverse, SharePoint and Entra ID. - Own the reporting data layer, including Power BI semantic models and the history tracking we need to measure cycle times and outcomes.
- Bring production integrations under standard controls: source control, code review, test environments and documentation. - Use AI-assisted tools (Claude Code, GitHub Copilot, Cursor or similar) as a normal part of your work for SQL, pipelines, testing and documentation. - Track all work in JIRA, with estimation and task breakdown before development begins, and write documentation as part of delivery.
● 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.
● 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.
- Protect the data: design and maintain permissions for staff, clients, auditors and AI tools across SQL Server, Dataverse, SharePoint and Entra ID. - Own the reporting data layer, including Power BI semantic models and the history tracking we need to measure cycle times and outcomes. - Support and maintain our existing applications and databases during the transition, so the business keeps running while the new platform comes online.
● 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.

Your next step

Complete your application on apply.workable.com. The employer’s form will show what is required.

Applying through Workable

  • No account needed. You can import your resume to fill in the form, or skip that and fill it in yourself.

Already applied? Track this application

Job description

View original posting ↗

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

  • A real rebuild. We're replacing a legacy platform with a modern Microsoft stack, and the data model you design is the one the company will run on for years.
  • AI is part of how we work. Our developers use Claude Code and similar tools every day, and our AI team is building tools that depend on clean, well-governed data. You'll be the person who makes that data ready.
  • Real ownership on a small team. You'll work directly with the development, AI and IT teams. Decisions don't sit in a queue, and your work shows up in the business quickly.
  • Modern and legacy, side by side. You'll learn and support the systems that run the business today while building what replaces them, so nothing gets lost along the way.

Responsibilities

  • Own the company's data model across SQL Server and Dataverse, and define the target model for our Dynamics 365 CRM before data is migrated into it.
  • Plan and run data cleanup and migration: one trusted ID for each account, property, utility and contact, clear matching and dedupe rules, and intake checks that stop bad data from coming back.
  • Plan, design and build data flows and integrations between SQL Server, Dataverse, SharePoint, finance systems and our AI platform, using APIs, Azure services and Power Automate.
  • Protect the data: design and maintain permissions for staff, clients, auditors and AI tools across SQL Server, Dataverse, SharePoint and Entra ID.
  • Own the reporting data layer, including Power BI semantic models and the history tracking we need to measure cycle times and outcomes.
  • Support and maintain our existing applications and databases during the transition, so the business keeps running while the new platform comes online.
  • Bring production integrations under standard controls: source control, code review, test environments and documentation.
  • Use AI-assisted tools (Claude Code, GitHub Copilot, Cursor or similar) as a normal part of your work for SQL, pipelines, testing and documentation.
  • Track all work in JIRA, with estimation and task breakdown before development begins, and write documentation as part of delivery.

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.

Demand for Data Leadership roles

New Data Leadership postings at the employers we follow are up 8% over the last 6 weeks compared with the 6 before.

Weekly new Data Leadership postings at the same employers, from the week of August 17 to the week of November 9. The fewest in a week was 751, the most 1,165, and the latest week had 775.
August 17Last week

Each bar is one week of new postings. The darkest bars are the last 6 weeks.

Counted from the hiring pages we’ve followed for at least five weeks, so employers we add don’t look like growth. Updated weekly.

About the role

We file this job under Data Leadership, by the work the posting describes.

Data leaders run data teams or design how a company's data fits together. Managers hire, set priorities and answer for whether the data work pays off; architects choose the systems and the shape of the data.

Expect years of hands-on data work, experience leading people or projects, and the ability to explain tradeoffs to executives.

Unlike a senior engineer or analyst, most of a data leader's week goes to people, planning and decisions rather than building.

US government figures for computer and information systems managers

Median yearly pay, May 2025
$175,140
Expected change, 2025 to 2035
15.8% more jobsagainst 3.5% for all jobs

The government has no code for data leaders, so these figures are for the closest group, computer and information systems managers, which includes data processing and data operations managers.

Source: US Bureau of Labor Statistics, Occupational Employment and Wage Statistics (May 2025) and Employment Projections (2025 to 2035). Occupation code 11-3021.

Source details

View original posting ↗

Source notes

Source excerpts

Selected passages from the saved posting. Check the full description for conditions and exceptions.

Pay

No pay amount identified in the saved description.

Location & working pattern

New York, United States

● 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
Work authorization

No clear work-authorization passage found. Eligibility is unconfirmed.

Find answers in the posting

AI
How answers work

AI selects complete passages from this posting. Check them for conditions and exceptions.

Uses this posting and your question. No profile needed.