Location: United,PA, USA
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 [email protected]. 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 [email protected] or by phone at 1-888-###-#### Extension 111. PMHFOS prohibits discrimination in any employment action; in admissions, referrals, operations, or delivery of services against individuals because of their race; color; national origin; sex (including pregnancy, sexual orientation, gender, and/or gender identity); creed; religious affiliation; disability; age; ancestry; genetic information; limited English proficiency; marital status; membership in volunteer emergency responder organization; victim of domestic violence, sexual assault, or 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