Finance Data Platform Engineer - SQL-Driven Analytics

AmeriLife; Town of Florida (NY); On-site; USD 115,000 - 130,000; Full time

Benefits offered by this job

PTO

Medical insurance

Dental insurance

Vision insurance

Retirement savings plan

Disability insurance

Life insurance

Job summary

AmeriLife is seeking a Finance Data Platform Specialist to drive implementation, enhancements, and operation of our Finance Data Platform. You will work with Finance, Accounting, Data Engineering, and stakeholders to manage data domains such as commissions, banking, GL, and reporting, using SQL for data validation and problem solving.

The role requires collaboration with data engineers and architects, strong analytical abilities, and experience with enterprise finance data.

Qualifications

• Bachelor's degree in Information Systems, Computer Science, Business, Finance, Accounting, or related discipline.
• 5+ years of experience supporting enterprise finance applications, finance data platforms, or financial systems.
• Experience with commissions, banking, general ledger (GL), financial reporting, attribution, reconciliations, or similar finance processes.
• Experience gathering and documenting business and functional requirements.
• Experience supporting User Acceptance Testing (UAT) and production implementations.
• Strong SQL skills for data analysis and validation.
• Excellent analytical, problem solving, and communication skills.
• Ability to collaborate effectively with both business and technical teams.

Responsibilities

• Gather, analyze, and document business and functional requirements for finance data initiatives.
• Prepare user stories, business rules, process flows, functional specifications, and acceptance criteria.
• Support initiatives involving commissions, banking, general ledger (GL), financial reporting, attribution, reconciliations, policy administration, and enterprise finance data.
• Work closely with Data Engineers and Data Architects to clarify business requirements and validate implemented solutions.
• Perform data validation, reconciliation, and functional testing to ensure data accuracy and business rule compliance.
• Coordinate and support User Acceptance Testing (UAT), defect tracking, and production validation.
• Assist with troubleshooting production issues, performing functional analysis, and validating issue resolution.
• Support data mapping, reference data, hierarchies, metadata, and business glossary activities.
• Maintain functional documentation, process documentation, and operational procedures.
• Participate in platform enhancements, process improvements, and release activities.
• Collaborate with Data Governance teams to support data quality, metadata, and business definitions.
• Utilize SQL to analyze, validate, and troubleshoot enterprise finance data.

Skills

SQL

Analytical thinking

Communication

Problem solving

Education

Bachelor's degree

Tools

Databricks

Azure

SQL Server

Job description

AmeriLife is seeking a Finance Data Platform Specialist to drive implementation, enhancements, and operation of our Finance Data Platform. You will work with Finance, Accounting, Data Engineering, and stakeholders to manage data domains such as commissions, banking, GL, and reporting, using SQL for data validation and problem solving.

The role requires collaboration with data engineers and architects, strong analytical abilities, and experience with enterprise finance data.