Senior Reporting Analyst (Business Objects, Crystal Reports, T-SQL, Data Mining, VBA) in Davidson, NC

Position: Senior Reporting Analyst (Business Objects, Crystal Reports, T-SQL, Data Mining, VBA)
Duration: Full-Time Permanent position (no contract, no corp to corp, no remote)
Location: Davidson, NC
Salary: Excellent compensation with benefits + bonus
Skills: Senior Reporting Analyst, Report Writer, Business Objects, Crystal Reports, T-SQL, Data Mining, VBA, Business Objects-WEBI, MS Access

ROLE DESCRIPTION:

The Senior Product Reporting Analyst will be responsible for driving innovation and automation of reporting tools and processes.

The role will be required to enhance reporting processes, develop QA process for World Class Data initiative, provide analytical insight into SKU development process and utilize analytical aptitude to interpret results and communicate performance on a recurring basis to senior management, including the Board of Directors and the Executive Team. The Sr. Product Reporting Analyst will play an important part in accessing data stored in multiple sources by utilizing available business intelligence tools and processes; advanced spreadsheet skills including macros, relational database knowledge and solid experience with advanced querying languages are required.

DUTIES AND RESPONSIBILITIES:

    Implements innovative and creative reporting solutions and techniques to communicate financial and operational performance to management team.
    Publish dashboard results, provide deeper analysis on SKU development progress via metrics and supplier level reporting to capture increased revenue from adding SKUs and support item graduation from DS Web to Stocked
    Develops and implements World Class Data (WCD) QA process to validate accuracy data for product SKUs and coordinates WCD QA process with Product Information team, serving up prioritized issues for resolution.
    Builds repeatable and automated processes, including queries, content, style and consistencies to support all future waves of World Class Data project.
    Leverages new product Taxonomy to build gross margin and profitability measurement tools highlighting top and bottom line opportunities.
    Plans, develops and implements decision support tools to drive sell price analytics and assist in establishing competitive pricing strategies and assess impact of discounting.
    Utilizes project management skills and knowledge gathering platforms such as Voice of the Customer (VOC) and Focus Groups, to enhance recurring operational and month-end reports by working with internal customers and other cross-functional leaders to understand business needs. Works with IT to align reporting tools and content with those needs.
    Plans, develops and implements decision support and analytical tools to assist in identifying customer trends, service levels and performance hits & misses by utilizing advanced features of MS-Excel, MS-Access.
    Creates gross margin and profitability measurement tools along with interactive models and various scenarios to highlight top and bottom line opportunities.
    Interprets and communicates performance results monthly in an intelligent and clear manner to operational and senior managers by utilizing dashboards and drill-down reporting.
    Assists in the development of key performance metrics and measurement tools for key business initiatives for the product leadership team.
    Identifies and drives automation of repetitive reporting processes to deliver productivity improvements and reduce non-value added activities.
    Effectively retrieves reporting data from data warehouse and multi-dimensional cubes utilizing T-SQL, Visual Basic for Applications and other advanced querying languages.
    Creates self-service tools for end users providing direct access to data needed for routine requests utilizing Crystal Reports and WEBI.
    Works cross-functionally with corporate planning, accounting, data warehouse and IT teams to ensure alignment and execution of reporting deliverables and capabilities.
    Fosters the corporate Culture in the department and throughout the company to ensure unity of purpose and fulfillment of corporate mission.
    Participate on special projects and perform additional duties as required.

MUST-HAVES REQUIREMENTS:

    Business Objects-Crystal Reports is required.
    Data mining and retrieval utilizing T-SQL is required
    Advanced financial modeling and various scenario building is required.
    Solid organizational and time management skills are required.
    Excellent analytical skills and problem solving ability is required.
    Advanced MS-Excel and MS-Access is required.
    Business Objects-WEBI is required.
    Solid organizational and time management skills are required.
    Advanced financial modeling and various scenario building is required.
    Excellent analytical skills and problem solving ability is required.
    Ability to prioritize multiple requests/projects and manage workload to meet deadlines is required.
    Excellent inter-personal and communication skills are required.

NICE-TO-HAVES REQUIREMENTS:

    Programming in Visual Basic for Applications (VBA) is preferred.
    AS400 experience is preferred.
    Project management skills and knowledge of MS-Project is preferred.
    Knowledge of financial metrics, ratios, profit & loss statements, balance sheets.
    Distribution/Retail experience with emphasis in sales, logistics, or product management functions is preferred.

EDUCATION AND EXPERIENCE:

    A Bachelor’s Degree in Finance, Accounting, Business or Computer Science with applicable reporting experience or equivalent work experience is required.
    Minimum of five years in related business experience is required.
    2 to 3 years of supervisory experience preferred.
    Distribution/Retail experience with emphasis in sales, logistics, or product management functions is preferred.

======================================