Business Intelligence Analyst
Sheer Science
Salary: $90,000 - 120,000 per year
Requirements:- At least 5 years of professional experience in business intelligence, data analysis, or a similar role; the posting also specifies 5 years of data analytics experience.
- Bachelors degree in a related field, or equivalent experience; a bachelors degree is preferred.
- Strong SQL fundamentals, with 5 years of SQL experience specified.
- Strong Power BI skills, including reports and semantic models; 5 years of Power BI experience is specified.
- 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, HTTP requests, authentication, and JSON responses.
- Clear written and verbal communication skills, including the ability to explain data findings to non-technical teammates.
- E-commerce or direct-to-consumer experience is preferred, particularly with customer, order, marketing, web, subscription, or product data; 1 year of e-commerce experience is listed as preferred.
- Must live in the New York metro area within commuting distance of Melville, NY, and be able to work in the office 2–3 days per week.
- Must be legally authorized to work in the United States for any employer, now and in the future, without visa sponsorship; we cannot sponsor work visas for this position.
- We rely on this role to support stakeholder requests for recurring reports, data extracts, segmentation, and ad hoc analysis.
- Maintain and enhance our Power BI reports and semantic models.
- Develop and maintain our data pipelines and ETL processes.
- Conduct 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.
- Use SQL for reconciliation, joins, aggregations, duplicate detection, and missing-record investigations.
- Perform initial troubleshooting of failed Azure/Synapse pipelines and escalate issues to engineering when needed.
- Document business logic, table definitions, pipeline dependencies, and reporting rules, and maintain data dictionaries and lightweight lineage documentation.
- Support quality assurance for new datasets, dashboards, and pipeline changes before they enter production.
- Azure
- Business Intelligence
- Cloud
- ETL
- HTTP
- Support
- JSON
- Jupyter
- Marketing
- Power BI
- Python
- SQL
- Web
More:
We are Sheer Science, a company focused on bringing effective, clinically supported products to market and improving customers lives. We value honesty, transparency, excellence, curiosity, collaboration, and a workplace where every employees voice is heard. This full-time Business Intelligence Analyst role is based in Melville, Long Island, NY, with a hybrid schedule of 2–3 days in our office and the remaining days remote; it is not fully remote, and the role requires a reasonable commute to Melville. Compensation is $90,000–$120,000 per year, depending on experience, with performance-based bonus opportunities. We offer medical, dental, vision, life insurance, an FSA, a 401(k) with employer match, up to 18 days of starting PTO that grows over time, flexible scheduling, a casual and supportive environment, team events, and employee referral bonuses. We are an equal opportunity and affirmative action employer, and employment decisions are based on qualifications related to the position.
last updated 46 week of 2026
Reference: WJ-31_28296172 · Posted 15 Nov 2026, 06:08 PM