JOB RESPONSIBILITIES
- Monitor data quality across production databases and reporting environments.
- Perform regular data validation and reconciliation checks.
- Identify missing, inconsistent, duplicated, or incorrect data.
- Investigate root causes of data quality issues.
- Coordinate corrective actions with business and technical teams.
- Develop automated controls and validation procedures to prevent recurring data issues.
- Execute controlled data corrections in production and non-production environments.
- Prepare and validate SQL scripts for data remediation activities.
- Support operational teams in resolving data-related incidents.
- Verify data consistency after releases, migrations, and system changes.
- Maintain audit records of performed corrections and data maintenance activities.
- Develop ad-hoc SQL reports based on business requests.
- Support regulatory, operational, and management reporting.
- Extract and transform data from PostgreSQL databases.
- Assist business users with data analysis and interpretation.
- Create reusable reporting datasets and views.
- Analyze query performance and identify bottlenecks.
- Optimize SQL queries, views, and stored procedures.
- Design and maintain database indexes.
- Support database housekeeping and performance improvement activities.
- Participate in database capacity planning and performance monitoring.
- Maintain documentation of data structures, business rules, and correction procedures.
- Contribute to data governance standards and data quality frameworks.
- Document reporting logic and reconciliation procedures.
- Support audits and compliance reviews related to data management activities.
JOB REQUIREMENTS
- Bachelor’s degree in Computer Science, Information Systems, Data Management, Software Engineering, or related field.
- 2+ years of experience working with relational databases.
- Experience writing complex SQL queries.
- Experience supporting production systems.
- Experience investigating and correcting data issues.
- Experience preparing operational or management reports.
Financial services, banking, securities, or fintech experience is an advantage.
- Strong practical knowledge of:
- SQL development
- Complex joins and aggregations
- Window functions
- Common Table Expressions (CTE)
- Views and materialized views
- Stored procedures and functions
- Query execution plans
- Database indexing
- Query performance optimization
- Experience with PostgreSQL, pgAdmin or similar database tools, Git,Microsoft Excel, Python, Power BI, Linux
- Strong attention to detail.
- Ability to identify anomalies and inconsistencies in large datasets.
- Ability to perform root cause analysis.
- Ability to diagnose data issues quickly.
- Ability to propose practical remediation solutions.
- Ability to work independently with minimal supervision.