Jr. Business Intelligence Developer

Full Time Regular
4714 Gettysburg Rd
Mechanicsburg, PA 17055
View Maps & Directions

Job Description

***We are not able to sponsor visas and are not interested in corp.-to-corp. business arrangements at this time.***

Select Medical is one of the nation's largest providers of specialized acute and post-acute care. Its network of nearly 50,000 employees operates or supports nearly 102 hospitals specializing in critical illness recovery, 35 medical rehabilitation hospitals, and more than 2,000 outpatient clinics offering physical and occupational therapy. In addition, Select Medical offers occupational health and urgent care services at nearly 500 locations through our Concentra brand. It also offers physical therapy and/or athletic training to approximately 300 high schools, colleges, and professional sports teams. Select Medical (NYSE: SEM) was founded in 1996 and is based in Mechanicsburg, Pennsylvania. For more information, visit selectmedical.com 

Role description

The Business Intelligence Specialist II is responsible for the development of business intelligence solutions using industry standard tools. The role requires a passion for data and technology, an understanding of business processes and goals, and the ability to combine these specialties into actionable business intelligence solutions for a rapidly growing organization.


This job will have access to confidential and sensitive information, and therefore requires ongoing discretion and strict compliance to all information security policies.


  • Acquire a deep understanding of source systems and all of the business intelligence toolset
  • Acquire an understanding of the Select Medical business units, their processes, and their goals
  • Collaborate with stakeholders, including executive management, to gather the technical requirements for business intelligence solutions
  • Become a subject matter expert on the organizations data, processes, and reporting solutions
  • Work with peers and stakeholders to ensure that the final solution meets the highest quality standards
  • Collaborate with team and keep the team informed of progress by keeping process deliverables up-to-date in our project tracking system
  • Provide insights, recommendations and strategies to enhance the operational delivery of BI solutions, and technical direction
  • Complete special projects and other functions, as required


Candidate will have a strong interest in business intelligence (BI), with a particular focus in dashboard development and reporting, user interface/user experience (UI/UX) design, and industry best practices. The ideal candidate for this opportunity will possess the following work experiences:

  • 2+ years of experience architecting business intelligence reporting solutions
  • 2+ years of experience analyzing, structuring and reporting data across an enterprise
  • 2+ years of experience working on an RDBMS like Oracle or SQL Server
  • 2+ years of experience working in a data warehouse environment

Key Competencies


  • Must be proficient in SQL
  • Proficient in understanding and explaining key concepts around general database design such as the different normal forms, primary key/foreign key, triggers and constraints
  • Proficient in understanding of data warehouse environments and dimensional modeling
  • Proficient in understanding of common table expressions, cursors, stored procedures, and functions Strong knowledge of an enterprise business intelligence platform like MicroStrategy, Tableau or Business Objects

Non Technical:

  • Must have a strong passion for data analytics
  • Excellent analytical and problem solving skills are essential
  • Ability to work both independently and in a team
  • Drive to take ownership of processes and/or projects to ensure their timely completion
  • Ability to effectively and efficiently collaborate with others
  • Detail oriented with a strong attention to detail and sensitivity to timelines
  • Excellent written and verbal skills since interaction with business will be common
  • Self-motivated, results-driven, and willing to learn and adapt in a fast-paced environment

Healthcare industry knowledge is preferable

Additional Data

Select Medical is an EOE




Apply Now

Apply from a Different Device

To complete your application on another device, simply send it to yourself here. We do not store this email or use it for any purpose other than forwarding this job to the name and email that you designate.

Not Ready to Apply? Join Our Talent Network

If you are interested in our Career opportunities but not ready to apply, join our Talent Network to stay connected to us and receive updates on the latest job opportunities and company now.

Join Our Talent Network
Questions? We can help!
Contact Us