Job Description

When you’re part of a team at Thermo Fisher Scientific, you provide important work with real-world impact; and be enthusiastically supported in achieving career goals. Employees are valued and recognized for their performance, all while collaborating with engaged and dynamic teammates. This role supports our Biosciences division, which represents over $4B in sales annually.

We are looking for an experienced data engineer/analyst to support end-to-end data analytics projects for the BID Digital Marketing Analytics Team. This engineer/analyst knows very well the entire data analytics life cycle from the business and data understanding to the deployment, communication, and documentation of the reports, but it is the deep analysis and the curation of the full story what finds exciting and allows you to turn a complex analysis into a digestible and actionable story.

You enjoy diving into the data, questioning results, addressing issues, enhancing, curating and being creative with data in your day by day, but you also are strategic minded and offer suggestions and well-thought plans to enhance reporting and self-serve capabilities for the analytics team on the long term.

Astute at simplifying the sophisticated is a vital skill in this role and you should have outstanding communication skills and be able to effectively communicate sophisticated processes and issues to other data engineers, analysts, and business partners.

You will be spending the most of your time discovering ways to integrate new data sources and striving to assist the team in efficient access to cleansed and consistent data. You will be dealing with all kinds of data sources including commercial, operational, financial, and digital marketing data from a variety of systems and tools, including but not limited to Adobe Analytics, AWS Redshift, AWS Athena, MS SQL Server, IBM Cognos, Google BigQuery, PBI Service, MS Azure, Databricks, Etc., and your data sets will be diverse, (structured, semi-structured, unstructured), and at times complex, but your unique viewpoints, experience, and teammates will keep you grounded and help you navigate. You will be responsible of the QA check of the data/reports ensuring alignment comparisons and data audits when necessary.

Curiosity, critical-thinking, and persistence are key. Self-assessment, a continual growth mindset, striving for efficient, quality work and willingness to continually improve your knowledge of new technologies (data tools and programing languages) are required, as the analytics field constantly changes.

You also enjoy sharing your knowledge via brainstorming, mentoring, guidance, and documentation of standard processes from the analytics perspectives.

Your duties include but are not limited to:

Leverage data integrations using AWS Athena, Redshift, Cognos, SharePoint and Power BI Services among other technologiesPropose development optimizations and implement to deliver solutions and enhanced reporting capabilitiesProvide timely and consistent updates and recommendations on dataflow and data pipeline operational issues and enhancements to team and partnersBecome a domain expert of data sources used by the Analytics team (Sales Force, Adobe Analytics, Redshift, internal databases, etc.) along with reports createdConsult data source owners to understand and document data collection and reporting processesGrowing understanding of business context/impact of data usedChampion data quality and integrity through proactive sleuthing and oversightEstablish alerts for data connection issues both technical and beyond expected thresholds (anomalies)Technical guidance and questioning of requests to prioritize and optimize the most useful data visualizationsCollaborate and cultivate relationships with business partners to continue strengthening our team’s profileResearch, documentation, and communication of standard methodologies, updates, developments, etc.Influence and maintain strong and healthy team culture through active involvement, inclusion, and leadershipBrainstorm strategic and forward-thinking initiatives (e.g. roadmap, team process/structure, philosophy)Proactive self-education and contribution to advance our analytics practices, methods, and strategy

Requirements:Familiar with digital marketing data analytics and standard business analytics processes in generalExperience taking requirements for new projects and understanding the needs of the business to generate insights and solve problemsExperience in the design and implementation of the different data processes like profiling, exploration, collection, processing, cleaning, and preparation of data, ETL, ELT, ETLT data processes and data pipelines with Python, SQL, Non-SQ, MS Power BI Services and Power QueryExperience in semantic data models and schemas like flat, star and snowflake schemasExperience in creating business intelligence reports/dashboards from scratch. That is business requirements gathering, understanding of the needs, exploration of the data sources, collection of the data, design, development, and deployment of the back-end data processes and the front-end of the self-serv data analytics and visualization toolsFamiliar with data engineering, analytics, and visualization best practicesEffective documentation of projects/processes and ability to explain them to othersStrong graphics and visualization aesthetics to convey messages simply and impactfullyExcellent prioritization and problem-solving skillsSelf-motivated to seek out guidance when requirements are vagueFamiliar with technical topics like Business Intelligence development, user experience design, and data architecture for self-serv data analytics and automatic reportingMinimum Qualifications:Bachelor’s degree (or above) in a pure science or engineering3+ years experience in a data analytics or engineering role with a solid understanding of technical, business, and operational process3+ years experience with Power BI Destop and Service (or similar business intelligence and data visualization tool)Intermediate DAX, M, Python and SQLExposure to data engineering and analytics with PythonPreferred Qualifications:Experience as digital marketing analyst with Adobe Analytics (preferred, but similar accepted)Ability to support and train teammates on data integration and visualization creationStatistics and data science familiarity (or interest)Big data experience and the ability to analyze trends associated withExperience gathering business requirements and creating solutions to enable business insightsGood interpersonal communication skills (written/verbal)Ease working on a fast-paced team with the ability to leverage resources to fill in knowledge or requirement gapsExperience working in a large corporation within a matrix organizational structureAdvanced MS ExcelExperience with GitHubExperience with agile scrum

This position has not been approved for Relocation Assistance as it is remote.