Bi Jobs in Yorkton, SK

Iron Systems is an innovative, customer-focused provider of custom-built computing infrastructure platforms such as network servers, storage, OEM / ODM appliances & embedded systems. For more than 15 years, customer have trusted us for our innovative problem solving combined with holistic design, engineering, manufacturing, logistic and global support services.

Job Title :  Data Architect

Location : SK Canada

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.