Passavant Memorial Homes

Database Analyst

Passavant Memorial Homes Family of Services - Harmarville, PA - Full Time

Passavant Memorial Homes is one of the foremost, consumer-focused providers of support to individuals with intellectual disabilities, autism, mental health, and behavioral health needs. The mission of Passavant Memorial Homes is to empower individuals to live successfully in the community. Our team of professionals have been dedicated to promoting choice and independence for individuals with intellectual disabilities for more than 120 years. Throughout our history, we have continuously focused on ensuring the highest quality support and providing a variety of opportunities for our employees to develop and advance.

The Database Analyst is responsible for utilizing Microsoft SQL Server Management Studio for database querying, creating and/or managing relevant databases, maintaining and enhancing datasets and overall reporting capabilities to provide analytical intelligence, and analyzing data across multiple databases and software platforms. The Database Analyst will additionally coordinate and collaborate with team members from a third-party information technology and software development organizations.

The Database Analyst must possess strong skills in developing queries for data mining on Microsoft SQL Servers and highly proficient in data manipulation.  Applicants must have experience with Microsoft Excel, including advanced features such as pivot tables, charting tools, and formula functions.

DUTIES AND RESPONSIBILITIES OF THE DATABASE ANALYST:

  • Utilize Microsoft SQL Server Management Studio to write queries and mine data.
  • Create and/or manage relevant databases.
  • Maintain and enhance datasets and overall reporting capabilities to provide analytical intelligence.
  • Analyze data across multiple databases and software platforms.
  • Gather and validate data from a variety of sources for use as inputs for analyses.
  • Assist in the development, deployment, and ongoing maintenance of automated reporting features to enhance decision support for leadership.
  • Coordinate and collaborate with team members from a third-party information technology and software development organization that works in partnership with PMHFOS.
  • Perform other tasks as requested by the Director of Analytics and Process Improvement.

REQUIRED SKILLS AND KNOWLEDGE OF THE DATABASE ANALYST:

  • Bachelor’s Degree in Business, Economics, Statistics, Information Technology, Mathematics, Analytics, Computer Science, Management Information Systems, or other related discipline.
  • Minimum of two years professional experience in an analytical, programming, database management, or similar role.
  • Strong query-writing and data mining skills.
  • Familiarity with Microsoft SQL Server databases and Microsoft SQL Server Management Studio, preferred.
  • Strong skills with Microsoft Office, specifically with Microsoft Excel, including advanced features such as pivot tables, charting tools, and formula functions.
  • Ability to multi-task, prioritize effectively, and solve problems in a timely manner.
  • Keen attention to detail, ensuring the highest data quality and accuracy.
  • Other preferred, but not required skills of interest include, experience developing business intelligence dashboards, configuring data pipelines/processes, or database architecture.

PASSAVANT MEMORIAL HOMES OFFERS:

  • Competitive Wages: $55,000 - $65,000
  • Comprehensive Health, Dental, and Vision Insurance Coverage
  • Generous PTO package
  • 401K Retirement Plan
  • Dynamic and Supportive Work Environment
  • Career Development and Advancement Opportunities

Passavant Memorial Homes Family of Services is an Equal Opportunity Employer.

INDMA

If you are having issues or need assistance while filling out the application, please reach out to careers@passavant.org.

By clicking “Submit Application,” you are indicating that you have read and accept our Privacy Statement. If you have any questions regarding any open positions, the application process, or filling out the electronic application, please contact our recruitment team by e-mail at careers@passavant.org or by phone at 1-888-764-6467 Extension 111.

