Senior Data Platform Engineer - AWS & SQL

Client Overview:
Our client is a well-established, high-growth lifestyle organization seeking a Senior Data Platform Engineer - AWS & SQL to join its technology team. This is a hands-on opportunity to take ownership of enterprise data architecture and pipelines while working within a collaborative, high-performing environment.

Salary/Hourly Rate:
$145,000 - $165,000

Position Overview:
The Senior Data Platform Engineer - AWS & SQL will build, optimize, and evolve an enterprise data platform. This is a highly hands-on position requiring advanced SQL skills, strong data architecture experience, and the ability to independently design and build scalable data pipelines.
This position includes a technical SQL assessment, and advanced SQL proficiency is required to move forward in the interview process.

Responsibilities of the Senior Data Platform Engineer - AWS & SQL:

• Design, build, and maintain scalable enterprise data architecture and pipelines within AWS.
• Develop and optimize complex SQL queries across large datasets.
• Build and manage data models and schemas within enterprise data warehouses.
• Develop data solutions using AWS services including S3, Glue, Lambda, Athena, EMR, and Redshift.
• Monitor, troubleshoot, and optimize data pipelines and infrastructure.
• Implement data quality checks, validation rules, and monitoring processes.
• Design scalable data models using dimensional modeling and star schema concepts.
• Partner with Data Science, Analytics, Engineering, and business stakeholders.
• Improve data lineage, cataloging, governance, and technical documentation.
• Mentor junior and offshore team members and promote data engineering best practices.

Required Experience/Skills for the Senior Data Platform Engineer - AWS & SQL:

• 6+ years of professional Data Engineering experience.
• Expert-level SQL skills; advanced SQL assessment required.
• Strong hands-on experience building complex SQL queries and optimizing query performance.
• Strong hands-on AWS data engineering experience, particularly S3, Glue, Lambda, Athena, EMR, and Redshift.
• Proven experience designing and implementing data architecture and enterprise data warehouses.
• Strong experience building and maintaining scalable ETL/ELT pipelines.
• Experience with dimensional modeling, star schemas, and large datasets.
• Ability to independently own data solutions from architecture/design through deployment.
• Must be authorized to work in the U.S. without current or future sponsorship.

Preferred Experience/Skills for the Senior Data Platform Engineer - AWS & SQL:

• dbt Labs experience.
• Python proficiency.
• Experience with data governance, data quality, and observability.
• Experience mentoring junior and/or offshore engineers.
• Experience with structured, semi-structured, and unstructured data.
• Git and version-controlled development workflows.

Education Requirements:

• Bachelor's degree in Computer Science, Engineering, Information Technology, or a related technical field preferred.

Benefits:

• Comprehensive benefits package, employee perks, and additional company benefits available upon eligibility.

Job Wrapping ID: #LI-AJ3

About Atrium:What you do matters. Guided by our Applicant-Centric™ approach, we foster an environment of collaboration, high performance, and innovation where your talents are valued, and your achievements are celebrated. Join us and become part of an inclusive team committed to your growth and success. By applying to this job, you agree to receive calls, AI-generated calls, text messages, and/or emails from Atrium and its affiliates, and contracted partners. Frequency varies for text messages. Message and data rates may apply. Carriers are not liable for delayed or undelivered messages. You can reply STOP to opt out on any message you receive. For more details, please review our Terms of Use and Privacy Policy . As a woman-owned firm, we value diversity. We are an equal opportunity and affirmative action employer and will consider all applications without regard to race, sex (including gender, pregnancy, sexual orientation and gender identity), age, color, religion or creed, national origin or ancestry, veteran status, disability (physical or mental), genetic information, citizenship or any other characteristic protected by law. We will ensure that individuals with disabilities are provided reasonable accommodation to participate in the job application or interview process, to perform essential job functions, and to receive other benefits and privileges of employment. Candidates who apply for roles through the Atrium website will be added to our candidate pool and may be considered for additional roles of a similar title. Please contact us to request an accommodation.
EOE/M/F/D/V/SO

Position ID: 406369