Senior Finance Manager OTC Ops Data Analytics - PowerBI

Reposted 4 Days Ago
Be an Early Applicant
Gurgaon Sector 14, Gurugram, Haryana, IND
In-Office
130K-150K Annually
Senior level
Other • Security
The Role
The Senior Finance Manager will analyze reports, oversee financial planning, drive automation in reporting, and manage a team, ensuring compliance and improving processes.
Summary Generated by Built In

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. General Manager 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, govern, and analyze enterprise-wide Power BI reports and exports highlighting business and financial performance. Own end-to-end governance on published dashboards and exported datasets for accuracy, consistency, and timeliness across Local Management, PBUs, and Global stakeholders.
  • Lead the design, build, and maintenance of scalable Process Dashboards and Export-ready Power BI models, ensuring metric standardization, version control, and zero-error reporting.
  • Support global financial planning and analytics through complex Power BI exports, data models, and centralized reporting initiatives that highlight operating and cash performance trends.
  • Own and oversee Power BI-based publishing of key AR reports such as AR Aging, Collections, Sales Register, Unapplied Cash & Credits, ensuring automation and seamless export capabilities for downstream consumers.
  • Lead quarterly AR Bad Debt Provision analysis through Power BI, enabling scenario-based assessment and compliance with JCI policy.
  • Oversee Month-end and Period-end AR reporting closures across ERP systems (SAP / Oracle / Baan / Qolsys / Amer), ensuring Power BI datasets are refreshed, reconciled, and aligned with closed periods.
  • Manage month-end reporting support activities including supervision of JE-related analytics for Intercompany, Unapplied Credits, WHT, Forex reinstatement, vendor balance transfers, etc.
  • Ensure full compliance with internal controls, reporting governance standards, export protocols, and applicable policies and regulations.

1: Operation Management

  • Own the strategy to identify, design, and implement export-optimized Power BI solutions that automate, simplify, and standardize reporting delivery for global businesses
  • Drive development of high-impact Accounts Receivable, Performance, KPI, and Executive dashboards with downloadable/export-ready formats for senior leadership and PBUs
  • Apply strong data governance and professional judgment to resolve complex data integrity, reconciliation, and model dependency issues
  • Proactively lead innovative initiatives to improve reporting efficiency, scalability, and user experience while managing reporting and data risks
  • Partner with IT, Data Engineering, and Architecture teams to integrate data from multiple ERP and source systems into Power BI semantic models
  • Lead cross-process coordination with OTC sub-processes (Billing, Cash App, Credit, Finance) to ensure timely and accurate data availability
  • Champion harmonization and standardization of reporting and export tools (Power BI, Easy Morph, Oracle DB, SQL Server, other visualization and ETL tools)
  • Maintain senior-level engagement with Power BI consumers (Operations, Finance, Cash Application, Leadership teams) to align reporting outputs with business needs
  • Oversee UAT cycles, data mapping, refresh schedules, and deployment governance for Power BI exports
  • Foster a performance-driven, business-focused reporting and analytics culture within the OTC Export & Reporting team
  • Drive timely completion of ad-hoc analytics, leadership requests, and month-end reporting activities
  • Act as an escalation point and proactively drive closure of open reporting, data, and stakeholder issues.

2: End-to-End process improvements

  • Ensure strict adherence to standardized reporting processes, data governance frameworks, and external/internal compliance requirements
  • Identify, initiate, and sponsor continuous improvement opportunities across Power BI reporting, export automation, and data validation processes
  • Lead and support transformation initiatives including reporting simplification, automation, and reduction of manual dependencies

3: 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 recommended.
  • Strong hands-on experience with Power BI data modeling, DAX, performance optimization, security, and export enablement
  • Mandatory proficiency in databases and data modeling (Oracle, SQL Server)
  • Experience with Power BI. Deep knowledge 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.
  • 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
  • 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

Skills Required

  • Bachelor's Degree in Information Technology required; Any Finance/Accounting experience preferred
  • Fluency in English in terms of both verbal and written communication skills
  • Over 13-15 years of relevant experience
  • 5-7 years of experience in OTC processes
  • Working proficiency of databases (Oracle, SQL Server) and data modelling
  • Deep knowledge of Power BI

Johnson Controls Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Johnson Controls and has not been reviewed or approved by Johnson Controls.

  • Retirement Support Retirement support is positioned as a meaningful part of the package through employer 401(k) matching, repeatedly framed as a strong pillar of the overall rewards mix. The matching contribution is described with specific match levels in multiple places, reinforcing perceived value for long-term saving.
  • Leave & Time Off Breadth Time off is presented as comparatively robust, with multiple paid holiday categories, vacation time, and sick time described as generous or “amazing” in places. Paid time off breadth appears to be a consistent contributor to total rewards attractiveness beyond base pay.
  • Flexible Benefits Benefits are described as broad and customizable, spanning standard medical/dental/vision plus optional add-ons like pet insurance, identity protection, and legal support. Tuition reimbursement is repeatedly highlighted as a high-value option supporting professional development.

Johnson Controls Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Chennai
100,000 Employees
Year Founded: 1885

What We Do

At Johnson Controls, we transform the environments where people live, work, learn and play. From optimizing building performance to improving safety and enhancing comfort, we drive the outcomes that matter most. Dedicated to protecting the environment, we deliver our promise in industries such as healthcare, education, data centers and manufacturing. With a global team of 100,000 experts in more than 150 countries and over 130 years of innovation, we are the power behind our customers’ mission. Our leading portfolio of building technology and solutions includes some of the most trusted names in the industry, such as Tyco®, York®, Metasys®, Ruskin®, Titus®, Frick®, Penn®, Sabroe®, Simplex®, Ansul® and Grinnell®.

Similar Jobs

Optum Logo Optum

Associate Director - Product

Artificial Intelligence • Big Data • Healthtech • Information Technology • Machine Learning • Software • Analytics
In-Office
Gurgaon, Gurugram, Haryana, IND
160000 Employees

Pfizer Logo Pfizer

Associate Manager, Medical Communications and Content Solutions​- Vaccines

Artificial Intelligence • Healthtech • Machine Learning • Natural Language Processing • Biotech • Pharmaceutical
Remote or Hybrid
India
121990 Employees
2-5 Annually

ZS Logo ZS

Consultant

Artificial Intelligence • Healthtech • Professional Services • Analytics • Consulting
Hybrid
4 Locations
15000 Employees

ZS Logo ZS

Artificial Intelligence Engineer

Artificial Intelligence • Healthtech • Professional Services • Analytics • Consulting
Hybrid
3 Locations
15000 Employees

Similar Companies Hiring

Credal.ai Thumbnail
Software • Security • Productivity • Machine Learning • Artificial Intelligence
Brooklyn, NY
Milestone Systems Thumbnail
Artificial Intelligence • Other • Security • Software • Analytics • Big Data Analytics
Lake Oswego, OR
1500 Employees
Fairly Even Thumbnail
Hardware • Other • Robotics • Sales • Software • Hospitality
New York, NY
30 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account