BI Engineer

Posted Yesterday
Be an Early Applicant
2 Locations
In-Office
77K-139K Annually
Junior
Healthtech • Insurance
The Role
Designs and develops end-to-end data integration pipelines, enterprise BI data marts, semantic data layers, and analytics solutions. Works with RDBMS, Teradata, Hadoop, and Azure cloud technologies while supporting multiple projects, data architecture initiatives, and business stakeholders. Requires SQL, data analytics, BI architecture, cloud, DevOps, scheduling, and strong communication skills.
Summary Generated by Built In

At HCSC, our employees are the cornerstone of our business and the foundation to our success. We empower employees with curated development plans that foster growth and promote rewarding, fulfilling careers.

Join HCSC and be part of a purpose-driven company that will invest in your professional development.

Job Summary

Job Summary:
An individual with the ability to design and develop data Integrations to deliver Enterprise BI Data Marts and BI Semantic Data layer(s). This role required strong technical skills in platforms such as RDMBS, MPP Platforms (Teradata), Hadoop Datalake and Azure cloud with ability to design and develop end to end data integration pipelines. As an Sr BI Engineer in the Enterprise Business Analytics & Business Intelligence team, this role is expected to manage multiple projects within the team and support others within the DAS organization. Many of these projects/initiatives are part of the HCSC & DAS initiatives to improve data processes, technology infrastructure and reporting/analytical services.

Required Job Qualifications:

  • Bachelor’s degree with 2 years of experience OR Masters Degree or 6 years of equivalent experience with data integration platforms
  • Minimum 1 years of experience working with SQL Experience.
  • Minimum 1 years of experience working in Data and Analytics tools and solutions.
  • Knowledge of Business Intelligence Architecture and technologies.
  • Experience working with a data architecture team to develop/manage a universal semantic model
  • Ability to work with business stakeholders to design, develop data products solution to enable insights.
  • Knowledge and understanding of Hadoop tech stack like HDFS, Hive, HQL, Spark, Scala, Pyspark/python, Sqoop.
  • Knowledge and understanding of MPP platforms like Teradata BTEQ, SQL etc
  • Knowledge and understanding of Azure Cloud Analytics Services Synapse, ADLS, ADF, Azure SQL etc.
  • Knowledge of DevOps / continuous deployment / integration process and tools.
  • Knowledge of working with Enterprise grade scheduling tools like control M, Zena etc
  • Be an avid learner, gain a solid understanding of available data and promote innovative insights.
  • Strong analytical skills Written, communications and presentation skills, ability to source interpret and present analytics in a thoughtful and meaningful manner
  • Proactive self-starter, quick-learner, flexible team-player, ability to work both independently and as part of a team
  • Ability to multi-task, maintain strong attention to detail, and prioritize work within tight deadlines.

Preferred Job Qualifications:

  • Healthcare sector experience preferred
  • Analytical thinking and problem-solving ability.
  • Strong knowledge of SQL, analytics tools and languages to analyze large data sets from multiple data sources
  • Anticipates and prevents problems and roadblocks before they occur

Are you being referred to one of our roles? If so, ask your connection at HCSC about our Employee Referral process!

Pay Transparency Statement:

At Health Care Service Corporation, you will be part of an organization committed to offering meaningful benefits to our employees to support their life outside of work. From health and wellness benefits, 401(k) savings plan, pension plan, paid time off, paid parental leave, disability insurance, supplemental life insurance, employee assistance program, paid holidays, tuition reimbursement, plus other incentives, we offer a robust total rewards package for employees.  Learn more about our benefit offerings by visiting https://careers.hcsc.com/totalrewards.

The compensation offered will vary depending on your job-related skills, education, knowledge, and experience. This role aligns with an annual incentive bonus plan subject to the terms and the conditions of the plan.

Flex employees are expected to be in the office a minimum of three days a week. Management will have discretion to modify an employee's weekly schedule for exigent circumstances.


HCSC Employment Statement:

We are an Equal Opportunity Employment employer dedicated to providing a welcoming environment where the unique differences of our employees are respected and valued. All qualified applicants will receive consideration for employment without regard to race, color, religion, sex, sexual orientation, gender identity, national origin, disability, protected veteran status, or any other legally protected characteristics. We are a drug-free and smoke-free workplace. Employment may be contingent upon successful completion of drug screening in accordance with applicable law.

Base Pay Range$76,600.00 - $138,500.00

