Data Analyst

Swoon; California (MO); On-site; USD 90,000 - 120,000; Full time

Job summary

Swoon is seeking an experienced Technical Data Analyst with SQL and MongoDB capabilities to support decision-making across patient access and coverage products. You will analyze data usage, document requirements, and help guide platform modernization and migrations.

Join a cross-functional team that translates data insights into actionable product priorities, ensures data quality, and collaborates across departments to optimize reporting and analytics for healthcare data environments.

Qualifications

• 3+ years' experience in SQL and MongoDB
• 3+ years' experience as a Data Analyst or similar role, healthcare data focus
• 3+ years' experience with data analysis, data integration, and database management
• 3+ years' experience with data visualization tools and techniques
• Bachelor's degree in a related field; advanced degrees welcome
• Experience with data integration tools or platforms
• Experience supporting platform modernization or migrations
• Familiarity with Confluence or Jira

Responsibilities

• Write and implement complex SQL queries to extract, manipulate, and analyze data
• Perform data retrieval and manipulation using MongoDB queries
• Produce detailed and actionable reports based on data analysis and query results
• Present findings and insights to partners
• Troubleshoot and resolve data-related issues
• Document and maintain clear requirements and analysis findings in Confluence or similar
• Collaborate with product and implementation teams to validate requirements
• Analyze usage and dependencies to inform migrations and platform updates
• Assist with query optimization to improve performance
• Research dependencies to support platform modernization and migration decisions
• Analyze configurations across levels to inform system design
• Partner with teams to understand data needs and provide analytical support

Skills

SQL

MongoDB

Data Analysis

Data Visualization

Education

Bachelor's degree in Computer Science, Data Science, IT, Statistics

Tools

Confluence

Jira

Job description

We're looking for an experienced Technical Data Analyst with SQL and MongoDB expertise. You will report to the Patient Access Curator/Coverage Discovery product team within and support stakeholder decision-making while analyzing platform and data usage patterns across legacy and new tools and systems. This work may directly shape product and development team priorities. Work will include researching data and development dependencies, analyzing usage patterns, and documenting requirements to inform decision making. This role is imperative to ensure accurate, applicable data insights across the organization, and to a smooth transition as we modernize our platforms.

Key Responsibilities:

• Work with partners and address their reporting requirements


• Collaborate with the product and development team


• Help with query optimization


• Research and identify dependencies to support platform updates


• Analyze usage and adoption patterns to help determine what data, rules, or configurations should carry forward during migrations or be transitioned to the new tools/product versus what can be retired


• Perform comparative analysis across systems or platforms to identify where functionality maps directly and where it needs to be redesigned


• Analyze clients and configurations to identify migration candidates, risks, and transition readiness


• Analyze how settings and configurations are used across different levels (e.g., account, client, user) to inform system design and migration decisions


• Write and implement complex SQL queries to extract, manipulate, and analyze data


• Perform data retrieval and manipulation using MongoDB queries


• Produce detailed and actionable reports based on data analysis and query results


• Present findings and insights to partners


• Troubleshoot and resolve data-related issues


• Document and maintain clear requirements and analysis findings (e.g., in Confluence or similar tools) to support ongoing projects and migrations


• Work with other team members and departments to understand data needs and provide analytical support


• Partner with product and implementation teams to validate requirements against real-world usage

Qualifications:

• 3+ years' experience in SQL and MongoDB required


• 3+ years' experience as a Data Analyst or similar role, with a focus on payer data or healthcare data


• 3+ years' experience with data analysis, data integration, and database management


• 3+ years' experience with data visualization tools and techniques


• Experience analyzing large datasets and extracting meaningful insights and presenting complex data and findings concisely


• Bachelor's degree in Computer Science, Data Science, Information Technology, Statistics, or a related field. Advanced degrees or certifications are welcome


• Experience with data integration tools or platforms


• Experience supporting platform modernization, product consolidation, migration, or sunset initiatives preferred


• Experience and comfort using AI tools (e.g., LLMs, AI-assisted coding and analysis platforms) to accelerate data analysis, documentation, and requirements work, paired with the judgement to critically evaluate AI-generated outputs for accuracy


• Knowledge of data warehousing concepts and practices


• Familiarity with additional programming languages or data manipulation tools


• Experience gathering, documenting, and validating business or technical requirements, ideally in a system migration or platform-consolidation context


• Familiarity with requirements and documentation tools such as Confluence or Jira