Thermo Fisher Scientific

Senior BI Developer

Thermo Fisher Scientific

full-time

Posted on:

Location Type: Remote

Location: India

Visit company website

Explore more

✨ AI Apply
Apply

Job Level

Senior

Tech Stack

Amazon RedshiftAWSERPETLPySparkSFDCSparkSQL

About the role

  • The Sr BI Developer is responsible for designing, developing, and delivering scalable business intelligence and analytics solutions that support data-driven decision-making across services and operational domains.
  • Engage with business stakeholders to elicit, analyze, and document detailed business and reporting requirements.
  • Facilitate workshops to define KPIs, standardized metric logic, and data definitions.
  • Develop functional specifications, source-to-target mappings, and technical design documentation.
  • Ensure traceability from requirements through development, testing, and deployment.
  • Design and develop enterprise dashboards and reports using Power BI (PBI) including advanced DAX, optimized data models, and performance tuning.
  • Build and maintain SSAS tabular models and semantic layers to support enterprise analytics.
  • Develop and optimize complex SQL queries within Amazon Redshift environments.
  • Perform dashboard performance optimization, query tuning, and model refinement.
  • Support UAT, deployment, and post-production stabilization activities.
  • Design and develop scalable data transformation workflows using the Databricks Lakehouse platform (Spark, PySpark, SQL, Delta Lake).
  • Build and maintain ETL/ELT pipelines within Databricks to support BI and advanced analytics workloads.
  • Implement and manage Delta Lake architecture, including partitioning strategies, performance optimization, and data version control.
  • Integrate Databricks pipelines with Amazon Redshift and AWS services (S3, Glue, IAM, Lambda).
  • Support ingestion of structured and semi-structured data from ERP, CRM, and service systems into curated analytical layers.
  • Perform pipeline monitoring, troubleshooting, and optimization to ensure reliability and scalability.
  • Contribute to advanced analytics initiatives including predictive metrics, anomaly detection, and automation use cases.
  • Support integration of AI/ML models and Generative AI (GenAI)-enabled reporting capabilities into BI solutions.
  • Explore opportunities for AI-assisted insights, natural language querying, and intelligent automation within dashboards.
  • Work closely with BI Leads, product owners, and data engineers to deliver prioritized solutions.

Requirements

  • Bachelor’s degree in Computer Science, Information Systems, Data Engineering, Business Analytics, or related field required.
  • 8+ years of experience combining Business Analysis, BI development, and data engineering.
  • Experience supporting service operations or commercial analytics domains preferred.
  • Strong requirement elicitation, documentation, and stakeholder engagement skills.
  • Experience preparing functional and technical design artifacts.
  • Exposure to ERP (SAP), CRM (SFDC), or service management systems.
  • Experience in service domain analytics.
  • Advanced expertise in Power BI (DAX, Power Query, enterprise modeling, performance optimization).
  • Strong hands-on experience with SSAS tabular modeling and cube development.
  • Proficiency in SQL with demonstrated experience in Amazon Redshift.
  • Strong hands-on experience with Databricks (Spark, PySpark, Delta Lake, Workflows).
  • Experience designing ETL/ELT pipelines within a Lakehouse architecture.
  • Working knowledge of the AWS ecosystem (S3, Redshift, Glue, IAM).
  • Strong understanding of data warehousing concepts, dimensional modeling, and pipeline optimization.
  • Exposure to AI/ML fundamentals and predictive analytics concepts.
  • Familiarity with Generative AI (GenAI), LLM-based analytics use cases, or AI-assisted reporting frameworks.
  • Experience working in Agile/Scrum delivery environments.
  • AWS, Databricks, Power BI, or AI/ML-related certifications.
Benefits
  • Health insurance
  • 401(k) matching
  • Flexible work hours
  • Paid time off
  • Remote work options
Applicant Tracking System Keywords

Tip: use these terms in your resume and cover letter to boost ATS matches.

Hard Skills & Tools
Power BIDAXSQLSSASDatabricksSparkPySparkDelta LakeETLELT
Soft Skills
requirement elicitationdocumentationstakeholder engagementbusiness analysiscommunicationcollaborationproblem-solvingperformance optimizationdata-driven decision-makingfacilitation
Certifications
AWS certificationDatabricks certificationPower BI certificationAI/ML certification