Careers > Open Positions > Business Intelligence Data Analyst

Business Intelligence Data Analyst

Pewaukee, WI


The Data Solution practice is composed of two main solution offerings, Data Analytics and Data Platform. The Data Analytics solutions look to build intelligent results that showcase the power of data to surface predictive, valuable insights for the Clients business. The team enables customers to make better, faster business decisions to support their specific business case. The Data Platform solutions help our customers to build, modernize and/or migrate their existing applications platform to the leading data solutions from Microsoft. The team focuses on Microsoft recommended best practices while considering the Clients current needs and priorities.

The Data Solutions team strives to help Clients achieve the most optimal and reliable database environments and empowers Clients with skills and options to understand how their data can work for them. The team looks to build an effective strategy, using the Client platform and/or analytics, to support success as a business outside of technology.

This position would require a candidate to possess a strong technical background in developing and delivering BI solutions along with a strong understanding of SQL Server environments. Candidates will be assessed during the interview process to determine the of level of expertise in accordance with team contributions, professional credentials, technical skills and abilities, education and the number of years of real world experience. All of these will topics will factor into how the candidate will be positioned within the team.


Essential Functions

  • Exudes a “can do” attitude with a focus on team first
  • Based on experience, one may mentor other engineers in developing scalable, secure, high-performance BI and Data solutions
  • Estimate development effort required with team members to frame in solution architectures
  • Assist Data Solutions Manager on technology direction for team and the organization
  • Ability to adjust development practices for delivering BI and Data solutions based on the project and client expectations
  • Ability to support and administer the underlining infrastructure and layout of a client data environment

Position Qualifications

  • Accuracy: Ability to produce high quality work deliverables leveraging industry best practices.
  • Analytical skills: Strong abilities required to effectively interpret customer business needs and translating them into application and operational requirements, resolving complex technical and business problems.
  • Communication etiquette and polish: Strong written, verbal and non-verbal communication skills, especially conveying complex information in an understandable manner.
  • Leadership skills: Ability to motivate and guide others to ensure performance is in accordance with clear expectations and goals. 
  • Learning: Ability to quickly learn new technologies to deliver solutions.
  • Presentation skills:  Ability to effectively conduct formal and informal presentations in both small and large group settings within all levels of a company.
  • Project management: Ability to demonstrate an understanding of process engineering, planning, organizing, staffing, directing and controlling work tasks. 
  • Time management: Ability to effectively utilize available time for managing multiple tasks/projects simultaneously.

Skills & Abilities


  • Microsoft Power BI
  • Microsoft SQL Server Integration Services (SSIS)
  • Microsoft SQL Server Reporting Services (SSRS)
  • Microsoft SQL Server Analysis Services (SSAS)
  • Transact-SQL (T-SQL)
  • Extract, Transform, Load (ETL)
  • Bachelor’s degree in business or I.T. related discipline accepted
  • Experience with needs analysis, software evaluation and selection, customization, and implementation
  • Strong understanding of report writing and visualization
  • Strong knowledge of SQL utilizing MS SQL Server
  • Understand multi-dimensional database structures and schemas
  • Experience with Azure including Azure SQL Database and Azure SQL Data Warehouse
  • Data Warehousing systems & architecture experience in 'real world', practical, successful implementations
  • General understanding of multiple Analytics platforms with the ability to articulate the differences and benefits of each platform i.e. Power BI, Qlik and Tableau
  • Expertise in Professional Services or similar client facing roles
  • Strong knowledge of system design, development, and deployment
  • Experience in multiple industry (Education, Healthcare, Retail, Manufacturing) verticals
  • PowerShell knowledge and understanding
  • MCSA: Cloud Platform
  • MCSE: Cloud Platform and Infrastructure
  • MCSE: Data Management and Analytics
  • MCSE: Business Intelligence Reporting
  • MCSA: SQL Server 2016 BI Development
Equal Opportunity Employer - Disabled/Vets