SQL Developer II

Eastern Bank - Lynn, MA

Full-time - Mid Level

Lynn, MA

Credit Intermediation and Related Activities

About the position

The Data Engineer role within the Credit Risk Analytics group is focused on maintaining the Credit Data Mart (CDM), ensuring data quality, and supporting reporting processes. This position involves developing new reporting tools, automating existing reports, and providing documentation and quality assurance for data outputs. The role requires collaboration with stakeholders and support for internal applications, while also addressing data quality issues and compliance requirements.

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

• Medical insurance
• Dental insurance
• Vision insurance
• Life insurance
• Disability insurance
• Retirement plan
• Vacation
• Tuition reimbursement