I'm looking for mid-level Data Engineer positions in Chicago, specifically focusing on healthcare technology, requiring 3-5 years of experience, and proficiency in SQL and Python. Also, I'd like to know about companies offering benefits like 401(k) and commuter benefits.

Okay, I've searched for mid-level Data Engineer roles in Chicago within the healthcare technology sector, requiring 3-5 years of experience, proficiency in SQL and Python, and offering 401(k) and commuter benefits. I found 67 positions that match your criteria.

Data Engineer

Chicago, IL

Healthcare Technology

3-5 years

SQL

Python

401(k)

Commuter Benefits

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

Sure. Here's the analysis:

Job Analysis:

The Data Engineer position at CancerIQ is fundamentally about building and maintaining robust data architecture to empower health systems in making data-driven decisions for cancer prevention and treatment. The primary responsibilities revolve around enhancing, debugging, and ensuring the functionality of ETL processes and reporting systems that are critical for operational efficiency and clinical analytics. The ideal candidate will not only need technical prowess in SQL, Python, and database management but also a collaborative mindset to work with product, engineering, and customer success teams to refine data needs into actionable insights. Success in this role means not just keeping the data flowing smoothly but also ensuring that data is accurate, secure, and effectively utilized across the organization to improve patient outcomes. Challenges may include navigating evolving requirements from stakeholders and ensuring compliance with healthcare data standards amidst a rapidly changing technological landscape.

Company Analysis:

CancerIQ operates at the intersection of technology and healthcare, specifically focused on enhancing cancer prevention and treatment through its innovative platform. The company is positioned as a growing disruptor in the healthcare technology space, leveraging significant funding to expand its reach and influence across clinical settings. With a mission-driven culture, CancerIQ prioritizes collaboration and commitment to making a meaningful impact on health outcomes, which creates a dynamic atmosphere for employees. The Data Engineer role fits into a collaborative, cross-functional team, and is likely to have substantial visibility given the organization's focus on data-driven decision-making for improved health outcomes. Importantly, this role is aligned with CancerIQ's strategic goal of scaling operations rapidly to meet increasing demands, making it crucial for the Data Engineer to not only possess technical abilities but also a passion for leveraging technology in the fight against cancer.

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 significant data pipeline issue. How did you approach the problem and what was the outcome?
Can you describe an experience where you had to collaborate with cross-functional teams to gather data requirements for a project?
What steps do you take to ensure data integrity and reliability in your projects? Can you provide a specific example?
Explain how you optimized a SQL query in your previous role. What approach did you take and what impact did it have on performance?
What is your experience with ETL processes, and can you provide an example of a time you enhanced such a process in your work?
How would you handle a situation where a stakeholder requests a report outside of your usual data sets? What steps would you take?
Imagine you are given a task to automate a regular reporting process. What considerations would you keep in mind, and which tools would you likely use?
What would you do if you notice discrepancies in data being reported to stakeholders? How would you approach resolving it?
Why are you interested in working at CancerIQ specifically, and how do you think your skills align with our mission?
In your opinion, what role does data play in improving patient outcomes, and how does that motivate you as a Data Engineer?
Given the fast-paced nature of our work, how do you prioritize tasks and manage deadlines?
Can you ask about the team's current challenges regarding data management and how a new Data Engineer could contribute to overcoming them?
What are the biggest trends you see emerging in healthcare data management that might impact this role in the next few years?

Job Details

Overview Company

Data Engineer

Lensa

a day ago

Highlight

OnsiteFull-time3+ yearsMid

Summary

CancerIQ is seeking a Data Engineer to join their team in Chicago, IL. The role involves maintaining and enhancing data pipelines, supporting reporting needs, and ensuring data integrity to improve patient outcomes.

About the Role

As a Data Engineer at CancerIQ, you will maintain, debug, and enhance ETL processes, data models, and reporting codebases. You will build and optimize data pipelines, collaborate with various teams to understand data needs, ensure data integrity, write efficient SQL queries, and support ad hoc reporting requests. You will also implement best practices for data governance and partner with stakeholders to automate reporting tasks.

About You

Required:

Bachelor’s degree in Computer Science, Information Systems, Engineering, or a related field, or equivalent practical experience.
3–5 years of professional experience in a data engineering or software engineering role.
Proficiency in SQL (PostgreSQL preferred) and experience with data modeling and database optimization.
Proficiency with a data visualization tool (e.g., Metabase, Looker, Tableau).
Experience with Python or similar scripting languages for data manipulation and workflow automation.
Strong analytical and problem-solving skills, with high attention to detail.
Excellent communication skills with a collaborative mindset.

Preferred:

Experience with modern data stack tools (e.g., dbt, Airflow, Fivetran, Snowflake).
Familiarity with healthcare data standards (e.g., HL7, FHIR) or experience working with clinical data.
Knowledge of cloud platforms such as Google Cloud Platform (GCP) or AWS.
Exposure to PHI data handling and HIPAA compliance.
Comfortability with AI tools like ChatGPT for task automation and support.

Benefits

Competitive pay and benefits (Health, Vision, Dental, HSA/FSA, EAP, 401-K, Commuter Benefits).
Headquartered in Chicago's iconic Wrigley Building, with complementary Water Taxi service to and from Union and Ogilvy Stations.
Complementary gym membership with daily instructor-led classes located in the building.
Generous company-paid holidays and monthly CancerIQ mental health days.
Formal training and professional development opportunities.
Bi-annual 'All Hands' weeks where local Chicago employees convene and connect with employees based in other cities.
Passionate, high-energy culture with a team of people that are excited to get stuff done and make an impact.

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