Data Quality Developer

Role Description

SMBC is seeking a Senior Data Quality Developer who has a strong passion for designing implementing andmaintainingenterprise Data Quality (DQ) rules to support regulatory reporting risk management and compliance within a banking environment. The Senior Data Quality Developer will require strong domainexpertise handson experience with Collibra Data Governance and Collibra Data Quality and advanced SQL skills to deliver scalable auditable and reliable data quality controls.

This role will report to the Director of Database Management.

Role Objectives: Delivery

• Design develop andmaintainData Quality rules inCollibra Data Qualityacross key data quality dimensions including completeness accuracy validity consistency timeliness and uniqueness.
• Developoptimize andmaintainadvanced SQLto support data quality validations across large and complex datasets.
• Own theendtoend Data Quality rule lifecycle including requirements analysis rule design development unit testing deployment monitoring and ongoing maintenance.
• Analyze rule execution results investigate exceptions perform rootcause analysis and proactively drive issues to resolution.
• Collaborate closely withRegulatory Reporting Risk Compliance Data Governance and Technologyteams to ensure alignment with business and regulatory requirements.
• Participate in the migration of existing Data Quality rules from legacy DQ frameworks or platforms to Collibra Data Quality (CDQ) ensuring functional equivalence and adherence to governance standards.
• Support rule output reconciliation processes to compare and validate results between legacy DQ solutions and CDQ ensuring accuracy completeness and regulatory consistency during and after migration.

Qualifications and Skills

• Strong experience in data quality rule development within the banking or financial services industry.
• Prior understanding of regulatory and risk reporting including FR Y9C FR 2052a CECL RWA Compliance Risk etc.
• Prior understanding of KDE DQ Controls / Business Specification Manual Data Controls etc.
• Extensive handson experience with Collibra Data Governance and Collibra Data Quality.
• Advanced SQL expertise (complex joins window functions performance tuning).
• Strong understanding of data quality frameworks and dimensions.
• Excellent communication skills with the ability to work across technical and business teams.
• Experience working inAgile delivery environments using tools such asJira.
• Handson experience working with data platforms such asOracle SQL Server Denodo Databricks or similar technologies.
• Experience with DevOps and CI/CD tools including GitHub or Bitbucket Jenkins and artifact repositories (PyPI or Maven).
• Experience working with API integration tools like Azure Logic Apps.
• Have strong verbal and written communication skills.
• Ability to demonstrate a self-motivated and disciplined approach to learning and working.
• Ability to work in a team environment and demonstrate leadership skills when needed.
• Possess a highly developed sense of personal accountability and follow-through with an ability to effectively prioritize multiple personal tasks projects and goals.
• Intermediate experience with Python for data analysis automation or rule support activities.
• Intermediate proficiency in Microsoft Excel including data analysis and reconciliation support.
• Familiarity with enterprise scheduling tools such as Tivoli Workload Scheduler (TWS) or equivalent.
• Experience using Power BI for reporting analysis or data quality insights.
• General understanding of Azure cloud concepts and data services.

Additional Requirements