Location: Basking Ridge, NJ
The Consultant – Executive BI & Reporting role is to provide the metrics, reports, dashboards and business intelligence to support the executive dashboards and reports and other ad hoc reporting, as well as, have mastery of all the current and new information data acquisition and reporting capabilities. The consultant should be cross trained so he can provide backup for senior analysts in the group.
The BI and Reporting consultant should have the capability and flexibility to use all his skills in SQL coding, BEX report development, Tableau coding and MS SQL Server Analysis Services to create the reports necessary for the business on a ad hoc basis. They also should be knowledgeable about the new tools available including, but not limited to, Teradata’s Aster, Hortonworks Hadoop and various data lakes and sandboxes within Verizon. They will need to know the tools and methods to transform the data in our systems into meaningful reports to support the information needs of the business, as well as, become the expert in understanding the business objectives, data questions, and reporting problems.
Be the main point of contact for critical supply chain business data requests and reports. Develop ad hoc reporting, metrics, dashboards and business intelligence based on the needs of the business, including S&OP, inventory valuation, sales and forecasting trending.
Be able to obtain and build reports and dashboards from data sources within the business, which includes, Oracle Supercluster, Hadoop, EDW, BW on HANA and SAP ECC, as well as, work closely with IT to standardize and automate the reports.
Stay current and learn business intelligence tools to provide business group with the best available reporting
Communicate reports and dashboards in an executive format ensuring flawless data quality and standards.
Be cross trained on the reporting that is conducted by the Reporting consultants by staying current with current business activities and day-today operational activities.
Create the reports, dashboards and metrics for executives in a timely fashion. Know the process of creating story boarding and be able to execute the process. Act as liaison between the business and IT technical teams to move a prototype report into production Create data models, schemas and OLAP to know how to build reporting and dashboards Work with business intelligence teams across VzW to know where the data resides, the best tools to access the data and build reporting. Maintain and store data definitions for the various data warehouse reports and dashboards and assist with maintaining these data definitions Provide on-going support for the business community and data warehouse staff in relation to existing reports/dashboards with respect to their definitions and differences Participate in the investigation and resolution of data warehouse related problems, stemming from the availability of the database, report, and programming errors. Ensure findings are communicated to the business community
- 3+ years and working knowledge of SQL, MS SQL Server Analysis Services, Tableau, COGNOS
- Background in supply chain
- Excellent verbal and written communication skills
- Proficiency in engaging and influencing large teams and functional leaders
- Experience and competency in supply chain management
Equal Employment Opportunity
We’re proud to be an equal opportunity employer – and celebrate our employees’ differences, regardless of race, color, religion, gender, sexual orientation, gender identity, national origin, age, disability, or Veteran status. Different makes us better.