Data Architect

This is a fully remote position, open to applicants in New York.

📋 Description

• Design and take ownership of the company's data model across SQL Server and Dataverse.

• Establish the target data model for Dynamics 365 CRM prior to migration.

• Plan and implement data cleanup and migration strategies, including trusted IDs, matching, deduplication, and intake validation.

• Create and develop data flows and integrations among SQL Server, Dataverse, SharePoint, finance systems, and the AI platform.

• Utilize APIs, Azure services, and Power Automate for integration processes.

• Design and manage access permissions across SQL Server, Dataverse, SharePoint, and Entra ID.

• Oversee the reporting data layer, which includes Power BI semantic models and history tracking.

• Provide support and maintenance for existing applications and databases during the transition phase.

• Bring production integrations under version control, code review processes, testing environments, and documentation standards.

• Employ AI-assisted tools such as Claude Code, GitHub Copilot, and Cursor for SQL, pipelines, testing, and documentation purposes.

• Monitor tasks in JIRA, including estimation and task breakdown prior to development.

• Create documentation as part of the delivery process.

• Collaborate closely with development, AI, and IT teams as the company transitions to an AI-enabled Microsoft workspace.

⛳️ Requirements

• Minimum of 5 years experience in data engineering, data architecture, or database development.

• Strong practical experience with SQL Server: T-SQL, schema design, and performance optimization.

• Familiarity with Dataverse or the Dynamics 365 data model, including tables, relationships, keys, and security roles.

• Experience building and supporting production integrations using REST APIs, Azure Data Factory, Azure Functions, Power Automate, or similar technologies.

• Expertise in data modeling and data quality, including legacy database migration, matching and deduplication rules, and maintaining a single source of truth.

• Knowledge of data security practices, such as role-based access and permissions across databases, Microsoft 365, SharePoint, and Entra ID.

• Proficiency in Power BI data modeling, including semantic models and DAX.

• Working knowledge of Microsoft 365 and SharePoint, focusing on libraries, metadata, permissions, and the Graph API.

• Proven hands-on experience using AI-assisted development tools in real-world projects; preference for Claude Code, with Copilot, Cursor, or similar tools accepted.

• Ability to plan data flows and articulate them clearly in both written and verbal formats to both technical and non-technical stakeholders.

• Comfortable working autonomously within a small, fully remote team environment.

• Experience with C#/.NET, particularly in legacy applications, is preferred.

• Proficiency in Python for data-related tasks is preferred.

• Experience in utility, energy, or billing data is preferred.

• Familiarity with integrations involving QuickBooks Online or other finance systems is preferred.

• Microsoft certifications such as PL-600 or DP-600 are preferred.

🏝️ Benefits

• Performance-based annual bonus.

• 401(k) plan with company matching.

• Health, dental, and vision insurance.

• Flexible spending accounts.

• Paid time off.

• 11 paid holidays.