In short
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…
SQLPYTHONPOWER BIAZURE
📋 About the job
📍
LocationMelville, NY (Long Island)
🗂️
Job typeFull-time
Business Intelligence Analyst (5+ Years Experience) – Hybrid, Melville, NY
Work Schedule: Hybrid – 2–3 days in our Melville office, remaining days remote. This role is not fully remote; candidates must be in NY and must live within a reasonable commute of Melville, NY.
Compensation: $90,000–$120,000/year (depending on experience), plus performance-based bonus opportunities
🏢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 leverage and trust. As our Business Intelligence Analyst, you will be the person who delivers this data and makes sure it is right. You’ll own data quality and reporting accuracy across our Power BI dashboards and Azure data environment, troubleshoot discrepancies, and partner directly with teams across the business to turn their questions into clear, reliable answers.
What you’ll do
🔹Support stakeholder requests for recurring reports, extracts, segmentation, and ad hoc analysis.
🔹Maintain and enhance Power BI reports and semantic models.
🔹Develop and maintain data pipelines and ETL processes
🔹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.
🔹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.