Data Engineer

Join the exciting world of Travel and help growAmerica’s largest full-service travel agency! 

Do you have a passion for making a meaningful impact? This is your chance to lead a transformation to modernize the data, reporting, and analytics environments of a very large department serving hundreds of vendors, thousands of employees, and millions of members. We support travel sales, service, and operations, including accounting, compensation, and financials. We have an ambitious goal to grow our travel business by 50%, and we need your help to build our next-generation data mart that will drive the creation of actionable solutions to help us drive sales, boost productivity, streamline our operations, and generally operate at a higher level. As a data engineer on the team, you’ll have the opportunity to drive the strategic direction of our data environment while working closely with your driven, friendly, and helpful team. Come be a part of something big as we transform our business for growth and success to support one of AAA’s core products.  

Who We Are Looking For 

If you are passionate about data, and you enjoy using it to drive change and solve business problems, then we want to hear from you! We’re looking for someone to lead the modernization of our data environment by creating our next-generation data mart in the cloud (AWS). To be successful in this mission, you should be very comfortable with large and highly complex data environmentsof a large enterprise,cloud environments like AWS, have strong data prep and scripting skills, especially using the Microsoft stack (SSMS, SSIS, SSDT, etc.), and be able to architect efficient, scalable, and performantdata solutions for consumption by analysts and engineers. We’re looking for someone who is consultant minded and can design solutions that solve business problems without requiring detailed specs. Your primary mission is to help drive sales, grow revenue, and optimizeoperations. To do this, you must understand the business well enough to independently architect data that can be easily used to develop solutions that delight our customers.  

Key Qualities We Value 

• Craftsmanship: Measure twice; cut once. Maintain an extreme attention to detail and focus on delivering the highest level of quality.  

• Integrity:Lead from the front and by example. Inspire others through your own growth, say what you mean, mean what you say, and exercise courageous candor.  

• Fun-loving: We believe in enjoying our work and celebrating successes together. 

• Communication: Be able to adjust your verbal and written communication based on your audience, whether explaining complex technical terms with a developer, an executive or any level in between. 

• Inspirational: Embrace challenges as opportunities and be inspired to try new things. 

• Creativity: Passionate about problem-solvingand seeking innovative solutions to overcome challenges, break through walls, and navigate barriers.  

•  Consultant-minded: Focus on deeply understanding the problem to make recommendations that others may not consider. Don’t be an order taker; be a solution provider.  

What You'll Be Doing 

• Designing, developing, and deployingdatabase solutions in AWS using various sources such as OLAP/OLTP databases, flat files, and cloud-based applications  

• Create ETLs that optimally prepare data for reporting and analytics  

• Optimizing and tune performance through various techniques  

• Contributing to reliability, quality, security and scalability of applications. 

• Working in a fast-paced environment with competing priorities, requiring you to manage expectations 

• Continuously learning and exceling at solution driven problem-solving by using your analytical skills. 

• Driving technical excellence within the team, ensuring best practices are followed  

• Collaborating with cross-functional teams to overcome and resolve dependencies  

• Maintaininga consultant-mindset in place of an order-taking mindset  

• Championing a collaborative and inclusive team environment, promoting communication, trust, and respect among team members. 

What We Require 

• Strong SQL programming skills, including query optimization and performance tuning  

• Experience working in Enterprise Data Warehouse environments and AWS 

• Proficient in database development using MS SQL in OLAP/OLTP environments 

• Proficient with ETL development, designing and developing data transformation solutions using a variety of SSIS components (ie. Control Flow, Data Flow, Transformations, Script components using C#) 

• Experience with Github version control 

• Experience with Scrum and Kanban methodologies  

• Experience working with CI/CD pipelines using Jenkins for deployments  

• Must be a self-starter and require limited guidance towards project deliverables 

#LI-SS1