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
11 days ago
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
U