Data Engineer

BCS Financial Corporation•Oakbrook Terrace, IL

3d•$111,000 - $140,000•Onsite

About The Position

The Data Engineer builds and scales enterprise data solutions within BCS’ ecosystem to support Enterprise Analytics, operational reporting, and self-service business intelligence. This role focuses on developing governed, high-performance, and reusable data assets aligned with enterprise data architecture standards. The Data Engineer plays a key role in enabling advanced analytics, including data exploration, feature engineering, statistical modeling, and AI-driven use cases. This position works in close coordination with the Enterprise Data Architect and broader IT teams to ensure consistency, scalability, security, and alignment with BCS’ long-term data strategy. This role supports key enterprise initiatives including Data Enablement and AI-driven analytics. This position will report to the Director of Data Engineering.

Requirements

Bachelor of Science degree in Information Systems, Computer Science, Statistics, Data Science or other related field
At least 5 years of experience in a data engineering role
Advanced SQL skills for data transformation and modeling
Hands on experience with Microsoft Fabric Data Factory for orchestration and ingestion
Experience with medallion data architecture patterns
Experience implementing data validation and pipeline monitoring
Experience with ETL tools (e.g SSIS or equivalent).
Working knowledge of .NET/C#, Python, APIs, version control, CI/CD practices and agile workflow

Nice To Haves

Relevant certifications in cloud, data engineering, or analytics platform
Insurance industry experience
Collaboration with data science teams
Familiarity with Azure ecosystem (Azure SQL, Azure Functions, storage, etc.)
Experience with data modeling techniques (e.g., dimensional modeling, star schema)

Responsibilities

Design ETL pipelines using Microsoft Fabric and other enterprise data platforms as appropriate.
Partner closely with the Enterprise Data Architect to align data models, pipelines, and storage patterns with enterprise data architecture standards.
Manage and optimize data within Microsoft Fabric OneLake, including data residency and shortcuts.
Develop and maintain transformation logic using Fabric Notebooks (PySpark/Spark SQL) across medallion architecture layers (bronze, silver, gold).
Design and implement efficient incremental data loading and change data capture strategies.
Partner with Analytics and business teams to deliver trusted, well-documented, and reusable datasets for reporting and advanced analytics.
Collaborate with analytics and data science teams to operationalize models and integrate outputs into business workflow.
Implement and enforce data governance standards, including data quality validation, lineage, classification, and access controls.
Support Enterprise Analytics’ use of AI techniques such as text extraction or natural language processing.
Ensure compliance with data privacy and regulatory requirements (e.g., PHI/PII handling).
Prepare and maintain documentation to ensure transparency, usability, and long-term maintainability.