Finance Data Analyst

Job Summary

As a highly motivated and detail-oriented team member, the successful candidate will utilize their knowledge in creating dashboards to provide analytical support directly to ATS’ Corporate Finance department. This role will focus on the creation and maintenance of data visualizations within Tableau, OneStream, and other tools.

The Data Analyst will identify continuous improvement opportunities to simplify and make improvements from a dashboarding and analytics perspective to drive positive change within Corporate and across the organization

Responsibilities

ANALYSIS

Develop dashboards and data visualizations in OneStream, Tableau, and other tools.

Integrate multiple data sources (actual, forecast, and plan data).

Recommend improvements for analytics, dashboards, and visualizations.

Collaborate with Finance and IT to define specs and project plans.

Monitor and resolve dashboard defects.

Support planning and forecasting enhancements.

Document all changes for SOX compliance.

Ensure confidentiality of financial information.

OPERATIONAL SUPPORT

Maintain business models, value drivers, KPIs, and benchmarks.

Create dashboards, reports, and project plans for Corporate and divisional use.

Analyze variances between actuals, forecast, and plan data.

Support finance application data integration.

Provide analysis in response to department inquiries, in coordination with Global Finance.

FINANCIAL REPORTING & ACCOUNTING

Collaborate with Global Finance, business analysts, and system analysts.

Provide variance commentary and support financial reporting needs.

Perform ad hoc financial analyses as needed.

INTERNAL CONTROLS & POLICIES

Ensure consistent application of financial reporting standards and internal policies.

Desired Skills

Experience with data visualization tools such as Tableau, Power BI, OneStream, or similar

Strong hands-on experience with database performance optimization such as SQL, MySQL, or Oracle (query languages)

Solid understanding of Extraction, Transforming and Loading processes (ETL); extracting data, combining, cleaning and producing a final output

Experience with Python focused on forecasting and problem-solving

Experience with Analysis Cubes (editing or creating data structures)

Knowledge of financial systems, accounting principles and financial, planning & analysis is beneficial

Ability to work with large datasets and derive insights from complex data structures

Strong desire to learn new industries and technologies

Qualification & Experience

University degree or college diploma in an IT Software Development discipline such as computer science or mathematics

Relevant product & technology certifications or proven experience

Looking for candidates with minimum of 5 years of experience