Work Schedule
Standard (Mon-Fri)Environmental Conditions
OfficeJob Description
As part of the Thermo Fisher Scientific team, you'll discover meaningful work that makes a positive impact on a global scale. Join our colleagues in bringing our Mission to life every single day to enable our customers to make the world healthier, cleaner and safer. We provide our global teams with the resources needed to achieve individual career goals while helping to take science a step beyond by developing solutions for some of the world's toughest challenges, like protecting the environment, making sure our food is safe or helping find cures for cancer.
DESCRIPTION:
The SPOT Developer role is responsible for designing, developing, and maintaining enterprise semantic models and underlying ETL logic build by using SSAS (Tabular) and Power BI datasets. The role owns governed business metric definitions and ensures consistent semantic modeling across reporting solutions. In addition, the role provides operational support for the semantic and reporting layers, ensuring performance, reliability, and continuity of analytics services.
Key Responsibilities:
Strategic Leadership & Planning
Define and standardize governed business metrics and calculation logic within semantic models.
Align semantic modeling practices with enterprise data governance standards.
Support structured enhancement planning for semantic and reporting improvements.
Project Oversight & System Ownership
Design and develop semantic layers.
Develop complex SQL queries and pyspark data transformations supporting semantic models.
Build and maintain Power BI datasets aligned to governed semantic models.
Optimize DAX measures, calculated columns, and model relationships.
Ensure semantic models are sourced from approved Redshift, Databricks, and Athena datasets.
Maintain documentation of metric definitions, transformation logic, and semantic structures.
Operations & Compliance
Monitor production semantic models and Power BI dataset performance and consumption.
Troubleshoot and resolve SQL, Tabular Model, and dataset performance issues.
Perform root cause analysis for reporting discrepancies related to semantic logic.
Maintain runbooks and operational documentation for semantic and reporting layers.
Validate semantic outputs when upstream data platform changes occur.
Team Leadership
- Promote consistent metric definitions and modeling standards across BI teams.
- Share SQL and semantic optimization best practices.
Cross- functional Collaboration
Work closely with BA/BI developers to ensure accurate consumption and representation of business metrics.
Coordinate with architecture teams on performance improvements and data source alignment.
Communicate with business stakeholders regarding metric definitions and changes.
REQUIREMENTS:
Education & Experience
Bachelor's degree in Information Systems, Computer Science, or related field is required.
Minimum of 5 years of experience in SQL development and semantic modeling.
Hands- on experience developing SSAS/AAS Tabular models and Power BI datasets.
Experience supporting production analytics environments.
Skills & Knowledge
Advanced SQL development (query optimization, joins, aggregations, stored procedures).
SSAS Tabular modeling and development.
DAX development and optimization.
Power BI dataset architecture and performance tuning.
Understanding of Redshift, Databricks, and Athena as upstream data sources. Experience working with AWS- based data platforms such as Redshift and Databricks.
Production support and troubleshooting skills.
Strong documentation discipline and metric governance awareness.
Skills Required
- Bachelor's degree in Information Systems, Computer Science, or related field
- Minimum of 5 years of experience in SQL development and semantic modeling
- Hands-on experience developing SSAS/AAS Tabular models and Power BI datasets
- Experience supporting production analytics environments
Thermo Fisher Scientific Compensation & Benefits Highlights
The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Thermo Fisher Scientific and has not been reviewed or approved by Thermo Fisher Scientific.
-
Retirement Support — Retirement programs include a strong company 401(k) match and an employee stock purchase plan that add meaningful long‑term value. Feedback suggests these features stand out among core financial benefits even when base pay feels average.
-
Healthcare Strength — Health coverage offers multiple national medical options alongside dental and vision, with company‑paid life and disability coverage. This breadth is considered a solid foundation even if some costs may not be the lowest among peers.
-
Parental & Family Support — Paid parental and caregiver leave, backup care, adoption assistance, and specialized family resources are available. Feedback suggests these supports are a notable plus for colleagues managing family and caregiving needs.
Thermo Fisher Scientific Insights
What We Do
Thermo Fisher Scientific Inc. is the world leader in serving science, with annual revenue of approximately $40 billion. Our Mission is to enable our customers to make the world healthier, cleaner and safer. Whether our customers are accelerating life sciences research, solving complex analytical challenges, increasing productivity in their laboratories, improving patient health through diagnostics or the development and manufacture of life-changing therapies, we are here to support them. Our global team delivers an unrivaled combination of innovative technologies, purchasing convenience and pharmaceutical services through our industry-leading brands, including Thermo Scientific, Applied Biosystems, Invitrogen, Fisher Scientific, Unity Lab Services, Patheon and PPD.
Why Work With Us
You will join a company which every colleague has the opportunity to create possibilities, for oneself, for our customers and patients. There is no more exciting place to be than at the forefront of solving problems which help improve lives around the world. As a company, we are committed to supporting your career aspirations and your journey.
Gallery
.png){kind=logo}
