Our client is a leading Global Software Solutions and Consulting firm that enables enterprise commerce for the world’s leading manufacturers, distributors and onmi-channel retailers. Based out of Carmel, Indiana, our client is an eight-time Inc. 5000 fastest growing privately held company with over 600 employees and serving world-leading brands throughout the US.

They are looking for a Senior BI Consultant to join their Business Intelligence team that supports the analytical needs of their clients through not just bringing data together but understanding the intricacies of their client’s business processes and how data can be applied to better track / manage those processes. Through their technology partnerships and experience across multiple industries they work to provide insights to solve real problems.

Primary Responsibilities of the Senior BI Consultant

  • Participate in planning and estimating sessions with clients
  • Analyze business requirements and design solutions and recommendations based on established best practices for business intelligence / analytics
  • Design and develop Data Lakes, Data Warehouses, and subject specific Data Marts
  • Develop and validate reports and dashboards
  • Troubleshoot query performance in SQL, DAX, M
  • Apply machine learning / data mining practices to enable richer insights
  • Drive strategies and adoption of business intelligence with our clients
  • Keep up to date on the latest technologies and analytical frameworks
  • Prepare training materials and provide user training
  • Present at seminars / conferences
  • Manage project tasks, status updates, issues, and timelines

Primary Requirements for the Senior BI Consultant

  • Bachelor’s degree in Data Analytics, Data Management or related field
  • 3-5 years of experience working with Business Intelligence (BI) architectures and toolsets
  • Experience developing ETL routines and database procedures / functions
  • Experience integrating data from a variety of sources (i.e., flat files, APIs, databases, XML)
  • Experience with Microsoft SQL Server 2012 – 2017 and the corresponding BI capabilities (SSIS, SSAS, SSRS, Machine Learning Services)
  • Experience with Microsoft Power BI, Tableau, Qlik, Jet, TARGIT, D3 or other reporting / dashboarding tools
  • Experience with Dimensional Modeling (i.e., Star Schema, Snowflake Schema)
  • Preferred experience with R and/or Python for machine learning and data mining
  • Preferred experience developing reports / dashboards against Microsoft AX / D365
  • Preferred experience with analytical / data management capabilities in Azure, AWS, or GCP
  • Proven track record of providing documentation, training, and support
  • Ability to work independently with clients and drive priorities
  • Ability to travel up to 40% to client locations
  • Attention to detail and strong sense of ownership
  • Excellent communication skills both verbal and written

Benefits of joining our client’s team as a Senior BI Consultant

  • Excellent salary in the $80k – $105k range but flexible for the right skills
  • Comprehensive benefits package includes major medical, dental, vision and more
  • Join a high-performance team with a great reputation for building elegant solutions for some of the largest and most well known companies in the country
  • Get training and continued certification support, and a career path