Data Architect

OmegaFi; Columbus (GA); Hybrid; USD 100,000 - 130,000; Full time

Benefits offered by this job

Medical, dental and vision insurance options

401(k) with company match

Flexible paid personal and vacation time

Pet Insurance

Job summary

In a hybrid work model, you will collaborate with various teams to ensure data quality and optimize integration processes within the company structure.

Qualifications

• 5+ years of experience in Data Architecture or related roles.
• Strong experience with Microsoft Dynamics 365 systems.
• Hands-on expertise with SQL Server and advanced SQL querying.

Responsibilities

• Conduct client data readiness assessments and evaluate source systems.
• Define data cleansing and transformation frameworks.
• Design and maintain data models within Microsoft Dynamics 365.

Skills

Data Architecture experience

SQL Server expertise

ETL processes expertise

Microsoft Dynamics 365 knowledge

Data modeling skills

Analytical skills

Communication skills

Education

Bachelor’s degree

Tools

SSIS

KingswaySoft

Pentaho Data Integration

Job description

Data Architect

Location: Austin, TX (hybrid)

Schedule: Full-time | Hybrid (2–3 days in office)

Work Authorization Notice

At this time, we are unable to provide immigration sponsorship for this position. Candidates must have current, unrestricted authorization to work in the country where the role is based.

About Us

Togetherwork is a $250M recurring revenue SaaS business with more than 33 software applications serving over 12 vertical markets. We help communities, organizations, and businesses thrive by delivering purpose‑built software that supports their missions and operations.

Headquartered on South Congress in Austin, TX, Togetherwork is scaling rapidly. We are customer‑focused, execution‑driven, and committed to operational excellence. Our teams value accountability, collaboration, and continuous improvement. We are building a modern data foundation to support our next phase of growth.

About This Role

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.

What You’ll Do

• 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.

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 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.

Preferred

• Knowledge of Microsoft Azure data services (Azure Data Factory, Azure SQL or related).
• Experience migrating data from legacy CRM/AMS systems and non‑normalised data sources.

Why You’ll Love Working Here

At Togetherwork, we help community‑driven organizations grow and thrive—creating better experiences for the people they serve. You will play a critical role in shaping the enterprise data foundation that powers our TW28 vision.

We are guided by values that shape how we work every day:

• Obsess over our customers
• Own it. Together.
• Move fast with purpose

Benefits

• Medical, dental and vision insurance options
• 100% Employer paid short and long term disability
• Basic Life
• 401(k) option with 100% company match up to 4%
• Flexible paid personal and 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 and Engagement Platform

Inclusion and Diversity

Togetherwork is an Equal Employment Opportunity Employer. We are a company where diverse backgrounds, experiences and viewpoints are valued. Togetherwork does not make hiring or employment decisions on the basis of race, color, religion, gender, gender identity, sex, sexual orientation, disability, veteran status, age, ethnic or national origin or any other basis protected by all local, state or federal laws.