Senior Data Engineer, Compliance Technology (Hybrid in LA, PHX 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 $156,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
JOB SUMMARY:
The Sr. Data Engineer for Compliance Technology will be responsible for designing and implementing scalable data infrastructure and pipelines to support the organization's financial compliance and risk management initiatives. Working closely with compliance, risk, and data teams, you will build solutions to ingest, process, and analyze complex data from various sources to ensure 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 Power BI data visualization tools (e.g. Power BI) to create meaningful reports and dashboards as needed.
- 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.
- 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, Fircosoft, 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.
- Develop ETL, data pipelines, and orchestrate movement of data in cloud platforms (Azure and GCP) for data storage, processing, and analysis.
- Develop automation using 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.
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.