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