Financial Systems Analyst

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

Job summary

Talentify in Stuart, FL is seeking a Financial Systems Analyst to architect and maintain scalable financial data models and reporting frameworks that support strategic decision-making.

You will design automated ETL pipelines using PowerQuery, SQL, and Python, build advanced dashboards with Power BI and Excel PowerPivot, and collaborate with cross-functional teams to translate requirements into data solutions.

Qualifications

• Master’s degree in Finance, Economics, Statistics or Data Analytics.
• At least 1 year in financial systems or data analytics roles.
• Experience with Power BI, Excel PowerPivot, and Python for reporting.
• Strong SQL querying and data modeling skills.
• Ability to design relational databases and ETL processes.
• Knowledge of data governance and data quality practices.
• Excellent cross-functional collaboration and documentation.

Responsibilities

• 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 PowerQuery, SQL, and Python.
• Develop advanced financial dashboards and visualizations using Power BI and Excel PowerPivot.
• Collaborate with cross-functional teams to gather requirements and translate them into data solutions.
• Lead integration of financial systems with ERP/CRM platforms for data consistency.
• Conduct root cause analysis on data anomalies and implement governance protocols.
• Evaluate internal systems for efficiency, scalability, and compliance with financial reporting standards.
• Prepare source-to-target mappings and data dictionaries for audits.
• Provide training to finance and business users 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

Data analytics

Financial data modeling

ETL processes

Data governance

Dashboards

KPI reporting

Education

Master's degree in Finance/Analytics

Tools

PowerQuery

SQL

Python

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.

Qualifications

Education

Masters

Equal Opportunity Employer/Protected Veterans/Individuals with Disabilities