AuroraRecruiter Since 2001
the smart solution for Aurora jobs

Power BI Architect (Remote)

Company: Johnson Controls, Inc.
Location: aurora
Posted on: May 3, 2021

Job Description:

What you will do

You will be responsible for analyzing the Business Intelligence (BI) needs of the organization and recommending BI solutions and strategy. You will design and implement an enterprise BI platform, lead and provide technical guidance, and serve as a mentor to other team members. You will also provide leadership in areas of specific technical knowledge with significant experience in complex reporting platforms.

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 and accurate estimates for the implementations. * Set up documentation for policies, best practices, standards and procedures (workflows) for reporting systems and services. * Lead and provide technical guidance and mentorship to other team members. * Keep abreast of and learn new analytics technologies in order to provide guidance to the team and user. * 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. * Partner with others in the organization to deliver strategies and functionality related to integrated report delivery and enhancements. * 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 Subject Matter Experts (SME) to ensure collaboration.

What we look for


* Bachelor's degree or higher from a reputed university in engineering, IT, economics, math, statistics, science or other related fields * Minimum of 7 years' experience in an Architect 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 * Good knowledge of Power Platform including Power Apps and Power Automate * 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 working with database client tools such as Toad * Database Design - especially relational database * 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.


* Knowledge of Data Mining, Clustering and Statistical Modelling * Oracle knowledge

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, status as a qualified individual with a disability, or any other characteristic protected by law. For more information, please view EEO is the Law. If you are an individual with a disability and you require an accommodation during the application process, please visit

Keywords: Johnson Controls, Inc., Aurora , Power BI Architect (Remote), Other , aurora, Colorado

Click here to apply!

Didn't find what you're looking for? Search again!

I'm looking for
in category

Other Other Jobs

Cleaning Technician
Description: Carpet Cleaning Technician br/ br/ Stanley Steemer is looking for motivated individuals We are looking for those who are career minded and eager to learn and advance in our growing company. Stanley (more...)
Company: Stanley Steemer International, Inc.
Location: Parker
Posted on: 05/13/2021

Seasonal Receiver Stocker Overnight - Parker - 80139
Description: What You Will Do At Lowes, weve always been more than just an improvement store. Were also home to everything that makes your home feel like home. And for thousands of Lowes associates, were home to fresh (more...)
Company: lowes
Location: Parker
Posted on: 05/13/2021

Special Education Teacher for School Year
Description: For Upcoming School Year Global Village Academy is an innovative charter school. Students learn core content through language immersion in their choice of French, Spanish, Mandarin, German or Russian (more...)
Company: Albany Charter School Network
Location: Parker
Posted on: 05/13/2021

Infant Room Lead Teacher
Description: La Petite Academy of Parker is Now Hiring a Infant Room Lead We are located at 11105 S Pikes Peak Drive Parker, CO 80138 The Lead Teacher promotes the social, physical, and intellectual growth of the (more...)
Company: North Country Academy
Location: Parker
Posted on: 05/13/2021

Sterile Processing Educator-Clinical Education
Description: Summary : Develops and provides services related to the orientation, continuing education, and assessment of Sterile Processing Technicians. Work Schedule: Full Time Rotating Responsibilities : Collaborates (more...)
Company: UCHealth
Location: Parker
Posted on: 05/13/2021

Part-time Special Education Teacher (Short-term Coverage)
Description: Job Description Were looking for an exceptional Special Education Teacher for a part-time position in Glendale, CO who can start immediately and work through May 27th. This is a 20-hour per week position (more...)
Company: TherapyTravelers
Location: Parker
Posted on: 05/13/2021

Teacher Special Assignments - SY 21-22 Parker
Description: Teacher With Special AssignmentsOUR MISSIONLeman Academy of Excellence offers a rigorous, classical education based on the traditions of Western culture where all disciplines are interrelated allowing (more...)
Company: Leman Academy of Excellence
Location: Parker
Posted on: 05/13/2021

Description: br/ br/ Live your best life possible by helping others live theirs. Our Caregivers are the heart and soul of what we do. At ComForCare, we like to celebrate successes and have fun while building meaningful (more...)
Company: ComForcare Health Care Holdings, Inc.
Location: Parker
Posted on: 05/13/2021

Description: The Role : The Lead Solar Roofer will bepart of Teslas Field Energy Operations team. As a leader at Tesla, the LeadSolar Roofer will continuously model to others Tesla standards andresponsibilities including (more...)
Company: Tesla
Location: Parker
Posted on: 05/13/2021

Border Patrol Agent
Description: Find your calling. Protect your country. Apply now. Working for U.S. Customs and Border Protection CBP means keeping your country safe from dangerous people and materials attempting to cross
Company: U.S. Customs and Border Protection
Location: Parker
Posted on: 05/13/2021

Log In or Create An Account

Get the latest Colorado jobs by following @recnetCO on Twitter!

Aurora RSS job feeds