BI Engineer

Overview

Who We Are Overhaul is a rapidly growing software company specializing in in-transit supply chain visibility and risk management solutions for global enterprise organizations. Our cutting-edge technology empowers organizations to gain real-time insights into their supply chain operations, mitigate risks, and optimize their logistics processes.

Overhaul is a rapidly growing software company specializing in in-transit supply chain visibility and risk management solutions for global enterprise organizations. Our cutting-edge technology empowers organizations to gain real-time insights into their supply chain operations, mitigate risks, and optimize their logistics processes.

We are seeking a BI Engineer to take ownership of end-to-end Business Intelligence solutions involving a high level of customer engagement. This BI Engineer will have a strong drive for continuous processes improvement. This role will help to scope, build, deploy and maintain a variety of BI solutions that will enable performance tracking, operational management, and ad hoc analyses for both our internal and external stakeholders.

• Ongoing support and maintenance of existing Power BI dashboards, ad hoc analyses and data extracts
• Collate data from various source systems and databases, cleanse, transform and prepare data for Power BI reporting and ad hoc analysis
• Build dashboards and ad hoc reports to synthesize and aggregate data across multiple sources for internal and external stakeholders
• Interpret data, and analyze results using statistical techniques
• Creation of clear written and visual artifacts to drive decision making
• Reinforce a high level of governance alignment with general client s guidelines across all data deliverability
• Ensure safety and accuracy of information across all data solutions delivered by the team
• Prepare and maintain BI reporting and analysis documentations
• Work closely with the other areas of the Business (such as IT and Data & Analytics) on design and implementation to ensure business requirements are being met accurately and in a scalable matter and communicated to the business at large

• Extensive experience with reporting using Power BI and similar tool sets
• Design and develop database objects, tables, stored procedures, views and triggers
• Independently analyze, solve, and correct issues in real time, providing problem resolution end-to-end
• Design and develop ETL processes that will transform a variety of raw data, flat files, xl spreadsheets into SQL Databases
• In-depth knowledge of standard concepts, practices and procedures related to database management
• Proven analytical problem solving and debugging skills
• Experience in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues etc.
• Design and develop enterprise and departmental business intelligence and data warehousing solutions
• Performs ad-hoc analysis using SQL query language within the database systems using a process-oriented approach
• Understands the concept of Data marts and Data lakes and experience with migrating legacy systems to data marts/lake

• Competitive starting base salary
• Progressive advancement opportunity and career mobility
• Top employee health and well-being benefits
• Rotating company ‘Perks at work’ program
• Employee Assistance Program
• Care giver/adoption/family leave
• Flexible Time Off Policy
• Flexible working
• Free parking

We are guided by our core values of Diversity and Synergy, Creativity, Problem Solving, Authenticity and Receptivity, Trust, Encouragement, Teaching and Learning, Wellness and Integrity. These values help us recruit aligned talent to join our rapidly expanding team around the globe. It is important to us that each and every Over hauler is not only eager to challenge themselves and knows how to get work done, but is also an awesome addition to our company culture.