Senior Analyst

About Team

The Cost Analytics team supports all analytical and data requirements that supports the accounting function – specifically Margin & Cost, Vendor Funding, Imports, Trade Payables and Transporation Accounting. Leveraging firm’s tech stack, the team works on varied problem statement and help in providing an optimum solution to end users

Job Summary
The Senior Business Analyst is primarily responsible for supporting a team dedicated to the accounting function for Lowe’s US operations. The principle purpose of the Senior Business Analyst is to work with the Business leaders in delivering impactful data driven analytics support to the COA office. This position is responsible for designing the report to business needs with analytical best practices, facilitate to analyze results and identify insights for decision making. A substantial amount of technical knowledge is needed to support the various user requests and special projects.

This is accomplished by utilizing advanced tools and methods to leverage various financial data. A goal of this position is automation of processes and enhancements of existing business analytics. To accomplish this, the Analyst must have decent knowledge of cost and financial analytics, be proficient in MS Excel, SQL, Teradata, Knime/Alteryx, Power Apps, Power Query, Power BI, Hadoop (Big data), Google Cloud Platform, Python, R etc.

The Senior Business Analyst will collaborate directly with various areas of accounting teams and other areas of the Business in order to ensure Inventory, Revenue and Margin are reported accurately both from an Operational and Financial perspective.

Core Responsibilities

• Partner with domain leaders to understand the requirements
• Research and document the requirements in collaboration with IT Finance
• Develop wireframes and seek feedback from end users
• Propose and present solution/analysis/recommendations to end users
• Create solutions addressing the specific challenge using various tools
• Create and maintain documentation of processes
• Act as a consultant to end users for recommendation on tools and technical feasibiliity

Minimum Qualification / Skillset

• 5+ years of experience in the domain of Reporting & Analytics / Power BI Development
• Bachelor's Degree in Finance, Accounting, Analytics, Engineering or Business Intelligence
• Post Graduate in Finance/ Business Analytics will be an added advantage
• Experience working with multiple stakeholders across locations.

Skill Set Required

Primary Skills (must have)

• Understanding of relational databases – Teradata, IBM DB2, Hadoop, Google Cloud Platform
• Expertise in SQL – DDL & DML – Joins, Partition, Update, Stored Procedures, Query tuning, etc
• Advance MS Excel experience
• Exposure to ETL tools like Alteryx and Knime
• Experience with Business Intelligence and Reporting tools, preferably in Power BI, Dart, Microstrategy
• Ability to create charts/visualization that aptly represents the trends and analysis
• Analytical mindset to understand and solve complex business problem

Secondary Skills (desired)

• Experience working with analytical tools like Python, R - Pandas, NumPy, PyOdbc,dateTime, etc
• Knowledge of HTML, CSS and JS
• Experience in Web Apps using React Framework
• Exposure to API concepts using NodeJS