Job ID: 2656
Job Location: Charlotte

Sr. Business Analytics Developer, Management Consulting - Charlotte


RoundTable Strategic Solutions is seeking a full-time Senior Business Analytics Developer in the Analytics & Finance Department for our Management Consulting team.

Job description

The Senior Business Analytics Developer supports the identification and development of new data/analytics solutions that enables the Management Consulting division to scale their services and products but facilitates improved business processes for our Management Consulting customers. He/She is primarily focused on the development, testing, and execution of healthcare analytics products and projects including, but not limited to: access, capacity management, strategic growth and others. In addition, he/she will design, build, and maintain the application infrastructure, tools, and best practices that enable access to and analysis of BI and Analytics information. He/She consults with and advises users of the Business Intelligence applications and will be able to form effective partnerships with senior leaders and external clients to understand their business goals to generate innovative solutions. The ideal candidate will be a self-starter, capable of taking initiative and working with minimal direction. He/she needs to be committed, accessible, resourceful, self-assured, self-motivated, and detail-oriented. The candidate should be a problem-solver with an ability to follow through, possesses a sense of urgency, ability to communicate and demonstrate action consistent with the company’s mission and objectives.


• Consult and analyze on complex projects with clients to scope and implement solutions
• Performs supply/demand, cost, utilization and marketing analyses
• Develop and manage new tools for measuring and understanding client projects and client outcomes
• Develops the process, integration, and validation of complex, custom datasets utilized for reporting and analysis
• Capture business reporting requirements with external clients and determine data extraction or ETL needs
• Design, develop and use interactive dashboards and other automated reporting in Power BI, SAS and other BI tools for internal leaders and external clients
• Identify and recommend process improvements to reduce inefficiencies and improve accuracy and automation of workflow and data transfers
• Provide data analysis to identify trends and patterns in client engagements using SAS or comparable statistical software
• Test, validate and verify new reporting and dashboard solutions to ensure accuracy
• Communicate effectively with clients and senior leadership

Job Requirements

  • Bachelors Degree in Mathematics/Statistics or Computer Science preferred
  • Strong background in Healthcare/Healthcare Claims, SAS, Tableau/Power BI and advance analytics (including statistical methodologies) experience
  • 3-5 years of experience with Microsoft SQL Server preferred with an emphasis in stored procedure development; or applicable experience in relational or dimensional data modeling
  • 3-5 years of experience in SAS or applicable statistical software with an emphasis on macro development
  • Experience in healthcare planning or operations preferred
  • Expertise in database and application development tools is required
  • Proven success developing reporting solutions and applications to meet client needs
  • Strong knowledge of Data Warehousing/ Business Intelligence best practices and techniques
  • Strong understanding of ETL processes and how to design develop and implement well integrated processes
  • Highly proficient with a variety of information systems technologies is preferred; desktop applications and databases

Reports to Sr. Director Business Intelligence & Analytics, Management Consulting Division