PMHFOS prohibits discrimination in any employment action; in admissions, referrals, operations, or delivery of services against individuals because of their race (to include hair type, hair texture, or hair style), color, religious creed (to include all aspects of religious observances and practice, as well as belief), disability, ancestry, national origin (including limited English proficiency), age (40 and over), sex (to include pregnancy status, childbirth status, breastfeeding status, sex assigned at birth, gender identity or expression, affectional or sexual orientation, and differences in sex), genetic information, marital status, membership in volunteer emergency responder organization, victim of domestic violence, sexual assault, stalking, family care responsibilities, reproductive health decisions, and retaliation for initiating a complaint of discrimination or opposing or participating in the investigation of a discriminatory practice. Visit our Compliance page for more information.

PMHFOS is dedicated to achieving a diverse workforce through application of its affirmative action, equal opportunity, and nondiscrimination policies in all aspects of employment. PMHFOS celebrates diversity and has a no-tolerance policy for harassment or discrimination of any kind. We value the unique skills, background, and experience of all of our employees.

#LI-DNI

Apply: Database Analyst
* Required fields
First name*
Last name*
Email address*
Location
Phone number*
Resume*

Attach resume or Paste resume

Attach resume as .pdf, .doc, .docx, .odt, .txt, or .rtf (limit 5MB) or paste resume

Paste your resume here or attach resume file

What's your highest level of education completed?*
Do you have a valid driver's license?*
Are you able to perform lifting tasks including "heavy" lifting (Note, this may include lifting individuals and/or assisting individuals in their daily activities)?**
Have you held permanent residency in the Commonwealth of Pennsylvania (i.e., your address and primary residence was in the Commonwealth of Pennsylvania) for the last seven (7) consecutive years?*
Have you ever been dismissed or left previous employment due to abuse or neglect of a client or resident?*
Have you ever been convicted of or plead guilty to a crime, or do you have any pending criminal charges (note, this includes summary offenses)?*
Have you been previously employed by or provided contracting services to Passavant Memorial Homes Family of Services?*
Are you knowingly related to any employee or Board Member of Passavant Memorial Homes Family of Services or individual served by Passavant Memorial Homes Family of Services?*
How did you hear about Passavant Memorial Homes Family of Services?*
Are you comfortable working in an on-call environment?*
Are you willing to travel to our regional locations as needed?*
CERTIFICATION

I certify that the answers given are true and complete to the best of my knowledge. I understand that by providing my consent to receive communication through SMS/Text from Passavant Memorial Homes to my mobile device, that message and data rates from my mobile carrier may apply. I authorize investigation of all statements contained on this application for employment as may be necessary in arriving at an employment decision. In the event of employment, I understand that false or misleading information given on my application or interview(s) may result in discharge.

I understand that if I am hired, a physical examination, drug screening, and Tuberculosis (TB) test will be required prior to starting employment. I will also be required to comply with Act 33/34 in relation to obtaining a Criminal History Records Check, Child Abuse Clearance, and possibly Federal Bureau of Investigation (FBI) Clearances. I also provide consent for Passavant Memorial Homes to complete all required background screening including criminal database records checks, motor vehicle records checks, and U.S. Department of Health and Human Services (HHS) Office of Inspector General (OIG) Medicaid Exclusions checks. If hired, I understand and consent to continuous monitoring of my criminal and motor vehicle records throughout my employment with Passavant Memorial Homes. I also understand that I am required to abide by all rules and regulations of Passavant Memorial Homes.*
Signature (type First and Last Name):*
Date:*
The following questions are entirely optional.
To comply with government Equal Employment Opportunity and/or Affirmative Action reporting regulations, we are requesting (but NOT requiring) that you enter this personal data. This information will not be used in connection with any employment decisions, and will be used solely as permitted by state and federal law. Your voluntary cooperation would be appreciated. Learn more.
Gender
Race/Ethnicity
Invitation for Job Applicants to Self-Identify as a U.S. Veteran
  • A “disabled veteran” is one of the following:
    • a veteran of the U.S. military, ground, naval or air service who is entitled to compensation (or who but for the receipt of military retired pay would be entitled to compensation) under laws administered by the Secretary of Veterans Affairs; or
    • a person who was discharged or released from active duty because of a service-connected disability.
  • A “recently separated veteran” means any veteran during the three-year period beginning on the date of such veteran's discharge or release from active duty in the U.S. military, ground, naval, or air service.
  • An “active duty wartime or campaign badge veteran” means a veteran who served on active duty in the U.S. military, ground, naval or air service during a war, or in a campaign or expedition for which a campaign badge has been authorized under the laws administered by the Department of Defense.
  • An “Armed forces service medal veteran” means a veteran who, while serving on active duty in the U.S. military, ground, naval or air service, participated in a United States military operation for which an Armed Forces service medal was awarded pursuant to Executive Order 12985.
