SQL Developer II

Eastern Bank - Boston, MA

Full-time - Mid Level

Boston, MA

Credit Intermediation and Related Activities

About the position

The SQL Developer II role at Eastern Bank is part of the Credit Risk Analytics group, focusing on the maintenance, documentation, and quality assurance of the Credit Data Mart (CDM). This position involves developing new reporting and dashboards, automating existing reports, and ensuring data accuracy through evaluations and reconciliations. The role also includes supporting internal application changes and providing quality control on team deliverables.

Responsibilities

• Develops new reporting and dashboards from the CDM and automates existing reporting for the Credit Risk Analytics group and its stakeholders.
• Evaluates, tests, and validates CDM outputs and performs reconciliations to ensure the accurate representation of data and analysis.
• Performs Business Requirements gathering and user documentation.
• Provides support for internal application programming changes and reporting process.
• Provides issue resolution on daily data loads.
• Knowledgeable with SDLC processes, and able to facilitate changes to a controlled data mart environment.
• Provides Quality Control and Assurance work on monthly team deliverables (various reports and financial disclosures).
• Remediates data quality issues.
• Provides support on requests from internal/external auditors and regulatory agencies.

Requirements

• Bachelor’s Degree in a quantitative field of study (i.e., Accounting, Business, Economics, Finance, Mathematics, Statistics, Engineering), or equivalent work experience.
• 7-10 years of work experience at a financial services company working as data analyst, programmer, or database administrator.
• 5+ years writing complex T-SQL.
• Past project work migrating legacy SQL Server Applications to an Azure environment is a plus.
• Experience in compliance, audit, or quality assurance is a plus.
• Training/certification on MS SQL Server products and Business Intelligence tools is a plus.
• Working knowledge of distributed applications including one or more of the following technologies: SQL Server 2016 and higher; ASP.NET, SSRS, SSIS, Power BI and data visualization tools.
• A robust knowledge of the characteristics and analytics associated with banking product portfolios.
• Experience with large scale data remediation projects, from issue identification, through to remediation/resolution including profiling, data mapping for data warehousing systems.
• Experience with writing and modifying complex SQL.
• Strong verbal and written technical communication skills.

Nice-to-haves

• Experience in compliance, audit, or quality assurance is a plus.
• Training/certification on MS SQL Server products and Business Intelligence tools is a plus.

Benefits

• Dental insurance
• Disability insurance
• Health insurance
• Tuition reimbursement
• Vision insurance