Data Architect

Role: Data Architect

Scope of Work:

This projects include implementing a data retention policy, addressing duplicate data across systems, and improving configuration management. With the agency's transition from on-premises Accela to a cloud-based Microsoft Dynamics 365 platform, a dedicated Data Architect is required to ensure scalability, compliance, and operational continuity as well as cost savings in terms of storage.

The consultant will operate across multiple initiatives directly tied to CRM and its related database systems, ensuring that data governance, architecture, and integration strategies are consistently applied. By bridging these interconnected issues, the Data Architect will maintain a unified architectural vision that supports both immediate needs and long-term modernization.

Objectives:

• Provide strategic support across CRM and its associated databases, ensuring solutions are aligned with agency modernization goals.
• Develop and implement a data retention and archival strategy to reduce storage costs and ensure compliance.
• Architect solutions for duplicate data cleanup across Business Automation (BA) and AIMS systems, enforcing master data management principles.
• Support configuration management improvements by aligning data governance with CRM and infrastructure needs.
• Deliver documentation and knowledge transfer to ensure sustainability beyond the consultant's engagement.

Role Description:

The Data Architect will join Client technical team to design and implement data strategies across CRM and its related database systems.

Responsibilities include:

• Enterprise data modeling and metadata management.
• Designing archival frameworks for CRM and AIMS data.
• Collaborating with CRM and infrastructure teams to align configuration management with governance standards.
• Leading deduplication and master data management initiatives.
• Preparing documentation and conducting knowledge transfer sessions for staff.

Qualifications:

The consultant must demonstrate significant experience in enterprise data architecture, with emphasis on Microsoft Dynamics CRM and its related database systems. Final selection will be based on interviews and demonstrated expertise.

Preferred qualifications include:

• • Extensive experience (8+ years) in enterprise data architecture, data governance, and metadata management.
  • Proven ability to design and implement data retention and archival strategies for large-scale systems.
  • Strong knowledge of CRM data structures and integration with external systems.
  • Familiarity with master data management and deduplication strategies.
  • Effective communication and stakeholder engagement skills to support cross-divisional initiatives. Equivalent experience may be considered.