Associate Data Architect II

UST Global Inc

Mill Creek, WA

Apply

JOB DETAILS

SALARY

$122,000–$183,000 Per Year

JOB TYPE

Full-time, Employee

SKILLS

Application Programming Interface (API), Best Practices, CRM Integration, Customer Relationship Management (CRM), Customer Relationship Management (CRM) Systems, Data Analysis, Data Lake, Data Management, Data Mapping, Data Migration, Data Modeling, Data Quality, Data Structures, DataArchitect Data Modeling Tool, Database Design, Diversity, ERP (Enterprise Resource Planning), Information/Data Security (InfoSec), Leadership, Maintain Compliance, Marketing, Microsoft Certifications, Microsoft Dynamics, Microsoft Dynamics CRM, Microsoft SQL Server, Microsoft Windows Azure, Microsoft Windows CE Operating System, Migration Strategy, Performance Tuning/Optimization, Printed Circuit Board Design, Quality Management, Query Analysis, REST (Representational State Transfer), Reconciliation, Regulatory Requirements, SQL Server Integration Services (SSIS), Sales, Siebel, System Migration, Technical Leadership, User Documentation

LOCATION

Mill Creek, WA

POSTED

30+ days ago

Role description

Microsoft Dynamics CRM (D365 CE) Data Architect

Experience

12+ years of overall experience with 5+ years in Microsoft Dynamics CRM / Dynamics 365 Customer Engagement data architecture roles

Role Summary

The Dynamics CRM Data Architect is responsible for defining, designing, and governing the data architecture, migration strategy, and integration patterns for Microsoft Dynamics 365 CE solutions. The role ensures data integrity, scalability, performance, and compliance across CRM implementations, upgrades, and transformation programs.

Key Responsibilities

Data Architecture & Design

Design end to end data architecture for Dynamics 365 CE, including entities, relationships, and data models
Define master data, transactional data, and reference data structures across CRM modules
Establish data standards, naming conventions, and governance models
Review and validate CRM schema designs created by development teams

Data Migration & Data Quality

Define and execute data migration strategies from legacy systems (e.g., SFDC, Siebel, custom CRMs) into D365 CE
Lead data migration using Data Migration Jobs, SSIS / KingswaySoft, staging databases
Perform data mapping, transformation rules, cleansing, and validation
Ensure reconciliation, auditability, and post migration data accuracy

Integration & Data Movement

Design and govern CRM integrations with upstream/downstream systems
Define patterns using REST APIs, OData, Azure Functions, Logic Apps, Service Bus
Ensure data consistency across CRM, ERP, analytics, and external platforms

Performance, Security & Governance

Optimize CRM data performance (indexes, bulk operations, async processing)
Define data security models, field level security, and access strategies
Ensure compliance with enterprise data governance, audit, and regulatory requirements

Collaboration & Leadership

Work closely with CRM Architects, Technical Leads, Functional Consultants, and Business SMEs
Guide developers on data modeling best practices and migration approach
Participate in architecture review boards and design walkthroughs
Support release planning, cutover, and hyper care phases

Mandatory Technical Skills

Microsoft Dynamics 365 CE / CRM (Sales, Service, Marketing)
Data modeling and CRM entity design
SQL Server, complex queries, and data analysis
SSIS / KingswaySoft for CRM data migration
CRM SDK / Web APIs / OData
Azure integration services (Functions, Logic Apps, Service Bus)
Experience with large scale data migration and transformation programs

Good to Have

Experience migrating from SFDC or legacy CRM platforms
Power Platform data integration exposure
Azure Data Factory / Data Lake exposure

Microsoft certifications: MB 200, MB 400, PL 400

Skills
data architecture,data integration,data governance,data quality management,
Benefits
Compensation range: $ 122,000.00 to 183,000.00 per year

UST Global celebrates diversity and inclusion. We are an Equal Employment Opportunity employer. We welcome candidates to apply for employment from diverse backgrounds and believe your unique perspective adds to the richness of our company culture. We do not discriminate based upon race, religion, color, national origin, sex (including pregnancy, childbirth, or related medical conditions), sexual orientation, gender identity, gender expression, age, status as a protected veteran, status as an individual with a disability, or other applicable legally protected characteristics.

About the Company

UST Global Inc

Resume Resources

Free Resume Templates Free Resume Builder