Responsible for building technical forecast sales reporting solutions for APJ Enterprise Business operations. The Solution Architect will join the Sales Process Decision Support organization in the sales forecasting team, and be accountable for understanding business requirements and transferring them into clear reporting solutions that focus on elements of process management. The candidate must be an expert in SQL and be able to create reports via SQL scripts. They will be responsible for working with various country counterparts to ensure data consistency, validity, and process governance. The individual must be capable of managing multiple workflows, contain expert level technical skill sets, and be proficient in multiple reporting technologies. One key area of focus in the Monthly Sales Review preparation, which involves mass data collection from various data sources, data editing/analysis, and working with country counterparts to validate data prior to distribution. The Solution Architect will be accountable for extracting data from multiple sales, finance, and compensation systems and generating a report across various business product lines and business units within APJ.
Job Description:
- Partner with regional, country, and worldwide teams to build effective reporting solutions
- Design and develop complex reporting solutions that provide visibility into forecasts, pipeline, sales effectiveness, and performance management
- Extract data from multiple data sources via SQL statements
- Validate data with various countries and business units to ensure solutions are high in data integrity
- Capable to comprehend and deliver results on complex algorithms and sales metrics related to HP forecasts
- Ensures sales process governance through BI reporting solutions
- Provides recommended analytical metrics to ensuring sales process adoption, consistency, and business clarity
- Guide the strategic direction of HP EB Operations sales process analytical framework
- Drive the stability and assurance of the APJ BI reporting platform
- Ensure the Business reflects confidence in team reporting solutions
Job Requirement:
- First-level university degree required; advanced university degree preferred
- Expert level experience in building sales reports using SQL from multiple data sources
- Typically 7+ years of experience in BI reporting and analytics
- Expert SQL proficiency, experience in designing database and extracting data for analysis
- Expert working with SQL Server, MS Access, Oracle, or SAP
- Very strong in VBA scripting, MS Excel and Access programming
- Strong technology business acumen
- Strong experience in sales forecast reporting required
- Strong MS Windows knowledge, including SharePoint , PowerPoint, Word, Macro, Visio and MS Project
- Experience leveraging multiple data sources for reporting solutions, large volumes of data, compiling data extracts
- Knowledge and experience with Data Warehousing and Data Modeling concepts
- Experience with CRM systems required
- Knowledge of Business Objects reporting tool knowledge, and other reporting technology are desirable while not mandatory
Other Knowledge and Skills required:
- Strong communication skills includes verbal, written, and presentation forms
- Strong analytical and business acumen; in-depth business and sales operations knowledge
- Expert technical skills including database designing and scripting and at least one programming language skills
- Experience with building forecast and pipeline reports
- Excellence in analytical reporting design, development, and execution within a multi-dimensional organization
- Ability to work internationally, across various forms of business units
- Number-driven, detailed oriented, resourceful, and pro-active individual
- Ability to work independently, prioritize and meet demanding deadlines
- Knowledge of sales operations, sales requirements, and sales processes/workflows
- Proven data quality and integrity process development