Here’s a more anonymized, less reverse-searchable version with the company name removed and the structure lightly reorganized while keeping the role intact:
Location: Austin, TX (Hybrid)
Schedule: Full-time | Hybrid (2–3 days onsite)
Work Authorization Notice
At this time, sponsorship is not available for this position. Candidates must have current, unrestricted authorization to work in the country where the role is based.
About the Company
We are a fast-growing SaaS business serving multiple vertical markets with a broad portfolio of software applications. Headquartered in Austin, the organization is scaling rapidly and is focused on operational excellence, customer success, and continuous improvement. The team is building a modern data foundation to support the next phase of growth.
About the Role
We are seeking a strategic and highly skilled Data Architect to support implementations on the Microsoft Dynamics 365 platform. This role will design and govern data migration, integration architecture, and CRM data models that enable scalable, reliable, and efficient onboarding outcomes. You will partner cross-functionally with Onboarding, Product, Engineering, and Analytics teams to protect data integrity, reduce implementation risk, and support long-term platform scalability.
Responsibilities
- Assess client data readiness by evaluating source systems, data quality, and migration complexity during early implementation phases.
- Define cleansing, transformation, and validation frameworks to improve migration success rates.
- Partner with Implementation Project Managers and Solution Consultants to ensure data architecture supports delivery timelines.
- Build standardized migration playbooks, mapping templates, and reusable ETL frameworks to accelerate onboarding.
- Design and maintain conceptual, logical, and physical data models within Microsoft Dynamics 365.
- Document data architecture standards, integration patterns, and governance best practices.
- Architect and oversee ETL processes using SSIS and other standard tools.
- Design integrations using KingswaySoft and/or Pentaho Data Integration.
- Lead data migration strategy and execution support for implementation projects.
- Identify data dependencies, risks, and integration gaps early in the delivery lifecycle.
- Ensure secure, scalable, 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 support reporting accuracy, consistency, and data integrity.
- Develop reusable integration templates, migration accelerators, and standardized data patterns.
- Identify systemic data design issues and recommend improvements to reduce rework and onboarding delays.
- Use AI-enabled tools to analyze source system structures, identify data quality risks, and support scalable migration and integration architectures.
- Maintain documentation of data flows, mappings, transformations, and integration logic.
Qualifications
- 5+ years of experience in Data Architecture, Data Engineering, or a related field.
- 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 without direct authority.
- Experience in client-facing consulting or professional services environments.
- Ability to explain complex data architecture concepts to non-technical stakeholders.
Preferred Experience
- Knowledge of Microsoft Azure data services such as Azure Data Factory or Azure SQL.
- Experience migrating data from legacy CRM/AMS systems and non-normalized sources.
