GoRight Fleet Solutions Looking for IT – BI Developer at Greater Toronto Area, Canada Full Time

GoRight is an innovator in the transportation maintenance industry. For over 15 years, we have provided customers with exceptional and transformative maintenance solutions. We believe that working with leading-edge technology in our shops is just as important as being innovators in all areas of our business.

Working at GoRight is more than a career for our people. We are a place that lives our values and are committed to delivering exceptional results to our employees and customers. We take our values seriously and are committed to safety, quality, responsiveness, honesty, integrity, and personal initiative every day.

We are seeking a very experienced Senior Power BI (Business Intelligence) Specialist to work out of our Mississauga, Ontario location. If you bring experience with Business Intelligence platforms and are ready for your next challenge, we want to hear from you.

The Senior Power BI (Business Intelligence) Specialist will work with our Data and Analytics team. The chosen candidate will be a highly motivated and experienced BI professional that will participate and contribute to all areas of advanced BI & analytics. This Power BI Specialist is expected to be an expert in BI analytics and able to scope, analyze, develop, automate, enhance, and validate BI reporting, analytics, and dashboard solutions in a timely and creative manner.

What we offer:

• Comprehensive Benefits – featuring 100% reimbursement on medical and dental, vision, AD&D, affordable STD/LTD, Life and Dependent Life Insurance.
• CareerPath™ – Company paid personal and professional development.
• RRSP program includes employer matching your contributions.
• Daily pay advances if you need pay in advance of your normal pay date.
• Employee Assistance Plan.
• Safe, clean, bright, and organized work environment.
• Open, inclusive culture.
• A great place to work!

What you’ll be doing:

• Design, build and deploy powerful BI solutions as per business requirements.
• Build customer facing BI reports and dashboards with Row level security.
• Conduct requirements analysis and translate data into informative reports, dashboards and KPI’s.
• Connect to data sources, import data, and transform data for Business Intelligence.
• Work with database schemas and referential integrity.
• Performance tuning and indexing with help from DBA.
• Create DAX queries in Power BI desktop.
• Responsible for design methodology and project documentation.
• Create and maintain ETL processes.
• Support and enhance existing reports and dashboards based on evolving business needs.
• Maintain and develop new approaches to automate internal and external data retrieval, client reporting and operational process. Interface with cross-functional teams to build centralized/custom data analytics tools to enhance the business process.
• Own and develop queries and data visualizations for ad-hoc, recurring, troubleshooting requests and projects. Create exploratory data analysis, reports, dashboards to surface data for different stakeholders.

What you bring to the table:

• 5+ Years of BI development and report management experience.
• 5+ years of Power BI skills.
• Advanced knowledge of T-SQL (Microsoft SQL Server databases / Microsoft Azure SQL databases).
• Ability to write stored procedures, views, and SQL functions.
• Experience reading and writing entity relationship diagrams.
• Understand how to use query plans for performance optimization.
• Knowledge and experience in prototyping, designing, and requirement analysis.
• Experience with Common Data Service (CDS).
• Knowledge and skills for secondary tools such as Microsoft Azure, SQL data warehouse, Visual Studio, etc.
• Experience slicing and pivoting SSAS OLAP cubes, Azure Active Directory, OAuth and RLS (row level security).
• Advanced knowledge of Microsoft Power BI development, publishing, and scheduling reports.
• Proficiency in DAX queries in Power BI desktop.
• Intermediate to advanced knowledge of SSRS/RDL development and management for creating paginated reports in Power BI.
• Intermediate knowledge of Power Automate, Dynamics CRM, and Office 365.
• Familiarity with JavaScript, CSS, and other JavaScript libraries.
• Excellent organization, planning, and prioritizing skills with a proactive approach to resolving issues.
• Effectively communicate highly technical information to function, technical team members and management.

#GoRightHP

At GoRight, we are dedicated to fostering a culture of belonging that enables us to serve the diverse needs of our community effectively. As part of our commitment to equity, diversity, and inclusion, we value applicants who have demonstrated a similar dedication and recognize the importance of diverse perspectives, experiences, and expertise in achieving our mission.

We are committed to the principles of the Accessibility for Ontarians with Disabilities Act (AODA). As such, we strive to make our recruitment, assessment, and selection processes as accessible as possible and provide accommodations as required for applicants with disabilities. If you require an accommodation, please email us at [email protected] .

Stay connected and follow us on social: LinkedIn , YouTube and Twitter .

Apply Now