BI Specialist

About This Role:
As a BISpecialist you will play a pivotal role in building and supporting the USCommercial data enablement self-service analytics and reportingcapability as part of the US Data Strategy for the US Commercial Organization. You will be a crucial member of the US Data teamhelping turn complex commercialdata assetsinto reliable reusable andanalytics-readydataproducts that support decision-makingacrosstheAlzheimers disease therapeutic areaand broaderUS organization.

Your primary focus will be to build and maintain trusted tables views joins business metrics and data quality checks in Snowflake while enabling downstream analytics Power BI reporting and AI-assisted analysis.

In this position you will partner closely with internal analytics stakeholders IT Finance CE&O Marketing Field Excellence and other cross-functional teams to translate business questions into scalable data solutions.

You will also help validate SQL queries and analytical logic including queries accelerated through tools such as Claude or Copilot ensuring that outputs are accurate explainable and aligned to business definitions.

This role is key to strengthening the data foundation that enables self-service analytics performance reporting and commercial insights across the organization.

What Youll Do:

• Collaborate with internal teams to understand business needs analytical use cases and data requirements across US Commercial functions.

• Translate complex business questions into analytics-ready datasets reusable tables views and reporting frameworks.

• Build and maintain logical datasets in Snowflake including joins across commercial data sources such as claims sales marketing field activity customer engagement and other relevant datasets.

• Create document and maintain business-defined metrics KPI logic filters and calculations to ensure consistent use across analytics and reporting products.

• Develop and validate SQL queries data transformations and analytical logic to support recurring reporting ad hoc analysis and self-service analytics.

• Review and validate queries generated or accelerated through AI tools such as Claude or Copilot ensuringjoins filters assumptions and outputs are accurate and explainable.

• Design and implement data quality checks reconciliation routines and QA processes to ensure accuracy completeness and integrity of commercial data assets.

• Partner with IT and data engineering teams on data integration data modeling and scalable data architecture efforts across multiple systems.

• Enable self-service analytics by creating trusted well-documented datasets and semantic layers that analysts and business users can confidently use.

• Develop and optimize Power BI reports and dashboards as a downstream consumption layer for trusted data products and business metrics.

• Design and maintain methodology data lineage metric definitions and project documentation.

• Conduct unit testing troubleshooting and root-cause analysis for data reporting and query-related issues.

• Conduct training or knowledge-sharing sessions to help analytics and business users understand available datasets metrics and self-service tools.

• Perform additional duties as assigned.

Who You Are:
You are ahands-on dataandanalytics engineeringprofessionalwho enjoys working directlywith complexdatasets building reliable data assets and enabling others to use data with confidence. You are comfortable moving beyond dashboards to understand how data is sourced joined transformed validated and translatedintobusiness metrics. You bring strong SQL skills attention to detail and a practical understanding of how commercial analytics teams use data to answer business questions.You communicate effectively with both technical and non-technical stakeholderstranslating business needs into scalable data solutions and explaining data logic clearly. You are curious self-driven and quality-oriented with a strong commitment to improving data accessibility consistency and trust across the organization.

Required Skills:

• Minimum of aBachelorsdegree in a business science technology engineering analytics or data-related field.

• 3 years of experience in business intelligence analytics engineering data enablement data management or related data roles.

• Strong proficiency writing debugging optimizing and validating SQL queries preferably in Snowflake.

• Experience building analytics-ready tables views joins data modelsDataMarts or semantic layers that support reporting and analysis.

• Experience creating and maintaining business metrics KPI definitions data quality checks and documentation.

• Understanding of ETL/ELT processes data transformation logic and modern cloud data platforms such as Snowflake.