Business Intelligence Engineer

Location: Ann Arbor, MI

Department: Information Technology

Type: Full Time

Min. Experience: 5+ Years

Logic Solutions is a full-service development firm headquartered in Plymouth, MI with 4 additional offices around the world. Founded in 1995, Logic offers specializes in customized web, mobile and now, AI applications with application integration services that span the entire software development lifecycle.

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

 

This is a full-time position reporting to the Chief Technology Officer. This is a salaried position with compensation based on experience and skill level. Benefits include medical, insurance, 401(k), paid time off (vacation, holidays, and sick days) and a professional work environment. Logic offers equal opportunities to all people. We would like to thank all applicants for expressing interest; however, only those selected for interviews will be contacted. Reference checks may be conducted with your permission.

Apply here.

Accepted file types: pdf, doc, docx.
Max. file size: 10 MB.

Services

Our Work

About Us