Exact compensation may vary based on skills, experience, and location.

Skills Required

  • Bachelor's degree with 2 years of experience, or master's degree, or 6 years of equivalent experience with data integration platforms
  • At least 1 year of SQL experience
  • At least 1 year of experience working with data and analytics tools and solutions
  • Knowledge of business intelligence architecture and technologies
  • Experience working with a data architecture team to develop or manage a universal semantic model
  • Ability to work with business stakeholders to design and develop data product solutions
  • Knowledge of Hadoop technologies including HDFS, Hive, HQL, Spark, Scala, PySpark or Python, and Sqoop
  • Knowledge of MPP platforms including Teradata, BTEQ, and SQL
  • Knowledge of Azure Cloud Analytics Services including Synapse, ADLS, ADF, and Azure SQL
  • Knowledge of DevOps and continuous deployment or integration processes and tools
  • Knowledge of enterprise scheduling tools such as Control-M and Zena
  • Strong analytical, written communication, and presentation skills
  • Ability to work independently and collaboratively, multitask, prioritize, and meet tight deadlines
  • Healthcare sector experience
  • Analytical thinking and problem-solving ability
  • Strong knowledge of SQL, analytics tools, and languages for analyzing large datasets
  • Ability to anticipate and prevent problems and roadblocks

Health Care Service Corporation Compensation & Benefits Highlights

The following summarizes recurring compensation and benefits themes identified from responses generated by popular LLMs to common candidate questions about Health Care Service Corporation and has not been reviewed or approved by Health Care Service Corporation.

  • Retirement Support — A pension plan alongside a matching 401(k) is offered, an uncommon combination in the private sector. This combination is described as a standout element that helps retain employees.
  • Healthcare Strength — Healthcare options are broad, with multiple medical, dental, and vision choices, wellness incentives, and access to resources like on-site fitness centers and an EAP. These offerings add meaningful value beyond base pay.
  • Parental & Family Support — Paid parental leave (up to six weeks at full pay after one year), adoption assistance, and mothers’ rooms are available. These supports reinforce family needs alongside work commitments.

Health Care Service Corporation Insights

Am I A Good Fit?
beta
Get Personalized Job Insights.
Our AI-powered fit analysis compares your resume with a job listing so you know if your skills & experience align.

The Company
HQ: Chicago, IL
13,563 Employees

What We Do

Imagine Something New, Something Different. Health Care Service Corporation, a Mutual Legal Reserve Company (HCSC), is the largest customer-owned health insurer in the nation and the fourth largest overall. Operating through our Blue Cross and Blue Shield Plans in Illinois, Montana, New Mexico, Oklahoma and Texas (as well as a variety of affiliates and subsidiaries,) we are expanding access to high-quality, cost-effective health care. We are equipping members with information and tools so they can make the best health care decisions for themselves and their families. HCSC is continuously recognized as an employer committed to community, diversity and inclusion, training and development. HCSC is committed to pioneering the health care space in ways as effective as they are creative. If you are passionate about the impact you want to have through your work, with a desire to apply innovative thinking to new and emerging challenges, we encourage you to learn more about HCSC. Learn about what we stand for, how we work and the difference we’re making in the lives of our 15 million members. Join HCSC and discover what new ways of thinking can mean for you, your community, our customers and our organization. Divisions of Health Care Service Corporation, a Mutual Legal Reserve Company, an Independent Licensee of the Blue Cross and Blue Shield Association.

Similar Jobs

Tempus AI Logo Tempus AI

Business Intelligence Engineer

Artificial Intelligence • Big Data • Healthtech • Machine Learning • Analytics • Biotech • Generative AI
Hybrid
Chicago, IL, USA
3775 Employees
70K-90K Annually
Hybrid
Chicago, IL, USA
289097 Employees
In-Office
Northbrook, IL, USA
20000 Employees
101K-152K Annually

CrossCountry Consulting Logo CrossCountry Consulting

Business Intelligence Engineer

Business Intelligence • Consulting
Hybrid
5 Locations
887 Employees
130K-185K Annually

Similar Companies Hiring

OneImaging Thumbnail
Healthtech
Miami, FL
62 Employees
Vitalize Thumbnail
Artificial Intelligence • Healthtech • Software
San Francisco, California
50 Employees
Vega Thumbnail
Artificial Intelligence • Automotive • Insurance • Transportation
US
65 Employees

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account