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-Mars 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

• Bachelors degree in data science computer science information systems or a related field plus2 years of experience in data management analysis or business intelligence roles.
  • OR: Associates 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: $55000 - $65000 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

Required Experience:

IC