Business Intelligence Engineer

Who We Are 

 Overhaul is a supply chain integrity solutions company that allows shippers to connect disparate sources of data into the first fully transparent situational analysis engine designed for the logistics industry. Data that is transformed into critical insights can instantly trigger corrective actions, impacting everything from temperature control to handling requirements or package-level tracking, ensuring cargo arrives at its destination safely, undamaged, and on time. We are a dynamic, innovative, and fun team who is highly committed to our customers’ experiences and our Mission and Vision.

The Role

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. 

 Primary Responsibilities

• 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 

Qualifications

• Extensive experience with reporting using Power BI, Sigma 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

What we can offer:

• 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
• Unlimited paid time off
• Flexible working 
• Free parking

 Our culture

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 Overhauler is not only eager to challenge themselves and knows how to get work done, but is also an awesome addition to our company culture.

 Diversity and Inclusivity Statement 

Overhaul has always been, and always will be, committed to diversity and inclusion. Our Overhaul Culture Code’s top listed commitment is to “Diversity and Synergy.”  All aspects of employment will be based on merit, competence, performance, and business needs. We do not discriminate on the basis of race, color, religion, marital status, age, national origin, ancestry, physical or mental disability, medical condition, pregnancy, genetic information, gender, sexual orientation, gender identity or expression, veteran status, or any other status protected under federal, state, or local law. We strongly encourage people from underrepresented groups to apply!