Job Location: United States
ASP is looking for a Data Engineer who will be responsible for the design, development and deployment of the enterprise data platform that will be the foundation for data driven transformation of various business functions. This is an exciting opportunity for a hands-on specialist who has strong analytical skills, can create data models, ETL/data pipelines and the ability to combine data from different sources.
Duties and Responsibilities
Develop the Data Warehousing Platform, consisting of an Operational Data Store (ODS), a Data Warehouse, and many subject-oriented Data Marts.
Create data models in the form of Entity Relationship Diagrams (ERDs) to design tables, indexes, and table relationships including modeling, developing, technical documentation, data diagrams and data dictionaries
Deploy data models to maintain development, test, and production environments
Develop data integration solutions to process data into, out of, and within the Data Warehousing Platform. Including ETL/building data pipelines and incorporating raw data from multiple sources
Create and tune SQL statements
Track data quality, availability, security against Service Level Agreements (SLAs)
Collaborate with the Analytical team to prototype and prove the viability of data solutions
Provide expertise in the development of standards, architectural governance, design patterns, and practices, evaluate best applicable solutions for different use cases
Participate in the creation, modification, and execution of operational and strategic plans
Define problem areas and evaluate, recommend, and implement alternative solutions to complex issues and problems
Prepare data for prescriptive and predictive modeling
Explore ways to enhance data quality and reliability
Update storage structures to meet the evolving needs of the company
Years of Related Experience:
5+ years’ experience in data engineering and development
Medical Device industry experience is a plus
Knowledge, Skills, Abilities, Certifications/Licenses, and Affiliations:
A Bachelor’s degree in Information Technology, Computer Science, or related field is required
Strong experience with ETL and database processes and technologies
Strong SQL experience with an understanding of database structures
Experience with database languages and technologies (Oracle, MS SQL, MySQL), SQL Server Integration Services, package design, and data analysis
Strong coding skills (sql/python/java)
Experience with Relational or Multidimensional Data Base Management Systems (e.g., Microsoft SQL Server and DB2) in one or more computing environments (e.g., Windows, Unix, Oracle)
Data administration and management functions (collection, cleaning, analysis, distribution, etc.)
Thorough understanding of the relational database model and solid theoretical knowledge of relational database techniques
Advanced knowledge of modern database and information system technologies
Fortive is a global family of more than 20 industry-leading industrial growth and technology companies, united by a shared purpose: to make the world stronger, safer, and more effective by providing essential technology for the people who accelerate progress. Here, you get the excitement of a “startup” with the stability and predictability of an organization strongly grounded in its roots and with a proven track record of growth. There’s no limit to what you can learn, or the impact you can make: for you, for us, for growth. Come join our team at Advanced Sterilization Products (ASP) and be part of a global leader in infection prevention solutions for the healthcare industry. With advanced products, technologies, and workflows for medical sterilization and disinfection, ASP is dedicated to defending the lives of patients, families, healthcare workers, providers, and communities. Add your talent to our extraordinary team and help us in our mission to make healthcare safer for everyone. ASP is based in Irvine, California with core sites in Everett, Washington and Schaffhausen, Switzerland plus many more offices around the world.
We Are an Equal Opportunity Employer
Fortive Corporation and all Fortive Companies are proud to be equal opportunity employers. We value and encourage diversity and solicit applications from all qualified applicants without regard to race, color, national origin, religion, sex, age, marital status, disability, veteran status, sexual orientation, gender identity or expression, or other characteristics protected by law. Fortive and all Fortive Companies are also committed to providing reasonable accommodations for applicants with disabilities. Individuals who need a reasonable accommodation because of a disability for any part of the employment process should ask to speak with a Human Resources representative to request an accommodation.