This job posting isn't available in all website languages

Sr IT Business Intelligence Architect

Business Strategy
WD30081136249 Requisition #
Sr IT Business Intelligence Architect

Johnson Controls is a global diversified technology and multi industrial leader serving a wide range of customers in more than 150 countries. Our 130,000 employees create intelligent buildings, efficient energy solutions, integrated infrastructure and next generation transportation systems that work seamlessly together to deliver on the promise of smart cities and communities. Our commitment to sustainability dates back to our roots in 1885, with the invention of the first electric room thermostat. We are committed to helping our customers win and creating greater value for all of our stakeholders through strategic focus on our buildings and energy growth platforms. For additional information, please visit www.johnsoncontrols.com or follow us @johnsoncontrols on Twitter. 

What will you do?
The IT Business Intelligence Architect 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 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
• 5 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 (7 or more years) with ETL tools and ability to extract data from various data sources (MS SQL, Oracle, Hadoop, CSV, Excel, Access)
• 5 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, Oracle OBIEE, 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


• 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
• Financial background is a plus.

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

Previous Job Searches

My Profile

Create and manage profiles for future opportunities.

Go to Profile

My Submissions

Track your opportunities.

My Submissions
View All Jobs