BI Engineer

FreightVerify is a cloud-based technology company that transforms the way that business is done in the transportation industry. Utilizing IoT, data, and AI technologies, FreightVerify provides a neutral platform that simplifies complex global supply chains to value-driven networks. FreightVerify was formed by a group of industry leaders in logistics and technology with the idea that by connecting shippers and carriers in new ways it will make for a more efficient and cost-effective market.

Job Summary

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. 

Note: This position is located in Ann Arbor, MI and requires onsite work. 

 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 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