Note: The job is a remote job and is open to candidates in USA. eTeam is seeking a contractor for Alcon to support data engineering initiatives. The role focuses on building reliable data pipelines and scalable data structures, while collaborating with data scientists and business stakeholders to ensure data is accessible and well-structured.
Responsibilities
- Design, build, and maintain cloud-based data pipelines for structured and semi-structured/unstructured data sources
- Develop ingestion, transformation, and refresh workflows using tools such as AWS S3, Glue, Athena, Lambda, Step Functions, DynamoDB, relational databases, and Python-based automation
- Create curated datasets, metadata tables, and reusable schemas that support analytics, dashboards, reporting, and application development
- Build data models that link related business objects using reliable identifiers, keys, and reference tables
- Develop SQL queries, views, and data access layers for recurring analytical and reporting needs
- Partner with data scientists and analysts to prepare clean, trusted datasets for downstream modeling, GenAI workflows, dashboards, and prototype applications
- Implement data quality checks, validation rules, exception handling, logging, and pipeline monitoring
- Document data sources, transformations, assumptions, refresh logic, and known limitations
- Support migration from manual or file-based workflows to automated, scalable cloud data pipelines
- Collaborate with platform, security, and infrastructure teams to follow enterprise standards for access, data handling, and operational reliability
Skills
- 5–8 years of relevant experience in data engineering, analytics engineering, cloud data platforms, ETL/ELT development, database design, or data integration
- 5 years: Able to independently build reliable data pipelines and queryable datasets
- 7–8 years: Able to define data architecture patterns, design reusable data models, improve operational reliability, and help scale prototype pipelines into more durable data products
- Bachelor's degree in Computer Science, Data Engineering, Information Systems, Software Engineering, Engineering, Applied Mathematics, or a related technical field
- Hands-on experience building data pipelines and data lake workflows using AWS S3, Glue, Athena, Lambda, Step Functions, DynamoDB, RDS or equivalent services
- Strong Python and SQL skills for extracting, cleaning, transforming, validating, and loading data
- Ability to design practical schemas, reference tables, metadata structures, and relational linkages across multiple business processes or systems
- Master's degree or equivalent experience in data engineering, cloud architecture, analytics engineering, or enterprise data platforms
Company Overview
Company H1B Sponsorship