About the role SmartSign is seeking a Commercial Finance Analyst who will join our Strategy and Finance teams. As a Commercial Finance Analyst, you will support our organization by partnering with leadership across sales, advertising, operations, finance, product management and corporate development and be responsible for creating, enhancing, and maintaining reporting and analysis across our organization. This role requires that you be a proactive and action-oriented self-starter who can effectively navigate ambiguity and manage competing objectives in a lean, fast-paced organization. You will conduct detailed industry and market research with the opportunity to present key insights. You will also aid in the development and rollout of operational processes to increase our efficiency and to support/enhance data capture for more robust and accurate reporting and analytics. Your work will directly support the strategic vision and active initiatives within the organization. Responsibilities Data structuring and cleaning
Structure data sets for analysis, including cleaning and manipulating large datasets
Combine data sources to enable improved analytics
Work with functional groups to understand data nuances to ensure accuracy of analytics
Data analysis
Build and maintain business intelligence dashboards supporting core commercial and financial metrics
Empower end-users through building capabilities across the organization to enable user-driven analytics
Develop financial models for budgeting and forecasting
Create pricing and profitability analytics
Support new product development through market opportunity assessment
Create customer ‘live review’ analytics
Develop inventory models to support supply planning
Analyze value chain of product lines to support make vs. buy decisions
Run cohort analyses to understand comparative value of customer groups
Assess customer payback on an ongoing basis
Conduct other ad hoc analysis
Interpretation and insights
Identify new opportunities to improve data management and usage
Derive and communicate key insights from analytics dashboards
Report to management team on core operating (e.g. customer, commercial, ecommerce, financial) metrics
Required qualifications
Bachelor’s Degree or higher in Data Analytics and/or Finance from a leading College or University
3+ years of experience in an analytical role (e.g. financial analyst, data analyst, management consultant)
Advanced technical skills across Excel, PowerPoint, SQL, Business Intelligence Tools (such as Power BI, Tableau, Looker, etc.)
Proficiency in financial modeling and data analysis tools
Strong analytical and quantitative skills; ability to determine trends and propose solutions
Project management experience, ability to manage multiple tasks concurrently with strong organizational and documentation skills
Competencies
Inquisitive individual who challenges the effectiveness of current processes and procedures
Self-starter who takes the initiative and shows ability to influence others
Creative problem solver who thrives in a fast-paced environment
Team builder who promotes cooperation and collaborative relationships