What are the responsibilities and job description for the BI Engineer position at FreightVerify?
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
