Data Engineer

Job Description

As part of the Thermo Fisher Scientific team, you'll discover meaningful work that makes a positive impact on a global scale. Join our colleagues in bringing our Mission to life every day to enable our customers to make the world healthier, cleaner, and safer. We provide our global teams with the resources needed to achieve individual career goals while helping to take science a step beyond by developing solutions for some of the world's toughest challenges, like protecting the environment, ensuring our food is safe, or helping find cures for cancer.

Discover Impactful Work:

We seek an experienced data engineer/analyst to support end-to-end data analytics projects for the BID Digital Marketing Analytics Team. This engineer/analyst knows the entire data analytics life cycle very well, from the business and data understanding to the deployment, communication, and documentation of the reports. Still, deep analysis and curation of the full story are exciting and allow 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 daily work. However, you are also strategic-minded and offer suggestions and well-thought plans to enhance reporting and self-serve capabilities for the analytics team in the long term.

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

You will spend most of your time discovering ways to integrate new data sources and striving to assist the team in efficiently accessing 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. Still, your unique viewpoints, experience, and teammates will keep you grounded and help you navigate. You will be responsible for 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 programming languages) is 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.

A Day in the Life:

• Leverage data integrations using AWS Athena, Redshift, Cognos, SharePoint, and Power BI Services, among other technologies
• Propose development optimizations and implement to deliver solutions and enhanced reporting capabilities
• Provide timely and consistent updates and recommendations on dataflow and data pipeline operational issues and enhancements to team and partners
• Become a domain expert on data sources used by the Analytics team (SalesForce, Adobe Analytics, Redshift, internal databases, etc.), along with reports created
• Consult data source owners to understand and document data collection and reporting processes
• Growing understanding of business context/impact of data used
• Champion data quality and integrity through proactive sleuthing and oversight
• Establish 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 visualizations
• Collaborate and cultivate relationships with business partners to continue strengthening our team's profile
• Research, documentation, and communication of standard methodologies, updates, developments, etc.
• Influence and maintain a strong and healthy team culture through active involvement, inclusion, and leadership
• Brainstorm 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

Education and Experience

• Bachelor's degree (or above) in a pure science or engineering
• 3+ years experience in a data analytics or engineering role with a solid understanding of technical, business, and operational process
• 3+ years experience with Power BI Desktop and Service (or similar business intelligence and data visualization tool)
• Intermediate DAX, M, Python, and SQL
• Exposure to data engineering and analytics with Python

• Experience as a digital marketing analyst with Adobe Analytics (preferred, but similar accepted)
• Ability to support and train teammates on data integration and visualization creation
• Statistics and data science familiarity (or interest)
• Big data experience and the ability to analyze trends associated with
• Experience gathering business requirements and creating solutions to enable business insights
• Good interpersonal communication skills (written/verbal)
• Ease working on a fast-paced team with the ability to leverage resources to fill in knowledge or requirement gaps
• Experience working in a large corporation within a matrix organizational structure
• Advanced MS Excel
• Experience with GitHub
• Experience with agile scrum

Knowledge, Skills, Abilities

• Familiar with digital marketing data analytics and standard business analytics processes in general
• Experience taking requirements for new projects and understanding the needs of the business to generate insights and solve problems
• Experience in the design and implementation of 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 Query
• Experience in semantic data models and schemas like flat, star, and snowflake schemas
• Experience 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-serve data analytics and visualization tools
• Familiar with data engineering, analytics, and visualization best practices
• Effective documentation of projects/processes and ability to explain them to others
• Strong graphics and visualization aesthetics to convey messages and impactfully
• Excellent prioritization and problem-solving skills
• Self-motivated to seek out guidance when requirements are vague
• Familiar with technical topics like Business Intelligence development, user experience design, and data architecture for self-serv data analytics and automatic reporting

Benefits:

We offer competitive remuneration, annual incentive plan bonus, healthcare, and a range of employee benefits. Thermo Fisher Scientific offers employment with an innovative, forward-thinking organization, and outstanding career and development prospects. We offer an exciting company culture that stands for integrity, intensity, involvement, and innovation

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. We will gladly provide reasonable accommodations covered under the ADA.