Senior Finance Manager OTC Ops Data Analytics - PowerBI

At Johnson Controls, we are passionate about making a positive impact on the lives of people all over the world. How do we do this? By working together on holistic solutions for smarter buildings and cities today and tomorrow. By protecting people and the environment. By giving back in the communities we live in. By solving today’s challenges while constantly asking ‘what’s next?’ So, what’s next in your future?

Create your next opportunity and join us as a Sr. Reporting Analyst to our Order To Cash department in Gurgaon, India.

By joining Johnson Controls, you’ll be part of a team that plays an essential role in helping to create a safe, comfortable, and sustainable world. As a globally diversified technology and multi-industrial leader serving a wide range of customers in more than 150 countries. Our 130,000 employees work to create intelligent buildings, efficient energy solutions, integrated infrastructure and next generation transportation systems that work seamlessly together to create smart cities and communities. 

We are committed to help our customers win and create greater value for all our stakeholders in everything that we do.

What will you do?

• Prepare and analyze various centralized reports highlighting business performance. Keep a governance on published report accuracy to Local Mangers & PBU counterparts. Should possess an in-depth knowledge of creating and maintaining Process Dashboard. Also ensure standardization of metrics in reporting and drive preparation and distribution of accurate reports with zero error
• Support financial planning activities of the businesses through the preparation and analysis of various centralized financial business process related projects and reports highlighting operating performance
• Reports Publishing - AR Aging Report / Collection Report / Sales Register / Unapplied Cash & Credits
• AR Provision for Bad Debt Report - Quarterly assessment of provision requirement as per JCI policy
• Monthly Closure of AR Module in SAP / Oracle / Baan / Qolsys / Amer - Closure of AR Module and Opening of new period
• Month Closing - Submitting JE to GL for intercompany, Unapplied Credit, WHT, Forex reinstate, Vendor balance transfer etc.
• To ensure compliance to applicable policies, guidelines, and regulations

How will you do it?

1: Operation Management

• Key focus in identifying opportunities to develop robust solutions to automate and optimize reporting activities for the business
• Drive development and implementation of Accounts Receivable dashboards, Performance dashboards, KPI dashboards, etc. to visualize in a simple and easy-to-read manner
• Apply professional judgment basis quantifiable data and information in resolving data integrity issues
• Be proactive and innovate ideas to improve service deliverables, based on improved performance/efficiency and with an understanding of risk
• Interact with the IT staff and leadership, analyzing issues and Integrate data from various sources to optimize reporting. Drive a coordination with other Sub Processes/teams to provide information effectively
• Support unification and harmonization of reporting presentation tools (e.g. through Power BI, Easy morph, Oracle database, and other relevant data presenting tools)
• Maintain close alignment with all customers of the Management Reporting and Data Mining teams to ensure their reporting requirements are being met (i.e. Operational, Cash App, Finance, etc.)
• Liaise with IT to manage process of data mapping, UAT testing, etc.
• Embrace a business focused and results oriented team within Order to Cash
• Perform various ad-hoc assignments and coordinate with month end closing process within timelines
• Coordinate and Interact with different stakeholders on a regular interval in driving closure to all open issues

2: People Management

• Responsible for team performance
• Develop, and train team members to ensure a positive, open, and flexible work environment and help them achieve their short-term and long-term goals
• Plan team capacity, allocate projects accordingly and address potential bottlenecks/ backlogs proactively
• Manage and motivate team members to have a better retention
• Develop a specific management culture for shared services aiming efficient service delivery
• Conduct regular team meetings, share goals, and provide feedback on teams’ performance.
• Initiate 1x1 and performance appraisal discussions with team and share a constructive feedback

3: End-to-End process improvements

• Ensure adherence to internal and external guidelines as well as to a standardized process landscape
• Contribute ideas and actions towards the continuous improvement of processes within area of influence
• Initiate and support improvement initiatives and related projects

4: Relationship Management

• Respond stakeholders on a timely manner
• Maintain a positive cross functional relationship with other teams of OTC
• Should be a part of the extended leadership team of PBU CFO

What we look for?

• Bachelor’s Degree in Information Technology required; Any Finance/Accounting experience preferred
• Working experience within a shared services environment supporting any Global region is mandatory
• Fluency in English in terms of both verbal and written communication skills would be preferred
• Essential: over 13 - 15 years of relevant experience; 5 – 7 Years of experience in OTC processes is required.
• Working proficiency of databases (Oracle, SQL Server) and data modelling is a mandatory requirement
• Essbase & MicroStrategy experience preferred
• Experience with any data visualization tool (Power BI, Tableau, or Qlik Sense). Deep knowledge of PowerBi is required.
• Advance skills in Microsoft® Word, Access, Excel, VBA, Visio, PowerPoint & Outlook including ability to utilize advanced formula, Utilize Pivot Tables and V-Lookups.
• Ability to develop complex macro to automatize reports
• Adhere to deadlines, provide value-added analysis to assist finance leaders to take calculative decisions
• Strong analytical and problem-solving skills with a proactive and solution-oriented approach toward business issues
• Team player with pro-active approach; Analytical / Quantitative problem-solving skillset
• Experience of working in a Shared Service Centre/Retained/Outsourced environment would be an added advantage
• Assist in establishing and maintaining strong, collaborative relationships with internal and external customers
• Experience in any Global process transition would be preferred

Johnson Controls does not request pregnancy or HIV testing as a requirement for admission, permanence, or promotion