Power BI Architect

Charger Logistics Inc. is a world- class asset-based carrier with locations across North America. With over 20 years of experience providing the best logistics solutions, Charger Logistics has transformed into a world-class transport provider and continues to grow.  

Charger Logistics invests time and support into its employees to provide them with the room to learn and grow their expertise and work their way up. We are entrepreneurial-minded organization that welcomes and support individual ideas and strategies. We are currently expanding and looking to add a motivated individual to our team based out of our Brampton office.  

Responsibilities: 

• Architect, design, develop, update and optimize Power BI dashboards, reports and scorecards to meet business requirements. 
• Utilize effectively the navigation features in Power BI to guide users through a compelling data-driven story.
• Design, publish and maintain Power BI data models with multiple interrelated tables which support both the visualization and analyze in Excel features Document solutions and work with analysts to flesh out details of user stories.
• Develop calculations in DAX Able to work with analysts and product managers to discuss with internal customers and stakeholders to formulate requirements for their analytical problems. 
• Integrate existing data sources with Power BI – including but not limited to Snowflake, Azure, SQL Server.
• Efficiently handle large sets of data and confidently process them into required formats 
• Implement row-level security on data along with an understanding of application security layer models in Power BI. 
• Responsible for design methodology and product documentation.
• Should be able to develop tabular and multidimensional models compatible with data warehouse standards. 

Requirements

• Degree in Computer Science, Engineering, Mathematics, or a related field and 4+ years industry experience 
• 5+ years’ experience in designing solutions with Power BI 
• In-depth knowledge and experience on capacity planning and optimizing Power BI premium workloads.
• Advanced knowledge in Microsoft BI stack Strong data analysis skills Strong SQL, DAX ability required, scripting languages such as R, Python a plus Experience with Cloud platform. 
• Experience developing and operating large-scale data structures for business intelligence analytics using ETL/ELT processes, OLAP technologies, data modeling, SQL 
• Proficiency to draw insights from data and clearly communicate (verbal/written) information to stakeholders and senior management as required 
• Experience configuring and using Tableau or other business intelligence (BI) applications to effectively visualize and demonstrate proposed user interface dashboard and scorecard solutions. 

• Strong knowledge of ETL design and development using Integration Services (SSIS). 

Benefits

• Competitive Salary  
• Healthcare Benefit Package  
• Career Growth