The Financial Controls and Data Insights Analyst is a key role that supports the Controllership function.  The Analyst will work to leverage data to embed the use of analytics to provide business intelligence, continuous monitoring, and assurance over financial data.  The role will support the company’s control environment by reviewing financial data and providing real time insights. 

The Analyst will be a partner with functions across the organization to assess business activities, key risks, and identify opportunities to leverage data to inform risk mitigation and monitoring. This role will help to develop and execute repeatable data analytics processes to strengthen internal controls over financial data. The role will also focus on providing business intelligence capabilities within the accounting function to help us become more predictive of risks. 

ESSENTIAL DUTIES AND RESPONSIBILITIES 

• Execute and enhance the Finance data analytics strategy to help become more predictive of risk.  

• Support Controllership management in continuous improvement and controls monitoring. 

• Build, develop, and maintain data models, key risk indicators, reporting systems, data automation systems, dashboards, and performance metrics that provide finance business intelligence.  

• Ability to support and conduct control workshops to identify financial data insights.  

• Ability to leverage large data sets from multiple sources seamlessly.  

• Ability to lead, develop, and conduct continuous monitoring projects using advanced data modeling and analysis techniques. 

• Ability to leverage and use technology effectively, including advanced data analytics techniques, visualization tools for dashboarding. 

• Develop and deliver training to Financial Accounting teams on data extraction and analysis techniques.  

• Coordinate with internal functions to ensure risk is managed holistically across the enterprise. 

• Develop an expert working knowledge and understanding of the Company and our objectives. 

• Demonstrates a high level of ethics, integrity, and professional judgement in all activities as a representative of Controllership and Advance Auto Parts overall. 

• Ability to execute multiple projects concurrently while delivering accurate and reliable insights.  

SUPERVISORY RESPONSIBILITIES 

This position will not directly oversee staff members. 

QUALIFICATIONS 

• Proficiency with Python, essential SQL skills, and advanced Excel and Power Query skills are required. 

• Proficiency and knowledge in leveraging open-source tools and software. 

• Proficiency leveraging generative AI solutions, Co-Pilot or other coding assistants. 

• Experience leveraging cloud data storage platforms (Snowflake, Databricks)  

• Ability to leverage business finance systems (Oracle experience preferred) and tools (Excel, Word, PowerPoint, PowerBI, etc.) to support data analytics execution and measurement of results. 

• Assimilate and synthesize complex data and information into a decision-making framework. 

• Excellent communication, facilitation, and interpersonal skills including the ability to build relationships and interact effectively across the business. 

• Solid critical thinking and analytical skills with the ability to quickly assess business processes, solve complex problems, and work on unstructured assignments. 

• Demonstrated project management skills, organizational skills and ability to prioritize assignments, deal with interruptions, and meet multiple deadlines in a fast-paced environment. 

• Highly motivated self-starter with the ability to work both individually and in a team environment. 

• Ability to simply and clearly write and present insights to senior stakeholders.  

EDUCATION and/or EXPERIENCE 

• 5+ years relevant Risk, Finance or Accounting related experience (public accounting or risk management) required. 

• Bachelor’s/ or Master’s degree in Accounting, Finance, Science, Management Information Systems, Business Administration, or related fields from a four-year college or university required. 

• Experience with data extraction & modeling business intelligence (BI) tools; experience using data analytics techniques and working knowledge of data analytics tools. 

• Ability to develop visual dashboards results using Power BI (DAX proficiency preferred), Tableau, or similar. 

• Experience in consumer or retail industry, preferred. 

Based in Raleigh, North Carolina, this will be a hybrid role with partial onsite office expectations in accordance with Company policy. 

PHYSICAL DEMANDS 

The physical demands described here are representative of those that must be met by an employee to successfully perform the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions. 

While performing the duties of this job, the employee is regularly required to sit and talk or hear.  The employee is occasionally required to stand; walk; use hands to finger, handle, or feel; reach with hands and arms; and stoop, kneel, crouch, or crawl.  The employee must regularly lift and/or move up to 10 pounds and occasionally lift and/or move up to 25 pounds.  Specific vision abilities required by this job include close vision, distance vision, color vision, and ability to adjust focus. 

WORK ENVIRONMENT 

The work environment characteristics described here are representative of those an employee encounters while performing the essential functions of this job. Reasonable accommodations may be made to enable individuals with disabilities to perform the essential functions.  The noise level in the work environment is usually moderate.