Hybrid Vice President, Data Engineer

at Sumitomo Mitsui Banking Corporation – SMBC Group

• Job title: Vice President, Data Engineer
• Job type: Full Time
• Experience level: Lead
• Salary: Not specified
• Degree requirement: Bachelor's Degree
• Tech skills: Azure, Cloud, Cyber Security, ETL, Java, Jenkins, Oracle, Python, ServiceNow, SQL, Unity
• Location requirements: Hybrid, Charlotte, United States

About the role

• VP, Senior Data Engineer responsible for designing and developing cloud data solutions for insider risk in Information Security at SMBC. Collaborating with multiple teams to enhance cybersecurity data platform.

Responsibilities

• Design, develop, testing & support of cloud data solutions for the CyberDW catalogue focusing on insider risk data ingestion, data quality, data tuning and performance of upstream cybersecurity and other data sources.
• Indirect leadership and mentorship of junior team members.
• Able to lead data feed development efforts and design initiatives.
• Participate in development meetings to align development priorities and objectives, assign tasks, and share experiences and challenges with applications under development.
• Consult with other technology and development teams as needed to coordinate on the integration of applications with the larger company software ecosystem.
• Capture and document metadata for identified Key Data Elements (KDEs) to ensure accuracy and completeness for Data Quality (DQ) rules and processing of daily datasets.
• Work with the data architecture team to align KDEs to the logical data models, develop physical data structures, and document physical data names, definitions, and data types.
• Partner with the data owners and stakeholders to create technical requirements and DQ rules around the data elements needed in the CyberDW.
• Partner with the Business Management team and Data Owners to understand what critical metrics and data fields are needed for Metric Dashboards.
• Establish CyberDW views to encapsulate the data so that it is fit for downstream consumption.
• Ensure that the data aligns with DQ rules established on that metadata, so it is fit for daily use.
• Identify and resolve DQ issues including inaccuracies and incomplete information.
• Enhance data quality efforts by implementing improved procedures and processes.

Requirements

• Bachelor’s degree in Computer Science, Information Security, Data Management, or related field
• 10+ years’ experience in IT development, data governance, data architecture or related roles, preferably in a highly regulated environment such as financial services.
• Strong knowledge of CI/CD and DevOps tooling (i.e., Git, Jenkins, Azure DevOps)
• Strong knowledge of Azure Databricks, Azure Data Factory, Azure Functions, Azure Data Lake storage, Azure Event Grid, Azure Log Analytics, Azure Monitor, Unity catalog repository configuration
• Proficient in data management & data modeling tools (e.g., Collibra DQIM/DQE, IBM Infosphere DA).
• Proficient in SQL Server, Oracle / PL-SQL, T-SQL and SQL stored procedures
• Proficient in Python, Java or similar high-level server-side languages
• Strong knowledge of enterprise Information Security data (i.e., Phishing, Identity Management, Privileged Access, Cloud Security, Incident Response, Vulnerability Management, Threat Detection).
• Data knowledge of PaaS/SaaS products (i.e., ServiceNow, Crowdstrike, MS Purview, Proofpoint, WIZ.IO, JIRA, SharePoint, Azure Active Directory, SAI360).
• Knowledge of Microsoft Sentinel for security information and event management (SIEM) is a plus.
• Understanding of information security frameworks (i.e., NIST, CIS, CRI Profile) and regulatory compliance (i.e., NYSDFS, GDPR, CCPA).
• Experience with REST API web services and microservice architecture.
• Strong understanding of ETL/ELT.
• Knowledge of IBM Tivoli Workload Scheduler a plus.
• Exposure to PowerBI for data visualization and reporting is a plus.
• Problem solving and analytical skills, with an initiative-taking and results oriented approach.

Benefits

• SMBC provides reasonable accommodations during candidacy for applicants with disabilities consistent with applicable federal, state, and local law.
• Prospective candidates will learn more about their specific hybrid work schedule during their interview process.