Data Warehouse Analyst – HigherEdJobs

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

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

Source link

Follow us on Google News

Disclaimers for

All the information on this website - - is published in good faith and for general information purpose only. does not make any warranties about the completeness, reliability, and accuracy of this information. Any action you take upon the information you find on this website (, is strictly at your own risk. will not be liable for any losses and/or damages in connection with the use of our website.

Leave a Comment

open in app