Job Title : Data Management Specialist / Senior Data Architect
Remote
Duration : One Year Contract with possibility of extensions
Position Summary :
IRG Clients is seeking an experienced Data Management professional to support data cleansing, migration, and modeling efforts as part of the modernization of its legacy case management system to a new cloud-based solution. This role will also contribute to the design and implementation of agency's cloud-based data stack to strengthen data analytics The position reports to the Lead Architect within the Data Management Team (DMT).
Key Responsibilities :
- Support data migration, cleansing, and architecture activities for the new system.
- Identify and manage data-related risks, issues, and gaps.
- Design and document source and target data architectures for applications and analytics platforms.
- Develop ETL architecture, data pipelines, and technical work packages.
- Create and maintain data models, ER diagrams, data dictionaries, and semantic models.
- Improve data quality and master data management processes.
- Define business rules for complex metrics and support analytics model development.
- Plan and implement data catalogues and metadata management within the cloud data stack.
- Collaborate with cross-functional teams to ensure accuracy, consistency, and accessibility of data.
Required Skills and Experience :
Minimum 8 years of experience in multidimensional database design, ETL design, and development.Minimum 8 years in data quality and master data management integration.Minimum 8 years in ERD creation, data dictionary, and schema mapping.Minimum 8 years in data analytics implementation projects.Minimum 3 years of experience with cloud-based data stack tools and platforms.Strong communication and documentation skills in English.Preferred Qualifications :
Experience in Child Welfare data modeling and case management analytics..Strong teamwork, communication, and knowledge-sharing abilities.