Business Intelligence Analyst

Work Schedule

Standard (Mon-Fri)

Environmental Conditions

Office

Job Description

Position Summary:

The BI Engineer role will collaborate with the Digital Enablement team supporting the reporting needs of various terms throughout GBS Shared Services including OTC, RTR, PTP and Customer Care.

This is a global role working across our Shared Services Centers in Costa Rica, Hungary and Scotland.

This role will work along with collaborators and colleagues to deliver tools, metrics and dashboards.

The objective would be to help prepare Thermo Fisher Scientific to successfully & efficiently scale up to the company’s 2030 vision of becoming a $50B revenue organization.

Key Responsibilities:

Partner with internal customers across multiple teams, collecting requirements and delivering end to end solutions

Work with global Shared Services team to identify new BI capabilities and projects

Conduct detailed explorations into operations execution and business problems, find opportunities, and lead or support implementation

Working independently, or with functional analysts, to build reports, data sets and mechanisms to provide access to business data

Be accountable for the diagnosis and support of Power BI reporting solutions, including investigation of data issues, data validation, scalability, balancing and row level security implementation

Build and deliver standards on defining, crafting, and documenting reference PBI architecture

Identify and provide input to new technology opportunities, including regular Microsoft PBI releases, that will have a positive impact on improving the BI visualization portfolio

Develop queries and visualizations for ad-hoc requests and projects, as well as ongoing reporting

Education:

Bachelor’s degree in computer science, Management Information Systems, or related field (master’s preferred).

3-5+ years’ experience in a BI developer role with a demonstrable understanding of technical, business, and operational process requirements.

Experience:

Proficiency in writing and optimizing composite SQL scripts and possess a solid background in ETL development.

Proven track record with data visualization tools like Tableau, Looker, Quicksight or similar (familiarity with PowerBI preferred)

3+ years of experience with data modeling in large Data warehousing, data lake environment. Familiarity with MSSQL, Oracle Redshift, Athena or similar data lakes preferred

2+ years of experience on Python/R or similar coding languages

ETL experience with tools like Alteryx (preferred), Informatica, SSIS very important

Knowledge, Skills, Abilities:

• B2 English Level.
• Expertise in crafting DAX queries in Power BI desktop
• Strong SQL skills, including writing sophisticated queries to extract and analyze large volumes of data
• Experience in Data Lake using AWS Databricks, Apache Spark & Python - Good to have
• Experience with Power Platform (Power Apps, Power Automate) - Nice to have
• Demonstrable ability to successfully conduct implementation of multiple projects at a time and manage priorities
• Ability to succeed in a fast paced, matrix structured environment
• Superb communication skills, both written and verbal

Thermo Fisher Scientific is an EEO/Affirmative Action Employer and does not discriminate on the basis of race, color, religion, sex, sexual orientation, gender identity, national origin, protected veteran status, disability or any other legally protected status.