Finance/Data Analyst (Remote)

Job Details
Who We Are
Sensormatic Solutions is the leading global retail solutions portfolio of Johnson Controls powering operational excellence at scale and enabling smart and connected shopper engagement. Our intelligent digital operating platform – Sensormatic IQ – combines the full Sensormatic Solutions portfolio, including unmatched insights into retail inventory, shopper behavior, and loss and liability, and Retailer and third-party solutions with advanced technologies, like AI and Machine Learning. This enables retailers to act on prescriptive, data-driven outcomes and confidently move into the future.
Want to learn more about Sensormatic Solutions and Sensormatic IQ? Find us here:
https://www.sensormatic.com/who-we-are
https://www.sensormatic.com/sensormatic-iq
This is a virtual/remote position considering candidates who reside within the United States, ideally located in the Eastern or Central time zones
What You Will Do
The Financial/Data Analyst will be responsible for reporting and presentation of information related to Sensormatic pricing projects for objective and timely decision making.
How You Will Do It

• Presentation of results using computer packages such as Microsoft PowerPoint at director and management levels
• Conduct quantitative and qualitative basic financial analysis of information and draw relevant conclusions for the business
• Use of different techniques to extract the most relevant indicators from the data
• Review problems /repeat issues for the data elements, building & maintaining mapping tables as identified
• Use of different techniques to extract the most relevant indicators from the data
• Preparation of information to be analyzed using different tools such as Microsoft Excel
• Information cleaning based on technical and business criteria
• Provide profitability and margin analysis across multiple attributes: customer, product, geography, etc.
• Support issue resolution for business owned data issues
• Distribute via SharePoint, Microsoft Teams or any other electronic means the data analysis reports
• Extraction of information from the different transactional systems of the organization
• Support the organization in regular pricing reviews and price increase analyses

Required
What we look for

• Experience with Informatica is a plus
• Experience working with BA and PM to gather requirements, perform data discovery, understand data model
• Prior experience with financial or pricing analytics a plus
• Excellent oral and written presentation skills
• Experience in Data Quality, Master Data Management data quality and BI analytics.
• At least 2 years in similar positions and activities
• Fluency in written and oral English required, bilingual Spanish a plus
• ETL experience supporting data extraction, transformations and loading processing
• SQL skills required
• Ability to understand complex business processes to derive conceptual and logical data models.
• Experience supporting Data conversion and cleansing activities. Data Profiling, Data Validation
• Advanced level in the use of Microsoft Power Point and Excel
• Bachelor’s degree in Administration, Computer Science, Finance or its equivalent of advanced university studies and experience in the position
• Power BI knowledge desirable
• Experience with Looker and BigQuery

Johnson Controls International plc. is an equal employment opportunity and affirmative action employer and all qualified applicants will receive consideration for employment without regard to race, color, religion, sex, national origin, age, protected veteran status, genetic information, sexual orientation, gender identity, status as a qualified individual with a disability or any other characteristic protected by law. To view more information about your equal opportunity and non-discrimination rights as a candidate, visit EEO is the Law. If you are an individual with a disability and you require an accommodation during the application process, please visit here.