Data Engineer

Overview

This is a great opportunity to be SMBCS 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.

The anticipated salary range for this role is between $145,000 and $189,000. The specific salary offered to an applicant will be based on their individual qualifications, experiences, and an analysis of the current compensation paid in their geography and the market for similar roles at the time of hire.  The role may also be eligible for an annual discretionary incentive award.  In addition to cash compensation, SMBC offers a competitive portfolio of benefits to its employees.

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

Salary : $145,000 - $189,000