Sr. CRM Data Integration Lead

Connsci
  • Gaithersburg, MD
  • Full-time
  • Quick Apply
10 days ago

Job Description

Connsci is seeking a Senior CRM Data Migration & Integration Lead to join our growing organziation in support of one of our government customers. This individual will own the integrity of the data conversion from legacy Microsoft Dynamics CRM to the modernized Dataverse-based CRM and lead delivery of two automated intake capabilities: public website submissions and designated email inboxes. This role is accountable for migration accuracy, reconciliation, SharePoint and document-reference continuity, secure integration design, production deployment, monitoring, and operational support. The ideal candidate is a senior, hands-on delivery lead who can move complex data safely and build reliable integrations for sensitive records.Key ResponsibilitiesLead end-to-end CRM data conversion. Profile legacy entities, fields, data quality, duplicates, attachments, history, cross-instance relationships, shared contacts, reporting dependencies, and other migration constraints across the current Dynamics environment.Own migration design and execution. Create source-to-target mappings, transformation and cleansing rules, deduplication logic, migration plans, rehearsal cycles, reconciliation methods, exception remediation, cutover steps, and rollback inputs.Validate SharePoint and records dependencies. Verify and remediate CRM-to-SharePoint links, document references, attachments, metadata, URLs, and downstream dependencies so document continuity is maintained after migration.Prove migration quality and performance. Produce reconciliation evidence, exception reports, validation results, performance benchmarks, operational runbooks, and cutover/rollback materials required for production readiness.Build secure automated website intake. Design, develop, test, and deploy automated public website submission intake using secure authentication, encryption in transit and at rest, validation, field mapping, configurable import rules, confirmation logging, error handling, retries, monitoring, and rollback.Build secure automated email intake. Implement equivalent automated ingestion from designated email inboxes, including mailbox integration methods, data flows, field mappings, exception logic, administrative controls, monitoring, and troubleshooting.Deliver production-grade integrations. Deploy solutions through test, UAT, and production environments and support unit, system, integration, security, performance, and user-acceptance testing.Own integration documentation and supportability. Create architecture and integration designs, technical/configuration specifications, test plans and results, user/admin documentation, go-live and rollback plans, monitoring guidance, and post-implementation reports.Partner across the delivery team. Coordinate data model, security, deployment, and operational decisions with the Power Platform Solution & Security Lead and Program Manager, and communicate risks, dependencies, and remediation plans clearly to stakeholders. Our Ideal Candidate Will HavePrior experience supporting government, inspector general, audit, investigation, complaint, or other regulated case-management environments.Strong data-quality and release discipline, including reconciliation evidence, test plans/scripts/results, deployment checklists, rollback procedures, runbooks, performance validation, and post-deployment support.Practical experience handling sensitive or restricted data with appropriate access controls, audit trails, records-retention considerations, and secure data exchange.Ability to lead technical discussions, document designs precisely, work through complex exceptions, and support business users through UAT and production stabilization. Required QualificationsAt least 10 years of experience migrating enterprise CRM data including profiling, extraction, mapping, cleansing, transformation, deduplication, rehearsal, reconciliation, and cutover.At least 5 years of experience migrating data from Microsoft Dynamics CRM or comparable enterprise CRM to Dataverse / Microsoft Power Platform.At least 5 years of experience validating or remediating SharePoint links, attachments, metadata, document references, and related content dependencies during a CRM or case-management migration.At least 5 years of experience with secure APIs, public web-form integrations, and mailbox/message ingestion, including authentication, encryption, validation, error handling, retry logic, exception queues, audit logging, monitoring, and operational troubleshooting.At least 1 year of experience with Dataverse integration patterns and Microsoft integration technologies such as Microsoft Graph, Logic Apps, Azure Functions, API Management, or comparable services. Preferred QualificationsRelevant Microsoft Power Platform and/or Azure certifications.5+ years of experience designing high-reliability intake solutions where incoming records must be traceable, recoverable, auditable, and processed without manual intervention. About ConnsciAt Connsci, our mission is to be a trusted strategic partner for our clients, helping them achieve impactful results by addressing mission-critical issues that affect their bottom line. We recognize the importance of customizing our services to best fit our clients' needs and understanding what it takes to propel their organizations forward. By implementing industry-leading best practices and leveraging our multifaceted experience and expertise, we deliver services that are essential for any organization aiming to reach its goals. What You Can Expect:Collaboration and Innovation: Work in an environment where collaboration and innovation are key. You'll have the opportunity to contribute to projects that make a real difference for our clients.Professional Growth: Be part of a team that values professional development. We offer opportunities for growth and advancement, allowing you to enhance your skills and career.Impactful Work: Engage in meaningful work that addresses mission-critical issues and supports organizations in achieving their goals.By joining Connsci, you'll become part of a dedicated team that is committed to delivering strategic, impactful solutions tailored to our clients' unique needs, enabling them to achieve their goals with confidence and efficiency. If you're passionate about cybersecurity and IT services, and eager to contribute to a dynamic team, we encourage you to explore opportunities with us.At this time, Connsci will not sponsor a new applicant for employment authorization for this position.  Connsci is an equal opportunity employer that is committed to diversity and inclusion in the workplace. We prohibit discrimination and harassment of any kind based on race, color, sex, religion, sexual orientation, national origin, disability, genetic information, pregnancy, or any other protected characteristic as outlined by federal, state, or local laws.  This policy applies to all employment practices within our organization, including hiring, recruiting, promotion, termination, layoff, recall, leave of absence, compensation, benefits, training, and apprenticeship. Connsci makes hiring decisions based solely on qualifications, merit, and business needs at the time.

