Data Analyst [Local Candidates Only - Wexford, PA]

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.

Do you have experience in Technical Proficiency?, Do you have a Associate's degree?, * 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.