Financial Data Analyst: SQL & Reporting Specialist

DSI Systems Inc.; Urbandale (IA); On-site; USD 55,000 - 85,000; Full time

Benefits offered by this job

Medical Insurance

Dental Insurance

Vision Insurance

Life Insurance

401k Matching

Paid Vacation

Paid Sick Days

Bereavement Time

Profit Sharing (DSI Bucks)

Job summary

DSI Systems Inc. is seeking a Financial Data Analyst to join our in-office team in Urbana Dale, Iowa. You will handle daily/weekly data tasks, respond to ad hoc requests, and collaborate with Sales, Accounting, and Credit to support decision making and efficiency.

You will work with MS SQL/Reporting Services and Excel to manage vendor data, payments, and reconciliations, while supporting other departments as needed. This is an in-office role reporting to IT.

Qualifications

• BA/BS with 2+ years of experience in IT, finance, accounting, or analytics.
• Proficiency in MS Excel with 1+ years of experience working with large data sets.
• Strong interpersonal and communication skills across departments.
• Excellent analytical and problem-solving abilities.
• Extremely detail-oriented and highly organized.
• Experience with MS SQL, MS SQL Reporting Services, MS Visual Basic, Domo a plus.
• Knowledge/experience with accounting or finance is a plus.

Responsibilities

• Processing dealer inquiries and interpreting data using SQL to query multiple vendor tables while resolving dealer disputes in a timely manner
• Execute data collection, reporting, dealer payments, and vendor receivable reconciliation over multiple DSI programs
• Analyze vendor data, ensuring changes are applied to current vendor payment processes
• Identifying high-level data issues from vendors while working with Sales across all levels
• Prepare ad hoc reporting of financial results by gathering data from various accounting applications and putting it in an appropriate format for the intended audience
• Provide admin-level support to other DSI departments where needed
• Other duties as assigned

Skills

SQL

MS Excel

Interpersonal communication

Analytical thinking

Problem solving

Attention to detail

Organization

Data analysis

Education

BA/BS in IT, finance, accounting, or analytics

Tools

MS SQL

MS SQL Reporting Services

MS Visual Basic

Domo

Job description

DSI Systems Inc. is seeking a Financial Data Analyst to join our in-office team in Urbana Dale, Iowa. You will handle daily/weekly data tasks, respond to ad hoc requests, and collaborate with Sales, Accounting, and Credit to support decision making and efficiency.

You will work with MS SQL/Reporting Services and Excel to manage vendor data, payments, and reconciliations, while supporting other departments as needed. This is an in-office role reporting to IT.