Database & Reporting Engineer

Mercurial Minds (Pvt.) Ltd. is a technology-driven company specializing in secure, scalable, and high-performance software platforms. We focus on enterprise solutions, cloud-native applications, data platforms, and digital transformation projects that empower businesses to enhance operational efficiency and make data-driven decisions. We are currently looking for a skilled Database & Reporting Engineer with strong expertise in PostgreSQL to support database design, data processing, reporting, and production database operations. This role involves maintaining data accuracy and integrity, developing customized reports, optimizing queries, supporting data ingestion and reconciliation, and automating processes to boost operational efficiency. The successful candidate will collaborate closely with technical teams and business stakeholders to ensure database reliability, data consistency, and accurate reporting aligned with business needs.

Key Responsibilities

- Database Design & Management: Design, maintain, and enhance PostgreSQL database schemas, tables, relationships, indexes, constraints, and queries to meet application and reporting requirements.

- Query Optimization & Performance: Analyze query execution plans, identify bottlenecks, and optimize SQL queries, indexing strategies, and database operations to improve response times and resource efficiency.

- Custom Reporting & Data Analysis: Develop and maintain custom SQL queries, reports, and data extracts based on business and operational needs, ensuring accuracy and consistency.

- ETL & Data Ingestion: Support data ingestion and ETL processes, including extraction, validation, transformation, and loading of data into PostgreSQL databases.

- Data Quality & Integrity: Implement and maintain data validation checks, integrity constraints, and quality controls to detect missing, duplicate, inconsistent, or inaccurate records.

- Data Reconciliation: Perform reconciliation across source systems, database records, and reporting outputs; investigate discrepancies and apply corrective actions.

- Automation & Process Improvement: Automate repetitive database tasks, reporting workflows, validation checks, and reconciliation activities to reduce manual effort and minimize errors.

- Access Control & Security: Manage database access permissions and role-based controls in line with organizational security policies and the principle of least privilege.

- Audit Trails & Traceability: Maintain audit trails and data-change traceability to support accountability, troubleshooting, and internal reviews.

- Production Support & Troubleshooting: Investigate and resolve database incidents, data discrepancies, failed queries, ingestion issues, and reporting errors in production environments.

- Documentation: Keep clear and up-to-date documentation of database structures, queries, reporting logic, data workflows, validation rules, and operational procedures.

- Cross-Functional Collaboration: Work closely with developers, QA engineers, data stakeholders, and business teams to clarify requirements and deliver reliable database and reporting solutions.

Required Qualifications

- A relevant degree in Computer Science, Software Engineering, Information Technology, Data Engineering, or a related field.

- Minimum of 4 years of professional experience in PostgreSQL database engineering, administration, reporting, or related operations.

- Strong practical experience with PostgreSQL and writing complex SQL queries.

- Solid understanding of relational database concepts, including design, normalization, indexing, constraints, and data integrity.

- Experience developing custom reports and data extracts tailored to business requirements.

- Familiarity with ETL processes, data ingestion workflows, and data transformation techniques.

- Proven ability to perform data validation, quality checks, and reconciliation across multiple datasets or systems.

- Skills in analyzing query performance and troubleshooting database bottlenecks.

- Experience automating database operations, reporting tasks, or data quality checks using SQL or scripting tools.

- Knowledge of database access controls, permissions, auditability, and secure data handling practices.

- Strong analytical and problem-solving capabilities with experience investigating production issues and identifying root causes.

- Effective documentation, communication, and collaboration skills.

Preferred Qualifications and Benefits

- Experience supporting production databases and critical business reporting workflows.

- Familiarity with database monitoring, backup and recovery, and performance maintenance.

- Exposure to scripting languages such as Python or Bash for automation purposes.

- Experience with reporting or business intelligence tools relevant to the reporting environment.

- Understanding of version control, change management, and controlled deployment of database changes.

Location: Islamabad, Pakistan
Work Arrangement: On-site
Employment Type: Full-time