Data Engineer (Azure)

RethinkFirst
Chicago, IL

About RethinkFirst 

RethinkFirst is a leading behavioral health technology company working to make mental wellness, education, and support accessible and scalable. Through our suite of cloud-based platforms—including RethinkEd, RethinkCare, and RethinkBH—we serve educators, employers, and providers with tools that deliver measurable, inclusive outcomes. 

We're on a mission to make behavioral health more effective, equitable, and human.

About the Role

We're seeking a highly skilled and motivated hands-on Data Engineer to design, build, and maintain our Microsoft Fabric Lakehouse as we migrate our Azure-Synapse enterprise data warehouse and analytics platform. You'll own the full lifecycle — from designing scalable pipelines and dimensional models to delivering reliable, secure data across the organization and supporting it in production.

You'll thrive here if you're fluent across Microsoft Fabric, Azure Synapse, and Databricks , comfortable using C# for API integrations, communicate clearly with both technical and business partners, and take genuine ownership of outcomes from design through production support.

What You'll Do

Data Modeling & Lakehouse / Warehouse Development

  • Design, build, and maintain scalable Lakehouse and data warehouse solutions on Microsoft Fabric and Azure Synapse

  • Develop, optimize, and deploy ETL/ELT pipelines and reusable framework for seamless data integration from multiple diverse sources

  • Implement data quality, validation, and transformation logic across pipelines, ensuring accuracy and consistency

  • Establish best practices for data engineering, including coding standards, governance, performance, and automation

  • Document models, pipelines, and operational runbooks so others can support and extend the platform

  • Develop and optimize dimensional/Semantic models for advanced BI and analytics

Data Integration & Operations

  • Integrate diverse source systems into the enterprise data warehouse

  • Ensure pipelines and Lakehouse/warehouse workloads are scalable, reliable, performant, and secure

  • Tune SQL, Spark jobs, and pipeline performance for cost and reliability

  • Implement monitoring, alerting, and operational practices for data workflows

  • Respond to production incidents, trouble-shoot root-causes, and implement effective solutions

  • Proactively identify gaps, propose improvements, and drive work to completion with minimal oversight

  • Implement API integrations and services where the platform requires it

Collaboration & Delivery

  • Partner with architects, analysts, product, and business stakeholders to translate requirements into Lakehouse/warehouse solutions

  • Communicate progress, risks, and tradeoffs clearly to both technical and non-technical audiences

  • Work within Agile/Scrum practices — planning, estimation, and demos

  • Collaborate effectively across onshore and offshore teams

  • Conduct and participate in Code Reviews to ensure code quality and maintainability

What You Bring

Required Qualifications

  • 2-5 years of hands-on experience in data warehouse / data engineering roles

  • Practical, production experience across Azure Synapse, Microsoft Fabric, and Azure Databricks

  • Strong SQL plus Python and/or scripting for transformation, automation, and tooling

  • Proven experience building and optimizing ETL/ELT pipelines and data models

  • Experience delivering within Agile/Scrum teams

  • Strong written and verbal communication skills

  • Demonstrated initiative, ownership, and reliability in delivering production data solutions

Preferred Qualifications

  • Experience with healthcare data systems

  • Familiarity with the ABA (Applied Behavior Analysis) domain

  • Experience with C# for API integrations and services

  • Exposure to AI (Azure OpenAI, Claude, Cursor)

  • Experience collaborating with distributed or offshore teams

Who You Are

  • You take initiative — you spot issues and opportunities, then drive solutions forward

  • You're accountable — you own quality, reliability, and follow-through

  • You communicate clearly — you can explain technical work to any audience


Job Type 

Full-time (W2 only) , Remote 


Benefits: 

  • Generous health, dental, & vision benefits package
  • Flexible paid time off   
  • 11 paid company holidays
  • 401k + matching
  • Parental leave
  • Access to our award-winning RethinkCare platform supporting neurodiversity in the workplace through parental success, professional resilience, and personal wellbeing.  

