> Markdown version of [/jobs/ext/3538229-data-architect](https://www.wearedevelopers.com/jobs/ext/3538229-data-architect). Every page supports `.md` or `Accept: text/markdown`. Links point to the HTML versions so they work for humans too. Agent guide: [/agents.md](https://www.wearedevelopers.com/agents.md).

---

# Data Architect

- **Company:** City of Weimar
- **Location:** New York, NY, United States (Remote available)
- **Experience:** Expert
- **Salary:** $95,000.0 - $110,000.0
- **Contract:** Permanent contract
- **Skills:** Legacy Database, .NET Framework, Microsoft Windows, Application Programming Interfaces (APIs), Artificial Intelligence, JIRA, Microsoft Azure, C Sharp (Programming Language), Code Review, Databases, Data Architecture, Information Engineering, Data Hub, Data Security, Cursor, Database Development, Microsoft Dynamics CRM, Metadata, Microsoft Dynamics, Microsoft SQL Server, Performance Tuning, QuickBooks (Software), Power BI, Microsoft Copilot, Microsoft SharePoint, SQL Databases, Data Streaming, Systems Integration, Transact-SQL, Microsoft Power Automate, Azure Data Factory, GitHub Copilot, Claude Code, Build Management, AI Platforms, Graphql, Restful APIs, Software Version Control, Serverless Computing
- **Published:** October 2, 2026
- **Apply:** https://www.careerjet.com/jobad/us4f299691c3d5792243ac2188a601cc6e

## About the Role

* 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.

## Description

* 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., Title - AI Data Architect Location: NYC, NY | Remote | Contract Although this role is remote they are looking for candidates in NY or as far as NJ, CT, or PA. This role will requ…
 + 13 days ago
+