POWER BI DEVELOPER Duration: 12 Months+ Work Location: Tempe, Arizona
Job Description: Activities - Work with ACE Business Analysts, Visual Analytics professionals, and Data Engineers to migrate existing Tableau content into Power BI - Assist ACE team in the configuration and setup of Power BI environment and workspaces - Participate in knowledge sharing and training events held by ACE with the SRP User Community
Technical Skills - 3+ years’ experience developing Power BI datasets, reports, and dashboards - 3+ years’ experience with Microsoft SQL Server - 3+ years’ experience writing complex SQL queries - Knowledge of DAX and Power Query - Experience setting up data refreshes via Power BI Gateway - Experience with reverse-engineering Tableau to facilitate migration to Power BI
Preferred Skills: - Knowledge of Data Visualization best practices - Experience with other data environments such as Oracle, Hadoop, SAP HANA, SAP BW - Data warehousing concepts - Developing data models for reporting - Experience writing/tuning SQL procedures, functions, and views - Power BI Admin experience - Strong technical as well as business communication abilities - SSAS Tabular Models - Extraction Loading and Transformation (ELT/ETL) Bonus Skills:- Python Knowledge of other Reporting tools such as SSRS, SAP Web intelligence Skill Required/Desired Amount of Experience 3+ years’ experience developing Power BI datasets, reports, and dashboards Required 3+ years’ experience with Microsoft SQL Server Required 3+ years’ experience writing complex SQL queries Required Knowledge of DAX and Power Query Required Experience setting up data refreshes via Power BI Gateway Required Experience with reverse-engineering Tableau to facilitate migration to Power BI Required Knowledge of Data Visualization best practices Desired Experience with other data environments such as Oracle, Hadoop, SAP HANA, SAP BW Desired Data warehousing concepts Desired Developing data models for reporting Desired Experience writing/tuning SQL procedures, functions, and views Desired Power BI Admin experience Desired SSAS Tabular Models Desired Extraction Loading and Transformation (ELT/ETL) Desired Python Nice to have Knowledge of other Reporting tools such as SSRS, SAP Web intelligence Nice to have
At Trane Technologies TM and through our businesses including Trane ® and Thermo King ® , we create innovative climate solutions for buildings, homes, and transportation that challenge what’s possible for a sustainable world. We\'re a team that dares to look at the world\'s challenges and see impactful possibilities. We believe in a better future when we uplift others and enable our people to thrive at work and at home. We boldly go.