Junior Data Integration Analyst Jobs in Rochester, NY

Description
SUMMARY
Oversee client invoicing and reconciliation operations for the largest client, serving as the primary liaison between finance and data systems. Lead issue resolution efforts and drive continuous process improvements.
KEY OUTCOMES & RESPONSIBILITIES
Key Outcome: Accurate Monthly Reconciliation - Ensure Precision in Financial Reporting
Key Responsibilities:
• Data Integration: Extract and compile payment processing and internal data into a Power Pivot template.
• Error Management: Identify, review, and resolve data discrepancies.
• Reporting: Communicate reconciliation results to finance for accurate journal entries and bank reconciliation.
Key Outcome: Effective Client Billing - Guarantee Correct and Timely Invoicing
Key Responsibilities:
• Data Extraction: Retrieve data from multiple custom platforms to verify accurate client billing for monthly subsidies.
• Invoicing: Prepare and execute quarterly invoices for outdoor media and passthrough fees and expenses.
• Issue Resolution: Address and resolve declined payment issues in collaboration with the account service team.
• Billing Oversight: Review and manage billing issues and escalations.
Key Outcome: Efficient Client Credits and Refunds - Streamline Credit Processing
Key Responsibilities:
• Data Reconciliation: Retrieve and reconcile client credit and refund data from proprietary platforms.
• Refund Processing: Handle or submit refund requests to finance for prompt processing.
Key Outcome: Responsive Ad Hoc Billing Requests - Address Special Billing Needs
Key Responsibilities:
• Troubleshooting: Resolve data issues in collaboration with other departments.
• Platform Management: Oversee and manage the payment processing platform.
Other Responsibilities:
• Additional accountabilities and tasks may be assigned by leader/management, to contribute to overall team and agency success.
Top of Form
Bottom of Form
QUALIFICATIONS
• REQUIRED
o Experience: 3+ years in accounts receivable or finance
o Sound independent judgment
o Customer focus
o Ability to establish trust and credibility
o Advanced knowledge in Excel, Office 365
• PREFERRED QUALIFICATIONS
o Detail oriented with a proven track record of accuracy, High level of interpersonal skills and integrity while executing responsibilities
o Education: Bachelor's Degree, accounting or finance a plus
CORE COMPETENCIES
• CUSTOMER FOCUS/CLIENT INTIMACY: seeking to understand client business challenges/needs and delivering continuous value to our clients
• COLLABORATIVE: working with teams and across the organization with ease
• OWNER AGILITY: able to continuously learn and quickly adapt to changing circumstance
• RESULTS DRIVEN: accepts accountability to deliver business outcomes, even under changing circumstances. Delivers on commitments
• DISCIPLINED: Thinks, plans, and prioritizes work on an ongoing basis, plans and aligns with key team members before acting
Travel Requirements
All employees, regardless of role or geographic location, are required to attend in person for onboarding during their first week of employment and annually for the Shareholder's Summit held in June. Additional travel is not routinely expected but may be required for key/critical meetings & events.
WORK ENVIORNMENT & PHYSICAL DEMANDS
The work environment and physical demands characteristics described here are representative of those an employee encounters while performing the essential functions of this job, typically in an office setting or in a home office. An employee in this role may be in a stationary position, often standing or sitting for prolonged periods and using office equipment and computers. The noise level in the office environment is usually moderate. (I.e., business office with computers and printers, light foot traffic, etc.). Reasonable accommodation may be requested to enable individuals to perform the essential functions.
EEO DISCLAIMER
Butler/Till is an Equal Opportunity Employer to all employees and applicants and prohibits discrimination and harassment of any kind without regard to race, color, religion, age, sex, national origin, disability status, genetics, protected veteran status, sexual orientation, gender identity or expression, or any other characteristic protected by federal, state, or local laws.
This applies to all terms and conditions of employment, including recruiting, hiring, placement, promotion, termination, layoff, recall, transfer, leaves of absence, compensation, and training.
COMPENSATION
Butler/Till is committed to providing pay transparency of our compensation philosophy and ensuring equitable pay practices for our employee owners. The compensation range for this position is $45,000 - $67,000 and represents the annual salary range in Rochester, NY. Base pay offered may vary depending on multiple individualized factors, including location, skills, and experience.
This is just one component of Butler/Till's total compensation package for employee owners. The total compensation package for this position may also include other elements, including ESOP (employee stock ownership plan), an annual bonus, in addition to a full benefits package, and paid time off benefits, including 100% paid parental leave. Details of participation in these benefit plans will be provided if an employee receives an offer of employment.