Veteran status
I IDENTIFY AS ONE OR MORE OF THE CLASSIFICATIONS OF PROTECTED VETERAN LISTED ABOVE
I AM NOT A PROTECTED VETERAN
I DON’T WISH TO ANSWER
Voluntary Self-Identification of Disability
Voluntary Self-Identification of Disability Form CC-305
OMB Control Number 1250-0005
Expires 04/30/2026
Why are you being asked to complete this form?

We are a federal contractor or subcontractor. The law requires us to provide equal employment opportunity to qualified people with disabilities. We have a goal of having at least 7% of our workers as people with disabilities. The law says we must measure our progress towards this goal. To do this, we must ask applicants and employees if they have a disability or have ever had one. People can become disabled, so we need to ask this question at least every five years.

Completing this form is voluntary, and we hope that you will choose to do so. Your answer is confidential. No one who makes hiring decisions will see it. Your decision to complete the form and your answer will not harm you in any way. If you want to learn more about the law or this form, visit the U.S. Department of Labor’s Office of Federal Contract Compliance Programs (OFCCP) website at www.dol.gov/ofccp.

How do you know if you have a disability?

A disability is a condition that substantially limits one or more of your “major life activities.” If you have or have ever had such a condition, you are a person with a disability. Disabilities include, but are not limited to:

  • Alcohol or other substance use disorder (not currently using drugs illegally)
  • Autoimmune disorder, for example, lupus, fibromyalgia, rheumatoid arthritis, HIV/AIDS
  • Blind or low vision
  • Cancer (past or present)
  • Cardiovascular or heart disease
  • Celiac disease
  • Cerebral palsy
  • Deaf or serious difficulty hearing
  • Diabetes
  • Disfigurement, for example, disfigurement caused by burns, wounds, accidents, or congenital disorders
  • Epilepsy or other seizure disorder
  • Gastrointestinal disorders, for example, Crohn's Disease, irritable bowel syndrome
  • Intellectual or developmental disability
  • Mental health conditions, for example, depression, bipolar disorder, anxiety disorder, schizophrenia, PTSD
  • Missing limbs or partially missing limbs
  • Mobility impairment, benefiting from the use of a wheelchair, scooter, walker, leg brace(s) and/or other supports
  • Nervous system condition, for example, migraine headaches, Parkinson’s disease, multiple sclerosis (MS)
  • Neurodivergence, for example, attention-deficit/hyperactivity disorder (ADHD), autism spectrum disorder, dyslexia, dyspraxia, other learning disabilities
  • Partial or complete paralysis (any cause)
  • Pulmonary or respiratory conditions, for example, tuberculosis, asthma, emphysema
  • Short stature (dwarfism)
  • Traumatic brain injury
Please check one of the boxes below:
YES, I HAVE A DISABILITY, OR HAVE HAD ONE IN THE PAST
NO, I DO NOT HAVE A DISABILITY AND HAVE NOT HAD ONE IN THE PAST
I DO NOT WANT TO ANSWER

PUBLIC BURDEN STATEMENT: According to the Paperwork Reduction Act of 1995 no persons are required to respond to a collection of information unless such collection displays a valid OMB control number. This survey should take about 5 minutes to complete.

Name Date
Human Check*