Senior Data Engineer, Compliance Technology (Hybrid LA, Phoenix or Charlotte) - SMBC
Charlotte, NC 28202
About the Job
ABOUT THE ORGANIZATION
SMBC MANUBANK was formed by a group of banking entrepreneurs in June 1962. Our scope is to serve the specialized needs of California middle-market businesses, manufacturers, wholesalers, distributors, importers, exporters, and service companies, including small businesses and professionals.
The anticipated salary range for this role is between $95,000.00 and $155,000.00. 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.
Our mission is to be "the bank of choice" for middle market and professional service companies by establishing long term customer relationships and loyalty, providing superior products and services through a core of highly skilled and seasoned bankers.
To achieve our mission to be the 'bank of choice' for middle market and professional services companies, we are focused on our vision to be the premier California regional business bank that can provide the sophistication and expertise of a larger institution with the personal 'high touch' services of a smaller bank.
Specialties:
Commercial Loans and Lines of Credit, Asset-Based Financing, SBA Loans, and Specialized Financing, Real Estate Loans, Cash Management Services, International Services
Principal Duties and Responsibilities:
Technical Business Analyst 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.
- Heavy use of Excel spreadsheets, Power BI or other visualization software.
- 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 into relevant tables for analysis.
- Utilize SQL queries to perform in-depth analysis, identify trends, discrepancies, potential issues, or problems related to compliance data.
- Develop and maintain SQL scripts for routine data processing and reporting tasks.
- Experience and familiarity with compliance software such as Verafin, and Actimize.
- Leverage your knowledge of these tools to enhance data analysis, monitoring, and reporting processes.
- Collaborate with IT and compliance teams to integrate and leverage these tools effectively.
- Understanding of cloud platforms (Azure, GCP) for data storage, processing, and analysis is a plus.
- Scripting languages (Powershell, Power Automate, Python)
- Generate ad hoc reports from Core system 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 pain points, 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.
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.
- Hands-on experience with data visualization tools (e.g. Power BI) to create meaningful reports and dashboards as needed.
- Familiarity with compliance software (Verafin, Actimize) is desirable.
- Knowledge of cloud platforms (Azure, GCP) for data analysis and management is a plus.
- Familiarity with regulatory frameworks and requirements in the financial sector (e.g. BSA/AML) is highly desirable.
- Strong problem-solving skills and an analytical mindset, coupled with the ability to translate complex data into actionable insights.
- Excellent communication skills, both written and verbal, to effectively interact with technical and non-technical stakeholders.
- Ease in leading presentations to stakeholders in a remote environment through Teams or Zoom.
EOE STATEMENT
We are an equal employment opportunity employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, gender, national origin, disability status, protected veteran status or any other characteristic protected by law.
CCPA DISCLOSURE
Personal Information Collection Notice: This notice contains information under the California Consumer Privacy Act (CCPA) about the categories of personal information (PI) of California residents that SMBC MANUBANK collects and the business or commercial purpose(s) for which the PI may be used. We do not sell PI. More information about our collection and use of PI may be found in our CCPA Privacy Policy at https://www.manufacturersbank.com/CCPA-Privacy. Persons with disabilities may contact our Customer Contact Center toll-free at (877) 560-9812 to request the information in this Notice in an alternative format.