Business Intelligence Engineer

Key Skills

Alteryx, Amazon Athena, Amazon RedShift, Business Intelligence, Data Analysis Expressions- DAX, Data Lake, Data Modeling, Data Visualization, Databricks, Effective communication skills, ETL/ELT technologies, Looker, Oracle, PowerBI, Python Programming, R Programming, Spark Core, SQL, SQL Server, Tableau

Job Description

As the world leader in serving science, we solve the world’s toughest problems, like giving cancer patients hope, ensuring water and food are safe, helping law enforcement solve cases through forensics and most recently, serving as the largest provider of COVID-19 solutions. Our Data Science, Digital and IT careers are a unique opportunity to apply your specialized skills and advanced experience in analytics, statistics, data science, programming, information technology and more to drive our Mission of enabling our customers to make the world healthier, cleaner and safer. It’s truly a career where your work makes a positive impact in our world. When you join Thermo Fisher Scientific, you’ll make an impact inside and outside the company on work that matters.

• 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

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.