Build your best future with the Johnson Controls team
As a global leader in smart, healthy and sustainable buildings, our mission is to reimagine the performance of buildings to serve people, places and the planet. Join a winning team that enables you to build your best future! Our teams are uniquely positioned to support a multitude of industries across the globe. You will have the opportunity to develop yourself through meaningful work projects and learning opportunities. We strive to provide our employees with an experience, focused on supporting their physical, financial, and emotional wellbeing. Become a member of the Johnson Controls family and thrive in an empowering company culture where your voice and ideas will be heard - your next great opportunity is just a few clicks away!
What we offer
Competitive salary
Paid vacation/holidays/sick time - 15 days of vacation first year
Comprehensive benefits package including 401K, medical, dental, and vision care - Available day one
Encouraging and collaborative team environment
Dedication to safety through our Zero Harm policy
JCI Employee discount programs (The Loop by Perk Spot)
Check us Out: A Day in the Life of the Building of the Future ;br>
What will you do
The IT Business Intelligence Analyst will be a key player for creating, maintaining and optimizing SQL server queries, stores procedures and database tables used as a source for reporting, analytics and dashboards in the Financial Reporting and Analysis (FP&A) organization.
This role requires strong technical and analytical skills to build best in class reporting and analytics platform that will support financial decision making.
How will you do it
Develop Data Warehouse architecture and supporting data model
Establish and maintain ETL processes
Ensure data quality and integrity
Develop, implement and optimize DTSX packages using Microsoft Integration Services
Implement DWH / BI improvements (architecture, OLAP, DevOps, etc.)
Create reports and dashboards in Power BI
Automate process
Create and maintain technical documentation
Provides support for existing applications and processes.
Supports and troubleshoots service requests and monitor system stability and performance
What we look for
Bachelor degree from an accredited university
Fluent English
3 or more years of experience with designing, developing and deploying of relational databases (SQL) and Business Intelligence solutions
Background in troubleshooting SQL Server performance and analyzing query execution plans
Strong T-SQL knowledge and skills
Strong experience with ETL tools and ability to extract data from various data sources (MS SQL, Oracle, Hadoop, CSV, Excel, Access)
3 years of experience with SQL Server Integration Services
Proficient knowledge of 2 or more programming languages.
Experience with Microsoft Power BI or similar platforms (MicroStrategy, IBM Cognos, Tableau, etc.)
ERP or other data source experience, with an understanding of business processes, design and data flows around source systems
Demonstrated ability to learn new technologies as required
Desired:
Basic knowledge of project management techniques (PMI, Agile, Scrum, etc)
Knowledge of Microsoft Office 365 suite for development (SharePoint, Flows, Power Apps, etc)
Predictive analytics background a big advantage
HFM / ESSBASE
OneStream
Financial background is a plus
#LI-Hybrid
#LI-KP
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.

Employers have access to artificial intelligence language tools (“AI”) that help generate and enhance job descriptions and AI may have been used to create this description. The position description has been reviewed for accuracy and Dice believes it to correctly reflect the job opportunity.