Business Intelligence Developer II

Transcarent; Chicago (IL); On-site; USD 90,000 - 140,000; Full time

Job summary

Transcarent is seeking a BI Developer II to join a fast‑moving data driven team. You will design and implement visual data reports and dashboards from multiple sources, and translate business requirements into actionable insights for stakeholders.

You will work with SQL Server, AWS Redshift, Hadoop and QlikView/QlikSense to deliver scalable BI solutions, train users, and contribute to data warehouse best practices. Strong communication and problem solving are essential.

Qualifications

• Bachelor's or Master’s Degree in Business, Information Management, Computer Science or Engineering related fields.
• 3–5 years of Report Development and BI experience.
• Strong proficiency in SQL scripting and BI reporting tools.

Responsibilities

• Develop and implement visual data reports and dashboards from multiple data sources.
• Translate business requirements into meaningful reports and train stakeholders.
• Collaborate to define reusable data objects like fields and KPIs.
• Solve data issues and deliver scalable solutions.
• Present reports to business stakeholders and support ad-hoc SQL queries.

Skills

SQL scripting

QlikView

QlikSense

Data visualization

Communication skills

Education

Bachelor's or Master's in Business/Info Mgmt/CS/Engineering

Tools

SQL Server

AWS Redshift

Hadoop

ETL tools

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 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.