Danaher Corporation Data Engineer in Evanston, Illinois
Leica Biosystems’ mission of “Advancing Cancer Diagnostics, Improving Lives” is at the heart of our corporate culture. We’re a global leader in cancer diagnostics with the most comprehensive portfolio from biopsy to diagnosis. Our easy-to-use and consistently reliable offerings help improve workflow efficiency and diagnostic confidence.
Our associates know that every moment matters when it comes to cancer diagnostics. When you come to work, you’re helping develop solutions that enable accurate diagnoses to turn anxiety into answers. Join our diverse, global team of talented people, and be inspired to grow every day.
Leica Biosystems is proud to work alongside a community of six fellow Diagnostics Companies at Danaher. Together, we’re working at the pace of change to improve patient lives with diagnostic tools that address the world’s biggest health challenges.
The Data Engineer role will be focused specifically on Data Warehousing, Data Management, BI, and Data Analytics projects within the Global Marketing team. The Data Engineer will take the lead in creating Data Pipelines and Infrastructure, proposing and implementing scalable data reporting as well as evaluating, producing, and refining dashboards and reports. As a Data Engineer, you’ll identify gaps in our data sources and develop solutions to bridge them in order to provide stronger customer visibility for enhanced marketing and sales targeting efforts. You’re not afraid of leveraging technology to solve data problems. You’ll make data converts out of non-believers, digging into complex data and turning them into actionable insights for marketers, sales professionals, and executives.
Drive our Marketing Data Platform program to enable strong customer profiling and visibility (such as install base, volume etc.) to improve our targeting efforts.
As an expert in dimensional modeling and schema design, you’re able to expertly write SQL in various flavors to build harmonized data models that our business users can plug into.
With a meticulous eye for detail, you’re not just on the lookout for data problems and defects, but also thinking of processes and approaches to test and optimize data quality.
You’ve got strong business and data requirements analysis skills, allowing you to evaluate problems, interact with stakeholders, design solutions, weigh the pros & cons, and then execute.
You will be integrating data from different sources with your experience in data integration and ETL.
You will be managing and designing the reporting environment, including data sources, security, and metadata.
You’ll also support the data warehouse in identifying and revising reporting requirements and providing technical expertise in data storage structures, data mining, and data cleansing.
You’ll own critical data pipelines and constantly improve pipeline efficiency and data quality
Conduct research into new data warehouse applications and determine viability for adoption
Create dashboards and reports to regularly communicate business results
Skilled in SQL and RDBMS (3+ years) including complex joins, unions, intersects, subqueries, string manipulation, and window functions.
Strong background in stored procedures/functions with an advanced database system – preferably Postgres.
Expert in Python programming especially in database manipulation, ETL & large data sets
Expertise in data warehouse & data mart design – building star/snowflake schemas, constructing multi-dimensional/OLAP cubes, performing MDX queries, and running analytical functions (i.e. rollups, drill downs, slicing/dicing, etc.)
Solid project management skills and comfortable working in both Scrum and Kanban approaches.
Power BI development expertise. Having at least 1-2 years of experience in DAX/Power Pivot and Power Query/M would be a big benefit. An interest in data visualization is even better.
Data modeling skills using Python, R, or another similar approach would be a nice addition, as would experience in JSON or other unstructured/semi-structured data.
Git and version control expertise.
Previous experience as a data engineer or in a similar role would be a plus
Strong marketing and sales data management (e.g. Pardot Marketing automation or Salesforce CRM) or Master Data Management skills would be a plus.
Experience working with cloud data platforms such as Azure or Google BigQuery,etc is a plus
Data engineering certification (e.g IBM Certified Data Engineer) is a plus
3+ years of overall technology experience, that includes at least 2+ years of hands-on data engineering, and data architecture
Utilizes critical thinking – ability to analyze and solve complex problems, managing information gaps by relentlessly seeking out Gemba data through stakeholder engagement, able to be flexible in thinking and responding positively to change
Moves strategy to action – through the contribution of action plan creation and alignment, ensuring key milestones are achieved on time, able to prioritize effectively, ability to modify and improve action plans
Listens and responds to customer needs –the ability to understand customer needs and data in marketing actions
Balances risk to advance innovation - able to influence and achieve alignment on broader goals and process
Delivers results, works with a sense of urgency, and can flex to achieve results, self-motivated to create plans, takes accountability
Champions continuous improvement: Observes and seeks information from stakeholders to improve and streamline processes. Can manage multiple priorities and deliver a consistently strong contribution.
Creates followership through collaboration – exhibited through example setting for new team members and new the wider internal community, in terms of following standard work and the collaborative mindset.
Consistently uses sound judgment – in a humble and self-aware way to stand behind the key principles of a customer’s goals and objectives firmly but fairly
Operates with transparency and is trusted. Ability to build trust with the team
- Bachelor’s degree. Preferably in Information Technology, Computer Science, Data Analytics, or related field; a Master’s Degree is a plus
Expertise in data warehouse & data mart design –building star/snowflake schemas, constructing multi-dimensional/OLAP cubes, performing MDX queries, and running analytical functions (i.e. rollups, drilldowns, slicing/dicing, etc.)
Experience in data integration and ETL. Ability to use scripting languages (e.g. Python) and middleware (e.g. Informatica) to integrate data from different sources and get it ready for use by downstream processes.
A strong sense of data architecture decision process thinking in order to provide the best possible foundation for our analysts.
Database DevOps experience building CI/CD pipelines ( with tools such as Liquibase or DBmaestro).
Experience working with Agile tools such as JIRA, Confluence
Experience with Cloud data platforms such as Azure or Google BigQuery, etc.
When you join us, you’ll also be joining Danaher’s global organization, where 80,000 people wake up every day determined to help our customers win. As an associate, you’ll try new things, work hard, and advance your skills with guidance from dedicated leaders, all with the support of powerful Danaher Business System (https://www.danaher.com/how-we-work/danaher-business-system) tools and the stability of a tested organization.
Danaher Corporation and all Danaher Companies are committed to equal opportunity regardless of race, color, national origin, religion, sex, age, marital status, disability, veteran status, sexual orientation, gender identity, or other characteristics protected by law. We value diversity and the existence of similarities and differences, both visible and not, found in our workforce, workplace and throughout the markets we serve. Our associates, customers and shareholders contribute unique and different perspectives as a result of these diverse attributes.The EEO posters are available here (https://www.dol.gov/agencies/ofccp/posters) .We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform crucial job functions, and to receive other benefits and privileges of employment. Please contact us at firstname.lastname@example.org to request accommodation. If you’ve ever wondered what’s within you, there’s no better time to find out.
- Danaher Corporation Jobs