Business Intelligence Analyst in Philadelphia, PA at Public Health Management Corporation

Date Posted: 9/17/2020

Job Snapshot

Job Description

The role of Business Intelligence Analyst (BI) will be responsible for the front end of all reporting related functions within the IT Department. The role will be responsible for identifying business intelligence, reporting, data analysis, data mining, patterns discovery, and data visualization. The BI Analyst interacts with business and IT teams at all levels to ensure reliable, accurate, relevant, and appropriately processed data is available for business decision making. The BI Analyst is responsible for the creation of documentation to educate users on data analysis, the automation of canned reporting, and to provide ad hoc self-service processes whenever possible. The role requires a strong view of PHMC’s change management process to ensure the delivery of tangible results and innovation to PHMC’s business community. The role also requires the ability to define tactical plans to meet data security and quality benchmarks set by the DBA.

The BI Analyst must have data modeling exposure and the ability to analyze functional business processes and functional business requirements to help PHMC IT develop BI and data warehouse (DW) strategy. This requires working with several teams to gather and cleanse disparate, and dirty data to produce high quality results. Participates in special projects and performs additional duties as required by management.

This role will work with application developers, systems, and business analysts, as well as network and systems administrators and the information technology management team. The role requires excellent analytical skills, time management skills, the ability to prioritize and multi task. Most important is the ability to make effective and timely decisions in alignment with departmental direction as required.

Work Schedule

  • This is a full-time position with a five day, 40 hours/week work schedule.


  • Provides subject matter expertise for key BI core functions.
  • Provides design support for the development of business intelligence solutions.
  • Works on highly complex, cross-functional enterprise IT and BI solutions.
  • Initiates BI technical process from inception, design, development, testing, and delivery of BI solutions. Participates in BI projects management and review.
  • Gathers, validates, and assesses business requirements for an adequate BI solution.
  • Participate in BI tools research, frameworks, and mechanisms for data analytics and contributes to knowledge sharing in BI, the tools, frameworks, and known best practices.
  • Stay abreast of BI products/tools and business strategies to assist DBA in recommendations for PHMC’s direction with regard to BI functions.
  • Adheres to current BI standards and provides recommendations to improve or develop new standards, policies, and procedures.
  • Designs, develops, and delivers end-user training and training materials.
  • Participate in training of Datawarehouse and DataMart users.
  • Develops and monitors data extract, transform, and load (ETL) using T-SQL/SQL, SSIS tools, and third-party tools.
  • Keeps IT management and others informed about work efforts and challenges that may affect normal work progress.
  • Responsible for the effective participation in the change management process.


  • Self-directed, the ability to work independently, and being highly-motivated while bringing an entrepreneurial spirit to Information Technology operations.
  • Ability to work in a fast-paced and deadline driven environment.
  • Ability to stay focused and complete tasks in a timely and accurate manner, respecting operational and organizational goals and processes.
  • Detail-oriented, dependable and trustworthy as this role may require contact with complex and sensitive documents and/or information.
  • Highly organized individual capable of defining project and driving though to delivery against defined plan.
  • Skilled at risk and issue management.
  • Effective communication skills, able to engage at all levels of the organization while operating under pressure and deadlines.


  • 3 years or more of experience in BI analyst position.
  • High level of proficiency in Business Intelligence functions.
  • Excellent organizational and time management skills, attention to detail to produce accurate work.
  • Good communication skills.
  • Knowledge in the following technical tools required: SQL, SSIS, SSAS, SSRS, Power BI, QLIK, or Tableau.
  • Advanced knowledge in EXCEL preferred
  • Healthcare setting experience preferred.
  • Quantitative research, statistics, R, Python, SAS, ArcGIS is a plus.

Education Requirement:

  • Bachelors degree in Data Science, Computer Science, Information Systems, or relevant experience required.
  • Business intelligence or database related certifications from accredited institution a plus.


  • This position reports to the Database Administrator

Physical Requirement:

  • Seeing to view a computer monitor and to read various materials
  • Hearing and speaking to exchange information in person or on the telephone