Role : Business Intelligence Engineer
Location: Hybrid at Ann Arbor, MI(Only local to MI)
Duration: 6+ Months Contract
Experience: 5+ years
If you are Interested, Drop me your Resume to Thomas@innovitusa.com (or) you can Reach
me on +1 408-755-2428 .
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
Innovit USA Inc. is the fastest growing IT Services,Product & IT Consulting Company Headquartered in Langhorne, PA. Innovit management has been in IT Industry for over 23 years.Innovit main goal is to provide high quality and cost effective IT solutions and services to our clients. Innovit provides innovative web development solutions and mobile app solutions to our several satisfied clients worldwide. We have several Direct Client reqs.