Financial Systems Analyst

Seacoast Bank; Town of Florida (NY); On-site; USD 85,000 - 110,000; Full time

Job summary

Seacoast Bank seeks a Financial Systems Analyst to architect scalable financial data models and build robust reporting frameworks. You will design automated ETL pipelines, develop Power BI dashboards, and collaborate with cross‑functional teams to translate requirements into data solutions.

The role includes integrating financial systems with ERP/CRM, performing data governance, and mentoring users on best practices while upholding the bank's Code of Conduct.

Qualifications

• Master's degree in Finance, Economics, Statistics, Data Analytics, or related field.
• At least 1 year in financial systems or data analytics roles.
• Experience with Power BI, Excel PowerPivot, and Python.
• SQL data modeling and complex queries.
• Power Query for data transformation.
• Data mining, statistical analysis, and visualization.
• Diagnosing systems issues and recommending scalable solutions.
• Knowledge of data governance and system administration.

Responsibilities

• Architect scalable financial data models and reporting frameworks.
• Design automated ETL pipelines using PowerQuery, SQL, and Python.
• Develop dashboards and visuals with Power BI and Excel PowerPivot to monitor KPIs.
• Collaborate with cross-functional teams to translate requirements into data solutions.
• Lead integration of financial systems with ERP/CRM for data consistency.
• Conduct root cause analysis on data anomalies and implement governance protocols.
• Evaluate internal systems for efficiency, scalability, and compliance with standards.
• Prepare source-to-target mappings and data dictionaries for audits.
• Provide mentorship and training on data tools and reporting best practices.
• Stay current with emerging technologies in financial analytics and visualization.
• Adhere to Seacoast Bank's Code of Conduct.

Skills

Power BI

Python

Data analytics

Data visualization

Excel

Education

Master's degree in Finance / Economics / Statistics / Data Analytics

Tools

SQL

PowerQuery

Excel PowerPivot

Job description

Position:

Financial Systems Analyst

Location:

Stuart, FL

Description

• Architect and maintain scalable financial data models and reporting frameworks to support strategic decision-making.
• Design and implement automated data pipelines and ETL processes using tools such as PowerQuery, SQL, and Python.
• Develop advanced financial dashboards and interactive visualizations using Power BI and Excel PowerPivot to monitor KPIs and business performance.
• Collaborate with cross-functional teams to gather business requirements and translate them into technical specifications and data solutions.
• Lead the integration of financial systems with enterprise platforms (e.g., ERP, CRM) to ensure data consistency and accuracy.
• Conduct root cause analysis on data anomalies and implement data governance protocols to improve data quality and integrity.
• Evaluate and enhance internal systems for efficiency, scalability, and compliance with financial reporting standards.
• Prepare source-to-target mapping documentation and data dictionaries to support system enhancements and audits.
• Provide technical mentorship and training to finance and business users on data tools and reporting best practices.
• Stay current with emerging technologies in financial analytics, data engineering, and visualization to recommend innovative solutions.
• Adhere to Seacoast Bank's Code of Conduct.

Minimum Requirements

• Must have a Master’s degree in Finance, Economics, Statistics, Data Analytics, or a closely related field.
• Must have one year experience in financial systems or data analytics roles, including:
• Developing financial reports and dashboards using Power BI, Excel PowerPivot, and Python.
• Designing and maintaining relational databases and data models.
• Writing complex SQL queries and using Power Query for data transformation.
• Performing data mining, statistical analysis, and visualization.
• Diagnosing and resolving systems analysis issues and recommending scalable solutions.
• Administering systems, ensuring optimal performance, data integrity, user access controls, and timely issue resolution.