Back to jobs
Job Description
This position is an important part of the company's financial and analysis activities:
- Design, develop and maintain daily / weekly / monthly processes that pull data from various systems, both internal and external, and loads into the Finance operational data store
- Develop tools and processes related to financial reporting, planning, scenario and sensitivity analysis and strategic financial projections
- Assist the Financial Systems Manager and business directors in understanding the company's performance through timely and insightful analysis
Job Responsibilities:
- Leverage system tools to collect, analyze data and develop various models in support of financial projections and other operational performance trends
- Prepare detail pricing analyses using automated tools (SQL, PowerQuery, Power Bi, etc.) to extract data from the system, manipulating, summarizing and analyzing results for executive and senior management review
- Identify process improvement opportunities within the Finance department to enhance efficiency
- Perform ETL functions in a data warehousing environment
- Design, build and deploy effective SSIS packages
- Translate requirements from the business and various Finance teams into technical code
- UAT latest developments by IT team to ensure compliance with expectations
- Identify and test for bugs and bottlenecks in the ETL solution
- Acts as a business partner on various financial analyses by bringing in business and technical expertise
- Other ad-hoc analyses as required or requested by management