Search for data engineering roles in Chicago, specifically focusing on AWS data lake architecture, requiring 7+ years of experience, involving duties with Glue or DBT, and offering a full-time schedule.

Okay, I've searched for data engineering roles in Chicago that focus on AWS data lake architecture, require 7+ years of experience, involve Glue or DBT, and offer a full-time schedule. I found 25 positions that match your criteria.

Data Engineer

Chicago, IL

7 years + Experience

Glue

DBT

Full Time

Can you help me to analyze the job description and company culture?

Sure. Here's the analysis:

Job Analysis:

The Data Engineer role at Lensa is fundamentally tasked with devising and managing data architectures within a healthcare application in an AWS environment. The position's core focus lies in developing innovative AWS data lake architecture solutions, which emphasizes the need for creativity and forward-thinking in data management practices. Key responsibilities include troubleshooting and configuring AWS data services, performing ETL tasks, and working with databases like Hudi and Aurora MySQL. A successful candidate will be expected to not only handle complex datasets but also to optimize performance and ensure seamless data migration. This suggests an underlying expectation of adaptability, as the candidate may face frequent changes in project scope or requirements, necessitating solid problem-solving skills. Success in this role would entail delivering high-quality data solutions, improving system efficiencies, and effectively collaborating with product development teams. Performance could be measured through the health and efficiency of data lakes, the successful implementation of migrations, and the overall impact on application performance over the first 6-12 months.

Company Analysis:

Lensa operates in a rapidly evolving tech space as a disruptor in job search and talent acquisition, utilizing machine learning to streamline the recruitment process. The company is positioned as a prominent player, given its vast user base and innovative technology, which suggests opportunities for data-driven decision-making in the role of Data Engineer. The culture at Lensa appears to be inclusive and collaborative, emphasizing the value of diverse perspectives and authentic identities in the workplace. This aligns with the expectations for the Data Engineer to work closely with cross-functional teams to develop solutions that cater to user needs. As a member of the product development team, this role will have significant visibility and influence on the company's offerings. Overall, this role aligns strategically with Lensa's goal of delivering optimized and responsive data solutions, ultimately supporting the efficiency of their platform and enhancing user experience, marking it as a crucial hire in their growth phase.

Mock up some interview questions based on the job description.

Absolutely. Here are some mock interview questions that could come up:

Tell me about a time when you had to troubleshoot a complex data migration issue. What steps did you take to resolve it?
Describe a project where you had to innovate a data architecture solution. What challenges did you face, and what was the outcome?
Can you explain your experience with AWS Glue or DBT? How have you utilized these tools in past projects?
Imagine you are tasked with improving the performance of a RedShift database. What strategies would you employ?
How would you approach creating a data lake architecture for a healthcare application? What specific considerations would you keep in mind?
In a previous role, how did you manage and optimize data workflows using AWS services? Can you provide an example?
Consider a situation where you need to collaborate with a software development team on data integration. How would you ensure effective communication and project success?
Why are you interested in the Data Engineer position at Lensa specifically, and how does your background align with our mission?
What attracts you to working in a company that prioritizes inclusivity and diversity?
How do you stay current with advancements in data engineering and AWS technologies?
What has been your biggest achievement in data engineering to date, and how did you measure its success?
Could you share your understanding of the healthcare data landscape and how it impacts your work as a Data Engineer?
What questions do you have about the team structure and expectations for this Data Engineer role?
How does your approach to data engineering reflect the values of innovation and user-centric solutions?
What insights do you have on the importance of accessibility in data management practices?

Job Details

Overview Company

Senior Data Engineer

Lensa

3 days ago

Highlight

OnsiteFull-time7+ yearsSenior

Summary

Lensa is seeking a Data Engineer INTL India - EOR deaabd89 to join their team in Chicago, IL. The role involves working on a product development team responsible for data lakes and architecture of a healthcare application in an AWS environment.

About the Role

As a Data Engineer, you will work on AWS data lake architecture, provide innovative solutions, and handle data migration services. You will manage ETL processes, work with Hudi databases, and develop SQS and Event Bridge Schedule. You will also manage Aurora MySQL database, including writing stored procedures and setting up read replication, and troubleshoot AWS resources for performance improvement.

About You

Required:

7-10+ years data engineering experience
AWS data lake architecture
Experience with Glue or DBT
Experience with RedShift or Snowflake
SQS Development
Event Bridge Scheduler
AWS data migration services
Hudi database management
AWS Aurora MySQL database management
Proficiency in Python or Scala

Preferred:

Innovative and creative approach to data engineering

Lensa

What if we could take the search out of job search? This is the question Lensa has been answering since launching in San Francisco, California in August 2016. Using machine learning, we instantly provide companies with candidates and match professionals with positions that fit their skills, goals, personalities, and needs. How does it work? Lensa applies complex algorithms that identify the skills needed to succeed on a given job. Candidates can play computer games that assess their work style, thus gaining insight into their strengths while unlocking career opportunities. The result: job search that puts people first while reducing the time and cost of talent acquisition.

Lensa passed 10 million job seeker registrations in 2019, making the com- pany one of the premier career platforms.

With teams in multiple U.S. locations and a 60-strong crew of developers and data scientists at its R & D headquarters in Europe, Lensa is working every day to share its transformative career technology with the world.

Chicago, IL