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