Data Architect - Remote

About Us

Togetherwork is a $250M recurring revenue SaaS business with over 33 software applications serving more than 12 vertical markets. We empower communities, organizations, and businesses by delivering purpose-built software that supports their missions and operations. Headquartered in Austin, TX, Togetherwork is experiencing rapid scaling, driven by a customer-focused approach, execution excellence, and a commitment to continuous improvement. We are actively building a modern data foundation to support our next phase of growth.

About the Role

Togetherwork is looking for a highly skilled and strategic Data Architect to support Protech implementations on the Microsoft Dynamics 365 platform. Your primary responsibilities will include designing and governing data migration, integration architecture, and CRM data models to ensure scalable, reliable, and efficient onboarding outcomes. You will collaborate cross-functionally with Onboarding, Product, Engineering, and Analytics teams to maintain data integrity, reduce implementation risks, and support long-term platform scalability.

What You’ll Do

• Conduct client data readiness assessments, evaluating source systems, data quality, and migration complexity.
• Define data cleansing, transformation, and validation frameworks to enhance migration success.
• Partner with Project Managers and Solution Consultants to align data architecture with delivery timelines.
• Establish standardized migration playbooks, mapping templates, and reusable ETL frameworks.
• 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 using 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 on 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.
• Utilize AI-enabled tools to analyze source system data structures, identify data quality risks, and support scalable architectures.
• Maintain clear documentation of data flows, mappings, transformations, and integration logic.

What You’ll Bring

• 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 or equivalent experience.
• Strong analytical, problem-solving, and systems-thinking skills.
• Excellent written and verbal communication skills.
• Ability to influence cross-functional stakeholders.
• Experience in client-facing consulting or professional services.
• Ability to explain complex data architecture concepts to non-technical stakeholders.

Preferred Qualifications

• Knowledge of Microsoft Azure data services (Azure Data Factory, Azure SQL, etc.).
• Experience migrating data from legacy CRM/AMS systems and non-normalized data sources.

Why You’ll Love Working Here

At Togetherwork, we help community-driven organizations grow and thrive. You will play a critical role in shaping the enterprise data foundation that powers our vision. We are guided by values: Obsess over our customers, Own it. Together., Move fast with purpose.

Benefits

• Medical, dental, and vision insurance options
• 100% Employer paid short/long-term disability
• Basic Life insurance
• 401(k) with 100% company match up to 4%
• Flexible paid personal/vacation time
• 10 sick days annually
• 10 company-paid holidays
• 6 weeks paid parental leave
• Pet Insurance
• Medical Travel Benefits
• Infertility Benefits
• Teladoc
• Employee Assistance Program
• Wellness Benefits & Engagement Platform

Inclusion and Diversity

Togetherwork is an Equal Employment Opportunity Employer. We value diverse backgrounds, experiences, and viewpoints.

Interview Process & Expectations

Interviews are interactive and conversational. Candidates are expected to respond based on their own experience and thinking. The use of real-time AI tools or external assistance during live interviews is not permitted.