Role Description We are seeking a motivated and detail-oriented Data Analyst to join our growing team. This role is ideal for candidates with at least 2 years of experience who are eager to build a career in data and e-commerce. As a Data Analyst, you will work with real-world datasets to uncover trends, support client reporting, and contribute to meaningful insights in one of the fastest-growing sectors in Southeast Asia. - Collaborate with cross-functional teams to gather and understand data and business requirements - Transform and clean data using Python (SQL is a plus) - Perform exploratory data analysis to identify trends, patterns, and anomalies - Assist in developing and implementing data models and algorithms - Analyze and interpret complex datasets to surface key metrics and statistical insights - Communicate findings effectively Qualifications - Strong analytical and problem-solving skills with a basic understanding of statistics and data interpretation - Proficiency in Python, Google Sheets, and Excel is essential; SQL knowledge is a plus - Experience with data warehouse platforms such as Snowflake, Amazon Athena, or Google BigQuery is a plus - Enthusiastic self-starter with a strong desire to learn and grow in the data field - Comfortable working in a fast-paced environment and adapting quickly to change - Passionate about e-commerce, with strong communication and collaboration skills - A Bachelor's degree in a quantitative field (e.g., Computer Science, Statistics, Mathematics, Economics, etc.) is preferred but not required

• 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.