Database Analyst

$55,000 - $65,000/Yr

Passavant Memorial Homes - Pittsburgh, PA

Full-time - Entry Level

Pittsburgh, PA

Nursing and Residential Care Facilities

About the position

The Database Analyst at Passavant Memorial Homes is responsible for managing and analyzing data across multiple databases and software platforms. This role involves utilizing Microsoft SQL Server Management Studio for database querying, enhancing datasets, and providing analytical intelligence to support decision-making. The analyst will collaborate with third-party IT and software development teams to ensure effective data management and reporting capabilities.

Responsibilities

• 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.

Requirements

• 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.

Nice-to-haves

• Experience developing business intelligence dashboards.
• Configuring data pipelines/processes.
• Database architecture.

Benefits

• 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