Numbers & Facts

LocationGaithersburg, MD
Job TypeFull-time

Skills

  • Acceptance Testingunmatched
  • Access Controlunmatched
  • Administrator Documentationunmatched
  • Application Programming Interface (API)unmatched
  • Authenticationunmatched
  • Benchmarkingunmatched
  • Best Practicesunmatched
  • Business Supportunmatched
  • CRM Integrationunmatched
  • Case Managementunmatched
  • Channel Strategiesunmatched
  • Continuous Integrationunmatched
  • Cryptographyunmatched
  • Customer Relationship Management (CRM)unmatched
  • Data Migrationunmatched
  • Data Modelingunmatched
  • Data Qualityunmatched
  • Diversityunmatched
  • Documentation Designunmatched
  • Email Softwareunmatched
  • Error Handlingunmatched
  • Field Mappingunmatched
  • Governmentunmatched
  • High Reliabilityunmatched
  • Identify Issuesunmatched
  • Information/Data Security (InfoSec)unmatched
  • Integration Testingunmatched
  • Internet Securityunmatched
  • Leadershipunmatched
  • Metadataunmatched
  • Microsoft Dynamics CRMunmatched
  • Microsoft Product Familyunmatched
  • Microsoft SharePointunmatched
  • Microsoft Windows Azureunmatched
  • Operational Supportunmatched
  • Production Controlunmatched
  • Production Supportunmatched
  • Production Systemsunmatched
  • Project/Program Managementunmatched
  • Reconciliationunmatched
  • Risk Managementunmatched
  • Service Deliveryunmatched
  • Support Documentationunmatched
  • System Integration (SI)unmatched
  • System Migrationunmatched
  • Team Playerunmatched
  • Technical Supportunmatched
  • Technical Writingunmatched
  • Technical/Engineering Designunmatched
  • Test Automationunmatched
  • Test Plan/Scheduleunmatched
  • Test Scriptsunmatched
  • Testingunmatched
  • Web Designunmatched
  • Web Formsunmatched

Be found by employers

5,500+ employers search our resume database daily. Add yours to get found by recruiters looking for candidates like you.

Level up your application

Professional resume templates

Browse dozens of recruiter approved resume templates, layouts and formats. Choose your favorite and make it your own in minutes.

Free resume templates

Free resume builder

Improve your existing resume or start from scratch and create a standout, ATS-friendly resume. Add job-specific content, download and apply.

Free resume builder