Overview Business Intelligence Analyst II (Hybrid/On-site/Local) 1-2 days on-site in Mechanicsburg, PA Employer will not sponsor work visas for this position now or in the future and is 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 102 hospitals specializing in long-term acute care, 35 medical rehabilitation hospitals, and more than 2,100 outpatient clinics offering physical and occupational therapy. In addition, Select Medical offers urgent care at close to 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. The Business Intelligence Analyst (Level 2) is responsible for designing, developing, and maintaining complex data integration systems that enable Select Medical's business operations teams to efficiently manage and analyze data. Key job responsibilities include developing reusable ETL workflows using programming languages such as SQL and Python, as well as tools like Oracle Data Integrator, to integrate data from various sources, including electronic health records (EHRs), billing systems, and other third-party applications. Responsibilities This position requires close collaboration with clinical, business, and operational stakeholders to understand business requirements, design data models that meet regulatory and compliance needs, and ensure seamless data exchange between departments. Additionally, this role is expected to troubleshoot and resolve complex technical issues related to data integrity, accuracy, and security, as well as optimize data pipeline performance to support business growth and customer satisfaction initiatives. Qualifications Candidate will have a strong interest in reporting, analytics, and data (business intelligence). Required: BS or BA or equivalent education and experience. 5+ yrs. ETL development experience. 5+ yrs. SQL or other database query language experience. 5+ yrs. business intelligence platform experience such as MicroStrategy, Tableau, Microsoft Reporting Services, Cognos, Business Objects, Crystal Reports, etc. Requires superior teamwork skills. Strong interpersonal and communication skills a must; ability to read, write, and speak in a professional manner. Excellent analytical and problem solving skills are essential. Must possess a personal sense of urgency. Ability to effectively multi-task and adapt to changing business priorities. Superior customer service skills. Excellent time management and organizational skills are required. Excellent attention to detail. Large scale multi-site IS operations experience. Knowledge of Microsoft productivity applications. Preferred: 3+ years of healthcare industry knowledge Additional Data Select Medical and its parent company, Select Medical Holdings Corporation (NYSE: SEM), are based in Mechanicsburg, Pennsylvania, and honored to be recognized as one of America’s Best-In-State (Pennsylvania) Employers 2020 by Forbes. For more information, visit selectmedical.com or https://youtube.com/SelectMedicalTV. Select Medical strives to provide our employees with a solid work-life balance, as we understand that happy employees have both fulfilling careers and fulfilling lives beyond our doors. An extensive and thorough paid orientation program. Paid Time Off (PTO) and Extended Illness Days (EID). Health, Dental, and Vision Insurance; Life insurance; Prescription coverage. A 401(k) retirement plan with a company match. Select Medical is committed to having a workforce that reflects diversity at all levels and is an equal opportunity employer. Qualified applicants are considered for employment, and employees are treated during employment without regard to race, color, religion, national origin, citizenship, age, sex, sexual orientation, gender identity, marital status, ancestry, physical or mental disability, veteran status, or any other characteristic protected under applicable law.
