Lead Analytics Engineer

HCSC, L.P.
Chicago, United States of America
yesterday

Role details

Contract type
Permanent contract
Employment type
Full-time (> 32 hours)
Working hours
Regular working hours
Languages
English
Experience level
Senior
Compensation
$ 203K

Job location

Chicago, United States of America

Tech stack

Data analysis
Azure
Big Data
Continuous Delivery
Data Architecture
Data Integration
Data Mart
Data Transformation
Data Systems
Relational Databases
DevOps
Hadoop
Hadoop Distributed File System
Hive
Python
SQL Azure
Performance Tuning
Power BI
Standard Sql
Scala
SQL Databases
Sqoop
Teradata
Spark
Data Layers
Avid Media Composer
Data Lake
PySpark
Databricks
Control M

Job description

Join our talent community and receive the latest HCSC news, content, and be first in line for new job opportunities.

Join our Talent Community. (https://hcsc.recsolu.com/app/collect/form/pmPA8v_eHgqFiDb2AuRTqQ)

For more than 80 years, HCSC has been dedicated to expanding access to high-quality, cost-effective health care and equipping our members with information and tools to make the best health care decisions for themselves and their families. As an industry leader, HCSC also has been helping to make the health care system work better for all Americans. To remain a leader, we offer compelling careers that encourage resourcefulness, strategic thought and empower you to make a difference in the lives of our members and their communities.

Today, with the industry at an important crossroad, HCSC is reimagining health care and looking for original thinkers who aren't afraid to make innovative contributions. We are an Equal Opportunity Employment employer dedicated to workforce diversity and a drug-free and smoke-free workplace. Learn more about HCSC, our commitment to our members and the opportunity you'll have to improve health care delivery in an open, collaborative environment.

HCSC is committed to diversity in the workplace and to providing equal opportunity to employees and applicants.

If you are an individual with a disability or a disabled veteran and need an accommodation or assistance in either using the Careers website or completing the application process, you can call us at 1-866-977-7378 to request reasonable accommodations.

Please note that only requests for accommodations in the application process will be returned. All applications, including resumes, must be submitted through HCSC's Career website on-line application process. If you have general questions regarding the status of an existing application, navigate to "candidate home" to view your job submissions.

Blue Cross and Blue Shield of Illinois, Blue Cross and Blue Shield of Montana, Blue Cross and Blue Shield of New Mexico, Blue Cross and Blue Shield of Oklahoma, and Blue Cross and Blue Shield of Texas,

Divisions of Health Care Service Corporation, a Mutual Legal Reserve Company, and Independent Licensee of the Blue Cross and Blue Shield Association

Requirements

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 requires strong technical skills across platforms such as RDBMS, MPP platforms (e.g., Teradata), Hadoop data lakes, Azure Cloud, and Azure Databricks, with the ability to design and develop end to end data integration and analytics engineering pipelines., * Bachelor's degree and 7 years of experience or 11 years of equivalent experience with data integration platforms

  • Strong technical experience in 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.
  • 3 + years of experience working with Hadoop tech stack like HDFS, Hive, HQL, Spark, Scala, Pyspark/python, Sqoop.
  • 5 + years of experience working with SQL and Analytics
  • 2 + years of experience working with MPP platforms like Teradata BTEQ, SQL etc
  • 2 + years of experience working with 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., * Strong experience with Databricks, including Spark-based data transformations and building scalable analytics pipelines
  • Hands-on expertise with Power BI, especially Semantic Model design, performance optimization, and enterprise reporting
  • Experience with Databricks GenAI features (GenAI Code, Databricks Agents) and Power BI Copilot to accelerate analytics development
  • Healthcare domain experience preferred, with the ability to work with healthcare data
  • Excellent analytical and problem-solving skills, translating business needs into reliable, high-quality data solutions

Benefits & conditions

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.

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.

Base Pay Range

$112,200.00 - $202,600.00

About the company

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., The role includes developing modern data engineering pipelines leveraging AI assisted capabilities, such as Databricks GenAI features and developer productivity tools (e.g., GitHub Copilot), to accelerate design, development, and optimization of data solutions. As a Lead Analytics Engineer within the Enterprise Business Analytics & Business Intelligence team, this role is expected to lead multiple projects, provide technical guidance, and support other team members within the DAS organization. Many of these projects and initiatives are part of HCSC & DAS enterprise efforts to improve data processes, technology infrastructure, and reporting and analytical services., Are you being referred to one of our roles? If so, ask your connection at HCSC about our Employee Referral process!

Apply for this position