Database Architect

Overview

Allied Consultants, Inc. is an Austin-based firm which has for 33 years been a premier provider of technical and business professionals to clients in Texas. We are currently seeking an experienced Database Architect to be a key resource on a technical services team.

 

Allied Consultants offers its family of consultants excellent rates, a local support staff, and an attractive benefits package which includes medical insurance (Allied shares a percentage of the cost), life insurance, a matching 401(k) plan and a cafeteria plan.Candidates selected for interview will be required to undergo criminal background checks and may be required to complete a drug screen in accordance with Federal and State Law.  Offers of Employment are contingent on a successful background checkAllied Consultants is an equal opportunities employer.

Responsibilities

The client of Texas is seeking the services of an experienced and knowledgeable Enterprise Information Management (EIM) Subject Matter Expert (SME). The EIM SME will focus on the strategy for ensuring the quality of enterprise master data and preparing client for its future-state data management and analytics platform. The SME will also assist in the development and implementation of a data archiving strategy and support the data warehousing strategy for client’s evolving data infrastructure.

 

This role will include responsibilities in two primary areas:

• Master Data Strategy – Maintaining and refining the existing master data strategy, with a focus on the Person domain and governance.
• Future-State Data Strategy – Supporting the data strategy assessment and roadmap development for client’s future data management platform.
• Data Archive Strategy – Assisting in the development and execution of client's data archiving strategy to ensure long-term data storage and compliance.

The role will also oversee the transition between the assessment vendor engagement and subsequent implementation, ensuring seamless continuity and readiness for future data management practices.

 

FUNCTIONAL RESPONSIBILITIES

Master Data Strategy:

• Governance and Stewardship:
  • Support and refine the Person domain master data strategy, emphasizing governance, stewardship, and best practices.
  • Ensure compliance with data standards, policies, and processes to maintain consistency across systems.
• Best Version of the Truth (BVoT):
  • Oversee the continued development of processes for identifying and maintaining a “best identity” for each person within the master data system.
  • Ensure integration and synchronization of master data across applications and systems.
• Data Quality and Integration:
  • Monitor and address data quality issues within the Person domain, including matching, merging, and deduplication processes.
  • Collaborate with internal stakeholders to ensure the master data strategy aligns with organizational needs and policies.

Preparation for Vendor Engagement:

• Develop and document metadata collection and cataloging processes, identifying data assets, categorizing them by role in supporting the client's mission, and specifying metadata requirements (e.g., quality, business context, and analytics applicability).
• Support the definition of scope and requirements for the data strategy assessment and roadmap vendor engagement.

Data Archiving Strategy:

• Advise and assist on strategy for archiving data not intended for migration to the future-state pension and benefits administration platform.
• Define/Document policies and tools to manage legacy data storage and retrieval.
• Integrate the archive strategy into the vendor engagement scope.

Gap Analysis and Readiness:

• Post-roadmap assessment, create plans to address critical gaps identified by the vendor that could impede roadmap implementation.
• Oversee pre-implementation initiatives to ensure readiness before transitioning to the implementation phase

Scope of Work Development:

• Collaborate with stakeholders to develop a comprehensive Scope of Work (SOW) for onboarding the implementation vendor.
• Ensure the SOW includes detailed requirements, deliverables, and milestones for executing the roadmap.

Ongoing Duties:

• Metadata and Data Catalog Implementation:
  • Implement metadata management and cataloging strategies across all phases, ensuring alignment with organizational goals.
• Collabo