Data Analyst [Local Candidates Only - Wexford, PA]

Description

POSITION OVERVIEW

The Data Analyst will play a critical role in advancing InVision Human Services' transformation into a data-driven organization. This position is responsible for turning raw data into actionable insights while also helping to shape the structure of the organization's data environment.

A key responsibility will be the design and maintenance of layered data models , including the use of views to simplify raw system feeds, curated tables to deliver standardized datasets, and a semantic model that supports self-service analytics in Power BI. This layered approach will reduce redundancy, improve performance, and create a consistent foundation for organizational reporting and decision-making.

The analyst will collaborate with stakeholders across all departments to deliver insights that improve operational quality, safety, and satisfaction for employees and the people we support.

ESSENTIAL FUNCTIONS:

Business Intelligence Development

• Collaborate on the implementation and continued enhancement of BI strategy with use of Microsoft Fabric and AI-powered analytics.
• Contribute to the foundation for predictive analytics and natural language interaction in Power BI by ensuring high-quality data pipelines and models.
• Collaborate with IT leadership to advance the infrastructure needed for AI-driven decision making, aligning daily work with the organization's long-term BI vision.
• Design and maintain layered data models to support analytics, including:
• • Creating SQL views to streamline and standardize raw data structures.
  • Building curated tables from those views for reliable and reusable reporting datasets.
  • Supporting a semantic data layer in Power BI that enables governed self-service analytics.
• Ensure consistency and accuracy of data definitions and calculations across reports and dashboards.
• Partner with IT, consultants, and system owners to enhance the data warehouse architecture and align it with strategic priorities.
• Optimize BI solutions for performance, scalability, and long-term sustainability.

Data Governance & Integrity

• Participate in organizational data governance processes to ensure data is accurate, secure, and properly managed.
• Identify and address data quality issues, working with system owners to resolve them.
• Support the development of policies, procedures, and standards that strengthen data management practices.

Collaboration & Stakeholder Engagement

• Engage stakeholders across departments to understand data needs and deliver meaningful insights.
• Support QMDC and subcommittee reporting requirements, including quarterly board reports and project tracking.
• Provide data literacy guidance to end users, fostering a culture of evidence-based decision-making.

Continuous Improvement

• Recommend improvements to data collection methods, reporting processes, and BI tools.
• Contribute to organizational efforts to embed data literacy and analytical thinking at all levels.
• Stay current with emerging trends in BI, data modeling, and visualization to bring forward innovative practices.

Behavior Expectations

• Model InVision's mission, philosophy, and values in all work.
• Uphold diversity, equity, inclusion, and person-centered practices.
• Maintain confidentiality and adhere to security and compliance standards.
• Foster respectful collaboration, transparency, and problem-solving.

EDUCATION and/or EXPERIENCE


• Associate's degree in Data Analytics, Information Systems, Statistics, Computer Science, or related field; equivalent experience considered..

• 2-3 years of experience in data analysis, business intelligence, or analytics, preferably in healthcare or human services.

• Proficiency in Power BI, SQL (Azure SQL preferred), and Excel.

• Experience designing data models and semantic layers for analytics.

• Familiarity with relational database concepts, ETL processes, and dimensional modeling (star schema, snowflake).

• Experience working with enterprise applications (EHR, HCM/HRIS, financial systems) is preferred.

• Knowledge of data governance principles and best practices is an asset.

Skills & Abilities

• Strong analytical and problem-solving skills.

• Ability to translate complex data into clear, actionable insights.

• Effective communication skills for both technical and non-technical audiences.

• Ability to manage multiple priorities and work independently or in a team.

PHYSICAL DEMANDS

While performing the duties of this job, the employee is frequently required to stand, walk, sit and talk. The employee must occasionally lift and/or move up to 20 pounds. Specific vision abilities required by this job include close vision, distance vision, and ability to adjust focus.


All job requirements listed indicate the minimum level of knowledge, skills, and/or ability deemed necessary to perform the job proficiently. This job description is not to be construed as an exhaustive statement of duties, responsibilities, or requirements. Employees may be required to perform any job-related function as directed by their supervisor.