Position Title: BI Analyst I (P1)
Company Summary
Crown Castle is the nation’s largest provider of shared communications infrastructure: towers, small cells and fiber. It all works together to meet unprecedented demand—connecting people and communities and transforming the way we do business. Whenever you make a call, track a workout or stream music and videos, we’re the ones providing the communications infrastructure that makes it all possible. From 5G and the internet of things to drones, autonomous vehicles and AR/VR, we enable the technologies that help people stay safe, connected and ready for the future. Crown Castle is publicly traded on the New York Stock Exchange (CCI), is part of the S&P 500 and is one of the largest Real Estate Investment Trusts in the US.
We offer a total benefits package and professional growth development for teammates in any stage of their career. Along with caring for our teammates, we’re an active member in the communities where we live, work and do business. We have a responsibility to give back, which we do through our Connected by Good program. Giving back allows us to improve public spaces where people connect, promote public safety and advance access to education and technology.
Role
The BI Analyst for Supply Chain will be responsible for providing accurate, complete and meaningful reports and analysis used for category management and decision making. In partnership with Supply Chain Category Managers, the BI Analyst is responsible for creating and maintaining reports and analysis to be utilized by the Supply Chain team to determine cost savings, identify sourcing opportunities, and monitor compliance. The BI Analyst is expected to deliver high quality analysis and drive continuous improvements throughout our category management processes, as well as support our analytics team in data mining and review, as necessary.
Responsibilites
Create and maintain reporting tools & analysis to determine cost savings, identify sourcing opportunites, and monitor compliance. Establish strategy, processes and tools to effectively build product should-cost models to identify opportunities and utilize for negotiations. Create insights from data to work with category managers, area material specialists and project managers to optimize supplier agreements. Proactively identify and partner to mitigate risks to performance and pursue opportunities to improve performance with key stakeholders. Review customer opportunities related to demand to identify new initiatives for the team that could result in cost savings measures. Build and maintain strong, collaborative relationships with other company stakeholders to drive accomplishment of overall company goals and objectives. Support analytics team with categorization and clean up efforts related to master data management. Provide ad-hoc analysis to category management team & perform specials projects as requested.
Education/Certifications
Bachelor’s Degree in Supply Chain, Business, Accounting, Finance or related discipline preferred.
Experience/Minimum Requirements
One (1) years of experience in an analyst or supply chain related position. Knowledge of MS Excel (specifically, advanced formulas, Vlookup, pivot tables and charts) including experience building complex financial models Familiarity with forecasting methods and data analysis Experience with JDE and Oracle Financial system or similar ERP systems Understanding of metrics and their use to drive behavior and process change
Expectations
Ability to recognize problems, recommend solutions, and collaboratively implement changes leveraging strong analytical and problem-solving skills Routine communication with management relating to financial analysis, issues and deliverables. Strong ability to effectively and efficiently communicate financial results to management. Demonstrate candor and poise to field difficult questions from internal and external audience. Excellent interpersonal skills, able to build and maintain trusting relationships. Understanding of the data sets that can be pulled from the system for reporting purposes. Make use of data to tell a story to the team and stakeholders and provide actionable recommendations. Effectively organize, prioritize and execute on initiatives to enhance performance. Support experimentation as a way to find the best solution. Ability to develop financial acumen to better understand economic and financial value drivers. Must have strong computer skills, specifically Microsoft (Excel, PowerPoint, Power BI), JDE ERP, & Oracle ERP
Organizational Relationship:
Reports to: Director, Strategic Sourcing
Title(s) of direct reports (if applicable): N/A
Working Conditions: This role falls into our hybrid work model working in the office Tuesdays, Wednesdays, and Thursdays. On Mondays and Fridays, teammates on the hybrid schedule will have the option to work from the office or home. There is an expectation of collaboration with teammates and stakeholders for moments that matter that could require travel.
#Li-IM1 LI-Hybrid