Data Analyst

Gather disparate data; analyze and normalize to ensure data integrity for analysis. Provide consistent, relevant and accurate data and analysis as well as guidance/knowledge of the data and definitions that are available. Constantly strive for process improvement looking to add value across the organization through insightful analytics.

Major Tasks, Responsibilities and Key Accountabilities

• Serves as a data expert across the entire organization.
• Gathers and compiles raw data; conducts research for industry trends and benchmarks; and normalizes data.
• Develops complex data models using disparate sources; transforms data into easily consumable sources that can be used to produce insightful and meaningful analytics.
• Analyzes, reports, makes comparisons to industry/company benchmarks, determines trends, and prepares cost analyses.
• Defines data definitions and documents data limitations.
• Prepares data models for analysis; create dashboards, reports, maps and ad hoc requests using tools such as Microsoft Excel, Alteryx, Tableau, Microsoft Power BI, SQL Server Management Studio, SAP BPC, Thought-spot and Showcase Query. May make presentations.
• Provides recommendations based on findings and analysis. Provides input on policies and procedures. Constantly questions the status quo and searches for opportunities to improve processes.
• Participates in department and interdepartmental projects.
• Performs other duties as assigned.

Minimum Qualifications

• Must be a minimum of 18 years of age or older
• Must pass per-employment assessment(s) if applicable

Preferred Qualifications

• Expertise in working with spreadsheets, databases, strong understanding of financial concepts and data.
• Experience in aggregating large volumes of financial data for analysis.
• Experience with data analysis in large distribution businesses.
• Certification on database/analysis tools.
• Experience in acquiring data within large multi-system enterprise environments.
• Advanced experience with Microsoft Office Suite
• Experience with Alteryx, SQL (SQL Server Management Studio), DB2, Tableau, Microsoft Power BI, SAP BPC, Thought-spot and Showcase Query a plus.