Data Engineer (Mid-Junior Level) Job at Preferred Risk Insurance, Bedford Park, IL

dUNmUjhMRlpJb3N2T3ZLeVBhLzBVNjNKUEE9PQ==
  • Preferred Risk Insurance
  • Bedford Park, IL

Job Description

We are seeking the ideal candidate for our Data Engineer opening for our growing insurance company.

As a Data Engineer, you will support our development and business teams by designing, building, and maintaining analytical data pipelines and data warehouse solutions . This role is focused on modernizing our enterprise data platform using Azure Data Lake Storage (ADLS) , Azure Synapse Analytics , and Azure Data Factory (ADF) .

The Data Engineer will work closely with senior engineers and analysts to ingest, transform, and model data at scale , supporting our transition from legacy, heterogeneous data systems into a centralized, cloud-based data lake and data warehouse optimized for analytics and reporting.

DUTIES & RESPONSIBILITIES:

  • Design and develop data ingestion and transformation pipelines using Azure Data Factory
  • Load, transform, and manage data in Azure Data Lake Storage (ADLS) and Azure Synapse Analytics
  • Contribute to the design and implementation of a centralized cloud data warehouse
  • Apply data warehousing and distributed data processing concepts to support large analytical datasets
  • Assist with data modeling (fact and dimension tables) to support reporting and analytics use cases
  • Support the migration of legacy SQL Server, SSIS, and SSRS data into Azure-based platforms
  • Perform data quality checks and validation to ensure accuracy and consistency
  • Collaborate with analytics, reporting, and application teams to deliver trusted datasets
  • Participate in documentation, testing, and continuous improvement of data pipelines and platform architecture

QUALIFICATIONS REQUIRED:

  • 3-5 years of experience in data engineering, data warehousing, or analytics-focused roles
  • Strong SQL skills for data transformation, validation, and analytical querying
  • Solid understanding of data warehousing principles and analytical data models
  • Experience or strong exposure to Azure data services , including:
    • Azure Data Lake Storage (ADLS)
    • Azure Synapse Analytics
    • Azure Data Factory (ADF)
  • Familiarity with ETL / ELT concepts and production data workflows
  • Understanding of distributed data processing concepts and working with large datasets
  • Experience working with structured and semi-structured data
  • Comfortable using AI-assisted development tools (GitHub Copilot, ChatGPT, etc.)

Preferred:

  • Experience with Apache Spark or Hadoop
  • Exposure to Databricks , Snowflake , or similar modern data platforms
  • Familiarity with dbt or analytics engineering workflows
  • Knowledge of modern data formats such as Parquet or Delta
  • Experience supporting on-prem to Azure data platform migrations
  • Exposure to Power BI or other analytics and visualization tools
  • Understanding of data governance, metadata, or data quality frameworks
  • Experience working in agile environments or collaborating across technical teams

Preferred Risk Insurance Services provides a competitive benefits package to all full- time employees. Following are some of the perks Preferred Risk employees receive:

  • Competitive Salaries
  • Commitment to your Training & Development
  • Medical and Dental and Vision Reimbursement
  • Short Term Disability/Long Term Disability
  • Life Insurance
  • Flexible Spending Account
  • Telemedicine Benefit
  • 401k with a generous company match
  • Paid Time Off and Paid Holidays
  • Tuition Reimbursement
  • Wellness Program
  • Fun company sponsored events
  • And so much more!

Estimated Compensation Range: $80,000/year-$100,000/year*

*Published ranges are estimates. Offered compensation will be based on experience, skills, education, certifications, and geographic location. In addition, starting salary may vary by position depending on whether the position is in-office, hybrid or remote.

Job Posted by ApplicantPro

Job Tags

Full time, Temporary work, Work at office, Remote work, Flexible hours,

Similar Jobs

Ernst & Young

Financial Services - Capital Markets - Digital Assets - Senior Manager Job at Ernst & Young

 ...dealing with regulatory change, defining their digital client strategy, enhancing their client...  ...Youll be responsible for managing client engagements, working with high-performing...  ...transportation. Expertise in Digital Assets : Demonstrated knowledge of digital assets... 

Care Options For Kids

Pediatric Nurse RN/LPN - Melbourne Job at Care Options For Kids

About the Role At Care Options for Kids, a pediatric home health care company providing one-on-one care in the home, we do things a little...  ...the families you care for. Benefits for Licensed Practical Nurses (LPNs) / Registered Nurses (RNs) Paid Time Off (PTO) and flexible... 

Prime Therapeutics

Billing Specialist - Remote Job at Prime Therapeutics

 ...Come build the future of pharmacy with us.**Job Posting Title**Billing Specialist - Remote**Job Description**The Billing Specialist...  ...security controls unique to their job, and comply with all applicable legal, regulatory, and contractual requirements and internal policies... 

PDGTransportation

Short Haul CDL-A Truck Driver Dedicated Fleet Job at PDGTransportation

~ CDL-A drivers will earn $1725- $2200 average weekly gross ~$1000 sign-on bonus ~ Dedicated freight ~ Driver home weekly ~ Drivers will have to unload freight...  ...veteran status or any other protected category under federal state or local regulations.... 

Onvida Health

Epic Analyst | Cupid & Radiant Job at Onvida Health

 ...rewards/compensation package offered to candidates. Min = $95,439.68 Mid = $119,299.59 Max = $143,159.51 Summary The Epic Analyst is responsible for providing analysis, build, implementation, support, maintenance, development and coordination of activities...