Data Architect, Togetherwork

• 5+ years of experience in Data Architecture, Data Engineering, or related roles
• Strong experience with Microsoft Dynamics 365 and CRM data structures
• Hands-on expertise with SQL Server and advanced SQL querying
• Proven experience with SSIS and enterprise ETL development
• Experience with KingswaySoft and/or Pentaho Data Integration
• Strong background in data modeling and multi-system integration architecture
• Ability to evaluate architectural tradeoffs in complex environments
• Experience supporting SaaS, professional services, or enterprise implementations
• Bachelor’s degree from an accredited college or university, or equivalent experience
• Strong analytical, problem-solving, and systems-thinking skills
• Excellent written and verbal communication skills
• Ability to influence cross-functional stakeholders without direct authority
• Experience working in client-facing consulting or professional services environments
• Ability to explain complex data architecture concepts to non-technical stakeholders

Desirable

• Togetherwork is seeking a highly skilled and strategic Data Architect to support Protech implementations on the Microsoft Dynamics 365 platform
• In this role, you will design and govern data migration, integration architecture, and CRM data models that enable scalable, reliable, and efficient onboarding outcomes
• You will collaborate cross-functionally with Onboarding, Product, Engineering, and Analytics teams to ensure data integrity, reduce implementation risk, and support long-term platform scalability
• Conduct client data readiness assessments, evaluating source systems, data quality, and migration complexity during early implementation phases
• Define data cleansing, transformation, and validation frameworks to improve migration success rates
• Partner with Implementation Project Managers and Solution Consultants to ensure data architecture supports predictable delivery timelines
• Establish standardized migration playbooks, mapping templates, and reusable ETL frameworks to accelerate onboarding and reduce implementation risk
• Design and maintain conceptual, logical, and physical data models within Microsoft Dynamics 365 (Protech)
• Define and document data architecture standards, integration patterns, and governance best practices
• Architect and oversee ETL processes using SSIS and other standard ETL tools
• Design and implement integrations leveraging KingswaySoft and/or Pentaho Data Integration
• Lead data migration strategy and execution support for onboarding and implementation projects
• Identify data dependencies, risks, and integration gaps early in the delivery lifecycle
• Ensure secure, scalable, and high-performance data exchange between D365 and external systems
• Collaborate with Product and Engineering to assess the architectural impact of platform enhancements
• Partner with Analytics teams to ensure reporting accuracy, consistency, and data integrity
• Develop reusable integration templates, migration accelerators, and standardized data patterns
• Proactively identify systemic data design issues and recommend improvements to reduce rework and onboarding delays
• Utilize AI-enabled tools to analyze source system data structures, identify data quality risks, and support scalable migration and integration architectures
• Maintain clear documentation of data flows, mappings, transformations, and integration logic