Data Analyst

Swoon; Richmond (VA); Hybrid; USD 80,000 - 110,000; Full time

Job summary

Swoon is seeking a Data Analyst in Richmond, VA to analyze complex datasets and deliver actionable insights. The role focuses on SQL/Python data analysis, data modeling, and supporting BI initiatives across Snowflake, Databricks, and AWS data storage.

The ideal candidate will work across multiple cloud data platforms, validate data quality, and translate business requirements into analytical solutions, collaborating with data engineering and business teams.

Qualifications

• Strong hands-on experience with SQL for querying, analyzing, and validating data.
• Experience using Python for data analysis, data manipulation, and automation.
• Experience working with Snowflake and/or Databricks for data exploration and analysis.
• Familiarity with AWS cloud environments, particularly Amazon S3 and cloud-based data storage.
• Understanding of data structures, data modeling, table relationships, and data architecture concepts.
• Experience with data validation, data quality analysis, reconciliation, and troubleshooting.
• Strong analytical, critical-thinking, and problem-solving skills.
• Ability to interpret business requirements and communicate analytical findings clearly.
• Ability to work in a hybrid environment in Richmond, Virginia.

Responsibilities

• Analyze large and complex datasets using SQL and Python to identify trends, patterns, discrepancies, and actionable insights.
• Write, maintain, and optimize SQL queries to extract, transform, validate, and analyze data.
• Work with Snowflake and Databricks to access, explore, and analyze data across cloud-based platforms.
• Utilize AWS data storage solutions, including Amazon S3, to locate and work with data required for analysis.
• Develop and maintain data models, analytical datasets, and structured data tables to support reporting and business analysis.
• Perform data profiling, validation, reconciliation, and quality checks to ensure data accuracy and consistency.
• Translate business questions and requirements into analytical queries, data investigations, and reporting solutions.
• Collaborate with data engineering, architecture, and business teams to understand data sources, relationships, and dependencies.
• Identify data quality issues, investigate root causes, and communicate findings and recommendations to stakeholders.
• Support dashboard development, recurring reports, and business intelligence initiatives as needed.

Skills

SQL

Python

Data analysis

Cloud data platforms

Tableau

Amazon QuickSight

Tools

Snowflake

Databricks

Amazon S3

Job description

Duration: 12 months with potential to extend

Position Overview:

We are seeking a skilled Data Analyst with strong experience in SQL, Python, data analysis, and modern cloud-based data platforms. This individual will analyze complex datasets, support data modeling and architecture initiatives, and deliver actionable insights to support business and operational decisions.

The ideal candidate has hands-on experience querying and analyzing data in Snowflake and Databricks, working with AWS-based data storage such as Amazon S3, and preparing data for reporting and analytics. Experience with Tableau or Amazon QuickSight is a plus.

This role is best suited for an analytical professional who can work across multiple data platforms, investigate data discrepancies, develop efficient queries, and collaborate with technical and business stakeholders to translate business requirements into meaningful data insights.

Key Responsibilities:

• Analyze large and complex datasets using SQL and Python to identify trends, patterns, discrepancies, and actionable insights.
• Write, maintain, and optimize SQL queries to extract, transform, validate, and analyze data.
• Work with Snowflake and Databricks to access, explore, and analyze data across cloud-based platforms.
• Utilize AWS data storage solutions, including Amazon S3, to locate and work with data required for analysis.
• Develop and maintain data models, analytical datasets, and structured data tables to support reporting and business analysis.
• Perform data profiling, validation, reconciliation, and quality checks to ensure data accuracy and consistency.
• Translate business questions and requirements into analytical queries, data investigations, and reporting solutions.
• Collaborate with data engineering, architecture, and business teams to understand data sources, relationships, and dependencies.
• Identify data quality issues, investigate root causes, and communicate findings and recommendations to stakeholders.
• Support dashboard development, recurring reports, and business intelligence initiatives as needed.

Qualifications:

• Strong hands-on experience with SQL for querying, analyzing, and validating data.
• Experience using Python for data analysis, data manipulation, and automation.
• Experience working with Snowflake and/or Databricks for data exploration and analysis.
• Familiarity with AWS cloud environments, particularly Amazon S3 and cloud-based data storage.
• Understanding of data structures, data modeling, table relationships, and data architecture concepts.
• Experience with data validation, data quality analysis, reconciliation, and troubleshooting.
• Strong analytical, critical-thinking, and problem-solving skills.
• Ability to interpret business requirements and communicate analytical findings clearly.
• Ability to work in a hybrid environment in Richmond, Virginia.

Preferred Qualifications:

• Experience with Tableau or Amazon QuickSight.
• Experience building dashboards, visualizations, or recurring analytical reports.
• Familiarity with data lakes, cloud data platforms, and enterprise data environments.
• Experience partnering with data engineers and business stakeholders on reporting and analytics initiatives.