Be an early applicantLess than 25 applicants

This job has closed.

Company

Original Job Post

Alchemee (formerly The Proactiv Company) · 2 days ago

Senior Data Engineer

New York, NY

Full-time

Onsite

Senior Level

5+ years exp

Wonder how qualified you are to the job?

Maximize your interview chances

BeautyCosmetics

H1B Sponsorship

Insider Connection @Alchemee (formerly The Proactiv Company)

Discover valuable connections within the company who might provide insights and potential referrals, giving your job application an inside edge.

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.

ETLData WarehousingData PipelinesData AnalyticsSQLData IngestionAPIsData StreamingDistributed SystemsData ArchitectureLambdaPythonJupyterAWSS3AWS GlueRedshiftAthenaLake FormationSparkData ModellingData Access ControlRedshift WorkloadsAWS Data AnalyticsSpark/GlueData ModelingPermission ManagementDegree in Economics/Statistics/Math/CS/MISAnalytical SkillsAdaptability

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.

Founded in 1995

Santa Monica, California, USA

51-200 employees

https://www.alchemee.com

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)