• Design and build ETL packages using MS SQL stored procedures and Integration Services (SSIS)
  
• Support and enhance OLAP cubes (SSAS)
  
• Support design and implementation of reports using Reporting Services (SSRS)
  
• Design, develop and support Tableau data sources, worksheets and dashboards
  
• Evaluate new Business Intelligence tools that will enhance reporting techniques and delivery
  
• Assist with development and implementation of a data analytics solution
  
• Work with database team to optimize database performance of queries and ETL processes.
  
• Work with customers to define customer requirements, communicating opportunities where technology can be used to improve business processes
  
• Provide end-user support by utilizing interpersonal skills to communicate with and instruct end-users on MS BI products and technologies
  
• Troubleshoot escalated BI issues including data, ETL and SSRS issues
  

Requirements

• Solid understanding of the entire Microsoft BI Stack including SQL Server, SSIS, SSAS, SSRS with at least 4 years of experience with Microsoft BI tools
  
• Experience designing, developing and supporting Tableau data sources and dashboards
  
• Experience with data analysis and data analytics tools including Microsoft Machine Learning
  
• Experience with various data types (e.g. structured relational, unstructured)
  
• Ability to commit to off-hour assistance and overtime required (evening/weekends) as necessary per project and solving production issues
  
• Bachelorâ??s degree in Computer Science or related discipline or proven hands-on experience
  
• Proficiency with Microsoft personal productivity tools (Excel, Word, Visio, Access)
  
• Excellent oral, written communication and interpersonal skills
  
• Able to work as a team member and willing to work independently when required.
  
• Strong troubleshooting and problem solving skills
  
• Experience working in an Agile/SCRUM SDLC environment
  
• Experience with TFS Team tools and TFS Database Projects