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 Power BI 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 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
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.