Data Architect - Intermediate

The successful candidate is expected to have a broad skill set and be capable of performing diverse functions and activities, including but not limited to :

• Understanding of data warehouse design principles, including dimensional modeling, star schemas, snowflake schemas, and the use of conformed dimensions to ensure consistency across data marts.
• Create both logical and physical data models that efficiently store data and support business processes.
• Support the development and adoption of best practices for data management, integration and common data management, and standardized methodologies.
• Contribute to development of individual data architectures and data quality practices, as needed, to support business objectives.
• Work with datasets using ETL (Extract, Transform, Load) tools and techniques for integrating data from various sources into the EDW.
• Interact with clients / partners (GOA-internal and / or external).

Duties :

• Design the data architecture, including the EDW structure, data marts, and conformed dimensions, to support reporting and analytical needs.
• Develop logical and physical data models for the EDW and data marts, ensuring they are optimized for performance and aligned with business processes.
• Plan and oversee the integration of data from various sources into the EDW, designing ETL processes that ensure data quality and consistency.
• Establish data governance policies and practices to manage data access, quality, and security throughout the project.
• Support the development, adoption, and implementation of best practices in data management, which includes data architecture, data sharing, data integration, data quality, common data, and standardized methodologies.
• Lead or assist in communicating activities surrounding the Data architecture.
• Document the data architecture, models, and processes, and ensure knowledge transfer to IT and business teams for ongoing operations and maintenance.
• Contribute to development of data sharing, data integration, data quality, common data and standardized methodologies.
• Participate in design reviews, regular or ad-hoc architectural reviews ensuring correct interpretation of the data architecture.
• Respond to requests for extensions to the scope of the data architecture, as needed.
• Work with developers and supporting information technology (IT) resources to manage ongoing data assets and process changes, as needed.
• Work with IT and business stakeholders to ensure the data architecture meets business requirements and is aligned with the organization’s strategic goals.

Deliverables :

• Specific deliverables and due dates will be determined by the client team.
• Status reports - weekly and monthly.

Equipment requirements :

Resource will require own equipment.

Resource must provide their own computer and related equipment. The computer's operating system must be a modern version of Windows or MacOS that is compatible with Azure Virtual Desktop (AVD) and related software for remote access.

Windows is preferred due to better compatibility. AVD / remote-related software will be installed on the resource's computer.