Location: Remote opportunities are available to candidates who reside in the following states: AL, AZ, CT, FL, GA, HI, IA, IL, IN, KY, LA, MD, MA, MI, MN, MO, MT, NC, NE, NH, NJ, NV, OH, OK, OR, PA, RI, TN, TX, VA, WA, WI, WY

Our commitment to an inclusive workplace 

RethinkFirst is an equal opportunity employer and is committed to providing a workplace free from harassment and discrimination. We celebrate the unique differences of our employees because that is what drives curiosity, innovation, and the success of our business. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, age, pregnancy, genetic information, disability, status as a protected veteran, or any other protected category under applicable federal, state, and local laws. Accommodations are available for applicants with disabilities. 

California Privacy Notice

Recruiting Fraud Alert: Job applicants should be aware that there are external parties posing as RethinkFirst recruiters. These scams may include fraudulent communications via social media platforms (such as LinkedIn), email, or requests to schedule interviews.  Note that any recruiting related communication you receive from RethinkFirst would come from an @rethinkfirst.com e-mail address, @applytojob.com email address (via our talent acquisition system), ‘[email protected]’ email address, and/or be found on the Rethinkfirst.com website.  Please also note that at no point during our recruitment process will we request any form of monetary payment. If you believe that you have been a victim of job recruiting fraud, you should file a report with your local law enforcement.

#remote
#BI-Remote

Posted 2026-08-20

Recommended Jobs

Grocery Lead

Meijer
Homer Glen, IL

As a family company, we serve people and communities. When you work at Meijer, you’re provided with career and community opportunities centered around leadership, personal growth and development. Con…

View Details
Posted 2026-08-18

Human Resources Generalist

Aspen Guard LLC
Chicago, IL

Job Description Job Description About Folding Guard: Folding Guard is a leading manufacturer and provider of innovative security and safety solutions for a wide range of industries. With a his…

View Details
Posted 2026-03-27

Patient Health Navigator

COMMUNITY HEALTH PARTNERSHIP OF ILLINOIS
Aurora, IL

Job Description Job Description Patient Health Navigator Community Health Partnership of Illinois is a is a non-profit organization that provides primary health care to migrant farmworkers and…

View Details
Posted 2026-08-08

People Partner Coordinator

Belcan
Normal, IL

Job Title: People Partner Coordinator Pay rate: $20.45- $27.05/hr. Location: Normal, IL Zip Code: 61761 Duration: 6 Months Start Date: Right Away Keywords: #NormalJobs; #Coordinatorjobs; We p…

View Details
Posted 2026-08-12

Executive Assistant

Addison Group
Chicago, IL

Title: Executive Assistant Industry: CPG Location: Chicago, IL – River North Assignment Type: Contract Pay: $32 - $38/hour Work Schedule: Monday-Friday, 8:30 AM - 5:00 PM | 100% …

View Details
Posted 2026-08-06

Regional Class A Tanker/Vac. Driver

Clean Harbors
Dolton, IL

Job Description Job Description Clean Harbors is looking for a Regional Class A Tanker/Vac Driver to join their safety conscious team in Dolton, IL. This route runs from Dolton, IL. to Midw…

View Details
Posted 2026-07-29

Handyman Carpenter

Handyman Connection of Rockford
Rockford, IL

Job Description Job Description What You Will Receive Earn $30-45/hour or up to $1,200+/week, depending on your skills and availability Professional Office Support - scheduling, customer su…

View Details
Posted 2026-07-29

CDL-A ISO Liquid Tanker Owner Operator - $12,000 Sign-on Bonus!

Quantix
Chicago, IL

Quantix Is Currently Partnering With CDL-A ISO Owner Operator Truck Drivers $12,000 SIGN-ON BONUS* Paid Out Within a Year, Including $4,000 on Your 1st Settlement! Regional Runs - Out 2-3 Days! …

View Details
Posted 2026-08-06

Senior Finance Manager, Global Commercial Reporting

AbbVie
Illinois

Company Description About AbbVie AbbVie's mission is to discover and deliver innovative medicines and solutions that solve serious health issues today and address the medical challenges of to…

View Details
Posted 2026-07-24