Skip to main content

This job has expired

Data Warehouse Analyst

Job Details



Data Warehouse Analyst


At PCOM, we espouse to grow a culturally competent workforce to advance healthcare that touches the lives of underserved communities. Diversity and inclusion is the core component of our institutional identity and a key pillar of PCOM’s strategic vision. Philadelphia College of Osteopathic Medicine affirms that diversity and inclusion are crucial to the intellectual vitality of the campus community. It is through freedom of exchange over different ideas and viewpoints in supportive environments that our graduates develop the critical thinking and citizenship skills that will benefit them throughout their lives.

Since 1899, PCOM has trained highly competent, caring physicians, health practitioners, and behavioral scientists who practice a “whole person” approach to care - treating people, not just symptoms. As the field of medicine has changed, we've changed with it - adapting our program offerings to better meet the needs of healthcare providers and the communities they serve. At the main campus in Philadelphia, Pennsylvania (PCOM), the branch campus in Suwanee, Georgia (PCOM Georgia), and our newest location in Moultrie, Georgia (PCOM South Georgia), PCOM students learn to approach problem-solving in a more professional, more team-oriented manner, which prepares them to work successfully in integrated healthcare settings with other health professionals. At Philadelphia College of Osteopathic Medicine you will be part of a caring, professional, and committed community focused on making the PCOM experience the best possible for our students.

We are currently seeking to fill our Data Warehouse Analyst position at the Philadelphia campus with a highly qualified and passionate individual.

Job Title: Senior Data Warehouse Analyst

Physical Location: ANY

Status: Exempt

Basic Function:

The Senior Data Warehouse Analyst is accountable for developing, delivering and managing Business Intelligence and Data warehouse solutions for the Enterprise Data Lake, Data Warehouse, and related Data Marts. In this role, he/she will interface directly with Institutional Research and other departments in the development of strategic level reports and analytics.

Duties/essential functions may include, but not be limited to, the following:
  • Responsible for designing, building, and supporting the components of the Enterprise Data Lake, Date Warehouse, and Data Marts to include ETL processes, databases, reports, and reporting environments.
  • Develop and automate ETL processes to include error and reconciliation handling using Python, SQL, and DBT.
  • Create processes for adding, maintaining and/or updating data from disparate source systems.
  • Actively monitor and report on end-to-end data flow from source systems to data warehouse.
  • Monitor, adjust, and report on Snowflake “Compute” and “Storage” usage and capacity.
  • Assemble performance statistics, analyzes, and makes recommendations for improvements.
  • Establishes and maintains system documentation.
  • Participate as active member of Data Governance Committee.
  • Actively work with Institutional Research on appropriate use of datasets in Tableau and other analytical tools.
  • Serve as primary interface with the Business for the purpose of requirements gathering, design, testing, and other project related activities
  • Proven ability to understand business needs and translate them into technical requirements
  • Perform related duties as assigned.
Minimum Qualifications: : A minimum of a Bachelor’s Degree in an applied technology area such as Information Systems or Computer Science and 5+ years work experience supporting relational databases and/or data warehouses.

Working Conditions / Physical Requirements:

Medium work: Exerting up to 50 pounds of force occasionally, and/or up to 30 pounds of force frequently, and/or up to 10 pounds of force constantly to move objects. Incumbent may be required to travel from building to building frequently and off campus occasionally.

PCOM is an equal opportunity employer and all qualified applicants will receive consideration. We adhere to a policy that prohibits discrimination on the basis of race, color, sex, sexual orientation, gender identity, religion, creed, national or ethnic origin, citizenship status, age, disability, veteran status, or any other legally protected class.


Company

PCOM

Since 1899, Philadelphia College of Osteopathic Medicine (PCOM) has trained healthcare professionals to see the whole person—not just the symptoms. We focus on preventative health—developing attitudes and lifestyles that help prevent disease—as part of our comprehensive approach to providing high quality, holistic care.

At PCOM, we continue to strengthen the worlds of health and science by providing our students with unique opportunities to work in teams across disciplines in a dynamic medical school environment at our Philadelphia, PA; Suwanee, GA and Moultrie, GA locations.

At Philadelphia College of Osteopathic Medicine, you will be part of a community of caring, professional and committed individuals who focus on making the PCOM experience the best possible for our students.

Why Work at PCOM?

Our dedication to academic and institutional excellence drives everything we do. As a PCOM employee at our Philadelphia, PA Suwanee, GA or Moultrie, GA locations, you can make a meaningful contribution to the continued success and improvement of the College.

At PCOM, you can become part of our rich heritage, enjoy a competitive compensation and benefits package, and take advantage of opportunities for professional and personal growth. Our professional development programs include leadership training and mentoring as well as diversity, equity and inclusion certificates.

Get job alerts

Create a job alert and receive personalized job recommendations straight to your inbox.

Create alert