Senior Data Engineer, Compliance Technology

Company: Sumitomo Mitsui Banking Corporation

Job Summary

We are seeking a talented and experienced Senior Data Engineer for our Compliance Technology team. In this vital role, you will be responsible for designing and implementing scalable data infrastructure and pipelines to support our financial compliance and risk management initiatives. Collaborate closely with compliance, risk, and data teams to build solutions that ingest, process, and analyze complex data from various sources, ensuring accurate reporting, monitoring, and audit capabilities.

Position Specifications

• Bachelor's degree in Business, Finance, Computer Science, or a related field.
• Proven experience (5+ years) as a Business Analyst, Data Engineer, or similar role within the financial industry, with a strong focus on compliance and regulatory matters.
• Proficiency in writing complex SQL queries to extract, transform, and load data, as well as perform detailed analysis for trends, discrepancies, and potential compliance issues.
• Proficiency in analyzing complex data using MS Excel.
• Hands-on experience with data visualization tools (e.g., Power BI) to create meaningful reports and dashboards.
• Familiarity with financial crimes compliance software (Verafin, Actimize) is desirable.
• At least 2 years of experience building and operating data pipelines, data lakes, and/or data warehouses in Azure cloud.
• Knowledge of Big Query and Looker in Google Cloud Platform is a plus.

Principal Duties & Responsibilities

• Collaborate with cross-functional teams to identify compliance-related data requirements and translate them into actionable insights.
• Conduct comprehensive analysis of complex data sets to identify trends, anomalies, and potential compliance risks.
• Utilize Excel spreadsheets and data visualization software like Power BI for reporting and monitoring.
• Design and implement efficient data pipelines, integrating data from various sources.
• Ensure data quality, accuracy, and consistency by implementing data cleansing, validation, and transformation processes.
• Collaborate with IT teams to optimize data storage, access, and retrieval for compliance reporting and monitoring.
• Write complex SQL queries to extract, transform, and load data for analysis.
• Develop and maintain SQL scripts for routine data processing and reporting tasks.
• Experience with compliance software such as Verafin, Fircosoft, and Actimize to enhance data analysis, monitoring, and reporting processes.
• Develop ETL processes, data pipelines, and orchestrate data movement in cloud platforms (Azure and GCP) for storage, processing, and analysis.
• Develop automation using scripting languages (Powershell, Power Automate, Python).
• Generate ad hoc reports from Core systems and Fraud detection software as requested.
• Maintain thorough documentation of data sources, methodologies, and processes to support audit and regulatory inquiries.
• Identify opportunities to streamline compliance processes through automation and innovative use of technology.
• Work closely with stakeholders to understand their needs and propose data-driven solutions to enhance compliance efficiency.
• Engage in effective communication with team members, management, and stakeholders to share insights, findings, and progress on compliance initiatives.

Join Sumitomo Mitsui Banking Corporation as a Senior Data Engineer and play a key role in our compliance technology initiatives.