Our mission at SPS FIA (Finance Insights Analytics) is to provide complete and accurate data for financial and business reporting and analytics. As such, Finance Analytics designs, builds, maintains and enhances scalable systems that provide accurate data as well as actionable insights to the business.
As a Business Analyst in SPS FIA team, you will be responsible for working with terabytes of data to develop automated and self service scalable solutions for Finance and Business Partners. You will be responsible for building a robust set of operational, financial and business metrics,requirements documentation and will utilize metrics to determine improvement opportunities.
From Day 1, you will be challenged with a variety of tasks, ranging from creating datasets, reports, dashboards to metadata modeling, pipeline monitoring. You will interact with internal program, finance, Operation and Capacity planning team, and technical teams to gather requirements, structure scalable and perform data solutions, and gain a deep understanding of key datasets. You will design, implement and drive adoption of new analytic technologies and solutions and promote industry standard best practices. You will be responsible to tune query performance against large and complex data sets. You will help translate analytic insights into concrete, actionable recommendations for business or product improvement.
Key job responsibilities
• Will have relevant experience in data analytics working with large data sets and to extract and transform data using various tools and technologies (SQL, Excel, other data management tool).
• Will transform data into actionable business information, and will make it readily accessible to stakeholders. Will be very comfortable juggling competing priorities and handling ambiguity
• Will thrive in an agile and fast-paced environment on highly visible projects and initiatives.
• Design and implement reporting solutions and dashboards to enable stakeholders to manage the business and make effective decisions.
• Support cross-functional teams on the day-to-day execution of the existing program implementation.
• Will have good business and communication skills to be able to work with product owners to understand key business questions to build reports that enable product owners to answer those questions quickly and accurately.
• Will have to utilize automation tools, such as Excel ,SQL and Python scripting language, to streamline the generation of reports, reducing manual effort.
- 5+ years of Excel (including VBA, pivot tables, array functions, power pivots, etc.) and data visualization tools such as Tableau experience
- 3+ years of business or financial analysis experience
- Bachelor's degree or equivalent
- Experience making business recommendations and influencing stakeholders
- Experience defining requirements and using data and metrics to draw business insights
- Experience with Excel
- 5+ years of tax, finance or a related analytical field experience
- 3+ year experience in SQL /ETL tools
- Bachelor's degree in computer science, engineering, mathematics or equivalent
- 3+ year experience in SQL /ETL tools
- 3+ year experience in Excel and automation.