Menu

We are our clients’ strategic Data Management partners. What goes on at the whiteboards in the basement project rooms of America’s financial institutions is ringed with confidentiality agreements and client privilege. Here’s the part we can tell you.

Choosing the Right Delivery Strategy for Your Data Management Implementation

by Adam Roderick

When I got into the business of data management, it struck me how many similarities these implementations share with standard software development projects. What struck me even more is how many organizations do not apply lessons learned from software development to data management system implementations. I wish I knew why, and I have some ideas,…

Read Full Post

Pomposity and the Sound of Heavy Gunfire

by Jason Williscroft

A young man approached me recently for advice on how to succeed in the Data Management industry. After I replied, I realized that any person who applies these principles—whether in Data Management or in any other walk of life—is someone I would be privileged to know. So, at the risk of wearing out my welcome, here is…

Read Full Post

Guide to Continuous Integration in Data Management

by Adam Roderick

Continuous Integration is a best practice of modern software development. All professional software developers worth their salt practice continuous integration. Enterprise data management system implementations rarely practice continuous integration, however, because data management systems lag in adoption of most modern software development practices. Why Poor quality, slow development cycles, and missed requirements are results of…

Read Full Post

Data Governance and the Enemy of the Good

by Jason Williscroft

This Monday, 18 April, marks the beginning of Enterprise Data World in San Diego, arguably the most important North American Data Governance conference of the year. I’ll be there, as will be most practitioners of note in the data world. We will be in the minority, though. Well over half of the attendees at EDW will come…

Read Full Post

Solid EDM: Why the Raw Table Matters

by Adam Roderick

Data in a data management system originates from many different sources. These sources live in a heterogenous environment, so the data can arrive in many different ways. The raw table sits at the forefront of the data ingestion process. It is the starting point that pulls the data into the EDM system, moving it from…

Read Full Post

The Data Pipeline Requirements Model

by Jason Williscroft

Data management projects are complex. In a previous article we made the case for explicitly capturing and decomposing High-Level Requirements (HLRs) into Low-Level Requirements (LLRs) in a manner that facilitates the tracking of individual LLRs through the analysis and development process and into production code. A more thorough treatment of this idea, along with the nuts and…

Read Full Post

That One Component Your Team Is Scared to Touch

by Adam Roderick

Efficient enterprise data management implementation teams practice good code reuse to allow themselves to move quickly, minimize errors, and keep their systems simpler than otherwise. This results in dependencies among database objects such as tables, views, functions, and stored procedures. Every team has good intentions to keep the system organized, and some do it successfully. But…

Read Full Post

Avoiding the Requirements Trap

by Jason Williscroft

HotQuant designs and builds Enterprise Data Management (EDM) systems—data pipelines—for large financial institutions. I’ve written elsewhere about sources of inertia that can send an EDM project sideways. In that piece I identified a major risk around requirements, which manifests as an inability to articulate solid High-Level Requirements and decompose them into Low-Level Requirements in a manner that facilitates the…

Read Full Post

Markit EDM Test Harness: First Looks

by Jason Williscroft

Last Thursday morning, Markit held a webinar announcing the release of their Markit EDM Test Harness. Two HotQuant partners were among the hundreds of attendees on the call. Here are their reactions: Matt Cutter Today, Markit held a WebEx meeting to announce the release of their Markit EDM Test Harness to their client base. Primarily…

Read Full Post

EDM Developer Interviewing Guide

by Jason Williscroft

Here at HotQuant we interview EDM developers all the time, both to subcontract for us and on behalf of our clients. Obviously much of an interview is going to be platform-specific, but the fundamentals are universal: the modeling, storage, and manipulation of data using SQL, and problem-solving in a data-centric environment. I’ve evolved a list…

Read Full Post