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 similarStrong 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-solvingExperience with Analysis Cubes (editing or creating data structures)Knowledge of financial systems, accounting principles and financial, planning & analysis is beneficialAbility to work with large datasets and derive insights from complex data structuresStrong desire to learn new industries and technologiesQualification & Experience
University degree or college diploma in an IT Software Development discipline such as computer science or mathematicsRelevant product & technology certifications or proven experienceLooking for candidates with minimum of 5 years of experience