• Configure, monitor, and troubleshoot inbound and outbound HIPAA 834 (Benefit Enrollment and Maintenance) transaction files with trading partners, employers, and TPAs • Validate 834 file structures for compliance with X12 5010 standards, identifying and resolving segment errors, loop discrepancies, and rejected transactions • Coordinate with trading partners to resolve enrollment exchange issues and ensure timely, accurate file transmission • Perform systematic validation of member enrollment records against source documents, 834 transactions, and plan eligibility rules • Identify data anomalies, duplicate records, coverage gaps, and demographic inconsistencies • Execute data quality audits on a scheduled and ad-hoc basis, documenting findings and remediation steps • Ensure enrollment data aligns with plan effective dates, benefit periods, and group contract terms • Accurately enter and update member demographic, eligibility, and coverage data across the web UI enrollment portal and the claims processing system • Process member adds, terminations, changes, and reinstatements in a timely manner in compliance with CMS and ACA guidelines • Maintain supporting documentation for all manual data changes per audit and compliance standards • Lead targeted data cleanup projects to address backlogs, legacy migration issues, and discrepancies identified through audits or operational escalations • Write and execute SQL queries against enrollment and member databases to identify, extract, and correct data issues • Collaborate with the engineering team on bulk update scripts and data remediation workflows • Partner with engineering, claims, and population health teams to surface enrollment data issues affecting downstream claim adjudication, reporting, and care management workflows • Support compliance and reporting requirements including ACA 1095-B and CMS enrollment submissions • Communicate enrollment discrepancies and resolution status to internal stakeholders and external partners

• Collect, clean, validate, and organize data from multiple sources. • Perform data analysis and generate reports using spreadsheets and dashboards. • Support website research, lead generation, and influencer data collection projects. • Assist with automation workflows and AI-powered data processes. • Work with APIs and external data sources including Google, Meta (Instagram/Facebook), and TikTok. • Maintain data quality and identify inconsistencies or missing information. • Create documentation and standard operating procedures for data processes. • Collaborate with internal teams on research, reporting, and automation projects.

Role Description The Data Analytics Consultant is responsible for designing risk management strategies and producing measurable outcomes for clients and prospects using data and technology. How you'll make an impact: - You possess a solid sense of professionalism and have a customer service disposition. - You are able to span managing people to get projects done, while also being a team player and not being afraid to “do the work.” - Highly analytical in nature, you are comfortable analyzing reports & data to make real world conclusions. Essential Duties and Responsibilities - Identify, analyze and interpret benefits plan data to identify population risk, financial trends, and utilization trends. - Develop risk strategies through value-based plan design, contribution, and benefit initiatives. - Prepare financial forecasts through predictive modeling tools. - Develop and implement databases, data collection systems, data analytics and other strategies that optimize efficiency and quality. - Enhance plan communications platform by leveraging technology. - Support sales and prospecting efforts in the Large Group Practice. Present plan performance reports to clients on a scheduled basis. - Evaluate current product results; identify needs to be filled; monitor competitive options; and analyze and relay customer experience. - Travel for client/prospect meetings and incorporate time in the office for planning, preparation, and training as needed. - Provide team and client with appropriate timelines to ensure that expectations and turnaround times are met. - Other duties as assigned. - Travel is expected to be up to 10% in this role. Qualifications - Typically requires a University Degree and minimum 5 years of prior relevant experience, or equivalent experience. Benefits - Medical/dental/vision plans, which start from day one! - Life and accident insurance. - 401(K) and Roth options. - Tax-advantaged accounts (HSA, FSA). - Educational expense reimbursement. - Paid parental leave. - Digital mental health services (Talkspace). - Flexible work hours (availability varies by office and job function). - Training programs. - Gallagher Thrive program – elevating your health through challenges, workshops and digital fitness programs for your overall wellbeing. - Charitable matching gift program. - And more... The benefits summary above applies to fulltime positions. If you are not applying for a fulltime position, details about benefits will be provided during the selection process.

Role Description A leading music streaming company seeks a Senior Data Analyst, People Analytics to support HR reporting, analytics, and compliance initiatives by maintaining data integrity, delivering actionable insights, and ensuring accurate people-related reporting. This role plays a key part in supporting ongoing People Analytics operations through dashboard management, data analysis, Workday reporting, and stakeholder-driven reporting requests in a fast-paced, data-driven environment. - Maintain, audit, and deliver recurring People Analytics dashboards and weekly/monthly reports, ensuring data accuracy, consistency, auditability, and timely completion of reporting deliverables. - Support people-related compliance reporting activities by preparing, validating, and assisting with the submission of required data while documenting reporting logic, metric definitions, and data sources, and escalating data quality concerns as needed. - Develop and refine SQL queries to extract, join, validate, and analyze data from HR systems and reporting sources, while supporting Workday reporting activities, including data extraction, troubleshooting, and basic report configuration and development. - Prepare analyses and insights in response to stakeholder requests, communicate findings and recommendations to non-technical audiences, and balance ad hoc reporting needs against recurring reporting priorities. - Leverage approved AI tools to improve workflow efficiency, support query development, summarize findings, document reporting logic, and streamline reporting processes while maintaining employee data privacy and confidentiality. Qualifications - Bachelor's degree or equivalent practical experience; a Master's degree may substitute for some experience based on organizational guidelines. - Experience in analytics or reporting within People Analytics, Human Resources, Operations, Finance, or a similar data-driven environment. - Working knowledge of SQL, including the ability to pull, join, validate, and analyze data from relational databases. - Experience with Workday or similar HRIS platforms, including reporting, data structures, data extracts, and troubleshooting activities. - Experience maintaining business intelligence dashboards and recurring reporting processes with a strong emphasis on data quality, accuracy, and audit readiness. - Experience utilizing approved AI tools (e.g., ChatGPT, Claude, Claude Code, or similar technologies) to improve reporting efficiency and analytical workflows while maintaining confidentiality standards. - Excellent verbal and written communication skills, with the ability to explain metrics, limitations, and recommendations to non-technical stakeholders. Requirements - Hourly pay: $50-$55/hr - Worksite: Remote - open for candidates located in the United States - W2 Employment - Group Medical, Dental, Vision, Life - Retirement Savings Program - PSL - 40 hours/week, 6 Month Assignment Shift - Remote: EST business hours for candidates located in the United States. - Candidates based in New York or New Jersey may be asked to attend the office on an occasional basis.