Data Engineer (498)

ABOUT THE COMPANY
Amplify Consulting Partners is a data-first consulting company trusted by Fortune 500 businesses to deliver high-impact professional services across the technology ecosystem—from data engineering and visual analytics to data-driven marketing and program management.
We build and empower high-performing people by promoting growth and connection across our company culture. We don't just hang core values on the wall, we make every decision with them in mind—developing trusted, long-term relationships on a foundation of transparency and accountability.

DEI STATEMENT
We hold ourselves accountable to creating an authentic workplace where every person feels heard and experiences a sense of belonging.
We believe that organizations can be an instrument for positive human impact when they champion a diverse, inclusive, and equitable environment. We do this at Amplify by enacting programs and policies that promote DEI—and with humility, if we miss the mark, we rigorously amend our practices to better achieve our targeted outcomes.
Simply stated, we turn our words into action.

ABOUT THE POSITION
In this position you'll be working as a fully embedded consultant at Amazon. The IDEAS team, part of the TES Benchmarking group, is looking for a BIE/DE with AWS experience that can support our existing data infrastructure and make improvements to ETL solutions and data pipelines.  The ideal candidate will be a detail oriented, a good communicator and an excellent problem solver. As part of a small team developing analytical solutions for the Transportation Engineering Services Organization, you will have the opportunity to work on a wide variety of projects and collaborate with multiple cross-functional teams and stakeholders. We prioritize cooperation, frequent and open communication, and stress the importance of peer support so that we can learn from each other succeed as a united team. REQUIREMENTS
Qualifications

• 3+ years of data engineering experience
• Experience with data modeling, warehousing and building ETL pipelines
• Experience with SQL
• Able to read, write, and debug Python code following best coding standards (e.g. version controlled, code reviewed, etc.)
• Experience with AWS technologies like Redshift, S3, AWS Glue, Lambda, CloudWatch, Step Function, and IAM roles and permissions
• Experience with AWS CDK (Cloud Development Kit) for Infrastructure as Code (IaC) to provision and manage AWS resources

Preferred Qualifications

• Experience working within an Amazon team with knowledge of Andes 3, Lake Formation, and Shepherd tickets
• Familiarity with agile software development methodologies and experience working in an agile environment
• Experience with AWS CodePipeline and AWS CodeBuild a plus

Key Responsibilities

• Troubleshoot and resolve issues in the existing data infrastructure, including data pipelines, ETL processes, and data warehousing components
• Implement improvements and optimizations to the current data architecture to enhance performance, reliability, and scalability
• Develop and maintain efficient data pipelines using AWS services like Glue, EMR, Athena, and Redshift to ingest, transform, and load data from various sources
• Collaborate with data engineers, business intelligence engineers, and other cross-functional teams to define and execute data strategies that support the broader business objectives
• Participate in code reviews and provide technical guidance to ensure the integrity, security, and compliance of the data environment
• Stay up-to-date with the latest trends and best practices in data engineering, and recommend innovative solutions to enhance the data ecosystem
• Proactively identify opportunities to automate manual processes, improve data quality, and streamline data workflows
• Document data pipeline designs, data models, and operational procedures to maintain knowledge sharing and ease of maintenance

Please note, we, unfortunately, cannot provide sponsorship at this time.

SALARY AND BENEFIT HIGHLIGHTS
At Amplify we take a holistic approach to total rewards in order to invest in the satisfaction and success of our employees both now and in the future. We consider the whole person and want to support our employees in living full lives both personally and professionally. The following is an overview of what you’ll get as a member of our team.

Pay Range: $80,000-$120,000
• PTO – 3 weeks (accrual)
• 10 observed holidays
• Medical/dental/vision – employee covered at 100%, dependents subsidized
• Parental leave, short-term disability, long-term disability, and life insurance
• Mentorship and training opportunities
• Business and employee referral bonus opportunities

OUR HIRING PRACTICES
All qualified applicants will receive consideration for employment without regard to age, race, color, religion, sex, sexual orientation, gender identity, national origin, disability, or status as a protected veteran. We are committed to creating a diverse and welcoming workplace that includes all employees with diverse backgrounds and experiences. We believe it enables us to meet our mission and values while serving clients throughout our communities. People of color, women, LGBTQIA+, veterans, and persons with disabilities are encouraged to apply. Qualified applicants with criminal histories will be considered for employment.