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