Overview

This is a great opportunity to be SMBC's lead data engineer/SQL Server developer across the compliance technology function. You will be responsible for design and build of a best-in-class data warehouse to support our business needs. You will work in a dynamic environment, partnering with data analyst, ETL developers, vendors and consultants while being a Subject Matter Expert (SME) in the areas of compliance surveillance data sets, transactional data sets, and bank related reference data.

At SMBC, we connect the diversity of our employees to the resilience of our firm. We believe an array of backgrounds, experiences, and perspectives creates stronger organizations and a better society. We strongly encourage an inclusive environment that allows all employees to be their authentic selves and fully thrive in their roles. Our culture is one of integrity and respect where we welcome everyone's contributions and feedback and accept it without judgment.

Responsibilities

• Perform detailed data analysis (i.e. determine the structure, content, and quality of the data through examination of source systems and data samples)
• Understand and transform technical specifications into a data model, and database deliverables for the build out of our compliance trade data warehouse and metrics data warehouse
• Solve complex data engineering problems and lead system design and development activities including understanding the business processes/requirements while adhering to the data quality control framework
• Work in the Agile framework and collaborate with business and technology teams on the delivery of our strategic data platforms
• Optimize database queries, build out complex stored procedures, database objects, indices, triggers, data import and export routines, support user and role management, grants, schema, object management and session monitoring and other logging capabilities
• Code, test, deploy and maintain your code while supporting team members with training, code reviews, developing dev best practices, code management processes and procedures
• Performance tune SQL and identify technical deficiencies in queries and resolve them
• Apply strong knowledge in Python and Shell Scripting required for file processing and database connections
• Lead the data engineering estimating effort related to new capabilities, defect fixes and enhancements

Qualifications

• Bachelor’s Degree in Computer Sciences or a related field
• 5 years of MS SQL Server development
• 3 years of database design, SSIS packages, Transact SQL, and query optimization experience
• AZURE experience
• Experience with Python, AutoSys and Unix a plus
• Database and data warehousing design and implementation as well as dimensional modeling required
• Markets experience a plus