Health Care Service Corporation Logo

Health Care Service Corporation

BI Engineer

Posted 2 Days Ago
Be an Early Applicant
In-Office
Chicago, IL
71K-150K Annually
Junior
In-Office
Chicago, IL
71K-150K Annually
Junior
Designs and develops end-to-end data integration pipelines, enterprise BI data marts, and semantic data layers across Teradata, Hadoop, and Azure platforms. Partners with data architecture teams and business stakeholders to create data products and enable analytics. Supports multiple projects, improves data processes and infrastructure, uses enterprise scheduling and DevOps tools, and communicates analytical insights effectively.
The summary above was generated by AI

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.

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$70,600.00 - $149,600.00

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

Similar Jobs

Yesterday
Hybrid
95K-135K Annually
Senior level
95K-135K Annually
Senior level
Artificial Intelligence • Big Data • Healthtech • Machine Learning • Analytics • Biotech • Generative AI
Owns the full lifecycle of business intelligence solutions, including requirements gathering, dashboard and report development, data modeling, visualization, governance, and production delivery. Partners with business, laboratory, engineering, and product stakeholders to perform root-cause analyses, develop datasets, support self-service analytics, and guide system changes. Requires advanced SQL, BI tool expertise, stakeholder management, and experience with agentic workflows.
Top Skills: Claude CodeCursorLookerSQLTableauWindsurf
3 Days Ago
Easy Apply
Hybrid
Easy Apply
72K-115K Annually
Senior level
72K-115K Annually
Senior level
Fintech • Information Technology • Machine Learning • Software • Analytics • Financial Services
Designs and maintains enterprise BI reporting, analytics applications, data marts, warehouses, and ETL/ELT pipelines. Partners with cross-functional stakeholders to gather requirements and deliver scalable solutions using SQL, Python, Snowflake, Airflow, and BI visualization tools. Leads initiatives through architecture, implementation, delivery, and support, while advancing AI adoption across the BI and data development workflow.
Top Skills: Apache AirflowAstronomer AirflowAws BedrockAws RedshiftBigQueryClaudeDatabricksGeminiLookerMicrostrategyPower BIPythonSnowflakeSQLTableau
Yesterday
In-Office or Remote
90K-190K Annually
Senior level
90K-190K Annually
Senior level
Information Technology • Consulting • Defense
Develop and architect Oracle HCM analytics solutions, including OTBI and BI Publisher reports, OAC dashboards, predictive analytics, HCM Extracts, semantic models, and workforce visualizations. Support federal HR compliance reporting, accessibility standards, agency onboarding, historical data migration, training, and self-service analytics. Lead technical workstreams, review deliverables, solve complex reporting challenges, and mentor junior team members.
Top Skills: AgileHcm ExtractOracle Analytics CloudOracle Bi PublisherOracle Cloud InfrastructureOracle Fusion Cloud HcmOracle Integration CloudOracle OtbiPower BIPythonRSafeSap BusinessobjectsSection 508SQLTableauWcag 2.1 Aa

What you need to know about the Los Angeles Tech Scene

Los Angeles is a global leader in entertainment, so it’s no surprise that many of the biggest players in streaming, digital media and game development call the city home. But the city boasts plenty of non-entertainment innovation as well, with tech companies spanning verticals like AI, fintech, e-commerce and biotech. With major universities like Caltech, UCLA, USC and the nearby UC Irvine, the city has a steady supply of top-flight tech and engineering talent — not counting the graduates flocking to Los Angeles from across the world to enjoy its beaches, culture and year-round temperate climate.

Key Facts About Los Angeles Tech

  • Number of Tech Workers: 375,800; 5.5% of overall workforce (2024 CompTIA survey)
  • Major Tech Employers: Snap, Netflix, SpaceX, Disney, Google
  • Key Industries: Artificial intelligence, adtech, media, software, game development
  • Funding Landscape: $11.6 billion in venture capital funding in 2024 (Pitchbook)
  • Notable Investors: Strong Ventures, Fifth Wall, Upfront Ventures, Mucker Capital, Kittyhawk Ventures
  • Research Centers and Universities: California Institute of Technology, UCLA, University of Southern California, UC Irvine, Pepperdine, California Institute for Immunology and Immunotherapy, Center for Quantum Science and Engineering

Sign up now Access later

Create Free Account

Please log in or sign up to report this job.

Create Free Account