Who We Are

tsworks Canada, Inc. (subsidiary of The Software Works, Inc, USA) is a technology product and services company in Ontario, Canada. Our mission is to provide domain expertise, innovative solutions and thought leadership to empower businesses to thrive in a digital world. We value our employees, take pride in providing best value in customer engagements defined by your skills, ideas, and attitude.

About This Role

tsworks Canada, Inc. is seeking driven and motivated Senior Data Architect to join its Digital Services Team. You will get hands-on experience with projects employing industry-leading technologies. This position will be reporting to the Chief Technology Officer, workplace type will be hybrid with 2-3 days per week, on-site, in our clients’ locations in Vancouver, British Columbia. This role would initially be focused on the operational readiness and maintenance of existing applications and would transition into a build and maintenance role in the long run.

• Position: Senior Data Architect
• Experience: 10+ Years
• Location: Vancouver, British Columbia

Mandatory Required Qualification

• 10 Years of hands-on experience in Information Technology, with 5+ years of experience designing and executing data solutions.
• Excellent problem solving and communication skills.
• Hands-on experience building data solutions using Python, SQL and Spark
• Experience building data solutions using with Snowflake or Databricks in Azure Cloud.

In This Role, You Will

• Design dimensional models for reporting and analytics.
• Design and execute the build of data ecosystems in cloud to support a Data Lake-House architecture.
• Integrate disparate data models across an organization into one enterprise-wide Unified Data Platform.
• Design functional database objects, build entity relationships and produce documentation necessary for catalog and governance of data models.
• Drive rationalization and standardization of data products.
• Surface inconsistencies in data definitions so that they can be reconciled.
• Develop a corporate data library / metadata repository including best practice for development of data transformation specifications.
• Must work at a client location multiple days a week.
• Participate in prototyping and proof of concept system development and benchmarking.
• Shape enterprise data architecture design patterns, design principles and best practices enhancing business solution delivery.
• Design and implement role-based access control, backup and recovery strategies, maintenance windows and provide an overall support for implementing ITIL standards.
• Participate in code reviews, ensuring best practices are followed.
• Identify and resolve production application issues.
• Perform database administration tasks, including automation, performance monitoring, system tuning, and SQL query optimization.

Skills & Knowledge

• Hands-on experience building data solutions in Azure Cloud.
• Hands-on experience building data solutions using Python, SQL, and Spark.
• Kimball or Inmon data models.
• Experience working with Restful APIs, JSON, Parquet, and Avro file formats, HDFS and Delta Lake and query frameworks such as Hive and Presto.
• Preferrable experience in Azure Data Factory or other ETL tools solutioning and development
• Proficiency in SQL for data querying and manipulation.
• Hands-on experience in data modelling, implementation, and management of OLTP and OLAP systems.
• Hands-on experience working in an agile setting.
• Self-driven, naturally curious, and able to adapt to a fast-paced work environment.
• Be able to articulate, create, and maintain technical and non-technical documentation.