Job Description

Business Intelligence (BI) Consultant will be responsible for the full life cycle of BI analytics including designing and developing data models, reports, and dashboards; data exploration; performing analysis; establishing and driving KPIs; and training clients.

Responsibilities

• Identify, analyze, document, and improve existing business processes and legacy reporting solutions
• Interact with various business units and tech teams to gather requirements
• Work closely across operations and technology teams, product managers, business and sales leaders to determine what critical, customer-impacting problems can be solved with the use of various artificial intelligence techniques and to support new products and services
• Conferring with the leadership team to gather requirements and analyze company’s financial and operative KPIs
• Design, develop, test and deploy BI solutions (data models, reports and dashboards) from end to end
• Ensure data quality, completeness and accuracy
• Collaborate with BI support team to resolve data questions, issues, or requests from company-wide stakeholders
• Troubleshoot and support existing business intelligence reports and dashboards
• Support back-end data pipeline processes with on-call coverage

Qualifications

• Strong experience in business intelligence, data warehousing, or a similar field.
• Strong SQL experience including advanced query concepts and query performance tuning
• Experience with Cloud technologies (AWS, Azure, and/or Oracle)
• Proven analytical, problem-solving, and design skills
• Ability to work collaboratively in a fast-paced, team-oriented, ambiguous environment
• Experience with standard star schema design and development concepts, including fact table types, grain levels, and SCDs
• Knowledge of MS BI Reporting Stack (SSRS, Power Query, DAX, Power BI)
• Proven track record of managing Power BI solutions end-to-end, including requirements gathering with business users, collaboration with backend engineering, front-end report development, technical documentation, and end-user training/rollout

Bonus Points If You Have

• Bachelor’s degree in Computer Science, Information Systems, Business Analytics, or similar field; or equivalent work experience
• Knowledge of multiple database programming languages and knowledge of relational and columnar databases
• Knowledge of Tableau, QuickSight, or similar
• Experience working with global remote teams
• Experience with financial and/or supply chain data is a plus