Alchemee (formerly The Proactiv Company) · 2 days ago
Senior Data Engineer
Wonder how qualified you are to the job?
BeautyCosmetics
Insider Connection @Alchemee (formerly The Proactiv Company)
Responsibilities
Communicate with internal and external stakeholders to define business requirements and analytical needs.
Develop a deep understanding of existing eCommerce performance and develop new KPIs and metrics.
Own regular and ad-hoc analysis on operational performance and projects to improve Alchemee's eCommerce operations.
Define and structure eCommerce customer and operational data, ensuring data reliability and integrity.
Perform data modeling and build automated data flows on AWS to extract and transform data from various sources.
Optimize ETL processes, design data pipelines, and process datasets efficiently.
Utilize AWS Data Analytics platform and related services for data warehousing and modeling.
Design and optimize Redshift workloads, define data access roles, and permissions.
Learn and adapt to new technologies, demonstrate good analytical skills.
Qualification
Find out how your skills align with this job's requirements. If anything seems off, you can easily click on the tags to select or unselect skills to reflect your actual expertise.
Required
5+ years of experience in ETL, Data warehousing, Data pipelines, Data Analytics, in Microsoft or Amazon cloud
Expert-level skills in writing and optimizing SQL
Experience operating very large data warehouses or data lakes
Expertise in ETL optimization, designing, coding, and data ingestion from Rest and GraphQL API
Experience with building data pipelines and applications to stream and process datasets at low latencies
Sound knowledge of distributed systems and data architecture utilizing Lambda, Python, and Jupyter
Experience in AWS Data Analytics platform and related services - S3, AWS Glue, Redshift, Athena, Lake Formation, Lambda, etc
Experience in building data pipelines using Spark/Glue
Good understanding of Data Warehousing and Data Modelling concepts on AWS Redshift
Experience in designing and optimizing Redshift Workloads
Good knowledge of defining data access roles and permission for Redshift
Capable of learning and adapting to new technologies along with good Analytical skills
4-year degree (Economics, Statistics, Mathematics, Computer Science, MIS, or similar focus)
Preferred
AWS Data Stack is preferred
Experience working on Visualization tools like AWS QuickSight, Tableau, or Sigma is a plus
Experience in Java, IntelliJ, Bitbucket, Gradle is plus
Company
Alchemee (formerly The Proactiv Company)
(formerly known as The Proactiv Company) At Alchemee, we create science-based solutions that provide better skin for life.
H1B Sponsorship
Alchemee (formerly The Proactiv Company) has a track record of offering H1B sponsorships. Please note that this does not
guarantee sponsorship for this specific role. Below presents additional info for your
reference. (Data Powered by US Department of Labor)
Distribution of Different Job Fields Receiving Sponsorship
Trends of Total Sponsorships
2023 (2)
2022 (2)
2021 (1)
Funding
Current Stage
Growth StageTotal Funding
unknown2022-02-01Acquired· by Taro
Recent News
Company data provided by crunchbase