Note: The job is a remote job and is open to candidates in USA. Guidehouse is a consulting firm focused on helping organizations improve their operations. They are seeking a Data Profiling Specialist to support a state agency's modernization efforts by enhancing data quality and readiness. The role involves evaluating data sources, assessing quality, and collaborating with teams to prepare for system modernization.
Responsibilities
- Evaluate and analyze data from legacy systems and disparate sources to assess quality, completeness, and consistency
- Develop and apply practical approaches to profile complex datasets, including structured and semi-structured data
- Identify data gaps, anomalies, and structural issues that may impact reporting, analytics, or system migration
- Recommend data quality improvements and remediation actions that are aligned to both current-state use and future-state system needs
- Support data readiness efforts for modernization and system replacement, including migration considerations
- Collaborate with stakeholders to validate findings and align on data priorities and remediation strategies
- Document data issues, patterns, and recommendations in a clear, actionable format
- Partner with program and technical teams to improve data usability for reporting and analytics
Skills
- Bachelor's degree from an accredited college/university
- Based on our contractual obligations, candidate must be located within the United States and US Citizen
- Must be able to obtain and maintain a federal public trust
- 2 + years of experience in data profiling, data analysis, or data quality assessment
- Prior experience in child welfare, human services, or related social programs (state agency, consulting, or nonprofit)
- Strong proficiency in SQL and data analysis for querying, analyzing, and profiling data across complex, multi-system environments
- Experience identifying data quality issues and recommending remediation actions
- Experience supporting data preparation for analytics, reporting, or system modernization efforts
- Ability to clearly communicate findings to both technical and non-technical stakeholders
- Familiarity with system modernization or data migration readiness efforts
- 10% travel may be required during key client deliverable milestones
- Experience with data profiling and data quality tools such as Informatica Data Quality, Talend, Collibra Data Quality, or similar platforms and technologies
- Advanced experience with data preparation and transformation techniques to support reporting, analytics, and modernization readiness
- Familiarity with data modeling concepts and data structures to evaluate how data can be used in current and future-state systems
- Experience supporting enterprise and/or programmatic data governance or data standardization efforts
- Familiarity with CCWIS or large human services system environments
Benefits
- Medical, Rx, Dental & Vision Insurance
- Personal and Family Sick Time & Company Paid Holidays
- Position may be eligible for a discretionary variable incentive bonus
- Parental Leave and Adoption Assistance
- 401(k) Retirement Plan
- Basic Life & Supplemental Life
- Health Savings Account, Dental/Vision & Dependent Care Flexible Spending Accounts
- Short-Term & Long-Term Disability
- Student Loan PayDown
- Tuition Reimbursement, Personal Development & Learning Opportunities
- Skills Development & Certifications
- Employee Referral Program
- Corporate Sponsored Events & Community Outreach
- Emergency Back-Up Childcare Program
- Mobility Stipend
Company Overview