Data Architect

Togetherwork

Data Architect supporting Protech implementations on Microsoft Dynamics 365 platform. Collaborating cross-functionally to ensure data integrity and scalable onboarding outcomes.

Posted 6/11/2026full-timeRemote • 🇺🇸 United StatesMid-LevelSeniorWebsite

Tech Stack

Tools & technologies

ETLSQLSSIS

About the role

Key responsibilities & impact

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.

Requirements

What you’ll need

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.

Benefits

Comp & perks

Medical, dental, and vision insurance options
100% Employer paid short/long term disability
Basic Life
401(k) option with 100% company match up to 4%
Flexible paid personal/vacation time built on mutual trust and accountability
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

ATS Keywords

✓ Tailor your resume

Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools

data architecturedata engineeringSQL Serveradvanced SQL queryingSSISETL developmentdata modelingdata transformationdata validationdata migration

Soft Skills

analytical skillsproblem-solving skillssystems-thinking skillswritten communicationverbal communicationinfluencing skillsclient-facing skillscross-functional collaborationability to explain complex conceptsorganizational skills

Certifications

Bachelor's degreedata architecture certificationdata engineering certification