Design and define enterprise data architectures and logical/physical data models using Kimball dimensional modelling; develop models with PowerDesigner; work with JOIN and JIMS; ensure alignment with information management, cybersecurity, privacy, and data governance; communicate technical concepts to technical and business stakeholders; support modernization initiatives.
This is a remote position.
A public-sector organization is seeking an experienced Senior Data Architect to support data architecture, data modelling, information management, and modernization initiatives within a complex enterprise environment.
The successful candidate will provide senior-level expertise in designing and defining data architectures, developing logical and physical data models, and applying Kimball dimensional modelling principles. The role will also involve working with justice-sector systems, including JOIN (Justice Online Information Network) and JIMS, while ensuring alignment with applicable information management, cybersecurity, privacy, and data governance requirements.
The ideal candidate will have strong experience working with complex enterprise data environments and the ability to communicate technical concepts clearly to both technical and business stakeholders.
Requirements
Similar Jobs
Information Technology • Professional Services • Software • Consulting
Lead data architecture for a Justice Information Management System modernization: consolidate reporting marts into an EDW, perform data profiling and modeling, develop ETL (SSIS), ensure data quality and governance, validate reporting, and communicate with stakeholders.
Top Skills:
Data MartsData ModelingData WarehousingEnterprise Data Warehouse (Edw)ETLPower BIRelational DatabasesSap PowerdesignerSQLSql Server Integration Services (Ssis)Sybase Powerdesigner
.png)
Agency
Lead design and delivery of cloud-based data architectures and ETL/ELT pipelines for marketing analytics. Advise clients, integrate marketing data, build and optimize pipelines and reusable models, ensure data quality/security, mentor team members, and align technical solutions to business goals.
Top Skills:
APIsAWSAzureBigQueryDatabricksDbtDevOpsEtl/EltGeminiGCPGoogle Marketing PlatformJavaScriptKotlinOauthPythonQaSnowflakeSQL
Fitness • Healthtech • Payments • Software
Lead enterprise data architecture across AWS and Databricks Lakehouse: design scalable data models, ensure governance and data quality, mentor teams, evaluate and adopt data technologies (Delta Lake, Unity Catalog), oversee large projects and deliverables, and incorporate generative AI to accelerate data modeling and delivery.
Top Skills:
Apache AirflowAws EksAws EmrAws GlueAws LambdaAws RedshiftAws S3Data VaultDatabricks LakehouseDatabricks SqlDatabricks WorkflowsDelta LakeGenerative Ai ToolsKimballPower BIPythonSQLUnity Catalog
What you need to know about the Ottawa Tech Scene
The capital city of Canada and the nation's fourth-largest urban area, Ottawa has proven a rapidly growing global tech hub. With over 1,800 tech companies, many of which are leaders in their sectors, the city's tech talent now makes up more than 13 percent of its total workforce. This growth is driven not only by the big players like UL Solutions and Dropbox, but also by a thriving startup ecosystem, as new businesses emerge to follow in the footsteps of those that came before them.
