Data architect

Iron Systems
Saskatchewan AB, CAN
$40-$75 an hour (estimated)
Full-time

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.
  • 30+ days ago
Related jobs
KPMG
Canada, Canada

Design, develop, adapt, and maintain data warehouse architecture and relational databases that support data mining. Hands-on experience in designing and implementing large-scale data architectures and data migration projects with modern data platform. Hands-on experience with data processing and ana...

Scribd
Remote US Canada
Remote

You will also serve as a data and analytics solution architect, leading architecture initiatives encompassing data warehousing, data pipeline development, data integrations, and data modeling. Experience developing standards for database design and implementation of various strategic data architectu...

BQ International Inc
Regina, Saskatchewan

Five (5) + years’ experience in a data design, data architecture, data management and data modelling;. Championing efforts to improve business performance through enterprise information capabilities, such as master data management (MDM), metadata management, analytics, content management, data integ...

Nutrien
Saskatoon, Saskatchewan

You will be responsible for delivering global direction for technical data warehouse architecture and project solution architecture for innovative data-centric solutions, working both independently and in collaboration with other architects from the data services team and beyond. Strive to implement...

BQ International Inc
Regina, Saskatchewan

Championing efforts to improve business performance through enterprise information capabilities, such as master data management (MDM), metadata management, analytics, content management, data integration, and related data management or data infrastructure;. The Enterprise Information Management (EIM...

KPMG
Canada, Canada

An Azure Lead Data Architect is responsible for designing, managing, and optimizing data architecture on the Microsoft Azure Cloud platform. Develop comprehensive data architectures that align with business requirements, including data models, storage solutions, data pipelines, and analytics framewo...

City of Regina
Regina, Saskatchewan

This position contributes to the development of the Technology Department business plans and leads development and implementation of the corporate Data Management Strategy with a focus on data culture, data architecture, security and integration, business intelligence and analytics, data standards a...

Iron Systems
Saskatchewan AB, CAN

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. Coordinate data model development with the higher-level data architecture to ensure cross-application con...

E-Solutions
Canada

Develop policies related to data quality and security. Design, maintain, and improve data solutions using systems including Hadoop and SQL. Lead technical architecture and design sessions and interact with customers to understand their business needs. Assemble reference materials for presales and de...

Lorven Technologies
Canada
Remote

Design and implement data models, data integration solutions, and data governance frameworks to ensure data accuracy, consistency, and security using AWS tools like Redshift, Glue, DynamoDB and also with tools like Talend, Snowflake and Salesforce. Lead data quality initiatives, including data profi...