CW Data Modeler Intern

Blue Cross and Blue Shield of Louisiana Inc.; Baton Rouge (LA); On-site; USD 22,041 - 33,062; Full time

Job summary

Blue Cross and Blue Shield of Louisiana Inc. in Baton Rouge is seeking a Data Modeler Intern to support the Enterprise Information Management team.

The role involves hands-on work maintaining data definitions, models, and documentation for the Enterprise Data Warehouse (EDW). You will collaborate with Business Data Architects and product teams, receive mentoring, and gain exposure to dimensional modeling and data usage within a healthcare data environment.

Qualifications

• Current undergraduate, graduate student, or recent graduate in a related field.
• Basic SQL scripting knowledge from coursework or projects.
• Basic database concepts including tables, views, and data modeling.
• Strong interest in data, analytics, enterprise reporting, or data warehousing.
• GPA 2.5 minimum; 3.0 preferred.

Responsibilities

• Assist with creating and maintaining data definitions for EDW tables and views.
• Support updates to logical and physical data models and documentation.
• Gather and analyze data requirements, data flows, and business needs.
• Contribute to data model design and enterprise reporting dashboards.

Skills

SQL scripting

Database concepts

Data modeling

Analytics interest

Team collaboration

Microsoft Office

Adaptability

Data visualization

Education

Business, Finance, CS, Math, Data Analytics, IS

GPA 2.5 minimum

Tools

Erwin

Job description

We take great strides to ensure our employees have the resources to live well, be healthy, continue learning, develop skills, grow professionally and serve our local communities. Residency in or relocation to Louisiana is preferred for all positions. The Enterprise Information Management team supports Louisiana Blue’s strategic direction to be data and analytics driven by developing and maintaining data definitions, data models, and model blueprints for the Enterprise Data Warehouse (EDW). The Data Modeler Intern will support team objectives through hands‑on project work, mentoring, and exposure to data modeling practices used across the organization.

ACCOUNTABILITIES & ESSENTIAL FUNCTIONS

• Assist with creating and maintaining data definitions for EDW tables and views in Erwin under team guidance.
• Support updates to logical and physical data models, model diagrams, and DDL documentation for tables and views.
• Help gather, document, and analyze data requirements, data flows, and business needs for reporting or feature‑development work.
• Participate in the creation of solution blueprints for features that require changes or additions to the EDW model.
• Assist with basic review of deployment scripts, plans, and documentation to support data model implementation.
• Support teams and business areas by researching basic questions related to an EDW subject area.
• Contribute to data model design and solutioning for enterprise reporting dashboards.
• Collaborate with Business Data Architects, Product Management, DI Architects, and other team members to understand how tables and views are designed to meet business needs.
• Participate in training or knowledge‑sharing activities related to EDW‑specific dimensional modeling and data usage.

Required Qualifications

• Current undergraduate, graduate student, or recent graduate, pursuing Business, Finance, Computer Science, Mathematics, Data Analytics, Information Systems, or a related field.
• Basic knowledge of SQL scripting through coursework, project work, internships, or related experience.
• Basic understanding of database concepts, including tables, views, data relationships, and data modeling principles.
• Strong interest in data, analytics, enterprise reporting, information management, or data warehousing.
• Cumulative GPA: 3.0 preferred; 2.5 minimum cumulative GPA.

Other Qualifications

• Ability to adapt quickly to change and coordinate activities with others in a team environment.
• Working knowledge of Microsoft Office suite, especially Word, Excel, PowerPoint, Teams, and Outlook.
• Knowledge of SQL, database design, data visualization, or reporting tools is preferred.
• Self‑motivated, professional, coachable, adaptable to a changing work environment, and team‑oriented.
• Must be able to work a minimum of 25 hours per week during Spring and Fall semesters and 25–30 hours per week during Summer.

An Equal Opportunity Employer

In support of our mission to improve the health and lives of Louisianians, we encourage the good health of its employees and visitors. We want to ensure that our employees have a work environment that will optimize personal health and well‑being. Due to the acknowledged hazards from exposure to environmental tobacco smoke, and in order to promote good health, our company properties are smoke and tobacco free. We perform background and pre‑employment drug screening after an offer has been extended and prior to hire for all positions. As part of this process records may be verified and information checked with agencies including but not limited to the Social Security Administration, criminal courts, federal, state, and county repositories of criminal records, Department of Motor Vehicles, and credit bureaus. Pursuant with Sec 1033 of the Violent Crime Control and Law Enforcement Act of 1994, individuals who have been convicted of a felony crime involving dishonesty or breach of trust are prohibited from working in the insurance industry unless they obtain written consent from their state insurance commissioner. Additionally, we are a Drug Free Workplace. A pre‑employment drug screen will be required and any offer is contingent upon satisfactory drug testing results.

Company Mission

To improve the health and lives of Louisianians.

Company Vision

To be the market leader that delivers unsurpassed value to our customers through partnerships across the healthcare system.

Blue Cross and Blue Shield of Louisiana is incorporated as Louisiana Health Service & Indemnity company and is an independent licensee of the Blue Cross and Blue Shield Association. Blue Cross and Blue Shield of Louisiana is licensed to sell products only in the state of Louisiana.