Data Engineer
Ascendion · Seattle, WA
- On site
- Full-time
- $150,000 / year
- Seattle, WA
Job highlights
- Design and implement data migration solutions.
- Utilize AWS data services for scalable pipelines.
- Collaborate with cross-functional engineering teams.
- Develop ETL/ELT processes for large datasets.
- Ensure data integrity and pipeline reliability.
About the role
About Ascendion
Ascendion is a full-service digital engineering solutions company. We make and manage software platforms and products that power and deliver captivating experiences to consumers and employees. Our engineering, cloud, data, experience design, and talent solution capabilities accelerate transformation and impact for enterprise clients. Headquarters in New Jersey, our workforce of 6,000+ Ascenders delivers solutions from around the globe. Ascendion is built differently to engineer the next.Ascendion | Engineering to elevate life
We have a culture built on opportunity, inclusion, and a spirit of partnership. Come, change the world with us:
- Build the coolest tech for world’s leading brands
- Solve complex problems - and learn new skills
- Experience the power of transforming digital engineering for Fortune 500 clients
- Master your craft with leading training programs and hands-on experience
- Experience a community of change makers!
About the Role
The ideal candidate combines strong hands-on engineering capabilities with the ability to work through ambiguity, support cross-functional stakeholders, and contribute to scalable migration frameworks and operational best practices.This role will partner closely with Data Engineers, TPMs, BI Engineers, Data Scientists, and business stakeholders to deliver reliable, secure, and scalable data solutions supporting sustainability and operational initiatives.
Data Engineer - AWS Data Migration
Required Qualifications
Must Have:
- Data Migration experience.
- Data Engineering and AWS Tech Stack
- Bachelor's degree in computer science, Data Engineering, Information Systems, or related technical field.
- 3-7+ years of experience in Data Engineering, ETL development, or large-scale data platform environments.
- Strong hands-on experience with AWS data technologies including: AWS Glue, Redshift, S3, Lake Formation, Managed Airflow (MWAA)
- Strong programming skills in: SQL, Python, PySpark
- Experience building and supporting scalable ETL/ELT pipelines in cloud-based environments.
- Experience working with structured and semi-structured datasets at scale.
- Understanding of data warehousing concepts, dimensional modeling, partitioning strategies, and query optimization.
- Experience supporting enterprise-scale migration, modernization, or data transformation initiatives.
- Familiarity with data validation, reconciliation, and migration testing methodologies.
- Experience troubleshooting distributed data processing workloads and production pipeline issues.
- Ability to work effectively in Agile delivery environments with cross-functional stakeholder teams.
- Strong communication, analytical, and problem-solving skills.
Location
Seattle, WA (Onsite 5 days a week)Salary Range
The salary for this position is between $140,000 - $160,000 annually. Factors which may affect pay within this range may include geography/market, skills, education, experience, and other qualifications of the successful candidate.Benefits
The Company offers the following benefits for this position, subject to applicable eligibility requirements: [medical insurance] [dental insurance] [vision insurance] [401(k) retirement plan] [life insurance] [long-term disability insurance] [short-term disability insurance]. The Paid time off benefits meet the paid sick and safe time laws that pertains to the City/ State] [10-15 days of paid vacation time] [6 paid holidays and 1 floating holiday per calendar year] [Ascendion Learning Management System]Key skills/competency
- Data Migration
- Data Engineering
- AWS
- AWS Glue
- Redshift
- S3
- Lake Formation
- Python
- PySpark
- SQL
Skills & topics
- Data Engineer
- AWS Data Migration
- Data Engineering
- AWS Glue
- Redshift
- S3
- Lake Formation
- Python
- PySpark
- SQL
- ETL
- ELT
- Cloud Data Warehousing
- Data Modeling
- Agile
How to get hired
- Tailor your resume: Highlight your AWS data migration and engineering experience, emphasizing skills like Python, PySpark, SQL, AWS Glue, Redshift, S3, and Lake Formation.
- Showcase project impact: Quantify your achievements in previous data engineering roles, especially those involving large-scale data platforms or migrations.
- Prepare for technical questions: Brush up on data warehousing concepts, dimensional modeling, ETL/ELT best practices, and AWS-specific data services.
- Demonstrate Agile proficiency: Be ready to discuss your experience working in Agile environments and collaborating with diverse stakeholder teams.
- Research Ascendion's culture: Understand their commitment to digital engineering and employee growth to align your responses with their values.
Technical preparation
Master AWS data services: Glue, Redshift, S3, Lake Formation.,Strengthen Python, PySpark, and SQL coding skills.,Review data warehousing, modeling, and optimization.,Practice troubleshooting distributed data pipelines.
Behavioral questions
Describe a complex data migration project.,How do you handle ambiguity in projects?,Share an experience collaborating with stakeholders.,How do you ensure data quality during migration?
Frequently asked questions
- What specific AWS data migration experience is Ascendion looking for in a Data Engineer?
- Ascendion is seeking a Data Engineer with direct experience in migrating data, specifically leveraging AWS data technologies such as AWS Glue, Redshift, S3, and Lake Formation. Experience with Managed Airflow (MWAA) is also a plus for orchestrating these migration processes.
- How important are Python and PySpark skills for this Data Engineer role at Ascendion?
- Python and PySpark are crucial programming skills for this Data Engineer position. They are essential for building and supporting scalable ETL/ELT pipelines and processing structured and semi-structured datasets within the AWS environment.
- What does Ascendion mean by 'work through ambiguity' for the Data Engineer role?
- Working through ambiguity means Ascendion expects the Data Engineer to be comfortable and effective even when all the details are not perfectly defined. This includes being proactive in problem-solving, defining processes, and driving initiatives forward with incomplete information.
- Can I apply for the Data Engineer position if my AWS experience is more focused on general cloud architecture than specific data services?
- While general AWS experience is valuable, this role specifically requires strong hands-on experience with AWS data technologies like Glue, Redshift, S3, and Lake Formation. Highlighting any data-specific projects within your general AWS experience would be beneficial.
- What are the typical data warehousing concepts Ascendion expects a Data Engineer to understand?
- Ascendion expects Data Engineers to have a solid understanding of data warehousing concepts, including dimensional modeling, partitioning strategies for efficient data storage and retrieval, and query optimization techniques to ensure high-performance data solutions.
- Does Ascendion offer remote work options for the Data Engineer role?
- No, this Data Engineer position is located in Seattle, WA, and requires the candidate to be onsite 5 days a week. Ascendion emphasizes in-person collaboration for this role.
- How does Ascendion support professional development for its Data Engineers?
- Ascendion fosters a culture of learning with its 'Ascendion Learning Management System,' providing leading training programs and hands-on experience to help engineers master their craft and advance their careers.