Your job, or that of the workman you hire to repoint your brick, is to take time and find sand that matches the sand in your existing mortar. You need to match both the color and grain size.
The one you choose needs to look good with the original brick and closely match the mortar's color between the bricks. Related: 11 Ways To Update Your Brick Without Painting It White For ...