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 and bonus plan

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 https://youtu.be/pdZMNrDJviY

What you will do

You will be responsible for analyzing BI needs of the organization and recommend BI solutions and strategy. You will develop and support an enterprise BI platform. Knowledge of MS BI Stack - Power BI, Power BI administration, SSRS, SSAS, Power Apps, Flow, SQL Server. 

How you will do it

• Responsible for enterprise-grade analytics solutions for both internal and external customers.
• Develop and maintain BI infrastructure architectural design and technical configurations.
• Provide frameworks, reference architectures & accurate estimates for the implementations.
• Set up documentation for policies, best practices, standards and procedures (workflows) for reporting systems and services.
• Serve as subject matter expert on Microsoft BI stack.
• Understand data standards and identify data abnormalities. Instill data quality in all solutions delivered.
• Design and develop scorecards and dashboards using Power BI, SSAS, SSRS and other related technologies.
• Develop overall project technical design and build custom elements of a project.
• Support operational excellence and six sigma activities by performing analysis where needed. Build data models and formulate decision or predictive models that relate operational activities to results and drive continuous improvement.
• Create new reports or modify existing reports using industry standards and best practices.
• Engage with IT to understand impact of new system development or changes to reporting.
• Maintain close alignment with all customers (internal, external, management and at the field level).
• Interact with other reporting teams and SME(s) to ensure collaboration.

What we look for

Required:

• Bachelor’s degree or higher from an accredited university in engineering, IT, economics, math, statistics, science or other related fields
• 7+ years in a developer-level role in business intelligence
• 5+ years of experience in Microsoft BI stack
• Experience in performance tuning of Power BI reports/dashboards, scheduling Reports/Direct query etc.
• Knowledge of Power BI set up and deployment architecture design. Gateway administration
• In-depth experience with Microsoft analytics Stack (SQL Server, SSAS Tabular, SSRS, Power BI, Power Query, DAX, SQL and T-SQL)
• Advanced knowledge Power BI
• Proficient in DAX, M language
• Experience in Extraction, Transformation and Loading (SSIS)
• Experience in Tabular/OLAP Model (Microsoft SSAS), Azure Analysis Services
• In-depth experience with Associated Development Tools - Visual Studios Data Tools, SQL Server Management Studio, SQL Server Data Tools, Microsoft TFS
• Implementation of access control and knowledge of security mechanisms for report access
• Experience with cube development using SSAS
• Understanding of Azure and its data services. Cloud and on-premise understanding
• Expertise with administering Azure Data Factory, Azure Data Lake, Azure SQL DW and Azure SQL environments
• Proficiency required with Microsoft Flow and Microsoft Power Apps setup and usage
• Knowledge of dimensional modelling and data warehousing concepts
• Proficient in Microsoft Office Suite and O365
• Superior documentation and organizational skills. Must be detail oriented
• Excellent critical-thinking skills with the ability to research and analyze data retrieved from multiple sources
• Must possess and demonstrate excellent verbal, written, and interpersonal communications skills
• Must be an adaptable self-starter and work with minimal supervision. Must be able to handle multiple projects and organize time effectively
• Must be willing to put in extra time and effort if need be. Go above and beyond the requirements of the job and strive to exceed expectations

#LI-Remote

#LI-KP1

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.