Finance Data Analyst

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

About ATS

ATS is an industry-leading automation solutions provider to many of the world’s most successful companies. ATS uses its extensive knowledge base and global capabilities in custom automation, repeat automation, automation products and value-added services, including pre-automation and after-sales services, to address the sophisticated manufacturing automation systems and service needs of multinational customers in markets such as life sciences, food & beverage, transportation, consumer products, and energy. Founded in 1978, ATS employs over 6,000 people at more than 50 manufacturing facilities and over 75 offices in North America, Europe, Southeast Asia, South Asia, and China. The Company’s shares are traded on the Toronto Stock Exchange under the symbol ATS.