KINZ GLOBAL CONSULT is an HR Consulting agency that works in staffing and recruitment. We match the employers and employees after reviewing and scrutinizing their needs, nature of work, and cost-effectiveness. We provide professional and competent staff for companies, corporate or non-corporate. We also provide temporary or contractual services on certain conditions and provide permanent staff on demand.
Responsibilities
- Develop and execute data validation checks to ensure accuracy, completeness, and consistency of datasets.
- Support ETL and data pipeline testing by verifying record counts, transformations, and joins.
- Write and optimize complex SQL (PosgreSQL) queries to validate data transformations, aggregations, and business rules.
- Use Excel (advanced functions, pivot tables, charts, macros) to analyze data and prepare reports for stakeholders.
- Partner with developers, QA engineers, and business teams to investigate discrepancies and improve data quality processes.
- Perform root cause analysis on data anomalies and propose corrective actions.
- Build and maintain data quality dashboards, reports, and documentation.
- Translate business requirements into data requirements and validation logic.
- Assist in creating and maintaining metadata, data dictionaries, and data lineage documentation. Contribute to a culture of data governance, accuracy, and accountability.
Experience
- (4+ years) as a Data Analyst, Business Analyst, or similar role in data-heavy environments.
- Strong SQL expertise (joins, window functions, aggregations, subqueries, performance tuning).
- Advanced Excel skills (pivot tables, VLOOKUP/XLOOKUP, INDEX/MATCH, conditional formulas, macros preferred).
- Proven ability to identify and resolve data quality issues and inconsistencies.
- Familiarity with relational databases (PostgreSQL (most important), MySQL, SQL Server, etc.).
- Strong understanding of data integrity, validation, and governance principles.
- Ability to work with large, complex datasets under tight deadlines.
- Strong communication skills to collaborate with technical and non-technical stakeholders.
Nice-to-Have Skills:
- Experience with data visualization tools (Tableau, Power BI, Grafana).
- Knowledge of statistical methods for data validation and anomaly detection.
- Exposure to ETL processes and data pipeline monitoring.
- Familiarity with Python or R for data cleaning and analysis.
- Experience with big data platforms (ClickHouse, Hadoop, Spark).
Method of Application
Signup to view application details.
Signup Now
