Data Specialist

Job Title: Data Specialist

Department: Technology
Reports To: Director of Technology
Status: Full-Time | Exempt

Position Summary

The Data Specialist plays a critical role in ensuring the integrity, accessibility, and strategic use of organizational data. This position is responsible for collecting, standardizing, managing, analyzing, reporting, and visualizing data to support decision-making, operational efficiency, and performance-based initiatives. The ideal candidate will be detail-oriented, technically proficient, and passionate about transforming raw data into actionable insights that will support Penn-Mar’s mission of supporting people with intellectual and developmental disabilities (IDD) to live courageously in pursuit of their best life.

Key Responsibilities

• Data Analysis and Reporting
  • Collaborate with stakeholders to gather, understand, and document business requirements.
  • Connect to data sources, import data, and transform data for Business Intelligence.
  • Collect and preprocess data from different sources.
  • Develop visual reports, dashboards, and KPI scorecards using Power BI.
  • Create analytic solutions through Power BI platform.
  • Serve as the primary contact with data consultants and platforms.
  • Follow established security policies and procedures to ensure appropriate access following the principle of least privilege.
• Data Maintenance
  • Collaborate with cross-functional teams to maintain data accuracy and integrity within application and BI systems.
  • Support data cleansing and data validation processes to ensure high-quality analysis.
  • Perform regularly scheduled data update, maintenance, and verification tasks.
• Data Standardization
  • Enforce company-wide data standardization based on the Data Dictionary and Data Entry Guidelines.
  • Coordinate data clean-up efforts within the organization.
  • Educate the organization on the importance of standardized data.
• Data Governance
  • Serve as contributing member of the Data Strategy and Data Governance Workgroups.
  • Lead and manage the cross-functional Data Management Workgroup and Data Team.
  • Develop, update, publish, and educate the organization on data-related policies, procedures, and guidelines.
  • Complete assigned HIPAA and security related tasks in a timely manner per Tech policies and procedures.
• Data Literacy and Culture
  • Promote and educate the company to become a data-driven organization.
  • Assist in development and implementation of data-driven strategies.
  • Provide Power BI training to end-users.

Required Qualifications

• Bachelor’s degree in data science, computer science, information systems, or a related field, plus 2+ years of experience in data management, analysis, or business intelligence roles.
  • OR: Associate’s degree in data science, computer science, information systems, or a related field, plus 4+ years of relevant experience.
• Strong analytical and problem-solving skills with high attention to detail.
• Excellent written and verbal communication skills.
• Hands-on experience with Microsoft Power BI, including DAX, Power Query, and data gateway configuration.
• Familiarity with database and data warehousing concepts and tools.
• Eagerness to learn and adapt to new data tools and technologies.

Preferred Qualifications

• Experience with Cognos Business Intelligence (or UKG Pro BI) platform
• Certification in Power BI or data analytics.
• Experience in social or human services and the non-profit sector.
• Knowledge of HIPAA data governance framework.

This outstanding Full-time opportunity includes:

Salary Range: $55,000 - $65,000 per year

Competitive Benefits package with:

• Medical, Rx, HRA, FSA, Dental, Vision, Life Insurances  
• 403b (Retirement Plan) with generous (2.5x) Match 
• Short- and Long-term disability insurance
• Paid Time Off (PTO) and 12 Paid Holidays

Qualifications Education Required Bachelors or better. Equal Opportunity Employer
This employer is required to notify all applicants of their rights pursuant to federal employment laws. For further information, please review the Know Your Rights notice from the Department of Labor.