Data Analyst

Job Location: Melville, NY or Boca Raton, FL

Hybrid

Work Schedule:

Must be able to reliably commute to either our Melville, NY office or Boca Raton, FL office. Split between 2-3 days in-office and remote workdays.

Company

Description:

Sheer Science is dedicated to improving lives through innovative products that deliver real results seen and experienced by our customers. We identify and bring to market effective products backed by clinical studies, earning trust and confidence through their performance. Our culture emphasizes an open, honest environment where every employee's voice is valued, fostering a fun, collaborative atmosphere. We live our values of honesty, transparency, and commitment to excellence, ensuring every team member feels engaged and motivated.

The Data Analyst will play a key role in supporting data quality, reporting accuracy, and analytics across the business. This mid-level role will own recurring validation and reconciliation efforts, investigate discrepancies across source systems, warehouse tables, and Power BI outputs, and support the maintenance and enhancement of dashboards, semantic models, and reporting datasets. The ideal candidate brings solid hands-on experience with SQL, Power BI, structured data analysis, and data documentation, along with the ability to troubleshoot data issues, communicate findings clearly, and partner with stakeholders to turn business questions into reliable, actionable insights.

• Own recurring data validation and quality checks across reporting datasets, pipelines, and source systems.
• Investigate discrepancies between source systems, warehouse tables, and Power BI/reporting outputs.
• Perform routine SQL analysis and troubleshooting, including joins, aggregations, reconciliation queries, duplicate detection, and missing record investigations.
• Maintain and enhance existing Power BI reports and semantic models.
• Handle stakeholder requests for recurring reports, extracts, segmentation, and ad hoc analysis.
• Document business logic, table definitions, pipeline dependencies, and reporting rules.
• Perform first-level troubleshooting on failed Azure/Synapse pipelines before escalating deeper engineering issues.
• Maintain data dictionaries and lightweight lineage documentation.
• Support QA for new datasets, dashboards, and pipeline changes before production deployment.

We’re looking for an experienced data professional with strong SQL, Power BI, reporting, and data validation skills. The ideal candidate can troubleshoot data issues, document business logic, and translate complex datasets into clear, actionable insights. E-commerce or direct-to-consumer (D2C) experience is preferred, especially with customer, order, marketing, web, subscription, or product data.

• Bachelor's degree or equivalent experience in related field.
• 3+ years professional work experience
• Strong SQL fundamentals
• Basic Python skills, plus use of Jupyter Notebooks for EDA, and presentation.
• Strong understanding of ETL/ELT concepts
• Familiarity with cloud data platforms;
  Azure experience would be ideal.
• Understanding of APIs, HTTP requests, authentication, and JSON responses.
• Familiarity with e-commerce and direct-to-consumer (D2C) business models preferred.

At Sheer Science we “Have fun and get it done!”. We pride ourselves in creating an open and honest environment where each employee’s voice is valued. Our teams consist of hungry, humble, curious and smart dedicated individuals. We are dedicated to fostering the highest level of employee engagement through living our values and commitment to culture! (We don’t just talk about it…we do it!)

• We never settle for the status quo!
• We are honest and transparent!
• We check our egos at the door!
• Competitive Compensation:
  Enjoy a robust salary package with performance-based bonus opportunities.
• 401(k) with Employer Match:
  Plan for your future with a competitive retirement program and generous company match.
• Comprehensive Health Coverage:
  Medical, dental, and vision insurance with strong employer contributions, plus FSA, life insurance, and more.
• Generous Paid Time Off:
  Start with up to 18 days of PTO, with…