SQL Data Analyst – Data Warehouse & Analytics (6-Month Contract)

Sound Physicians; United States; On-site; USD 90,000 - 117,000; Full time

Job summary

Sound Physicians is seeking an experienced Data Analyst for a 6-month contract to join our IT Data & Analytics team. You will analyze source data, profile quality, translate business needs into technical requirements, and support reliable data integration and analytics across our enterprise data warehouse.

The ideal candidate has strong SQL skills, data warehousing knowledge, and experience communicating findings to business and technical stakeholders.

Qualifications

• Bachelor's degree in Data Science, Information Systems, Computer Science, or a related field.
• Minimum of three years of experience in a data analyst or comparable analytical role.
• Strong proficiency in SQL, including advanced querying techniques such as joins, subqueries, CTEs, aggregations, and window functions.
• Strong understanding of data warehousing concepts, data integration practices, and ETL processes.
• Experience profiling source data and assessing data quality, completeness, consistency, and usability.
• Experience documenting technical requirements, source-to-target mappings, data definitions, transformation rules, or similar specifications.
• Ability to translate business requirements into structured technical and analytical deliverables.
• Ability to manage multiple priorities and contribute effectively within an Agile delivery environment.

Responsibilities

• Profile and analyze source data using SQL to assess data structure, completeness, quality, and alignment with business and technical requirements.
• Perform advanced ad hoc querying to support data investigations, troubleshooting, solution design, and project scoping.
• Translate business requirements into clear, actionable technical requirements for data integration, warehousing, and reporting solutions.
• Develop and maintain source-to-target mappings, technical specifications, data definitions, and related solution documentation.
• Partner with ETL developers to validate transformation logic and ensure data is appropriately structured for downstream reporting and analytical use.
• Collaborate with business stakeholders to understand operational needs, clarify requirements, and translate complex business questions into practical data solutions.
• Support the development and refinement of data models that promote consistency, scalability, and effective reporting.
• Conduct data validation, reconciliation, and testing to confirm the accuracy, completeness, and reliability of analytical deliverables.
• Identify data quality issues, investigate root causes, document findings, and collaborate with appropriate partners to support resolution.

Skills

SQL proficiency

Data profiling

Data warehousing

ETL processes

Documentation

Analytical thinking

Agile collaboration

Education

Bachelor's degree in Data Science, Information Systems, Computer Science

Tools

ETL tools

Job description

Sound Physicians is seeking an experienced Data Analyst for a 6-month contract to join our IT Data & Analytics team. You will analyze source data, profile quality, translate business needs into technical requirements, and support reliable data integration and analytics across our enterprise data warehouse.

The ideal candidate has strong SQL skills, data warehousing knowledge, and experience communicating findings to business and technical stakeholders.