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.
This is a remote position.
We are seeking a Senior Data Architect to support a large-scale Justice Information Management System (JIMS) 3.0 data integration and modernization initiative. The successful candidate will help consolidate multiple reporting data marts into an integrated Enterprise Data Warehouse (EDW) and supporting data marts and views. This role will focus on data architecture, data profiling, data modeling, ETL development, data quality, reporting validation, and enterprise data governance.
Requirements
- Post-secondary degree or diploma in Computer Science, Information Technology, Cybersecurity, Data Management, or a related discipline.
- 5+ years of experience providing architecture risk assessments and architecture-related services.
- 2+ years of experience working in or with public-sector environments, with an understanding of public-sector policies and practices.
- 5+ years of experience working with data architecture, data modeling, and enterprise data solutions.
- 5+ years of experience developing with data modeling/architecture tools such as SAP/Sybase PowerDesigner or equivalent.
- Strong experience with data warehousing, ETL, data marts, facts, dimensions, and data modeling.
- Experience with SQL Server Integration Services (SSIS).
- Strong SQL and relational database experience.
- Experience with Power BI or similar business intelligence/reporting tools.
- Strong understanding of information management, data governance, data quality, and cybersecurity policies.
- Excellent communication skills with the ability to explain complex technical concepts to technical and non-technical stakeholders.
Similar Jobs
Information Technology • Professional Services • Software • Consulting
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.
Top Skills:
Cloud ComputingJimsJoinKimball Dimensional ModellingSap/Sybase PowerdesignerSQL
.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.
