Job Description

• IT AWS Data Lake project \xe2\x80\x93 supporting strategic AWS Data Lake project within Manufacturing and Quality

• Build different types of data lake layers based on specific use cases.
• Lead the design, implementation, and successful delivery of large-scale, critical, or difficult data solutions involving a significant amount of work.
• Build scalable data infrastructure and understand distributed systems concepts from a data storage and compute perspective.
• Utilize expertise in Python, SQL and have a strong understanding of ETL and data modeling.
• Ensure the accuracy and availability of data to customers and understand how technical decisions can impact their business\xe2\x80\x99s analytics and reporting.
• Be proficient in at least one scripting/programming language to handle large volume data processing.
• Interfaces and Integrations \xe2\x80\x93 modernize interfaces to data lake as part transformation projects, e.g. QMS, structured intake, EU MDR, pharmacovigilance, MES.
• Project Collaboration - work with business and IT stakeholders to identify and implement opportunities for leveraging company data to drive business transformation.

• Participate in design reviews and provide input to design recommendations; incorporate security requirements into design; and provide input to information/data flow, and understand and comply with Agile Project Life Cycle Methodology in all planning/execution steps.
• Document detailed application specifications (User Requirement Specifications, Functional Specifications and System Design Specifications), translate technical requirements into programmed application modules and develop/enhance software application modules.
• Data Pipeline \xe2\x80\x93 Over time this role will be also responsible to collect large volumes of on-premises data from our global medical device manufacturing plants and move to data warehouse for advanced data analytics to transform our manufacturing sites to a smart factory.

• Involved from inception of projects, understand requirements, architect, develop, deploy, and maintain data pipelines.
• Support and troubleshoot the data pipeline and environment.

Minimum Requirements:

• A Graduate degree in Computer Science, Statistics, Informatics, Information Systems or another quantitative field
• A minimum of 5+ years of professional experience in Data Engineer role
• Knowledge in Pharma industry, medical device, and GxP validation preferred
• Experience with AWS cloud services: S3, RDS, Redshift, DynamoDB
• Experience with AWS Glue, Step Functions, Lambda, MuleSoft preferred
• Experience with object-oriented/object function languages: Python, Java, C++, SQL
• Experience with Knime or Alteryx a plus
• Experience with Oracle database preferred; experience with SQL server a plus
• Excellent analytical skills and abilities
• Ability to manage in an ever changing environment; change agent
• Excellent teamwork and facilitation skills
• Ability to multi-task; ability to think outside the box and develop intuitive and creative solutions
• Excellent communications skills, both oral and written; proven ability in technical writing
• Working knowledge of Logical and Physical Data Modeling concepts
• Demonstrated experience in all phases of the Software Development Life Cycle (SDLC)
• Demonstrated experience working with a project team to develop a design, technical solution, and ultimately to implement high quality technical solutions
• Demonstrated ability prioritizing and managing development and implementation of enhancements/changes to multiple applications
• Proven ability overseeing Deployment and Release Management including the final production acceptance review and signoff
• Experience in handling large volume of data preferred
• Hands on experience on data mart design & development
• Knowledge of version and revision control practices and procedures
• Familiarity with big data collection technology such as edge gateways, data brokers, historians

Alcon is an Equal Opportunity Employer and takes pride in maintaining a diverse environment. We do not discriminate in recruitment, hiring, training, promotion or other employment practices for reasons of race, color, religion, gender, national origin, age, sexual orientation, gender identity, marital status, disability, or any other reason.

Alcon