Financial Systems Analyst

Company: Springs Window Fashions
Location: Middleton
Posted on: November 17, 2023

Job Description:

Description

Financial Systems Analyst

This role is based in our Middleton, WI Corporate Headquarters. Candidates seeking remote work will not be considered.

Join Springs Window Fashions as a Financial Systems Analyst supporting a team of finance and accounting professionals while working in an award-winning, newly renovated corporate office in Madison, WI. As a critical member of the Finance team, you can expect to:

• Become a technical expert, providing training and support to your co-workers
• Deliver robust financial systems that boost user productivity and satisfaction
• Design, develop, and deploy innovative technical solutions that foster collaboration and advance analytical and reporting capabilities
• Adapt and optimize tools and technology to align with dynamic business processes
• Drive business systems initiatives in collaboration with IT to effectively integrate technology across the finance, accounting, and planning organizations
  Job Responsibilities
  
  Systems Support: Provide general support for Springs Window Fashions financial systems including Tagetik, Microsoft D365 F&O, Anaplan, and Frontier ERP
  
  • Identify, document, and design solutions to continually enhance the features and functionality of company financial reporting and planning systems
  • Create and maintain system documentation, process diagrams, and work instructions to establish consistency and facilitate knowledge transfer
  • Administer system access and security for new and existing users
  • Train associates on use of financial systems and act as a liaison to IT
  • Field inquiries from multiple areas of the organization and collaborate effectively to provide a timely and accurate response
    System Admin: Manage all operations of the Tagetik financial reporting and forecasting system including security, data processing, reporting, and maintenance
    
    • Configure system and deploy data to enable FP&A team delivery of quarterly financial plans and annual Budgets
    • Maintain workforce planning for use in forecasting wages and benefits
    • Develop reports and input templates in Tagetik and manage related interfaces between the system and external sources
    • Troubleshoot issues quickly to resolve or escalate to Tagetik support team
      Analytics & Reporting: Ensure essential information is accurate, available, and accessible to associates to analyze and project financial performance.
      
      • Use and maintain reporting and tools, coordinate security setup with IT, and communicate outages with remediation plans to the user base as necessary
      • Contribute to the development, design, and deployment of new analytical tools, reports, and certified datasets
      • Provide customized data to support ad hoc requests from business partners
      • Assist users w/ advanced Excel: Cubes, Cube Functions, & PowerPivot
        Data Management: Reliably deliver accurate datasets to financial system users
        
        • Own and maintain all financial systems master data, mappings, and hierarchies to ensure proper data synchronization and change management
        • Leverage SQL to manage datasets, monitor performance of scheduled jobs, and develop ad hoc analytical queries across multiple data environments
        • Perform data transfers and ETLs between systems and data warehouses
        • Analyze and work to resolve reporting and data discrepancies
          Systems Projects: Lead vital elements of financial system projects that result from new implementations or significant changes required by other business initiatives
          
          • Work with business partners to collect and document requirements, participate in scoping, support development, perform testing and train users
          • Contribute to moderately complex aspects of project execution
          • May lead small projects, including maintaining project plans, assigning work to project team members, and coordinating efforts across departments
          • May help perform integration testing for broader business processes
            
            Requirements
            
            Education and Experience
            
            • Requires Bachelor's degree in business, accounting, finance, technology, or similar and some combination of the following:
            • Minimum 2 years of experience in an analytical role, accounting, finance, or systems
            • Experience using financial systems in a complex business setting
            • Financial system support, implementation, or project experience is a plus
              Technical Skills
              
              • Must be Proficient in Microsoft Office with advanced Excel skills
              • Cube Functions, PowerPivot, PowerQuery, MDX, and DAX Excel skills are a plus
              • Preference given to applicants proficient in writing SQL code
                Knowledge, Skills, and Abilities
                
                • This position requires strong analytical, critical thinking, and project management skills to complete detailed and accurate work. Due to a high level of autonomy, the candidate must be self-motivated and adapt quickly to change. Strong communication and interpersonal skills are also vital to working across functional areas and levels of the organization.
                • Uses analytical thinking to evaluate complex data, draw meaningful conclusions, and make decisions or recommendations
                • Uses critical thinking to assess situations, consider options, and provide clear recommendations that consider key stakeholders
                • Drives continuous improvement by identifying and executing enhancements that improve user experience, increase efficiency, and eliminate waste / rework
                • Prioritizes customer satisfaction and remains calm and productive under pressure
                • Leverages project planning and project management skills to prioritize workload and drive assignments to completion on time and within budget
                • Data mines confidently in large, detailed datasets with precision to identify errors or anomalies and summarize findings with financial acumen (using SQL is a plus)
                • Uses sensitivity and discretion when working with confidential information
                • Maintains flexibility and urgency working in a fast paced, dynamic environment to support changing requirements, ad hoc projects, and user requests
                • Knowledge and experience with business requirements to define scope and system boundaries, set technical specifications, and construct process design is a plus
                  Quality
                  
                  • Uses Agile project plan and project schedule methodology
                  • Clearly defines and utilizes processes in daily work
                  • Looks for innovative ways to streamline work processes and involves stakeholders
                  • Establishes forums to share best practices
                    Behavioral Competencies
                    
                    • Ensures Accountability - Holding self and others accountable to meet commitments
                    • Drive Engagement - Creating a climate where people are motivated to do their best to help the organization achieve its objectives
                    • Instill Trust - Gaining the confidence and trust of others through honesty, integrity, and authenticity
                    • Drive Results - Consistently achieving results, even under tough circumstances
                    • Consumer/Customer Focus - Building strong customer relationships and delivering on customer-centric solutions
                    • Critical Thinking - Making Sense of complex, high quantity, and sometimes contradictory information to effectively solve problems
                    • Being Resilient - Rebounding from setbacks and adversity when facing difficult situations
                    • Optimize Work Processes - Knowing the most effective and efficient processes to get things done, with a focus on continuous improvement

Keywords: Springs Window Fashions, Madison , Financial Systems Analyst, Professions , Middleton, Wisconsin