Data Analyst

Job Description

Job Description

The Enterprise Data Management team is a nimble, cross-functional group that thrives on solving complex data challenges. We manage enterprise data assets, engineer scalable reporting solutions, and deliver actionable insights that inform strategic decisions across the bank.
We’re seeking a Data Analyst with a strong analytical mindset and a passion for coding—someone who can bridge the gap between raw data and business intelligence. This role offers the opportunity to work with modern data stacks and contribute to the evolution of our data infrastructure.
KEY RESPONSIBILITIES:
Data Analysis & Insights Generation (30%)

• Perform exploratory data analysis (EDA) and statistical profiling using Python (leveraging libraries such as Pandas, NumPy, and SciPy) and Java for backend data processing tasks.
• Develop reusable scripts and modular code for data wrangling, anomaly detection, and KPI tracking.
• Apply object-oriented programming principles to build scalable data pipelines and analytical utilities.

• Design and implement interactive dashboards using Tableau, Power BI, or custom-built web interfaces.
• Utilize DAX, Power Query, and Salesforce APIs to integrate disparate data sources into unified reporting layers.
• Translate complex datasets into intuitive visual narratives that support executive decision-making.

• Build and maintain ETL workflows using Python, Java, and SQL-based tools to extract data from PostgreSQL, MSSQL, and cloud-based data lakes.
• Automate data cleansing and transformation routines using Apache POI (for Excel automation in Java), VBA, and Power Query.
• Ensure data integrity through rigorous validation, schema enforcement, and exception handling.

• 2+ years of experience in data analysis, software development, or business intelligence, preferably in financial services or a regulated industry.
• Proficiency in Python and Java, with experience in data manipulation, automation, and backend integration.
• Strong SQL skills and familiarity with relational databases (PostgreSQL, MSSQL).
• Experience with data visualization tools (Power BI, Tableau) and dashboard development.
• Familiarity with ETL processes, data modeling, and version control systems (e.g., Git).
• Experience with Excel (including Power Query and VBA), and process documentation tools (Visio, Lucidchart).
• Excellent communication and stakeholder management skills.
• Bachelor’s degree in Computer Science, Data Science, Information Systems, or a related field.
• High proficiency in technical writing and documentation.

• Experience with DuckDB, Polars, or other high-performance analytical engines.
• Exposure to cloud data platforms like AWS Redshift, Azure Synapse, or Google BigQuery.
• Familiarity with Git for version control and collaborative development.
• Interest in machine learning, predictive modeling, or statistical inference.

About Northern Bank & Trust Company

Northern Bank is a full-service bank dedicated to providing practical, common sense financial solutions to help our customers live their lives and grow their businesses. From deposit products to loans to payment and collections services, we work hands-on with our entrepreneurial customers, both locally and across the country, to provide the financial support they need to realize their personal and business goals. Founded in 1960, Northern Bank has assets of over $3 billion with 12 locations serving communities throughout Middlesex County. Northern Bank is a Member of the FDIC, and an Equal Housing Lender. For more information on online banking services, please visit or follow Northern Bank on Facebook (/NorthernBankM A/), Twitter (@northernbankma), Instagram (@northernbankma) and LinkedIn (company/northern-bank-ma/).

Powered by JazzHR

nljh9cgjoS