Financial Controls & Data Insights Analyst

Job Description**LOCATION & WORK AVAILABILITY**This position is of a Hybrid Work Arrangement requiring; 4-days in office, 1-day remote per week. Based at our corporate headquarters in Raleigh, North Carolina (North Hills).The Financial Controls and Data Insights Analyst is a key role that supports the Controllership function. The Analyst will leverage data, AI-driven tools, and automation to embed analytics across finance operations—delivering business intelligence, continuous monitoring, and financial assurance over critical data. The role will strengthen the company’s control environment by building automated accounting controls, performing finance analytics, and providing real-time insights that drive confident decision-making.The Analyst will partner with functions across the organization to assess business activities, identify process improvement opportunities, and leverage AI and automation to enhance financial assurance and monitoring. This role will develop and execute repeatable, scalable data analytics processes—including automated workflows and intelligent controls—to strengthen the integrity of financial data. The role will also focus on building business intelligence capabilities within the accounting function to deliver proactive, forward-looking insights.ESSENTIAL DUTIES AND RESPONSIBILITIESExecute and enhance the Finance data analytics strategy, incorporating AI and machine learning techniques to deliver proactive financial insights and assurance.Design, build, and maintain automated accounting controls, data models, reporting systems, dashboards, and performance metrics that provide finance business intelligence.Identify and implement automation opportunities across financial processes to improve accuracy, efficiency, and scalability of controls monitoring.Leverage generative AI and intelligent automation tools to streamline data extraction, reconciliation, and anomaly detection within financial data.Support Controllership management in continuous improvement of controls and finance operations through data-driven recommendations.Support and conduct control workshops to identify financial data insights and opportunities for process automation.Integrate and analyze large data sets from multiple sources seamlessly, applying advanced analytics and AI-assisted techniques to surface actionable intelligence.Lead, develop, and conduct continuous monitoring projects using advanced data modeling, automation frameworks, and analysis techniques.Leverage technology effectively, including AI/ML platforms, advanced data analytics techniques, and visualization tools for dashboarding and reporting.Develop and deliver training to Financial Accounting teams on data extraction, analysis techniques, and emerging AI and automation tools.Coordinate with internal functions to ensure financial controls are managed holistically and that automation solutions align with enterprise standards.Develop an expert working knowledge and understanding of the Company and our objectives.Demonstrate a high level of ethics, integrity, and professional judgement in all activities as a representative of Controllership and Advance Auto Parts overall.Execute multiple projects concurrently while delivering accurate and reliable insights.SUPERVISORY RESPONSIBILITIESThis position will not directly oversee staff members.QUALIFICATIONSProficiency with Python, essential SQL skills, and advanced Excel and Power Query skills are required.Proficiency and knowledge in leveraging open-source tools, libraries, and software for data analytics and automation.Proficiency leveraging generative AI solutions, AI-powered coding assistants (e.g., Co-Pilot, Claude), and automation frameworks to accelerate analytics development.Experience leveraging cloud data storage platforms (Snowflake, Databricks) and building automated data pipelines.Ability to leverage business finance systems (Oracle experience preferred) and tools (Excel, Word, PowerPoint, Power BI, 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 EXPERIENCE0-5 years relevant Finance, Accounting, or Analytics related experience (public accounting, financial systems, or automation/analytics roles) strongly preferred.Bachelor’s or Master’s degree in Accounting, Finance, Data Science, Management Information Systems, Business Administration, or related fields from a four-year college or university required.Experience with data extraction and modeling, business intelligence (BI) tools, and working knowledge of data analytics and AI/ML platforms.Ability to develop visual dashboards and automated reporting 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.Applicants must be legally authorized to work in the United States for any employer. This position is ineligible for employment visa sponsorship. This includes initial or change of employer filings of any kind, including but not limited to H-1B, TN, or E-3.PHYSICAL DEMANDSThe 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 ENVIRONMENTThe 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.#LI-GG1We are an Equal Opportunity Employer and do not discriminate against any employee or applicant for employment because of race, color, sex, age national origin, religion, sexual orientation, gender identity, status as a veteran and basis of disability or any other federal, state or local protected class. We comply with all applicable federal, state, and local laws.California Residents click below for Privacy Notice:https://jobs.advanceautoparts.com/us/en/disclosures #J-18808-Ljbffr