Key skills
ETLSQLSSISAIData EngineeringAnalyticsSQL ServerSaaSCRMCommunication
About this role
Role Overview
- 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
- 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.
Tech Stack
- ETL
- SQL
- SSIS
Benefits
- 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