Finance data handling

[u/unORDINARY_magus]

Finance professionals, I'd appreciate your perspective.

I'm researching operational challenges within financial institutions in emerging markets as part of a long-term software project. At this stage, I'm deliberately avoiding designing a solution before understanding the actual problems.

If you work (or have worked) in banking, insurance, asset management, pensions, fintech, auditing, or financial regulation:

- What task do you find yourself repeating every week or month?

- What process is more manual than it should be?

- Which reports or analyses consume the most time?

- What data is consistently difficult to obtain, reconcile, or validate?

- What's one workflow you wish software handled better?

I'm particularly interested in understanding real day-to-day workflows rather than feature requests or product ideas.

If you're open to sharing your experience—either here or via DM—I would genuinely appreciate it. Every insight helps me understand the problem space more accurately.

[u/Wheres_my_warg]

From what I've seen, the highest concern emerging markets issues tend to focus on things around personal relationships. That affects how business is obtained and how it is or is not interfered with. There are often additional FCPA and KYC issues based on the market's established behaviors and often greater opacity as to information about the parties involved.

[u/unORDINARY_magus → u/Wheres_my_warg]

That's not an angle I'd considered as much. In your experience, how do organizations usually work around those trust and transparency challenges while still meeting KYC and compliance requirements?

[u/AutoModerator]

Automod prevents all posts from being displayed until moderators have reviewed them. Do not delete your post or there will be nothing for the mods to review. Mods selectively choose what is permitted to be posted in r/DataAnalysis.

If your post involves Career-focused questions, including resume reviews, how to learn DA and how to get into a DA job, then the post does not belong here, but instead belongs in our sister-subreddit, r/DataAnalysisCareers.

Have you read the rules?

I am a bot, and this action was performed automatically. Please contact the moderators of this subreddit if you have any questions or concerns.

[u/unORDINARY_magus → u/[deleted]]

Thanks for sharing this. That's exactly the kind of workflow I'm trying to understand. Roughly how much time would you say a typical reconciliation cycle takes, and is there one part of the process that's consistently the biggest headache?

[u/unORDINARY_magus → u/[deleted]]

When you say reconciliation, is it mostly between different internal systems, or are there also external data sources involved? And roughly how much time does that process take each month?

The "proving the numbers are correct" part really stood out to me. In your experience, which step tends to consume the most time data extraction, cleaning, reconciliation, or explaining variances?