Business Intelligence Analyst

Business Intelligence Analyst (5+ Years Experience) – Hybrid, Melville, NY

Job Location: Melville, NY (Long Island)

Work Schedule: Hybrid – 2–3 days in our Melville office, remaining days remote. This role is not fully remote; candidates must live within a reasonable commute of Melville, NY.

Employment Type: Full-time

About Sheer Science

Sheer Science is dedicated to improving lives through innovative products that deliver real results our customers can see and feel. We find and bring to market effective products backed by clinical studies, earning trust through performance. Our culture is open and honest, every employee’s voice is valued, and we keep things fun and collaborative. We live our values of honesty, transparency, and commitment to excellence.

Why this role?

Every decision at Sheer Science – what we launch, who we market to, how we serve customers – depends on data people can trust. As our Business Intelligence Analyst, you will be the person who makes sure it is right. You’ll own data quality and reporting accuracy across our Power BI dashboards and Azure data environment, track down the “why don’t these numbers match?” questions, and partner directly with teams across the business to turn their questions into clear, reliable answers.

What you’ll do

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

What you’ll need

• Minimum of 5 years of professional experience in business intelligence, data analysis, or a similar role.
• Bachelor’s degree in a related field, or equivalent experience.
• Strong SQL fundamentals.
• Strong Power BI skills (reports and semantic models).
• Solid understanding of ETL/ELT concepts.
• Familiarity with cloud data platforms (Azure experience is ideal).
• Working knowledge of Python and Jupyter Notebooks for exploratory analysis and presentation.
• Understanding of APIs, requests, authentication, and JSON responses.
• Clear written and verbal communication, and the ability to explain data findings to non-technical teammates.
• Must live in the New York metro area (within a commute of Melville, NY) and be able to work on-site 2–3 days per week.

Nice to have

• E-commerce or direct-to-consumer (D2C) experience, especially with customer, order, marketing, web, subscription, or product data.

Why you’ll like working here

At Sheer Science we “Have fun and get it done!” Our teams are hungry, humble, curious, and smart, and we are committed to an open, honest environment where your voice is heard. We don’t just talk about culture… we do it.

Our values:

· We never settle for the status quo.

· We are honest and transparent.

· We check our egos at the door.

· We deliver on our promises.

· We get it done.

Perks & benefits

· Competitive pay: $85,000–$100,000/year plus performance-based bonus opportunities.

· Comprehensive health coverage: Medical, dental, and vision with strong employer contributions, plus FSA, life insurance, and more.

· 401(k) with employer match: Competitive retirement plan with a generous company match.

· Generous PTO: Start with up to 18 days of PTO, with your balance growing over time.

· Work-life balance: Hybrid schedule with flexible scheduling.

· Casual & supportive environment: Relaxed dress code, a friendly team, and a culture of continuous learning.

· Team events: Team events and social activities throughout the year.

· Employee referral bonus: Earn rewards for helping us grow the team.

Ready to apply?

If you enjoy being the person your team trusts to get the numbers right, we’d love to hear from you. Apply with your resume and a few lines on a data-quality problem you tracked down and solved.

We are an equal opportunity and affirmative action employer, and we pride ourselves on hiring and developing the best people. All employment decisions (including recruitment, hiring, promotion, compensation, transfer, training, discipline, and termination) are based on the applicant’s or employee’s qualifications as they relate to the requirements of the position under consideration. These decisions are made without regard to age, gender, sexual orientation, gender identity or expression, genetic characteristics, race, color, creed, religion, ethnicity, national origin, alienage, citizenship, disability, marital status, military status, pregnancy, or any other legally recognized protected basis prohibited by applicable law.

Pay offered to a successful candidate will be based on various factors including the candidate’s level of education, qualifications, relevant work experience, work location, specific job duties, professional certifications, etc. If you require a reasonable accommodation to make your application or interview experience a great one, please contact