Associate, Software Engineer SCDT

Alcon MX; Fort Worth (TX); Hybrid; USD 85,000 - 110,000; Full time

Job summary

Alcon in Fort Worth, TX is seeking an Associate, Software Engineering (Science/Tech/Engineering Path) to design and maintain data solutions powering supply chain analytics. You will build ETL workflows, pipelines and dashboards, and apply ML techniques to forecast trends and optimize operations.

The role requires a High School Diploma, 3 years of relevant experience, and onsite work hours on first shift. Sponsorship and relocation are not available.

Qualifications

• High School Diploma or equivalent required.
• Fluent reading, writing and speaking English.
• 3 years of relevant experience in analytics or data engineering.
• Location: Onsite in Fort Worth, TX; 1st Shift, Mon-Fri 8:00 AM–5:00 PM CST.
• Relocation/Sponsorship: Not Available.

Responsibilities

• Design, develop and maintain ETL workflows using Alteryx, Looker, Glue and other data integration platforms to support supply chain analytics initiatives
• Extract, transform and load data from multiple sources to create robust data pipelines that enable business intelligence and decision-making
• Write and optimize complex SQL queries to extract, manipulate and analyze large datasets from data lakes, enterprise databases and data warehouses
• Develop Python scripts using pandas, NumPy and other standard libraries for data cleaning, transformation, and automated reporting processes
• Build interactive dashboards and visualizations using Tableau, Power BI or similar business intelligence tools to communicate insights to stakeholders across the supply chain organization
• Apply statistical analysis and machine learning techniques to identify patterns, forecast trends and optimize supply chain operations including demand planning, inventory optimization, and logistics efficiency
• Collaborate with supply chain business partners to translate analytical requirements into technical solutions that drive operational improvements
• Develop predictive models and algorithms to support supply chain forecasting, risk analysis and scenario planning
• Conduct A/B testing and experimental design to validate hypotheses and measure the impact of supply chain process improvements
• Implement model evaluation techniques including cross validation, hyperparameter tuning and performance metrics to ensure model accuracy and reliability
• Participate in code reviews and documentation to ensure data quality
• Support the testing and validation of data models, ensuring accuracy and reliability of analytical outputs
• All associates must adhere to SOPs, maintain documentation and ensure quality control.

Skills

ETL tools

SQL

Python

Tableau/Power BI

English fluency

Education

High School Diploma or equivalent

Tools

Alteryx

Looker

AWS Glue

Job description

At Alcon, we're passionate about enhancing sight and helping people see brilliantly. With more than 25,000 associates, we innovate fearlessly, champion progress, and act swiftly to impact global eye health. We foster an inclusive culture, recognizing your contributions and offering opportunities to grow your career like never before. Together, we make a difference in the lives of our patients and customers. Are you ready to join us? This role is part of Alcon's Supply Chain Analytics function, a team that delivers cutting-edge technology solutions to Alcon associates and customers to help our people and the world see brilliantly. The Associate, Software Engineering (Science/Tech/Engineering Path) will play a key role in designing and maintaining data solutions that power supply chain analytics. This role involves building and optimizing ETL workflows, developing robust data pipelines, and creating interactive dashboards to support business intelligence and decision-making at our Main Office in Fort Worth, TX.

• Design, develop and maintain ETL workflows using tools such as Alteryx, Looker, Glue and other data integration platforms to support supply chain analytics initiatives
• Extract, transform and load data from multiple sources to create robust data pipelines that enable business intelligence and decision-making
• Write and optimize complex SQL queries to extract, manipulate and analyze large datasets from data lakes, enterprise databases and data warehouses
• Develop Python scripts using pandas, NumPy and other standard libraries for data cleaning, transformation, and automated reporting processes
• Build interactive dashboards and visualizations using Tableau, Power BI or similar business intelligence tools to communicate insights to stakeholders across the supply chain organization
• Apply statistical analysis and machine learning techniques to identify patterns, forecast trends and optimize supply chain operations including demand planning, inventory optimization, and logistics efficiency
• Collaborate with supply chain business partners to translate analytical requirements into technical solutions that drive operational improvements
• Develop predictive models and algorithms to support supply chain forecasting, risk analysis and scenario planning
• Conduct A/B testing and experimental design to validate hypotheses and measure the impact of supply chain process improvements
• Implement model evaluation techniques including cross validation, hyperparameter tuning and performance metrics to ensure model accuracy and reliability
• Participate in code reviews and documentation to ensure data quality
• Support the testing and validation of data models, ensuring accuracy and reliability of analytical outputs
• All associates must adhere to GxP regulations by strictly following Standard Operating Procedures (SOPs), maintaining accurate and complete documentation, ensuring rigorous quality control, and completing all required training
• Associates are responsible for meeting their individual job requirements and contributing to the overall compliance of the organization
• Compliance with regulatory requirements and a commitment to continuous improvement are essential to our operations

WHAT YOU’LL BRING TO ALCON:

• High School Diploma or equivalent
• The ability to fluently read, write, understand, and communicate in English
• 3 years of Relevant Experience
• Work hours: 1st Shift; Monday – Friday; 8:00 AM – 5:00 PM CST
• Location: Onsite
• Travel Requirements: 0 – 10%
• Relocation Assistance: Not Available
• Sponsorship Available: Not Available

Preferred Qualifications/Skills/Experience:

• Proficiency in ETL tools such as Alteryx, Looker, or equivalent platforms
• Strong SQL skills with experience writing complex queries, joins, and stored procedures
• Working knowledge of Python programming, particularly panda’s library and other standard data analysis packages
• Experience with data visualization tools including Tableau, Power BI, or similar platforms

HOW YOU CAN THRIVE AT ALCON:

Collaborate with teammates to share standard processes and learnings as work evolves!

See your career like never before with focused growth and development opportunities

Join Alcon’s mission to provide outstanding, innovative products and solutions to improve sight, improve lives, and grow your career!

Alcon provides robust benefits package including health, life, retirement, flexible time off for exempt associates, PTO for hourly associates, and much more!

ALCON IS AN EQUAL OPPORTUNITY EMPLOYER AND PARTICIPATES IN E-VERIFY Alcon takes pride in maintaining an inclusive environment that values different perspectives and our policies are non-discriminatory in recruitment, hiring, training, promotion or other employment practices for reasons of race, color, religion, gender, national origin, age, sexual orientation, marital or veteran status, disability, or any other legally protected status. Alcon is also committed to working with and providing reasonable accommodation to individuals with disabilities. If, because of a medical condition or disability, you need a reasonable accommodation for any part of the application process, or in order to perform the essential functions of a position, please send an email to [e-mail] and let us know the nature of your request and your contact information.