Senior BI Engineer - Data Integration & Analytics

Corporate Strategy Division; Chicago (IL); On-site; USD 71,000 - 150,000; Full time

Job summary

HCSC is seeking a Senior BI Engineer to design and develop end-to-end data integration pipelines, delivering Enterprise BI Data Marts and semantic data layers. You will work with SQL-based analytics, Hadoop, Teradata, and Azure cloud services, coordinating multiple projects within the DAS organization.

The role requires strong analytical skills, stakeholder collaboration, and experience with BI architectures. A proactive, fast learner who can work independently or in a team is essential.

Qualifications

• Bachelor's degree with 2 years of experience OR Masters degree or 6 years of equivalent experience with data integration platforms.
• Minimum 1 year of experience working with SQL.
• Minimum 1 year of experience working in Data and Analytics tools and solutions.
• Knowledge of Business Intelligence Architecture and technologies.
• Experience with a data architecture team to develop a universal semantic model.
• Ability to design data products to enable insights.
• Knowledge of Hadoop stack: HDFS, Hive, HQL, Spark, PySpark, Python, Sqoop.
• Knowledge of Teradata BTEQ and SQL.
• Knowledge of Azure Cloud Analytics: Synapse, ADLS, ADF, Azure SQL.
• Knowledge of DevOps / CI/CD processes.
• Knowledge of enterprise scheduling tools: Control-M, Zena.
• Be an avid learner and promote innovative insights.
• Strong written, verbal, and presentation skills.
• Proactive, fast learner, team player.
• Ability to multi-task with attention to detail.

Responsibilities

• Design and develop data integrations to deliver Enterprise BI Data Marts and BI Semantic Data layers.
• Manage multiple projects within the Enterprise BI team and support others in DAS.
• Collaborate with stakeholders to design data products for insights.
• Contribute to data process improvements and analytics services.

Skills

SQL

Hadoop

Teradata

Azure

Data Integration

BI Architecture

Semantic Model

DevOps

Scheduling Tools

Python/PySpark

Scala

Education

Bachelor’s degree with 2 years experience OR Master’s degree

6 years equivalent experience

Tools

Teradata

Hadoop

Azure Synapse

ADLS

ADF

Control-M

Zena

Job description

HCSC is seeking a Senior BI Engineer to design and develop end-to-end data integration pipelines, delivering Enterprise BI Data Marts and semantic data layers. You will work with SQL-based analytics, Hadoop, Teradata, and Azure cloud services, coordinating multiple projects within the DAS organization.

The role requires strong analytical skills, stakeholder collaboration, and experience with BI architectures. A proactive, fast learner who can work independently or in a team is essential.