SQL Developer II

Eastern Bank - Lynn, MA

Full-time - Mid Level

Lynn, 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 and compliance with regulatory standards.

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 a plus.
• Experience in compliance, audit, or quality assurance a plus.
• Training/certification on MS SQL Server products and Business Intelligence tools a plus.

Nice-to-haves

• Experience with large scale data remediation projects, from issue identification, through to remediation/resolution including profiling, data mapping for data warehousing systems.
• Strong verbal and written technical communication skills.

Benefits

• Comprehensive compensation plans
• Medical insurance
• Dental insurance
• Vision insurance
• Life insurance
• Disability insurance
• Retirement plans
• Vacation
• Tuition reimbursement