Job Title: Business Intelligence Engineer
Reports to: Supervisor
Career Band: 5
Group / Division: Global Business Services
**Position Summary**:
The BI Engineer role will be part of the Performance and Productivity team supporting the reporting needs of various terms throughout GBS Shared Services including OTC, RTR and PTP.
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 optimally & 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 deep dive investigations 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 responsible for the diagnosis and support of Power BI reporting solutions, including investigation of data issues, data validation, scalability, balancing and row level security implementation
- Create 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).
- 5-7+ years' experience in a BI developer role with a solid understanding of technical, business, and operational process requirements.
**Experience**:
- Sophisticated level of SQL, data modeling and ETL; ability to write and tune complex SQL scripts and ETL development
- Demonstrated ability 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**:
- Expertise in designing DAX queries in Power BI desktop
- Strong SQL skills, including writing complex 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) - Good to have
- Proven ability to successfully execute 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
- T_hermo 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._