Data architect

Job Responsibilities and Required Skills

• The data architect Service Area will assist WCB with the following, but not limited to: 
• Strategically design, develop, and implement data models, and solutions for BI Applications and systems. 
• Create short-term tactical solutions to achieve long-term objectives, and an overall WCB BI strategy and roadmap. 
• Architected data models at the conceptual, logical, and physical levels for BI Application and subject area. 
• Establish processes for governing the identification, collection, and use of corporate metadata, and take steps to assure data accuracy and validity. 
• Establish methods and procedures to track data quality, completeness, redundancy, and identify opportunities for improvements. 
• Collaborate with business unit leaders and users, and project teams, for all projects involving enterprise data, analyze user requirements for reports, forms, queries, and data extraction. 
• Architect and design the mapping of data sources, data movement, interfaces, and analytics, with the goal of ensuring data quality and governance at all levels in BI application and environment. 
• Develop and deploy end-user practices and tools for data extraction, queries, and data manipulation in accordance with business processes. 
• Develop and administer BI architecture for the use-case-specific modeling. 
• Work with BI Development Team to develop BI design standards, ETL Coding standards, reporting standards, data quality assurance policies, and procedures. 
• Create and document BI models for any new development and/or changes to existing ones through Erwin data modeling tool, data flowcharting etc. 
• Develop, implement, and maintain change control and testing processes for modifications to data models. 
• Coordinate data model development with the higher-level data architecture to ensure cross-application consistency. 
• Ensure the stability and reliability of data access and data quality within BI environment and platform via ongoing support and maintenance. 
• Collaborate with DBAs to monitor database system details, stored procedures and execution time, database access and performance issues, and implement efficiency improvements. 
• Assist with the network and security team for the installation and configuration of relevant network components to ensure BI environment and platform access, consistency, and integrity. 
• Proficient in Erwin Data Modeling tool, SSIS ETL tool, Tabular cube design, data extraction, and transformation processes, etc. 

Mandatory Skills

Architect and design the mapping of data sources, data movement, interfaces, and analytics, with the goal of ensuring data quality and governance at all levels in BI application and environment.