Business Intelligence Developer II

Transcarent; Chicago (IL); On-site; USD 95,000 - 125,000; Full time

Benefits offered by this job

Competitive medical, dental, and vison

401(k) plan with generous companymatch

Flexible Time Off

Life Insurance and Disability

Mental Health and Wellness benefits

Job summary

Transcarent is seeking a Business Intelligence Developer II to join a fast-paced, data-driven team in Chicago. You will develop and deploy visual reports and dashboards, turning complex data into actionable insights for stakeholders. The role emphasizes collaboration, agile development, and rapid iteration.

You will work with SQL Server and AWS Redshift, leveraging metadata and data quality tools to build scalable BI solutions and train business users on reporting capabilities.

Qualifications

• Bachelor’s or Master’s degree in a relevant field
• 3–5 years of Report Development/BI experience
• Strong proficiency in SQL scripting (T-SQL, PL/SQL)
• Proficiency with QlikView and QlikSense
• Experience with SQL Server and AWS Redshift
• Familiarity with Hadoop ecosystem (Hive/Impala)
• Knowledge of data warehouse concepts and data quality tooling
• Strong written and verbal communication skills

Responsibilities

• Develop, program, and implement visual data reports and interactive dashboards from multiple data sources
• Translate business requirements into meaningful reports and train stakeholders on reports
• Contribute to library of reusable objects (fields, calculations, KPIs)
• Identify data-related problems and provide scalable solutions
• Assist in defining application scope and objectives through research

Skills

SQL scripting

Data visualization

Communication

Education

Bachelor’s or Master’s in Business, Information Management, CS or Engineering

Tools

QlikView

QlikSense

SQL Server

AWS Redshift

Hadoop

Hive

Impala

Job description

The Business Intelligence Developer II is responsible for solving hard problems and finding solutions that drive the business. As a part of the Business Intelligence team, you will be working on a high priority, dynamic, data driven team. If you believe in being a great teammate, love fast paced agile development methodology , while being curious, high energy and confident, then this is the place for you.

A day in the life…

Write/program/develop and implement visual data reports and build personalized, interactive data visualizations, reports and dashboards from multiple data sources

Work with the business to process requirements and convert them into meaningful reports as well as be able to train and communicate the reports to the business stakeholders

Assist with process definition and library of reusable objects (fields, calculations, KPI, etc.)

Solve issues with minimal direction, identifies data related problems and provide scalable solutions

Participate in the definition of application scope and objectives through research and fact finding

Maintain productive working relationships with project sponsors and key systems users

Communicate and present the reports to the business stakeholders

Support adhoc requests by writing advanced SQL queries

What we are looking for…

Bachelors or Master’s Degree in Business , Information Management, Computer Science Engineering related fields

3 - 5 years of Report Development and Business Intelligence experience

Strong proficiency in SQL scripting languages (T-SQL, PL/SQL, etc.)

Proficiency in Reporting tools like Qlikview , QlikSense

Data warehouse concepts and experience in working on SQL Server (required) & AWS Redshift (preferred)

Familiarity with Big Data solutions including Hadoop (Hive, Impala)

Familiarity with predictive analytics and forecasting

Strong working knowledge of Metadata, MDM, and Data Quality tool suites

Strong communication skills, both oral and written

Who we are

Transcarent is the One Place for Health and Care, bringing medical, pharmacy, and point solutions together with the WayFinding experience, the first and only generative AI-powered health and care platform for health consumers.

Our WayFinding experience, paired with transparent and consumer-driven pharmacy care, 2nd.MD expert medical opinions, and virtual primary care, works seamlessly with comprehensive Care Experiences – Cancer Care, Surgery Care, and Weight Health – to support people with all of their health needs, simple or serious. More than 1,700 employers and health plans rely on us to provide information, guidance, and care, empowering health consumers with more choice, an experience they love, access to higher-quality care, and lower costs for 21 million Members. For more information, visit transcarent.com , and follow us on LinkedIn .

At Transcarent, our values guide everything we do:

• People First: We prioritize our Members, clients, and each other in every decision
• Care: Every decision starts with improving health and care for our Members
• Resilience: We push boundaries and take the uncharted path to change an industry
• Results: We take ownership, solve with speed, and deliver for our people and each other
• Humble and Human: We lead with humility, bring fun to tough moments, and go further together

Total Rewards

Individual compensation packages are based on a few different factors unique to each candidate, including primary work location and an evaluation of a candidate’s skills, experience, market demands, and internal equity. Salary is just one component of Transcarent's total package. All regular employees are also eligible for the corporate bonus program or a sales incentive (target included in OTE) as well as stock options.

Our benefits and perks programs include, but are not limited to:

• Competitive medical, dental, and vision coverage
• Competitive 401(k) Plan with a generous company match
• Flexible Time Off/Paid Time Off, 13 paid holidays
• Protection Plans including Life Insurance, Disability Insurance, and Supplemental Insurance
• Mental Health and Wellness benefits

Transcarent is an equal opportunity employer. We celebrate diversity and are committed to creating an inclusive environment for all employees. If you are a person with a disability and require assistance during the application process, please don’t hesitate to reach out!

Research shows that candidates from underrepresented backgrounds often don’t apply unless they meet 100% of the job criteria. While we have worked to consolidate the minimum qualifications for each role, we aren’t looking for someone who checks each box on a page; we’re looking for active learners and people who care about disrupting the current health and care with their unique experiences.